sonar runner - Update SonarQube 3.7.4 to 5.0 AddNetworkUseSubCharacteristic: Fail to upgrade database -
hi: both have errror when migrating:
the log:
2015.07.16 15:36:57 info app[o.s.p.m.monitor] process[web] 2015.07.16 15:40:54 info web[dbmigration] == replacekeyregexpbykeysearchinmeasurefiltersdata: migrating ================ 2015.07.16 15:40:54 info web[dbmigration] == replacekeyregexpbykeysearchinmeasurefiltersdata: migrated (0.0150s) ======= 2015.07.16 15:40:54 info web[dbmigration] 2015.07.16 15:40:55 info web[dbmigration] == addprovisioningpermission: migrating ====================================== 2015.07.16 15:40:55 info web[dbmigration] == addprovisioningpermission: migrated (0.1250s) ============================= 2015.07.16 15:40:55 info web[dbmigration] 2015.07.16 15:40:55 info web[dbmigration] == addtechnicaldebttoissue: migrating ======================================== 2015.07.16 15:40:55 info web[dbmigration] -- add_column("issues", "technical_debt", :integer, {:null=>true}) 2015.07.16 15:40:55 info web[dbmigration] -> 0.0940s 2015.07.16 15:40:55 info web[dbmigration] -> 0 rows 2015.07.16 15:40:55 info web[dbmigration] == addtechnicaldebttoissue: migrated (0.0940s) =============================== 2015.07.16 15:40:55 info web[dbmigration] 2015.07.16 15:40:55 info web[dbmigration] == renamewidgetsqalepyramidtotechnicaldebtpyramid: migrating ================= 2015.07.16 15:40:55 info web[dbmigration] == renamewidgetsqalepyramidtotechnicaldebtpyramid: migrated (0.0160s) ======== 2015.07.16 15:40:55 info web[dbmigration] 2015.07.16 15:40:55 info web[dbmigration] == resizetimelinewidgets: migrating ========================================== 2015.07.16 15:40:55 info web[dbmigration] == resizetimelinewidgets: migrated (0.1090s) ================================= 2015.07.16 15:40:55 info web[dbmigration] 2015.07.16 15:40:55 info web[dbmigration] == adduniqueconstrainttogroupsusers: migrating =============================== 2015.07.16 15:40:55 info web[dbmigration] -- remove duplications 0 user group associations 2015.07.16 15:40:55 info web[dbmigration] -> 0.0000s 2015.07.16 15:40:55 info web[dbmigration] -- add_index(:groups_users, [:group_id, :user_id], {:name=>"groups_users_unique", :unique=>true}) 2015.07.16 15:40:56 info web[dbmigration] -> 0.6080s 2015.07.16 15:40:56 info web[dbmigration] -> 0 rows 2015.07.16 15:40:56 info web[dbmigration] == adduniqueconstrainttogroupsusers: migrated (0.6240s) ====================== 2015.07.16 15:40:56 info web[dbmigration] 2015.07.16 15:40:56 info web[dbmigration] == addcharacteristicscolumns: migrating ====================================== 2015.07.16 15:40:56 info web[dbmigration] -- add_column("characteristics", :parent_id, :integer, {:null=>true}) 2015.07.16 15:40:56 info web[dbmigration] -> 0.0160s 2015.07.16 15:40:56 info web[dbmigration] -> 0 rows 2015.07.16 15:40:56 info web[dbmigration] -- add_column("characteristics", :root_id, :integer, {:null=>true}) 2015.07.16 15:40:56 info web[dbmigration] -> 0.0310s 2015.07.16 15:40:56 info web[dbmigration] -> 0 rows 2015.07.16 15:40:56 info web[dbmigration] -- add_column("characteristics", :function_key, :string, {:null=>true, :limit=>100}) 2015.07.16 15:40:56 info web[dbmigration] -> 0.0160s 2015.07.16 15:40:56 info web[dbmigration] -> 0 rows 2015.07.16 15:40:56 info web[dbmigration] -- add_column("characteristics", :factor_value, :decimal, {:null=>true, :precision=>30, :scale=>20}) 2015.07.16 15:40:56 info web[dbmigration] -> 0.0150s 2015.07.16 15:40:56 info web[dbmigration] -> 0 rows 2015.07.16 15:40:56 info web[dbmigration] -- add_column("characteristics", :factor_unit, :string, {:null=>true, :limit=>100}) 2015.07.16 15:40:56 info web[dbmigration] -> 0.0160s 2015.07.16 15:40:56 info web[dbmigration] -> 0 rows 2015.07.16 15:40:56 info web[dbmigration] -- add_column("characteristics", :offset_value, :decimal, {:null=>true, :precision=>30, :scale=>20}) 2015.07.16 15:40:56 info web[dbmigration] -> 0.0160s 2015.07.16 15:40:56 info web[dbmigration] -> 0 rows 2015.07.16 15:40:56 info web[dbmigration] -- add_column("characteristics", :offset_unit, :string, {:null=>true, :limit=>100}) 2015.07.16 15:40:56 info web[dbmigration] -> 0.0150s 2015.07.16 15:40:56 info web[dbmigration] -> 0 rows 2015.07.16 15:40:56 info web[dbmigration] -- add_column("characteristics", :created_at, :datetime, {:null=>true}) 2015.07.16 15:40:56 info web[dbmigration] -> 0.0310s 2015.07.16 15:40:56 info web[dbmigration] -> 0 rows 2015.07.16 15:40:56 info web[dbmigration] -- add_column("characteristics", :updated_at, :datetime, {:null=>true}) 2015.07.16 15:40:56 info web[dbmigration] -> 0.0160s 2015.07.16 15:40:56 info web[dbmigration] -> 0 rows 2015.07.16 15:40:56 info web[dbmigration] == addcharacteristicscolumns: migrated (0.1720s) ============================= 2015.07.16 15:40:56 info web[dbmigration] 2015.07.16 15:40:56 info web[dbmigration] == migratecharacteristics: migrating ========================================= 2015.07.16 15:41:13 info web[dbmigration] == migratecharacteristics: migrated (17.1290s) =============================== 2015.07.16 15:41:13 info web[dbmigration] 2015.07.16 15:41:13 info web[dbmigration] == addadministerissuesperm: migrating ======================================== 2015.07.16 15:41:28 info web[dbmigration] == addadministerissuesperm: migrated (14.7110s) ============================== 2015.07.16 15:41:28 info web[dbmigration] 2015.07.16 15:41:28 info web[dbmigration] == removeuselesscharacteristicsdata: migrating =============================== 2015.07.16 15:41:28 info web[dbmigration] -- remove_column("characteristics", "quality_model_id") 2015.07.16 15:41:28 info web[dbmigration] -> 0.5300s 2015.07.16 15:41:28 info web[dbmigration] -> 0 rows 2015.07.16 15:41:28 info web[dbmigration] -- remove_column("characteristics", "depth") 2015.07.16 15:41:28 info web[dbmigration] -> 0.0940s 2015.07.16 15:41:28 info web[dbmigration] -> 0 rows 2015.07.16 15:41:28 info web[dbmigration] -- remove_column("characteristics", "description") 2015.07.16 15:41:28 info web[dbmigration] -> 0.0930s 2015.07.16 15:41:28 info web[dbmigration] -> 0 rows 2015.07.16 15:41:28 info web[dbmigration] -- drop_table(:characteristic_properties) 2015.07.16 15:41:29 info web[dbmigration] -> 0.5460s 2015.07.16 15:41:29 info web[dbmigration] -> 0 rows 2015.07.16 15:41:29 info web[dbmigration] -- drop_table(:characteristic_edges) 2015.07.16 15:41:29 info web[dbmigration] -> 0.0780s 2015.07.16 15:41:29 info web[dbmigration] -- drop_table(:quality_models) 2015.07.16 15:41:29 info web[dbmigration] -> 0.0780s 2015.07.16 15:41:29 info web[dbmigration] -> 0 rows 2015.07.16 15:41:29 info web[dbmigration] == removeuselesscharacteristicsdata: migrated (1.5290s) ====================== 2015.07.16 15:41:29 info web[dbmigration] 2015.07.16 15:41:29 info web[dbmigration] == addpermtemplatekeypatterncolumn: migrating ================================ 2015.07.16 15:41:29 info web[dbmigration] -- add_column("permission_templates", :key_pattern, :string, {:null=>true, :limit=>500}) 2015.07.16 15:41:29 info web[dbmigration] -> 0.0150s 2015.07.16 15:41:29 info web[dbmigration] -> 0 rows 2015.07.16 15:41:29 info web[dbmigration] == addpermtemplatekeypatterncolumn: migrated (0.0150s) ======================= 2015.07.16 15:41:29 info web[dbmigration] 2015.07.16 15:41:29 info web[dbmigration] == addnetworkusesubcharacteristic: migrating ================================= 2015.07.16 15:41:30 error web[o.s.s.ui.jrubyfacade] fail upgrade database error has occurred, later migrations canceled: activerecord::jdbcerror: ora-00904: "description": identificador no válido : insert characteristics (quality_model_id, kee, name, rule_id, depth, characteristic_order, description, enabled, parent_id, root_id, function_key, factor_value, factor_unit, offset_value, offset_unit, created_at, updated_at, id) values(null, 'network_use_efficiency', 'network use', null, null, null, null, 1, 10734, 10734, null, null, null, null, null, to_timestamp('2015-07-16 15:41:30:245000','yyyy-mm-dd hh24:mi:ss:ff6'), to_timestamp('2015-07-16 15:41:30:245000','yyyy-mm-dd hh24:mi:ss:ff6'), ?) c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/connection_adapters/abstract_adapter.rb:227:in `log' c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/connection_adapters/abstract_adapter.rb:212:in `log' c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-jdbc-adapter-1.1.3/lib/arjdbc/oracle/adapter.rb:183:in `ora_insert' c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/connection_adapters/abstract/query_cache.rb:26:in `insert_with_query_dirty' c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/base.rb:2967:in `create' c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/timestamp.rb:53:in `create_with_timestamps' c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/callbacks.rb:266:in `create_with_callbacks' c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/base.rb:2933:in `create_or_update' c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/callbacks.rb:250:in `create_or_update_with_callbacks' c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/base.rb:2583:in `save' c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/validations.rb:1089:in `save_with_validation' c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/dirty.rb:79:in `save_with_dirty' org/jruby/rubykernel.java:2227:in `send' c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/transactions.rb:229:in `with_transaction_returning_status' c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/connection_adapters/abstract/database_statements.rb:136:in `transaction' c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/transactions.rb:182:in `transaction' c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/transactions.rb:228:in `with_transaction_returning_status' c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/transactions.rb:196:in `save_with_transactions' c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/transactions.rb:208:in `rollback_active_record_state!' c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/transactions.rb:196:in `save_with_transactions' c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/base.rb:727:in `create' c:/program files (x86)/sonarqube-5.0/web/web-inf/config/../lib/../db/migrate/466_add_network_use_sub_characteristic.rb:42:in `up' org/jruby/rubykernel.java:2223:in `send' c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/migration.rb:282:in `migrate' jar:file:/c:/program%20files%20(x86)/sonarqube-5.0/lib/server/jruby-complete-1.7.9.jar!/meta-inf/jruby.home/lib/ruby/1.8/benchmark.rb:293:in `measure' c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/migration.rb:282:in `migrate' org/jruby/rubykernel.java:2227:in `send' c:1:in `migrate' c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/migration.rb:491:in `migrate' org/jruby/rubyproc.java:290:in `call' org/jruby/rubyproc.java:224:in `call' c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/migration.rb:576:in `ddl_transaction' c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/migration.rb:490:in `migrate' org/jruby/rubyarray.java:1613:in `each' c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/migration.rb:477:in `migrate' c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/migration.rb:401:in `up' c:/program files (x86)/sonarqube-5.0/web/web-inf/gems/gems/activerecord-2.3.15/lib/active_record/migration.rb:383:in `migrate' c:/program files (x86)/sonarqube-5.0/web/web-inf/config/../lib/database_version.rb:62:in `upgrade_and_start' c:/program files (x86)/sonarqube-5.0/web/web-inf/app/models/database_migration_manager.rb:109:in `start_migration' org/jruby/rubyproc.java:290:in `call' org/jruby/rubyproc.java:228:in `call' it insert not deletes fields. failing in class addnetworkusesubcharacteristic can not find problem. , try several times backup , restore.
i migrating basis of oracle another, , same. error persists. !!
Comments
Post a Comment