Uploaded image for project: 'SonarQube'
  1. SonarQube
  2. SONAR-6846

Database migration can fail on step FeedFileSources

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.0
    • Fix Version/s: 5.6
    • Component/s: Database
    • Labels:

      Description

      For an unexplained reason the table SNAPSHOT_SOURCES can contain multiple rows for the same snapshot. That's not possible with the new table FILE_SOURCES as a unique index is defined.

      2015.09.07 17:19:05 INFO  web[DbMigration] ==  CreateFileSources: migrated (1.6710s) =====================================
      2015.09.07 17:19:05 INFO  web[DbMigration]
      2015.09.07 17:19:05 INFO  web[DbMigration] ==  FeedFileSources: migrating ================================================
      2015.09.07 17:20:05 INFO  web[o.s.s.d.m.MassUpdate] 16249 files processed (270 items/sec)
      2015.09.07 17:20:23 ERROR web[o.s.s.d.m.DatabaseMigrator] Fail to execute database migration: org.sonar.server.db.migrations.v50.FeedFileSources
      java.lang.IllegalStateException: Error during processing of row: [uuid=ac0bab68-341f-44ab-9b65-da5d23f96f04,uuid=cdbf23db-1885-423d-8e7f-378c01f4baff,data=xxx,updated_at=2015-07-21 15:03:18.0,text_value=null,measure_data=null,text_value=null,measure_data=null,text_value=null,measure_data=null,text_value=xxx,measure_data=null]
              at org.sonar.server.db.migrations.SelectImpl.newExceptionWithRowDetails(SelectImpl.java:90) ~[sonar-server-5.1.1.jar:na]
              at org.sonar.server.db.migrations.SelectImpl.scroll(SelectImpl.java:82) ~[sonar-server-5.1.1.jar:na]
              at org.sonar.server.db.migrations.MassUpdate.execute(MassUpdate.java:76) ~[sonar-server-5.1.1.jar:na]
              at org.sonar.server.db.migrations.v50.FeedFileSources.execute(FeedFileSources.java:280) ~[sonar-server-5.1.1.jar:na]
              at org.sonar.server.db.migrations.BaseDataChange.execute(BaseDataChange.java:45) ~[sonar-server-5.1.1.jar:na]
              at org.sonar.server.db.migrations.DatabaseMigrator.executeMigration(DatabaseMigrator.java:94) ~[sonar-server-5.1.1.jar:na]
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.7.0_75]
              at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[na:1.7.0_75]
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.7.0_75]
              at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_75]
              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 org.jruby.ast.FCallOneArgNode.interpret(FCallOneArgNode.java:36) [jruby-complete-1.7.9.jar:na]
              at org.jruby.ast.LocalAsgnNode.interpret(LocalAsgnNode.java:123) [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_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:303) [jruby-complete-1.7.9.jar:na]
              at org.jruby.runtime.InterpretedBlock.yieldSpecific(InterpretedBlock.java:229) [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_5AD958E31099104265C835112D1C30E23EEF72B1198798334.__file__(jar:file:/sonarqube-5.1.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_5AD958E31099104265C835112D1C30E23EEF72B1198798334.__file__(jar:file:/sonarqube-5.1.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 org.jruby.ast.CallNoArgBlockNode.interpret(CallNoArgBlockNode.java:64) [jruby-complete-1.7.9.jar:na]
              at org.jruby.ast.LocalAsgnNode.interpret(LocalAsgnNode.java:123) [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:204) [jruby-complete-1.7.9.jar:na]
              at org.jruby.internal.runtime.methods.DefaultMethod.call(DefaultMethod.java:206) [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.ast.CallSpecialArgBlockPassNode.interpret(CallSpecialArgBlockPassNode.java:66) [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.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.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 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.ast.IfNode.interpret(IfNode.java:118) [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.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.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.ast.BlockNode.interpret(BlockNode.java:71) [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.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:228) [jruby-complete-1.7.9.jar:na]
              at org.jruby.internal.runtime.RubyRunnable.run(RubyRunnable.java:97) [jruby-complete-1.7.9.jar:na]
              at java.lang.Thread.run(Thread.java:745) [na:1.7.0_75]
      Caused by: java.sql.BatchUpdateException: Duplicata du champ '5bc67c6f-67c7-41c3-9ee6-0752f99c542b' pour la clef 2
              at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1815) ~[mysql-connector-java-5.1.34.jar:5.1.34]
              at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1277) ~[mysql-connector-java-5.1.34.jar:5.1.34]
              at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) ~[commons-dbcp-1.4.jar:1.4]
              at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) ~[commons-dbcp-1.4.jar:1.4]
              at org.sonar.server.db.migrations.UpsertImpl.addBatch(UpsertImpl.java:42) ~[sonar-server-5.1.1.jar:na]
              at org.sonar.server.db.migrations.MassUpdate$1.handle(MassUpdate.java:80) ~[sonar-server-5.1.1.jar:na]
              at org.sonar.server.db.migrations.SelectImpl.scroll(SelectImpl.java:79) ~[sonar-server-5.1.1.jar:na]
              ... 161 common frames omitted
      Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicata du champ '5bc67c6f-67c7-41c3-9ee6-0752f99c542b' pour la clef 2
              at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.7.0_75]
              at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) ~[na:1.7.0_75]
              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_75]
              at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_75]
              at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) ~[mysql-connector-java-5.1.34.jar:5.1.34]
              at com.mysql.jdbc.Util.getInstance(Util.java:360) ~[mysql-connector-java-5.1.34.jar:5.1.34]
              at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:971) ~[mysql-connector-java-5.1.34.jar:5.1.34]
              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) ~[mysql-connector-java-5.1.34.jar:5.1.34]
              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) ~[mysql-connector-java-5.1.34.jar:5.1.34]
              at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) ~[mysql-connector-java-5.1.34.jar:5.1.34]
              at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) ~[mysql-connector-java-5.1.34.jar:5.1.34]
              at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) ~[mysql-connector-java-5.1.34.jar:5.1.34]
              at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) ~[mysql-connector-java-5.1.34.jar:5.1.34]
              at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2141) ~[mysql-connector-java-5.1.34.jar:5.1.34]
              at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1773) ~[mysql-connector-java-5.1.34.jar:5.1.34]
              ... 167 common frames omitted
      2015.09.07 17:20:23 ERROR web[o.s.s.ui.JRubyFacade] Fail to upgrade database
      An error has occurred, all later migrations canceled:
      
      Fail to execute database migration: org.sonar.server.db.migrations.v50.FeedFileSources
              org.sonar.server.db.migrations.DatabaseMigrator.executeMigration(DatabaseMigrator.java:100)
              sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
              sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
              java.lang.reflect.Method.invoke(Method.java:606)
              org.jruby.javasupport.JavaMethod.invokeDirectWithExceptionHandling(JavaMethod.java:455)
              org.jruby.javasupport.JavaMethod.invokeDirect(JavaMethod.java:316)
              org.jruby.java.invokers.InstanceMethodInvoker.call(InstanceMethodInvoker.java:61)
              org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:168)
              org.jruby.ast.CallOneArgNode.interpret(CallOneArgNode.java:57)
              org.jruby.ast.NewlineNode.interpret(NewlineNode.java:105)
              org.jruby.evaluator.ASTInterpreter.INTERPRET_METHOD(ASTInterpreter.java:74)
              org.jruby.internal.runtime.methods.InterpretedMethod.call(InterpretedMethod.java:182)
              org.jruby.internal.runtime.methods.DefaultMethod.call(DefaultMethod.java:198)
              org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:326)
              org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:170)
              org.jruby.ast.FCallOneArgNode.interpret(FCallOneArgNode.java:36)
              org.jruby.ast.NewlineNode.interpret(NewlineNode.java:105)
              org.jruby.evaluator.ASTInterpreter.INTERPRET_METHOD(ASTInterpreter.java:74)
              org.jruby.internal.runtime.methods.InterpretedMethod.call(InterpretedMethod.java:161)
              org.jruby.internal.runtime.methods.DefaultMethod.call(DefaultMethod.java:190)
              org.jruby.internal.runtime.methods.AliasMethod.call(AliasMethod.java:81)
              org.jruby.RubyClass.finvoke(RubyClass.java:527)
              org.jruby.RubyBasicObject.send(RubyBasicObject.java:2590)
              org.jruby.RubyKernel.send(RubyKernel.java:2223)
              org.jruby.RubyKernel$INVOKER$s$send.call(RubyKernel$INVOKER$s$send.gen)
              org.jruby.internal.runtime.methods.JavaMethod$JavaMethodOneOrNBlock.call(JavaMethod.java:350)
              org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:326)
              org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:170)
              org.jruby.ast.FCallOneArgNode.interpret(FCallOneArgNode.java:36)
              org.jruby.ast.LocalAsgnNode.interpret(LocalAsgnNode.java:123)
              org.jruby.ast.NewlineNode.interpret(NewlineNode.java:105)
              org.jruby.evaluator.ASTInterpreter.INTERPRET_BLOCK(ASTInterpreter.java:112)
              org.jruby.runtime.InterpretedBlock.evalBlockBody(InterpretedBlock.java:384)
              org.jruby.runtime.InterpretedBlock.yield(InterpretedBlock.java:303)
              org.jruby.runtime.InterpretedBlock.yieldSpecific(InterpretedBlock.java:229)
              org.jruby.runtime.Block.yieldSpecific(Block.java:111)
              rubyjit.Benchmark$$measure_5AD958E31099104265C835112D1C30E23EEF72B1198798334.__file__(jar:file:/sonarqube-5.1.1/lib/server/jruby-complete-1.7.9.jar!/META-INF/jruby.home/lib/ruby/1.8/benchmark.rb:293)
              rubyjit.Benchmark$$measure_5AD958E31099104265C835112D1C30E23EEF72B1198798334.__file__(jar:file:/sonarqube-5.1.1/lib/server/jruby-complete-1.7.9.jar!/META-INF/jruby.home/lib/ruby/1.8/benchmark.rb)
              org.jruby.ast.executable.AbstractScript.__file__(AbstractScript.java:38)
              org.jruby.internal.runtime.methods.JittedMethod.call(JittedMethod.java:161)
              org.jruby.internal.runtime.methods.DefaultMethod.call(DefaultMethod.java:193)
              org.jruby.internal.runtime.methods.WrapperMethod.call(WrapperMethod.java:74)
              org.jruby.runtime.callsite.CachingCallSite.callBlock(CachingCallSite.java:143)
              org.jruby.runtime.callsite.CachingCallSite.callIter(CachingCallSite.java:154)
              org.jruby.ast.CallNoArgBlockNode.interpret(CallNoArgBlockNode.java:64)
              org.jruby.ast.LocalAsgnNode.interpret(LocalAsgnNode.java:123)
              org.jruby.ast.NewlineNode.interpret(NewlineNode.java:105)
              org.jruby.ast.BlockNode.interpret(BlockNode.java:71)
              org.jruby.evaluator.ASTInterpreter.INTERPRET_METHOD(ASTInterpreter.java:74)
              org.jruby.internal.runtime.methods.InterpretedMethod.call(InterpretedMethod.java:204)
              org.jruby.internal.runtime.methods.DefaultMethod.call(DefaultMethod.java:206)
              org.jruby.RubyClass.finvoke(RubyClass.java:567)
              org.jruby.RubyBasicObject.send(RubyBasicObject.java:2595)
              org.jruby.RubyKernel.send(RubyKernel.java:2227)
              org.jruby.RubyKernel$INVOKER$s$send.call(RubyKernel$INVOKER$s$send.gen)
              org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:356)
              org.jruby.runtime.callsite.CachingCallSite.callBlock(CachingCallSite.java:213)
              org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:217)
              org.jruby.ast.CallSpecialArgBlockPassNode.interpret(CallSpecialArgBlockPassNode.java:66)
              org.jruby.ast.NewlineNode.interpret(NewlineNode.java:105)
              org.jruby.ast.RescueNode.executeBody(RescueNode.java:221)
              org.jruby.ast.RescueNode.interpret(RescueNode.java:116)
              org.jruby.evaluator.ASTInterpreter.INTERPRET_METHOD(ASTInterpreter.java:74)
              org.jruby.internal.runtime.methods.InterpretedMethod.call(InterpretedMethod.java:182)
              org.jruby.internal.runtime.methods.DefaultMethod.call(DefaultMethod.java:198)
              org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:168)
              org.jruby.ast.CallOneArgNode.interpret(CallOneArgNode.java:57)
              org.jruby.ast.NewlineNode.interpret(NewlineNode.java:105)
              org.jruby.ast.BlockNode.interpret(BlockNode.java:71)
              org.jruby.evaluator.ASTInterpreter.INTERPRET_BLOCK(ASTInterpreter.java:112)
              org.jruby.runtime.InterpretedBlock.evalBlockBody(InterpretedBlock.java:384)
              org.jruby.runtime.InterpretedBlock.yield(InterpretedBlock.java:336)
              org.jruby.runtime.BlockBody.call(BlockBody.java:73)
              org.jruby.runtime.Block.call(Block.java:101)
              org.jruby.RubyProc.call(RubyProc.java:290)
              org.jruby.RubyProc.call(RubyProc.java:224)
              org.jruby.RubyProc$INVOKER$i$0$0$call.call(RubyProc$INVOKER$i$0$0$call.gen)
              org.jruby.internal.runtime.methods.DynamicMethod.call(DynamicMethod.java:202)
              org.jruby.internal.runtime.methods.DynamicMethod.call(DynamicMethod.java:198)
              org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:134)
              org.jruby.ast.CallNoArgNode.interpret(CallNoArgNode.java:60)
              org.jruby.ast.NewlineNode.interpret(NewlineNode.java:105)
              org.jruby.ast.IfNode.interpret(IfNode.java:118)
              org.jruby.ast.NewlineNode.interpret(NewlineNode.java:105)
              org.jruby.evaluator.ASTInterpreter.INTERPRET_METHOD(ASTInterpreter.java:74)
              org.jruby.internal.runtime.methods.InterpretedMethod.call(InterpretedMethod.java:161)
              org.jruby.internal.runtime.methods.DefaultMethod.call(DefaultMethod.java:190)
              org.jruby.runtime.callsite.CachingCallSite.callBlock(CachingCallSite.java:143)
              org.jruby.runtime.callsite.CachingCallSite.callIter(CachingCallSite.java:154)
              org.jruby.ast.FCallNoArgBlockNode.interpret(FCallNoArgBlockNode.java:32)
              org.jruby.ast.NewlineNode.interpret(NewlineNode.java:105)
              org.jruby.ast.RescueNode.executeBody(RescueNode.java:221)
              org.jruby.ast.RescueNode.interpret(RescueNode.java:116)
              org.jruby.ast.BeginNode.interpret(BeginNode.java:83)
              org.jruby.ast.NewlineNode.interpret(NewlineNode.java:105)
              org.jruby.ast.BlockNode.interpret(BlockNode.java:71)
              org.jruby.evaluator.ASTInterpreter.INTERPRET_BLOCK(ASTInterpreter.java:112)
              org.jruby.runtime.InterpretedBlock.evalBlockBody(InterpretedBlock.java:384)
              org.jruby.runtime.InterpretedBlock.yield(InterpretedBlock.java:357)
              org.jruby.runtime.InterpretedBlock.yield(InterpretedBlock.java:312)
              org.jruby.runtime.Block.yield(Block.java:142)
              org.jruby.RubyArray.eachCommon(RubyArray.java:1606)
              org.jruby.RubyArray.each(RubyArray.java:1613)
              org.jruby.RubyArray$INVOKER$i$0$0$each.call(RubyArray$INVOKER$i$0$0$each.gen)
              org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:316)
              org.jruby.runtime.callsite.CachingCallSite.callBlock(CachingCallSite.java:145)
              org.jruby.runtime.callsite.CachingCallSite.callIter(CachingCallSite.java:154)
              org.jruby.ast.CallNoArgBlockNode.interpret(CallNoArgBlockNode.java:64)
              org.jruby.ast.NewlineNode.interpret(NewlineNode.java:105)
              org.jruby.ast.BlockNode.interpret(BlockNode.java:71)
              org.jruby.evaluator.ASTInterpreter.INTERPRET_METHOD(ASTInterpreter.java:74)
              org.jruby.internal.runtime.methods.InterpretedMethod.call(InterpretedMethod.java:139)
              org.jruby.internal.runtime.methods.DefaultMethod.call(DefaultMethod.java:182)
              org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:306)
              org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:136)
              org.jruby.ast.CallNoArgNode.interpret(CallNoArgNode.java:60)
              org.jruby.ast.NewlineNode.interpret(NewlineNode.java:105)
              org.jruby.evaluator.ASTInterpreter.INTERPRET_METHOD(ASTInterpreter.java:74)
              org.jruby.internal.runtime.methods.InterpretedMethod.call(InterpretedMethod.java:225)
              org.jruby.internal.runtime.methods.DefaultMethod.call(DefaultMethod.java:214)
              org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:346)
              org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:204)
              org.jruby.ast.FCallTwoArgNode.interpret(FCallTwoArgNode.java:38)
              org.jruby.ast.NewlineNode.interpret(NewlineNode.java:105)
              org.jruby.ast.WhenOneArgNode.whenNoTest(WhenOneArgNode.java:27)
              org.jruby.ast.WhenOneArgNode.when(WhenOneArgNode.java:45)
              org.jruby.ast.CaseNode.interpret(CaseNode.java:132)
              org.jruby.ast.NewlineNode.interpret(NewlineNode.java:105)
              org.jruby.evaluator.ASTInterpreter.INTERPRET_METHOD(ASTInterpreter.java:74)
              org.jruby.internal.runtime.methods.InterpretedMethod.call(InterpretedMethod.java:182)
              org.jruby.internal.runtime.methods.DefaultMethod.call(DefaultMethod.java:198)
              org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:326)
              org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:170)
              org.jruby.ast.CallOneArgNode.interpret(CallOneArgNode.java:57)
              org.jruby.ast.NewlineNode.interpret(NewlineNode.java:105)
              org.jruby.ast.BlockNode.interpret(BlockNode.java:71)
              org.jruby.evaluator.ASTInterpreter.INTERPRET_METHOD(ASTInterpreter.java:74)
              org.jruby.internal.runtime.methods.InterpretedMethod.call(InterpretedMethod.java:139)
              org.jruby.internal.runtime.methods.DefaultMethod.call(DefaultMethod.java:182)
              org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:306)
              org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:136)
              org.jruby.ast.CallNoArgNode.interpret(CallNoArgNode.java:60)
              org.jruby.ast.NewlineNode.interpret(NewlineNode.java:105)
              org.jruby.ast.BlockNode.interpret(BlockNode.java:71)
              org.jruby.ast.RescueNode.executeBody(RescueNode.java:221)
              org.jruby.ast.RescueNode.interpret(RescueNode.java:116)
              org.jruby.ast.BeginNode.interpret(BeginNode.java:83)
              org.jruby.ast.NewlineNode.interpret(NewlineNode.java:105)
              org.jruby.evaluator.ASTInterpreter.INTERPRET_BLOCK(ASTInterpreter.java:112)
              org.jruby.runtime.InterpretedBlock.evalBlockBody(InterpretedBlock.java:384)
              org.jruby.runtime.InterpretedBlock.yield(InterpretedBlock.java:336)
              org.jruby.runtime.BlockBody.call(BlockBody.java:73)
              org.jruby.runtime.Block.call(Block.java:101)
              org.jruby.RubyProc.call(RubyProc.java:290)
              org.jruby.RubyProc.call(RubyProc.java:228)
              org.jruby.internal.runtime.RubyRunnable.run(RubyRunnable.java:97)
              java.lang.Thread.run(Thread.java:745)
      
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              sebastien.lesaint Sebastien Lesaint
              Reporter:
              simon.brandhof Simon Brandhof (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Due:
                Created:
                Updated:
                Resolved: