Failed upgrade from 4.5.2 to 5.1 - Index source lines?

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Failed upgrade from 4.5.2 to 5.1 - Index source lines?

Jan Sandquist
After a number of attempts (checking the compatibility matrix to get the proper plugins in place) I got quite far with the migration from 4.5.2 to 5.1.

...
2015.05.18 12:57:24 INFO  web[DbMigration] ==  FeedFileSources: migrating ================================================
2015.05.18 12:57:30 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=adde9ae1-1d35-4bed-a98b-c2ea4367d4c9,uuid=68eaae3f-28cb-4974-b870-41fa71398788,data=net.sourceforge.jtds.jdbc.ClobImpl@548b13af,updated_at=2014-12-17 12:37:40.073,text_value=null,measure_data=null,text_value=null,measure_data=null,text_value=null,measure_data=null,text_value=null,measure_data=null,text_value=null,measure_data=null,text_value=null,measure_data=null,text_value=null,measure_data=null,text_value=null,measure_data=null,text_value=null,measure_data=null,text_value=null,measurea=null,text_value=null,measure_data=null,text_value=null,measure_data=null,text_value=<duplications><g><b s="545" l="45" r="AAA.BBBB:CobolSource/Q1234567.cbl"/><b s="943" l="44" r="AAA.BBBB:CobolSource/Q1234567.cbl"/></g></duplications>,measure_data=null]
at org.sonar.server.db.migrations.SelectImpl.newExceptionWithRowDetails(SelectImpl.java:90) ~[sonar-server-5.1.jar:na]
at org.sonar.server.db.migrations.SelectImpl.scroll(SelectImpl.java:82) ~[sonar-server-5.1.jar:na]
at org.sonar.server.db.migrations.MassUpdate.execute(MassUpdate.java:76) ~[sonar-server-5.1.jar:na]

Ah, Cobol - we tested the Cobol plugin some time ago but it has expired so I did not place it in the plugins folder.

Next attempt - removed .../data/es/ and installed the latest Cobol plugin (sonar-cobol-plugin-2.6.jar; still expired) and now got a different error: 

2015.05.18 15:37:59 INFO  web[o.s.s.s.IndexSynchronizer] Index issues
2015.05.18 15:39:00 INFO  web[o.s.s.es.BulkIndexer] 340723 requests processed (5678 items/sec)
2015.05.18 15:39:05 INFO  web[o.s.s.s.IndexSynchronizer] Index source lines
2015.05.18 15:39:45 ERROR web[o.s.s.ui.JRubyFacade] Fail to upgrade database
java.util.concurrent.ExecutionException: java.lang.NullPointerException
com.google.common.base.Throwables.propagate(Throwables.java:156)
org.sonar.server.es.BaseIndexer.index(BaseIndexer.java:77)
org.sonar.server.search.IndexSynchronizer.execute(IndexSynchronizer.java:90)
org.sonar.server.platform.ServerComponents$1.doPrivileged(ServerComponents.java:852)
org.sonar.server.user.DoPrivileged.execute(DoPrivileged.java:43)
org.sonar.server.platform.ServerComponents.executeStartupTasks(ServerComponents.java:847)
org.sonar.server.platform.Platform.executeStartupTasks(Platform.java:126)
org.sonar.server.platform.Platform.startLevel34Containers(Platform.java:122)
org.sonar.server.platform.Platform.doStart(Platform.java:81)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:497)
org.jruby.javasupport.JavaMethod.invokeDirectWithExceptionHandling(JavaMethod.java:440)
org.jruby.javasupport.JavaMethod.invokeDirect(JavaMethod.java:304)
org.jruby.java.invokers.InstanceMethodInvoker.call(InstanceMethodInvoker.java:52)
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.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)

Something ES related it seems. Any hints - should I delete the Cobol project before migrating (if related)?

Best Regards / Jan

PS. I've looked around and found three different migration issues but nothing matching my exact error message, e.g. http://markmail.org/message/7rf3p7qxsj32d7bo
Reply | Threaded
Open this post in threaded view
|

Re: Failed upgrade from 4.5.2 to 5.1 - Index source lines?

Jan Sandquist
Problem solved - removed the COBOL projects used for evaluation/tests of the (now expired) Cobol plugin and the migration succeeded.

On Mon, May 18, 2015 at 9:52 PM, Jan Sandquist <[hidden email]> wrote:
After a number of attempts (checking the compatibility matrix to get the proper plugins in place) I got quite far with the migration from 4.5.2 to 5.1.

...
2015.05.18 12:57:24 INFO  web[DbMigration] ==  FeedFileSources: migrating ================================================
2015.05.18 12:57:30 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=adde9ae1-1d35-4bed-a98b-c2ea4367d4c9,uuid=68eaae3f-28cb-4974-b870-41fa71398788,data=net.sourceforge.jtds.jdbc.ClobImpl@548b13af,updated_at=2014-12-17 12:37:40.073,text_value=null,measure_data=null,text_value=null,measure_data=null,text_value=null,measure_data=null,text_value=null,measure_data=null,text_value=null,measure_data=null,text_value=null,measure_data=null,text_value=null,measure_data=null,text_value=null,measure_data=null,text_value=null,measure_data=null,text_value=null,measurea=null,text_value=null,measure_data=null,text_value=null,measure_data=null,text_value=<duplications><g><b s="545" l="45" r="AAA.BBBB:CobolSource/Q1234567.cbl"/><b s="943" l="44" r="AAA.BBBB:CobolSource/Q1234567.cbl"/></g></duplications>,measure_data=null]
at org.sonar.server.db.migrations.SelectImpl.newExceptionWithRowDetails(SelectImpl.java:90) ~[sonar-server-5.1.jar:na]
at org.sonar.server.db.migrations.SelectImpl.scroll(SelectImpl.java:82) ~[sonar-server-5.1.jar:na]
at org.sonar.server.db.migrations.MassUpdate.execute(MassUpdate.java:76) ~[sonar-server-5.1.jar:na]

Ah, Cobol - we tested the Cobol plugin some time ago but it has expired so I did not place it in the plugins folder.

Next attempt - removed .../data/es/ and installed the latest Cobol plugin (sonar-cobol-plugin-2.6.jar; still expired) and now got a different error: 

2015.05.18 15:37:59 INFO  web[o.s.s.s.IndexSynchronizer] Index issues
2015.05.18 15:39:00 INFO  web[o.s.s.es.BulkIndexer] 340723 requests processed (5678 items/sec)
2015.05.18 15:39:05 INFO  web[o.s.s.s.IndexSynchronizer] Index source lines
2015.05.18 15:39:45 ERROR web[o.s.s.ui.JRubyFacade] Fail to upgrade database
java.util.concurrent.ExecutionException: java.lang.NullPointerException
com.google.common.base.Throwables.propagate(Throwables.java:156)
org.sonar.server.es.BaseIndexer.index(BaseIndexer.java:77)
org.sonar.server.search.IndexSynchronizer.execute(IndexSynchronizer.java:90)
org.sonar.server.platform.ServerComponents$1.doPrivileged(ServerComponents.java:852)
org.sonar.server.user.DoPrivileged.execute(DoPrivileged.java:43)
org.sonar.server.platform.ServerComponents.executeStartupTasks(ServerComponents.java:847)
org.sonar.server.platform.Platform.executeStartupTasks(Platform.java:126)
org.sonar.server.platform.Platform.startLevel34Containers(Platform.java:122)
org.sonar.server.platform.Platform.doStart(Platform.java:81)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:497)
org.jruby.javasupport.JavaMethod.invokeDirectWithExceptionHandling(JavaMethod.java:440)
org.jruby.javasupport.JavaMethod.invokeDirect(JavaMethod.java:304)
org.jruby.java.invokers.InstanceMethodInvoker.call(InstanceMethodInvoker.java:52)
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.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)

Something ES related it seems. Any hints - should I delete the Cobol project before migrating (if related)?

Best Regards / Jan

PS. I've looked around and found three different migration issues but nothing matching my exact error message, e.g. http://markmail.org/message/7rf3p7qxsj32d7bo