Error during upgrade to Sonar 6.1 from Sonar 5.6.3 (LTS)

[niki...@gmail.com]

I started upgrade to Sonar 6.1 from Sonar 5.6.3 (LTS). I am using mySQL 5.7. The upgrade failed with following error:

2016.10.27 00:50:53 ERROR web[][o.s.s.p.d.m.DatabaseMigrator] Fail to execute database migration: org.sonar.db.version.v60.PopulateUuidPathColumnOnProjects

java.lang.IllegalStateException: Error during processing of row: [uuid=AVf3j0G_DwKqDxnw716-,project_uuid=AVf3j0G_DwKqDxnw7169]

at org.sonar.db.version.SelectImpl.newExceptionWithRowDetails(SelectImpl.java:89) ~[sonar-db-6.1.jar:na]

at org.sonar.db.version.SelectImpl.scroll(SelectImpl.java:81) ~[sonar-db-6.1.jar:na]

at org.sonar.db.version.MassUpdate.execute(MassUpdate.java:91) ~[sonar-db-6.1.jar:na]

at org.sonar.db.version.v60.PopulateUuidPathColumnOnProjects.handleRoot(PopulateUuidPathColumnOnProjects.java:83) ~[sonar-db-6.1.jar:na]

at org.sonar.db.version.v60.PopulateUuidPathColumnOnProjects.execute(PopulateUuidPathColumnOnProjects.java:60) ~[sonar-db-6.1.jar:na]

at org.sonar.db.version.BaseDataChange.execute(BaseDataChange.java:45) ~[sonar-db-6.1.jar:na]

at org.sonar.server.platform.db.migrations.DatabaseMigrator.executeMigration(DatabaseMigrator.java:95) ~[sonar-server-6.1.jar:na]

at sun.reflect.GeneratedMethodAccessor27.invoke(Unknown Source) ~[na:na]

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_111]

at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_111]

at org.jruby.javasupport.JavaMethod.invokeDirectWithExceptionHandling(JavaMethod.java:455) [jruby-complete-1.7.9.jar:na]

at org.jruby.javasupport.JavaMethod.invokeDirect(JavaMethod.java:316) [jruby-complete-1.7.9.jar:na]

at org.jruby.java.invokers.InstanceMethodInvoker.call(InstanceMethodInvoker.java:61) [jruby-complete-1.7.9.jar:na]

at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:168) [jruby-complete-1.7.9.jar:na]

at org.jruby.ast.CallOneArgNode.interpret(CallOneArgNode.java:57) [jruby-complete-1.7.9.jar:na]

at org.jruby.ast.NewlineNode.interpret(NewlineNode.java:105) [jruby-complete-1.7.9.jar:na]

at org.jruby.evaluator.ASTInterpreter.INTERPRET_METHOD(ASTInterpreter.java:74) [jruby-complete-1.7.9.jar:na]

at org.jruby.internal.runtime.methods.InterpretedMethod.call(InterpretedMethod.java:182) [jruby-complete-1.7.9.jar:na]

at org.jruby.internal.runtime.methods.DefaultMethod.call(DefaultMethod.java:198) [jruby-complete-1.7.9.jar:na]

at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:326) [jruby-complete-1.7.9.jar:na]

at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:170) [jruby-complete-1.7.9.jar:na]

at org.jruby.ast.FCallOneArgNode.interpret(FCallOneArgNode.java:36) [jruby-complete-1.7.9.jar:na]

at org.jruby.ast.NewlineNode.interpret(NewlineNode.java:105) [jruby-complete-1.7.9.jar:na]

at org.jruby.evaluator.ASTInterpreter.INTERPRET_METHOD(ASTInterpreter.java:74) [jruby-complete-1.7.9.jar:na]

at org.jruby.internal.runtime.methods.InterpretedMethod.call(InterpretedMethod.java:161) [jruby-complete-1.7.9.jar:na]

at org.jruby.internal.runtime.methods.DefaultMethod.call(DefaultMethod.java:190) [jruby-complete-1.7.9.jar:na]

at org.jruby.internal.runtime.methods.AliasMethod.call(AliasMethod.java:81) [jruby-complete-1.7.9.jar:na]

at org.jruby.RubyClass.finvoke(RubyClass.java:527) [jruby-complete-1.7.9.jar:na]

at org.jruby.RubyBasicObject.send(RubyBasicObject.java:2590) [jruby-complete-1.7.9.jar:na]

at org.jruby.RubyKernel.send(RubyKernel.java:2223) [jruby-complete-1.7.9.jar:na]

at org.jruby.RubyKernel$INVOKER$s$send.call(RubyKernel$INVOKER$s$send.gen) [jruby-complete-1.7.9.jar:na]

at org.jruby.internal.runtime.methods.JavaMethod$JavaMethodOneOrNBlock.call(JavaMethod.java:350) [jruby-complete-1.7.9.jar:na]

at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:326) [jruby-complete-1.7.9.jar:na]

at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:170) [jruby-complete-1.7.9.jar:na]

at rubyjit.ActiveRecord::Migration$$migrate_18492D5320618EC94E0F22A95C6CD80EEFB6A64D1465743607.block_0$RUBY$__file__(/Disk1/home/sonar/sonarqube-6.1/web/WEB-INF/gems/gems/activerecord-2.3.15/lib/active_record/migration.rb:282) [jruby-complete-1.7.9.jar:na]

at rubyjit$ActiveRecord::Migration$$migrate_18492D5320618EC94E0F22A95C6CD80EEFB6A64D1465743607$block_0$RUBY$__file__.call(rubyjit$ActiveRecord::Migration$$migrate_18492D5320618EC94E0F22A95C6CD80EEFB6A64D1465743607$block_0$RUBY$__file__) [jruby-complete-1.7.9.jar:na]

at org.jruby.runtime.CompiledBlock.yield(CompiledBlock.java:112) [jruby-complete-1.7.9.jar:na]

at org.jruby.runtime.CompiledBlock.yield(CompiledBlock.java:95) [jruby-complete-1.7.9.jar:na]

at org.jruby.runtime.CompiledBlock.yieldSpecific(CompiledBlock.java:75) [jruby-complete-1.7.9.jar:na]

at org.jruby.runtime.Block.yieldSpecific(Block.java:111) [jruby-complete-1.7.9.jar:na]

at rubyjit.Benchmark$$measure_5AD958E31099104265C835112D1C30E23EEF72B11465743607.__file__(jar:file:/Disk1/home/sonar/sonarqube-6.1/lib/server/jruby-complete-1.7.9.jar!/META-INF/jruby.home/lib/ruby/1.8/benchmark.rb:293) [jruby-complete-1.7.9.jar:na]

at rubyjit.Benchmark$$measure_5AD958E31099104265C835112D1C30E23EEF72B11465743607.__file__(jar:file:/Disk1/home/sonar/sonarqube-6.1/lib/server/jruby-complete-1.7.9.jar!/META-INF/jruby.home/lib/ruby/1.8/benchmark.rb) [jruby-complete-1.7.9.jar:na]

at org.jruby.ast.executable.AbstractScript.__file__(AbstractScript.java:38) [jruby-complete-1.7.9.jar:na]

at org.jruby.internal.runtime.methods.JittedMethod.call(JittedMethod.java:161) [jruby-complete-1.7.9.jar:na]

at org.jruby.internal.runtime.methods.DefaultMethod.call(DefaultMethod.java:193) [jruby-complete-1.7.9.jar:na]

at org.jruby.internal.runtime.methods.WrapperMethod.call(WrapperMethod.java:74) [jruby-complete-1.7.9.jar:na]

at org.jruby.runtime.callsite.CachingCallSite.callBlock(CachingCallSite.java:143) [jruby-complete-1.7.9.jar:na]

at org.jruby.runtime.callsite.CachingCallSite.callIter(CachingCallSite.java:154) [jruby-complete-1.7.9.jar:na]

at rubyjit.ActiveRecord::Migration$$migrate_18492D5320618EC94E0F22A95C6CD80EEFB6A64D1465743607.__file__(/Disk1/home/sonar/sonarqube-6.1/web/WEB-INF/gems/gems/activerecord-2.3.15/lib/active_record/migration.rb:282) [jruby-complete-1.7.9.jar:na]

at rubyjit.ActiveRecord::Migration$$migrate_18492D5320618EC94E0F22A95C6CD80EEFB6A64D1465743607.__file__(/Disk1/home/sonar/sonarqube-6.1/web/WEB-INF/gems/gems/activerecord-2.3.15/lib/active_record/migration.rb) [jruby-complete-1.7.9.jar:na]

at org.jruby.internal.runtime.methods.JittedMethod.call(JittedMethod.java:201) [jruby-complete-1.7.9.jar:na]

at org.jruby.RubyClass.finvoke(RubyClass.java:567) [jruby-complete-1.7.9.jar:na]

at org.jruby.RubyBasicObject.send(RubyBasicObject.java:2595) [jruby-complete-1.7.9.jar:na]

at org.jruby.RubyKernel.send(RubyKernel.java:2227) [jruby-complete-1.7.9.jar:na]

at org.jruby.RubyKernel$INVOKER$s$send.call(RubyKernel$INVOKER$s$send.gen) [jruby-complete-1.7.9.jar:na]

at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:356) [jruby-complete-1.7.9.jar:na]

at org.jruby.runtime.callsite.CachingCallSite.callBlock(CachingCallSite.java:213) [jruby-complete-1.7.9.jar:na]

at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:217) [jruby-complete-1.7.9.jar:na]

at org.jruby.runtime.callsite.CachingCallSite.callVarargs(CachingCallSite.java:114) [jruby-complete-1.7.9.jar:na]

at rubyjit.ActiveRecord::MigrationProxy$$migrate_F82210E5123BB0207C1ADAC1D40F1F34A4C5A1671465743607.chained_0_rescue_1$RUBY$SYNTHETIC__file__(/Disk1/home/sonar/sonarqube-6.1/web/WEB-INF/gems/gems/activerecord-2.3.15/lib/active_record/migration.rb:365) [jruby-complete-1.7.9.jar:na]

at rubyjit.ActiveRecord::MigrationProxy$$migrate_F82210E5123BB0207C1ADAC1D40F1F34A4C5A1671465743607.__file__(/Disk1/home/sonar/sonarqube-6.1/web/WEB-INF/gems/gems/activerecord-2.3.15/lib/active_record/migration.rb) [jruby-complete-1.7.9.jar:na]

at rubyjit.ActiveRecord::MigrationProxy$$migrate_F82210E5123BB0207C1ADAC1D40F1F34A4C5A1671465743607.__file__(/Disk1/home/sonar/sonarqube-6.1/web/WEB-INF/gems/gems/activerecord-2.3.15/lib/active_record/migration.rb) [jruby-complete-1.7.9.jar:na]

at org.jruby.ast.executable.AbstractScript.__file__(AbstractScript.java:42) [jruby-complete-1.7.9.jar:na]

at org.jruby.internal.runtime.methods.JittedMethod.call(JittedMethod.java:181) [jruby-complete-1.7.9.jar:na]

at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:168) [jruby-complete-1.7.9.jar:na]

at org.jruby.ast.CallOneArgNode.interpret(CallOneArgNode.java:57) [jruby-complete-1.7.9.jar:na]

at org.jruby.ast.NewlineNode.interpret(NewlineNode.java:105) [jruby-complete-1.7.9.jar:na]

at org.jruby.ast.BlockNode.interpret(BlockNode.java:71) [jruby-complete-1.7.9.jar:na]

at org.jruby.evaluator.ASTInterpreter.INTERPRET_BLOCK(ASTInterpreter.java:112) [jruby-complete-1.7.9.jar:na]

at org.jruby.runtime.InterpretedBlock.evalBlockBody(InterpretedBlock.java:384) [jruby-complete-1.7.9.jar:na]

at org.jruby.runtime.InterpretedBlock.yield(InterpretedBlock.java:336) [jruby-complete-1.7.9.jar:na]

at org.jruby.runtime.BlockBody.call(BlockBody.java:73) [jruby-complete-1.7.9.jar:na]

at org.jruby.runtime.Block.call(Block.java:101) [jruby-complete-1.7.9.jar:na]

at org.jruby.RubyProc.call(RubyProc.java:290) [jruby-complete-1.7.9.jar:na]

at org.jruby.RubyProc.call(RubyProc.java:224) [jruby-complete-1.7.9.jar:na]

at org.jruby.RubyProc$INVOKER$i$0$0$call.call(RubyProc$INVOKER$i$0$0$call.gen) [jruby-complete-1.7.9.jar:na]

at org.jruby.internal.runtime.methods.DynamicMethod.call(DynamicMethod.java:202) [jruby-complete-1.7.9.jar:na]

at org.jruby.internal.runtime.methods.DynamicMethod.call(DynamicMethod.java:198) [jruby-complete-1.7.9.jar:na]

at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:134) [jruby-complete-1.7.9.jar:na]

at rubyjit.ActiveRecord::Migrator$$ddl_transaction_3154E5716AE12F6E5915C8C10138A66869AC914C1465743607.__file__(/Disk1/home/sonar/sonarqube-6.1/web/WEB-INF/gems/gems/activerecord-2.3.15/lib/active_record/migration.rb:576) [jruby-complete-1.7.9.jar:na]

at rubyjit.ActiveRecord::Migrator$$ddl_transaction_3154E5716AE12F6E5915C8C10138A66869AC914C1465743607.__file__(/Disk1/home/sonar/sonarqube-6.1/web/WEB-INF/gems/gems/activerecord-2.3.15/lib/active_record/migration.rb) [jruby-complete-1.7.9.jar:na]

at org.jruby.internal.runtime.methods.JittedMethod.call(JittedMethod.java:161) [jruby-complete-1.7.9.jar:na]

at org.jruby.runtime.callsite.CachingCallSite.callBlock(CachingCallSite.java:143) [jruby-complete-1.7.9.jar:na]

at org.jruby.runtime.callsite.CachingCallSite.callIter(CachingCallSite.java:154) [jruby-complete-1.7.9.jar:na]

at org.jruby.ast.FCallNoArgBlockNode.interpret(FCallNoArgBlockNode.java:32) [jruby-complete-1.7.9.jar:na]

at org.jruby.ast.NewlineNode.interpret(NewlineNode.java:105) [jruby-complete-1.7.9.jar:na]

at org.jruby.ast.RescueNode.executeBody(RescueNode.java:221) [jruby-complete-1.7.9.jar:na]

at org.jruby.ast.RescueNode.interpret(RescueNode.java:116) [jruby-complete-1.7.9.jar:na]

at org.jruby.ast.BeginNode.interpret(BeginNode.java:83) [jruby-complete-1.7.9.jar:na]

at org.jruby.ast.NewlineNode.interpret(NewlineNode.java:105) [jruby-complete-1.7.9.jar:na]

at org.jruby.ast.BlockNode.interpret(BlockNode.java:71) [jruby-complete-1.7.9.jar:na]

at org.jruby.evaluator.ASTInterpreter.INTERPRET_BLOCK(ASTInterpreter.java:112) [jruby-complete-1.7.9.jar:na]

at org.jruby.runtime.InterpretedBlock.evalBlockBody(InterpretedBlock.java:384) [jruby-complete-1.7.9.jar:na]

at org.jruby.runtime.InterpretedBlock.yield(InterpretedBlock.java:357) [jruby-complete-1.7.9.jar:na]

at org.jruby.runtime.InterpretedBlock.yield(InterpretedBlock.java:312) [jruby-complete-1.7.9.jar:na]

at org.jruby.runtime.Block.yield(Block.java:142) [jruby-complete-1.7.9.jar:na]

at org.jruby.RubyArray.eachCommon(RubyArray.java:1606) [jruby-complete-1.7.9.jar:na]

at org.jruby.RubyArray.each(RubyArray.java:1613) [jruby-complete-1.7.9.jar:na]

at org.jruby.RubyArray$INVOKER$i$0$0$each.call(RubyArray$INVOKER$i$0$0$each.gen) [jruby-complete-1.7.9.jar:na]

at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:316) [jruby-complete-1.7.9.jar:na]

at org.jruby.runtime.callsite.CachingCallSite.callBlock(CachingCallSite.java:145) [jruby-complete-1.7.9.jar:na]

at org.jruby.runtime.callsite.CachingCallSite.callIter(CachingCallSite.java:154) [jruby-complete-1.7.9.jar:na]

at org.jruby.ast.CallNoArgBlockNode.interpret(CallNoArgBlockNode.java:64) [jruby-complete-1.7.9.jar:na]

at org.jruby.ast.NewlineNode.interpret(NewlineNode.java:105) [jruby-complete-1.7.9.jar:na]

at org.jruby.ast.BlockNode.interpret(BlockNode.java:71) [jruby-complete-1.7.9.jar:na]

at org.jruby.evaluator.ASTInterpreter.INTERPRET_METHOD(ASTInterpreter.java:74) [jruby-complete-1.7.9.jar:na]

at org.jruby.internal.runtime.methods.InterpretedMethod.call(InterpretedMethod.java:139) [jruby-complete-1.7.9.jar:na]

at org.jruby.internal.runtime.methods.DefaultMethod.call(DefaultMethod.java:182) [jruby-complete-1.7.9.jar:na]

at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:306) [jruby-complete-1.7.9.jar:na]

at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:136) [jruby-complete-1.7.9.jar:na]

at org.jruby.ast.CallNoArgNode.interpret(CallNoArgNode.java:60) [jruby-complete-1.7.9.jar:na]

at org.jruby.ast.NewlineNode.interpret(NewlineNode.java:105) [jruby-complete-1.7.9.jar:na]

at org.jruby.evaluator.ASTInterpreter.INTERPRET_METHOD(ASTInterpreter.java:74) [jruby-complete-1.7.9.jar:na]

at org.jruby.internal.runtime.methods.InterpretedMethod.call(InterpretedMethod.java:225) [jruby-complete-1.7.9.jar:na]

at org.jruby.internal.runtime.methods.DefaultMethod.call(DefaultMethod.java:214) [jruby-complete-1.7.9.jar:na]

at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:346) [jruby-complete-1.7.9.jar:na]

at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:204) [jruby-complete-1.7.9.jar:na]

at org.jruby.ast.FCallTwoArgNode.interpret(FCallTwoArgNode.java:38) [jruby-complete-1.7.9.jar:na]

at org.jruby.ast.NewlineNode.interpret(NewlineNode.java:105) [jruby-complete-1.7.9.jar:na]

at org.jruby.ast.WhenOneArgNode.whenNoTest(WhenOneArgNode.java:27) [jruby-complete-1.7.9.jar:na]

at org.jruby.ast.WhenOneArgNode.when(WhenOneArgNode.java:45) [jruby-complete-1.7.9.jar:na]

at org.jruby.ast.CaseNode.interpret(CaseNode.java:132) [jruby-complete-1.7.9.jar:na]

at org.jruby.ast.NewlineNode.interpret(NewlineNode.java:105) [jruby-complete-1.7.9.jar:na]

at org.jruby.evaluator.ASTInterpreter.INTERPRET_METHOD(ASTInterpreter.java:74) [jruby-complete-1.7.9.jar:na]

at org.jruby.internal.runtime.methods.InterpretedMethod.call(InterpretedMethod.java:182) [jruby-complete-1.7.9.jar:na]

at org.jruby.internal.runtime.methods.DefaultMethod.call(DefaultMethod.java:198) [jruby-complete-1.7.9.jar:na]

at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:326) [jruby-complete-1.7.9.jar:na]

at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:170) [jruby-complete-1.7.9.jar:na]

at org.jruby.ast.CallOneArgNode.interpret(CallOneArgNode.java:57) [jruby-complete-1.7.9.jar:na]

at org.jruby.ast.NewlineNode.interpret(NewlineNode.java:105) [jruby-complete-1.7.9.jar:na]

at org.jruby.evaluator.ASTInterpreter.INTERPRET_METHOD(ASTInterpreter.java:74) [jruby-complete-1.7.9.jar:na]

at org.jruby.internal.runtime.methods.InterpretedMethod.call(InterpretedMethod.java:139) [jruby-complete-1.7.9.jar:na]

at org.jruby.internal.runtime.methods.DefaultMethod.call(DefaultMethod.java:182) [jruby-complete-1.7.9.jar:na]

at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:306) [jruby-complete-1.7.9.jar:na]

at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:136) [jruby-complete-1.7.9.jar:na]

at org.jruby.ast.CallNoArgNode.interpret(CallNoArgNode.java:60) [jruby-complete-1.7.9.jar:na]

at org.jruby.ast.NewlineNode.interpret(NewlineNode.java:105) [jruby-complete-1.7.9.jar:na]

at org.jruby.evaluator.ASTInterpreter.INTERPRET_METHOD(ASTInterpreter.java:74) [jruby-complete-1.7.9.jar:na]

at org.jruby.internal.runtime.methods.InterpretedMethod.call(InterpretedMethod.java:112) [jruby-complete-1.7.9.jar:na]

at org.jruby.internal.runtime.methods.DefaultMethod.call(DefaultMethod.java:164) [jruby-complete-1.7.9.jar:na]

at RbCallUpgrade_1565430607.callUpgrade(RbCallUpgrade_1565430607.gen:13) [jruby-complete-1.7.9.jar:na]

at org.sonar.server.platform.db.migrations.PlatformDatabaseMigration.doUpgradeDb(PlatformDatabaseMigration.java:126) ~[sonar-server-6.1.jar:na]

at org.sonar.server.platform.db.migrations.PlatformDatabaseMigration.doDatabaseMigration(PlatformDatabaseMigration.java:108) ~[sonar-server-6.1.jar:na]

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) ~[na:1.8.0_111]

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) ~[na:1.8.0_111]

at java.lang.Thread.run(Thread.java:745) ~[na:1.8.0_111]

Caused by: java.lang.NullPointerException: null

at org.sonar.db.version.v60.PopulateUuidPathColumnOnProjects$Snapshot.access$300(PopulateUuidPathColumnOnProjects.java:137) ~[sonar-db-6.1.jar:na]

at org.sonar.db.version.v60.PopulateUuidPathColumnOnProjects.lambda$handleComponent$4(PopulateUuidPathColumnOnProjects.java:120) ~[sonar-db-6.1.jar:na]

at java.util.stream.LongPipeline$3$1.accept(LongPipeline.java:231) ~[na:1.8.0_111]

at java.util.Spliterators$LongArraySpliterator.forEachRemaining(Spliterators.java:1115) ~[na:1.8.0_111]

at java.util.Spliterator$OfLong.forEachRemaining(Spliterator.java:757) ~[na:1.8.0_111]

at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:481) ~[na:1.8.0_111]

at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:471) ~[na:1.8.0_111]

at java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:708) ~[na:1.8.0_111]

at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234) ~[na:1.8.0_111]

at java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:499) ~[na:1.8.0_111]

at org.sonar.db.version.v60.PopulateUuidPathColumnOnProjects.handleComponent(PopulateUuidPathColumnOnProjects.java:121) ~[sonar-db-6.1.jar:na]

at org.sonar.db.version.v60.PopulateUuidPathColumnOnProjects.lambda$handleRoot$2(PopulateUuidPathColumnOnProjects.java:83) ~[sonar-db-6.1.jar:na]

at org.sonar.db.version.MassUpdate.callSingleHandler(MassUpdate.java:117) ~[sonar-db-6.1.jar:na]

at org.sonar.db.version.MassUpdate.lambda$execute$0(MassUpdate.java:91) ~[sonar-db-6.1.jar:na]

at org.sonar.db.version.SelectImpl.scroll(SelectImpl.java:78) ~[sonar-db-6.1.jar:na]

... 144 common frames omitted

2016.10.27 00:50:53 INFO  web[][o.s.s.p.d.m.PlatformDatabaseMigration] DB migration failed | time=25919744ms

2016.10.27 00:50:53 ERROR web[][o.s.s.p.d.m.PlatformDatabaseMigration] DB Migration or container restart failed. Process ended with an exception

org.jruby.exceptions.RaiseException: (StandardError) An error has occurred, all later migrations canceled:

Any help is appreciated.

[Simona Avornicesei]

Hi,

LTS version was released prior to 6.1 so you can't upgrade. You would actually need downgrade but that's unsupported.

You should wait for the next 6.x LTS version if you want to move from rolling release to LTS.

All the best,
Simo

[stoyan....@gmail.com]

Hi Simo,

Following the upgrade wiki http://docs.sonarqube.org/display/SONAR/Upgrading ->

Upgrading across multiple versions is handled automatically. However, if in your migration path you have an LTS version, you must first migrate to this LTS and then migrate to your target version.

Example 1 : 4.2 -> 6.1, migration path is 4.2 -> 4.5.7 LTS -> 5.6 LTS -> 6.1

You mean that it is not possible to migrate from 5.6 LTS -> 6.1 since 6.1. is not LTS. Right? 

All the best,

Stoyan

[G. Ann Campbell]

Hi,

You can migrate from an LTS directly to any subsequent version up to and including the next LTS. So 5.6->6.1 works fine.

Ann

[Simona Avornicesei]

Hi,

My bad. I misread the issue (thought about downgrade).

Thanks,
Simo

[niki...@gmail.com]

Hi all,

Thanks for your help!. The issue still exist. I also find another similar reported issue but without answer.

http://stackoverflow.com/questions/40080719/unable-to-upgrade-sonarqube-6-1-error-at-row-during-uuid-path-upgrade

Kind Regards,

Nikolay

[Simona Avornicesei]

Hi,

Did you try to upgrade to 6.0 version first (please note that it might take some time, depending on the DB size)?

All the best,
Simo

[niki...@gmail.com]

Hi Simo,

Actually the original version of sonar is 4.5.1. I followed the upgrade wiki.

I migrated first to 4.5.7 (LTS). After that to 5.6.3. On 5.6.3 i made a backup and tested the sonar. It works fine. After that I tried to migrate to 6.0 but it failed with same error. I restored backup (backup is fine I tested it) and tried a different combination of settings and tried to migrate to 6.1. All my tries failed with the same issue.

[Simona Avornicesei]

Yeah, it's a bumpy ride upgrading to the latest from an old release because of deprecated, unmaintained and/or incompatible plugins.

Please make sure that you're not using any incompatible plugins in SQ 6.0 - see here the compatibility list.

All the best,
Simo

[m...@soloplan.de]

Hi,

I hit the same problem today. I'm also updating from 5.6.3 (LTS) to 6.1, but I'm on an Oracle database. Pretty much the same callstack with

Fail to execute database migration: org.sonar.db.version.v60.PopulateUuidPathColumnOnProjects

at the end.
Can I provide any additional information so that this can be fixed?

Bye,
Markus

[Simon Brandhof]

Hi,

This bug in DB migration is tracked in https://jira.sonarsource.com/browse/SONAR-8391.

Sorry for the inconvenience. 

Regards

--
You received this message because you are subscribed to the Google Groups "SonarQube" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sonarqube+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/sonarqube/1898151f-0e99-4638-b56f-f88af1589b47%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Simon BRANDHOF | SonarSource
Tech Lead & Co-Founder
http://twitter.com/SimonBrandhof