Is it possible to upgrade SonarQube 5.1.2 to 5.3? -
i interested in improvements sonarqube 5.3 brings. using 5.1.2 currently. 5.3 not lts noticed on website.
in test environment noticed upgrade 5.1.2 5.3 fail.
message in /opt/sonarqube-5.3/logs/sonar.log show database migration not working.
how can fix this?
2016.01.27 09:32:43 info web[o.s.s.d.m.platformdatabasemigration] starting db migration 2016.01.27 09:32:43 info web[dbmigration] == addprojectlinkscomponentuuid: migrating =================================== 2016.01.27 09:32:43 info web[dbmigration] -- columns("project_links") 2016.01.27 09:32:43 info web[dbmigration] -> 0.0100s 2016.01.27 09:32:43 info web[dbmigration] -- add_column("project_links", "component_uuid", :string, {:limit=>50}) 2016.01.27 09:32:43 info web[dbmigration] -> 0.0370s 2016.01.27 09:32:43 info web[dbmigration] -> 0 rows 2016.01.27 09:32:43 info web[dbmigration] == addprojectlinkscomponentuuid: migrated (0.0490s) ========================== 2016.01.27 09:32:43 info web[dbmigration] 2016.01.27 09:32:43 info web[dbmigration] == feedprojectlinkscomponentuuid: migrating ================================== 2016.01.27 09:32:44 info web[o.s.d.v.massupdate] 870 project links processed (14 items/sec) 2016.01.27 09:32:44 info web[dbmigration] == feedprojectlinkscomponentuuid: migrated (0.1430s) ========================= 2016.01.27 09:32:44 info web[dbmigration] 2016.01.27 09:32:44 info web[dbmigration] == removeprojectlinksprojectid: migrating ==================================== 2016.01.27 09:32:44 info web[dbmigration] -- columns("project_links") 2016.01.27 09:32:44 info web[dbmigration] -> 0.0070s 2016.01.27 09:32:44 info web[dbmigration] -- remove_column("project_links", "project_id") 2016.01.27 09:32:44 info web[dbmigration] -> 0.0290s 2016.01.27 09:32:44 info web[dbmigration] == removeprojectlinksprojectid: migrated (0.0360s) =========================== 2016.01.27 09:32:44 info web[dbmigration] 2016.01.27 09:32:44 info web[dbmigration] == addeventscomponentuuid: migrating ========================================= 2016.01.27 09:32:44 info web[dbmigration] -- columns("events") 2016.01.27 09:32:44 info web[dbmigration] -> 0.0060s 2016.01.27 09:32:44 info web[dbmigration] -- add_column("events", "component_uuid", :string, {:limit=>50}) 2016.01.27 09:32:44 info web[dbmigration] -> 0.0260s 2016.01.27 09:32:44 info web[dbmigration] -> 0 rows 2016.01.27 09:32:44 info web[dbmigration] -- index_exists?("events", "component_uuid", {:name=>"events_component_uuid"}) 2016.01.27 09:32:44 info web[dbmigration] -> 0.0040s 2016.01.27 09:32:44 info web[dbmigration] -- add_index("events", "component_uuid", {:name=>"events_component_uuid"}) 2016.01.27 09:32:44 info web[dbmigration] -> 0.0180s 2016.01.27 09:32:44 info web[dbmigration] -> 0 rows 2016.01.27 09:32:44 info web[dbmigration] == addeventscomponentuuid: migrated (0.0590s) ================================ 2016.01.27 09:32:44 info web[dbmigration] 2016.01.27 09:32:44 info web[dbmigration] == feedeventscomponentuuid: migrating ======================================== 2016.01.27 09:32:44 error web[o.s.s.d.m.databasemigrator] fail execute database migration: org.sonar.db.version.v52.feedeventscomponentuuid java.lang.illegalstateexception: error during processing of row: [uuid=208f1f81-5e64-4b35-8bfd-9a0bb53ce9a5,id=1829] @ org.sonar.db.version.selectimpl.newexceptionwithrowdetails(selectimpl.java:89) ~[sonar-db-5.3.jar:na] @ org.sonar.db.version.selectimpl.scroll(selectimpl.java:81) ~[sonar-db-5.3.jar:na] @ org.sonar.db.version.massupdate.execute(massupdate.java:76) ~[sonar-db-5.3.jar:na] @ org.sonar.db.version.v52.feedeventscomponentuuid.execute(feedeventscomponentuuid.java:45) ~[sonar-db-5.3.jar:na] @ org.sonar.db.version.basedatachange.execute(basedatachange.java:45) ~[sonar-db-5.3.jar:na] @ org.sonar.server.db.migrations.databasemigrator.executemigration(databasemigrator.java:95) ~[sonar-server-5.3.jar:na] @ sun.reflect.nativemethodaccessorimpl.invoke0(native method) ~[na:1.7.0_45] @ sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:57) ~[na:1.7.0_45] @ sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:43) ~[na:1.7.0_45] @ java.lang.reflect.method.invoke(method.java:606) ~[na:1.7.0_45] @ org.jruby.javasupport.javamethod.invokedirectwithexceptionhandling(javamethod.java:455) [jruby-complete-1.7.9.jar:na] @ org.jruby.javasupport.javamethod.invokedirect(javamethod.java:316) [jruby-complete-1.7.9.jar:na] @ org.jruby.java.invokers.instancemethodinvoker.call(instancemethodinvoker.java:61) [jruby-complete-1.7.9.jar:na] @ org.jruby.runtime.callsite.cachingcallsite.call(cachingcallsite.java:168) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.calloneargnode.interpret(calloneargnode.java:57) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.newlinenode.interpret(newlinenode.java:105) [jruby-complete-1.7.9.jar:na] @ org.jruby.evaluator.astinterpreter.interpret_method(astinterpreter.java:74) [jruby-complete-1.7.9.jar:na] @ org.jruby.internal.runtime.methods.interpretedmethod.call(interpretedmethod.java:182) [jruby-complete-1.7.9.jar:na] @ org.jruby.internal.runtime.methods.defaultmethod.call(defaultmethod.java:198) [jruby-complete-1.7.9.jar:na] @ org.jruby.runtime.callsite.cachingcallsite.cacheandcall(cachingcallsite.java:326) [jruby-complete-1.7.9.jar:na] @ org.jruby.runtime.callsite.cachingcallsite.call(cachingcallsite.java:170) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.fcalloneargnode.interpret(fcalloneargnode.java:36) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.newlinenode.interpret(newlinenode.java:105) [jruby-complete-1.7.9.jar:na] @ org.jruby.evaluator.astinterpreter.interpret_method(astinterpreter.java:74) [jruby-complete-1.7.9.jar:na] @ org.jruby.internal.runtime.methods.interpretedmethod.call(interpretedmethod.java:161) [jruby-complete-1.7.9.jar:na] @ org.jruby.internal.runtime.methods.defaultmethod.call(defaultmethod.java:190) [jruby-complete-1.7.9.jar:na] @ org.jruby.internal.runtime.methods.aliasmethod.call(aliasmethod.java:81) [jruby-complete-1.7.9.jar:na] @ org.jruby.rubyclass.finvoke(rubyclass.java:527) [jruby-complete-1.7.9.jar:na] @ org.jruby.rubybasicobject.send(rubybasicobject.java:2590) [jruby-complete-1.7.9.jar:na] @ org.jruby.rubykernel.send(rubykernel.java:2223) [jruby-complete-1.7.9.jar:na] @ org.jruby.rubykernel$invoker$s$send.call(rubykernel$invoker$s$send.gen) [jruby-complete-1.7.9.jar:na] @ org.jruby.internal.runtime.methods.javamethod$javamethodoneornblock.call(javamethod.java:350) [jruby-complete-1.7.9.jar:na] @ org.jruby.runtime.callsite.cachingcallsite.cacheandcall(cachingcallsite.java:326) [jruby-complete-1.7.9.jar:na] @ org.jruby.runtime.callsite.cachingcallsite.call(cachingcallsite.java:170) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.fcalloneargnode.interpret(fcalloneargnode.java:36) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.localasgnnode.interpret(localasgnnode.java:123) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.newlinenode.interpret(newlinenode.java:105) [jruby-complete-1.7.9.jar:na] @ org.jruby.evaluator.astinterpreter.interpret_block(astinterpreter.java:112) [jruby-complete-1.7.9.jar:na] @ org.jruby.runtime.interpretedblock.evalblockbody(interpretedblock.java:384) [jruby-complete-1.7.9.jar:na] @ org.jruby.runtime.interpretedblock.yield(interpretedblock.java:303) [jruby-complete-1.7.9.jar:na] @ org.jruby.runtime.interpretedblock.yieldspecific(interpretedblock.java:229) [jruby-complete-1.7.9.jar:na] @ org.jruby.runtime.block.yieldspecific(block.java:111) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.zyieldnode.interpret(zyieldnode.java:25) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.newlinenode.interpret(newlinenode.java:105) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.blocknode.interpret(blocknode.java:71) [jruby-complete-1.7.9.jar:na] @ org.jruby.evaluator.astinterpreter.interpret_method(astinterpreter.java:74) [jruby-complete-1.7.9.jar:na] @ org.jruby.internal.runtime.methods.interpretedmethod.call(interpretedmethod.java:161) [jruby-complete-1.7.9.jar:na] @ org.jruby.internal.runtime.methods.defaultmethod.call(defaultmethod.java:190) [jruby-complete-1.7.9.jar:na] @ org.jruby.internal.runtime.methods.wrappermethod.call(wrappermethod.java:74) [jruby-complete-1.7.9.jar:na] @ org.jruby.runtime.callsite.cachingcallsite.callblock(cachingcallsite.java:143) [jruby-complete-1.7.9.jar:na] @ org.jruby.runtime.callsite.cachingcallsite.calliter(cachingcallsite.java:154) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.callnoargblocknode.interpret(callnoargblocknode.java:64) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.localasgnnode.interpret(localasgnnode.java:123) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.newlinenode.interpret(newlinenode.java:105) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.blocknode.interpret(blocknode.java:71) [jruby-complete-1.7.9.jar:na] @ org.jruby.evaluator.astinterpreter.interpret_method(astinterpreter.java:74) [jruby-complete-1.7.9.jar:na] @ org.jruby.internal.runtime.methods.interpretedmethod.call(interpretedmethod.java:204) [jruby-complete-1.7.9.jar:na] @ org.jruby.internal.runtime.methods.defaultmethod.call(defaultmethod.java:206) [jruby-complete-1.7.9.jar:na] @ org.jruby.rubyclass.finvoke(rubyclass.java:567) [jruby-complete-1.7.9.jar:na] @ org.jruby.rubybasicobject.send(rubybasicobject.java:2595) [jruby-complete-1.7.9.jar:na] @ org.jruby.rubykernel.send(rubykernel.java:2227) [jruby-complete-1.7.9.jar:na] @ org.jruby.rubykernel$invoker$s$send.call(rubykernel$invoker$s$send.gen) [jruby-complete-1.7.9.jar:na] @ org.jruby.runtime.callsite.cachingcallsite.cacheandcall(cachingcallsite.java:356) [jruby-complete-1.7.9.jar:na] @ org.jruby.runtime.callsite.cachingcallsite.callblock(cachingcallsite.java:213) [jruby-complete-1.7.9.jar:na] @ org.jruby.runtime.callsite.cachingcallsite.call(cachingcallsite.java:217) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.callspecialargblockpassnode.interpret(callspecialargblockpassnode.java:66) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.newlinenode.interpret(newlinenode.java:105) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.rescuenode.executebody(rescuenode.java:221) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.rescuenode.interpret(rescuenode.java:116) [jruby-complete-1.7.9.jar:na] @ org.jruby.evaluator.astinterpreter.interpret_method(astinterpreter.java:74) [jruby-complete-1.7.9.jar:na] @ org.jruby.internal.runtime.methods.interpretedmethod.call(interpretedmethod.java:182) [jruby-complete-1.7.9.jar:na] @ org.jruby.internal.runtime.methods.defaultmethod.call(defaultmethod.java:198) [jruby-complete-1.7.9.jar:na] @ org.jruby.runtime.callsite.cachingcallsite.call(cachingcallsite.java:168) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.calloneargnode.interpret(calloneargnode.java:57) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.newlinenode.interpret(newlinenode.java:105) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.blocknode.interpret(blocknode.java:71) [jruby-complete-1.7.9.jar:na] @ org.jruby.evaluator.astinterpreter.interpret_block(astinterpreter.java:112) [jruby-complete-1.7.9.jar:na] @ org.jruby.runtime.interpretedblock.evalblockbody(interpretedblock.java:384) [jruby-complete-1.7.9.jar:na] @ org.jruby.runtime.interpretedblock.yield(interpretedblock.java:336) [jruby-complete-1.7.9.jar:na] @ org.jruby.runtime.blockbody.call(blockbody.java:73) [jruby-complete-1.7.9.jar:na] @ org.jruby.runtime.block.call(block.java:101) [jruby-complete-1.7.9.jar:na] @ org.jruby.rubyproc.call(rubyproc.java:290) [jruby-complete-1.7.9.jar:na] @ org.jruby.rubyproc.call(rubyproc.java:224) [jruby-complete-1.7.9.jar:na] @ org.jruby.rubyproc$invoker$i$0$0$call.call(rubyproc$invoker$i$0$0$call.gen) [jruby-complete-1.7.9.jar:na] @ org.jruby.internal.runtime.methods.dynamicmethod.call(dynamicmethod.java:202) [jruby-complete-1.7.9.jar:na] @ org.jruby.internal.runtime.methods.dynamicmethod.call(dynamicmethod.java:198) [jruby-complete-1.7.9.jar:na] @ org.jruby.runtime.callsite.cachingcallsite.call(cachingcallsite.java:134) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.callnoargnode.interpret(callnoargnode.java:60) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.newlinenode.interpret(newlinenode.java:105) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.ifnode.interpret(ifnode.java:118) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.newlinenode.interpret(newlinenode.java:105) [jruby-complete-1.7.9.jar:na] @ org.jruby.evaluator.astinterpreter.interpret_method(astinterpreter.java:74) [jruby-complete-1.7.9.jar:na] @ org.jruby.internal.runtime.methods.interpretedmethod.call(interpretedmethod.java:161) [jruby-complete-1.7.9.jar:na] @ org.jruby.internal.runtime.methods.defaultmethod.call(defaultmethod.java:190) [jruby-complete-1.7.9.jar:na] @ org.jruby.runtime.callsite.cachingcallsite.callblock(cachingcallsite.java:143) [jruby-complete-1.7.9.jar:na] @ org.jruby.runtime.callsite.cachingcallsite.calliter(cachingcallsite.java:154) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.fcallnoargblocknode.interpret(fcallnoargblocknode.java:32) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.newlinenode.interpret(newlinenode.java:105) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.rescuenode.executebody(rescuenode.java:221) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.rescuenode.interpret(rescuenode.java:116) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.beginnode.interpret(beginnode.java:83) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.newlinenode.interpret(newlinenode.java:105) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.blocknode.interpret(blocknode.java:71) [jruby-complete-1.7.9.jar:na] @ org.jruby.evaluator.astinterpreter.interpret_block(astinterpreter.java:112) [jruby-complete-1.7.9.jar:na] @ org.jruby.runtime.interpretedblock.evalblockbody(interpretedblock.java:384) [jruby-complete-1.7.9.jar:na] @ org.jruby.runtime.interpretedblock.yield(interpretedblock.java:357) [jruby-complete-1.7.9.jar:na] @ org.jruby.runtime.interpretedblock.yield(interpretedblock.java:312) [jruby-complete-1.7.9.jar:na] @ org.jruby.runtime.block.yield(block.java:142) [jruby-complete-1.7.9.jar:na] @ org.jruby.rubyarray.eachcommon(rubyarray.java:1606) [jruby-complete-1.7.9.jar:na] @ org.jruby.rubyarray.each(rubyarray.java:1613) [jruby-complete-1.7.9.jar:na] @ org.jruby.rubyarray$invoker$i$0$0$each.call(rubyarray$invoker$i$0$0$each.gen) [jruby-complete-1.7.9.jar:na] @ org.jruby.runtime.callsite.cachingcallsite.cacheandcall(cachingcallsite.java:316) [jruby-complete-1.7.9.jar:na] @ org.jruby.runtime.callsite.cachingcallsite.callblock(cachingcallsite.java:145) [jruby-complete-1.7.9.jar:na] @ org.jruby.runtime.callsite.cachingcallsite.calliter(cachingcallsite.java:154) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.callnoargblocknode.interpret(callnoargblocknode.java:64) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.newlinenode.interpret(newlinenode.java:105) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.blocknode.interpret(blocknode.java:71) [jruby-complete-1.7.9.jar:na] @ org.jruby.evaluator.astinterpreter.interpret_method(astinterpreter.java:74) [jruby-complete-1.7.9.jar:na] @ org.jruby.internal.runtime.methods.interpretedmethod.call(interpretedmethod.java:139) [jruby-complete-1.7.9.jar:na] @ org.jruby.internal.runtime.methods.defaultmethod.call(defaultmethod.java:182) [jruby-complete-1.7.9.jar:na] @ org.jruby.runtime.callsite.cachingcallsite.cacheandcall(cachingcallsite.java:306) [jruby-complete-1.7.9.jar:na] @ org.jruby.runtime.callsite.cachingcallsite.call(cachingcallsite.java:136) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.callnoargnode.interpret(callnoargnode.java:60) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.newlinenode.interpret(newlinenode.java:105) [jruby-complete-1.7.9.jar:na] @ org.jruby.evaluator.astinterpreter.interpret_method(astinterpreter.java:74) [jruby-complete-1.7.9.jar:na] @ org.jruby.internal.runtime.methods.interpretedmethod.call(interpretedmethod.java:225) [jruby-complete-1.7.9.jar:na] @ org.jruby.internal.runtime.methods.defaultmethod.call(defaultmethod.java:214) [jruby-complete-1.7.9.jar:na] @ org.jruby.runtime.callsite.cachingcallsite.cacheandcall(cachingcallsite.java:346) [jruby-complete-1.7.9.jar:na] @ org.jruby.runtime.callsite.cachingcallsite.call(cachingcallsite.java:204) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.fcalltwoargnode.interpret(fcalltwoargnode.java:38) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.newlinenode.interpret(newlinenode.java:105) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.whenoneargnode.whennotest(whenoneargnode.java:27) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.whenoneargnode.when(whenoneargnode.java:45) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.casenode.interpret(casenode.java:132) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.newlinenode.interpret(newlinenode.java:105) [jruby-complete-1.7.9.jar:na] @ org.jruby.evaluator.astinterpreter.interpret_method(astinterpreter.java:74) [jruby-complete-1.7.9.jar:na] @ org.jruby.internal.runtime.methods.interpretedmethod.call(interpretedmethod.java:182) [jruby-complete-1.7.9.jar:na] @ org.jruby.internal.runtime.methods.defaultmethod.call(defaultmethod.java:198) [jruby-complete-1.7.9.jar:na] @ org.jruby.runtime.callsite.cachingcallsite.cacheandcall(cachingcallsite.java:326) [jruby-complete-1.7.9.jar:na] @ org.jruby.runtime.callsite.cachingcallsite.call(cachingcallsite.java:170) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.calloneargnode.interpret(calloneargnode.java:57) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.newlinenode.interpret(newlinenode.java:105) [jruby-complete-1.7.9.jar:na] @ org.jruby.evaluator.astinterpreter.interpret_method(astinterpreter.java:74) [jruby-complete-1.7.9.jar:na] @ org.jruby.internal.runtime.methods.interpretedmethod.call(interpretedmethod.java:139) [jruby-complete-1.7.9.jar:na] @ org.jruby.internal.runtime.methods.defaultmethod.call(defaultmethod.java:182) [jruby-complete-1.7.9.jar:na] @ org.jruby.runtime.callsite.cachingcallsite.cacheandcall(cachingcallsite.java:306) [jruby-complete-1.7.9.jar:na] @ org.jruby.runtime.callsite.cachingcallsite.call(cachingcallsite.java:136) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.callnoargnode.interpret(callnoargnode.java:60) [jruby-complete-1.7.9.jar:na] @ org.jruby.ast.newlinenode.interpret(newlinenode.java:105) [jruby-complete-1.7.9.jar:na] @ org.jruby.evaluator.astinterpreter.interpret_method(astinterpreter.java:74) [jruby-complete-1.7.9.jar:na] @ org.jruby.internal.runtime.methods.interpretedmethod.call(interpretedmethod.java:112) [jruby-complete-1.7.9.jar:na] @ org.jruby.internal.runtime.methods.defaultmethod.call(defaultmethod.java:164) [jruby-complete-1.7.9.jar:na] @ rbcallupgrade_2043231604.callupgrade(rbcallupgrade_2043231604.gen:13) [jruby-complete-1.7.9.jar:na] @ org.sonar.server.ruby.platformrubybridge$1.trigger(platformrubybridge.java:52) [sonar-server-5.3.jar:na] @ org.sonar.server.db.migrations.platformdatabasemigration.doupgradedb(platformdatabasemigration.java:130) [sonar-server-5.3.jar:na] @ org.sonar.server.db.migrations.platformdatabasemigration.dodatabasemigration(platformdatabasemigration.java:112) [sonar-server-5.3.jar:na] @ org.sonar.server.db.migrations.platformdatabasemigration.access$000(platformdatabasemigration.java:37) [sonar-server-5.3.jar:na] @ org.sonar.server.db.migrations.platformdatabasemigration$1.run(platformdatabasemigration.java:100) [sonar-server-5.3.jar:na] @ java.util.concurrent.threadpoolexecutor.runworker(threadpoolexecutor.java:1145) [na:1.7.0_45] @ java.util.concurrent.threadpoolexecutor$worker.run(threadpoolexecutor.java:615) [na:1.7.0_45] @ java.lang.thread.run(thread.java:744) [na:1.7.0_45] caused by: java.sql.batchupdateexception: cannot execute statement: impossible write binary log since binlog_format = statement , @ least 1 table uses storage engine limited row-based logging. innodb limited row-logging when transaction isolation level read committed or read uncommitted. @ com.mysql.jdbc.preparedstatement.executepreparedbatchasmultistatement(preparedstatement.java:1446) ~[mysql-connector-java-5.1.35.jar:5.1.35] @ com.mysql.jdbc.preparedstatement.executebatch(preparedstatement.java:1277) ~[mysql-connector-java-5.1.35.jar:5.1.35] @ org.apache.commons.dbcp.delegatingstatement.executebatch(delegatingstatement.java:297) ~[commons-dbcp-1.4.jar:1.4] @ org.apache.commons.dbcp.delegatingstatement.executebatch(delegatingstatement.java:297) ~[commons-dbcp-1.4.jar:1.4] @ org.sonar.db.version.upsertimpl.addbatch(upsertimpl.java:41) ~[sonar-db-5.3.jar:na] @ org.sonar.db.version.massupdate$1.handle(massupdate.java:80) ~[sonar-db-5.3.jar:na] @ org.sonar.db.version.selectimpl.scroll(selectimpl.java:78) ~[sonar-db-5.3.jar:na] ... 159 common frames omitted caused by: java.sql.sqlexception: cannot execute statement: impossible write binary log since binlog_format = statement , @ least 1 table uses storage engine limited row-based logging. innodb limited row-logging when transaction isolation level read committed or read uncommitted. @ com.mysql.jdbc.sqlerror.createsqlexception(sqlerror.java:998) ~[mysql-connector-java-5.1.35.jar:5.1.35] @ com.mysql.jdbc.mysqlio.checkerrorpacket(mysqlio.java:3835) ~[mysql-connector-java-5.1.35.jar:5.1.35] @ com.mysql.jdbc.mysqlio.checkerrorpacket(mysqlio.java:3771) ~[mysql-connector-java-5.1.35.jar:5.1.35] @ com.mysql.jdbc.mysqlio.sendcommand(mysqlio.java:2435) ~[mysql-connector-java-5.1.35.jar:5.1.35] @ com.mysql.jdbc.mysqlio.sqlquerydirect(mysqlio.java:2582) ~[mysql-connector-java-5.1.35.jar:5.1.35] @ com.mysql.jdbc.connectionimpl.execsql(connectionimpl.java:2535) ~[mysql-connector-java-5.1.35.jar:5.1.35] @ com.mysql.jdbc.preparedstatement.executeinternal(preparedstatement.java:1911) ~[mysql-connector-java-5.1.35.jar:5.1.35] @ com.mysql.jdbc.preparedstatement.execute(preparedstatement.java:1203) ~[mysql-connector-java-5.1.35.jar:5.1.35] @ com.mysql.jdbc.preparedstatement.executepreparedbatchasmultistatement(preparedstatement.java:1386) ~[mysql-connector-java-5.1.35.jar:5.1.35] ... 165 common frames omitted 2016.01.27 09:32:44 info web[o.s.s.d.m.platformdatabasemigration] db migration failed | time=625ms 2016.01.27 09:32:44 error web[o.s.s.d.m.platformdatabasemigration] db migration or container restart failed. process ended exception org.jruby.exceptions.raiseexception: (standarderror) error has occurred, later migrations canceled: fail execute database migration: org.sonar.db.version.v52.feedeventscomponentuuid vagrant@devops:/opt/sonarqube-5.3/logs$
as turns out caused mysql/mariadb binlog_format setting. changed mixed in config file /etc/mysql/my.cnf
[mysqld] .. binlog_format = mixed it seems sonarqube 5.3 required now. didn't use setting 5.1.2
Comments
Post a Comment