Can not create new project, ORA-00001: unique constraint (SONAR3.SYS_C0034944) violated

upgrade
oracle

(Stas Roshkolts) #1

Hello,
We use Sonarqube 5.5 and want to upgrade to the latest one.
During the test we created copy of production server by exporting and importing DB to playground.

Unfortunately, in playground we can not create new project and getting next error in log:

 2018.06.11 16:57:41 ERROR web[o.s.s.w.WebServiceEngine] Fail to process request http://ilvpbg1570:19090/api/ce/submit?projectKey=com.amdocs.jenkins.plugins:JP_selenium&projectName=JP_selenium
org.apache.ibatis.exceptions.PersistenceException:
### Error updating database.  Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (SONAR3.SYS_C0034944) violated

### The error may involve org.sonar.db.component.ResourceIndexMapper.insert-Inline
### The error occurred while setting parameters
### SQL: insert into resource_index (kee, position, name_size, resource_id, root_project_id, qualifier)     values (?, ?, ?,     ?, ?, ?)
### Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (SONAR3.SYS_C0034944) violated

        at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:26) ~[mybatis-3.2.7.jar:3.2.7]
        at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:154) ~[mybatis-3.2.7.jar:3.2.7]
        at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:141) ~[mybatis-3.2.7.jar:3.2.7]
        at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:51) ~[mybatis-3.2.7.jar:3.2.7]
        at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:52) ~[mybatis-3.2.7.jar:3.2.7]
        at com.sun.proxy.$Proxy83.insert(Unknown Source) ~[na:na]
        at org.sonar.db.component.ResourceIndexDao.insertIndexEntries(ResourceIndexDao.java:199) ~[sonar-db-5.5.jar:na]
        at org.sonar.db.component.ResourceIndexDao.indexResource(ResourceIndexDao.java:181) ~[sonar-db-5.5.jar:na]
        at org.sonar.db.component.ResourceIndexDao.indexResource(ResourceIndexDao.java:157) ~[sonar-db-5.5.jar:na]
        at org.sonar.server.component.ComponentService.createProject(ComponentService.java:199) ~[sonar-server-5.5.jar:na]
        at org.sonar.server.component.ComponentService.create(ComponentService.java:162) ~[sonar-server-5.5.jar:na]
        at org.sonar.server.component.ComponentService.create(ComponentService.java:153) ~[sonar-server-5.5.jar:na]
        at org.sonar.ce.queue.report.ReportSubmitter.submit(ReportSubmitter.java:70) ~[sonar-server-5.5.jar:na]
        at org.sonar.server.ce.ws.SubmitAction.handle(SubmitAction.java:86) ~[sonar-server-5.5.jar:na]
        at org.sonar.server.ws.WebServiceEngine.execute(WebServiceEngine.java:100) ~[sonar-server-5.5.jar:na]
        at sun.reflect.GeneratedMethodAccessor167.invoke(Unknown Source) ~[na:na]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_60]
        at java.lang.reflect.Method.invoke(Method.java:497) ~[na:1.8.0_60]
        at org.jruby.javasupport.JavaMethod.invokeDirectWithExceptionHandling(JavaMethod.java:425) [jruby-complete-1.7.9.jar:na]
        at org.jruby.javasupport.JavaMethod.invokeDirect(JavaMethod.java:292) [jruby-complete-1.7.9.jar:na]
        at org.jruby.java.invokers.InstanceMethodInvoker.call(InstanceMethodInvoker.java:44) [jruby-complete-1.7.9.jar:na]
        at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:296) [jruby-complete-1.7.9.jar:na]
        at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:72) [jruby-complete-1.7.9.jar:na]
        at rubyjit.Api::JavaWsController$$index_F0093F46F7B98A69318D6BFF77A0745BB14C850A521696073.__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/app/controllers/api/java_ws_controller.rb:34) [jruby-complete-1.7.9.jar:na]
        at rubyjit.Api::JavaWsController$$index_F0093F46F7B98A69318D6BFF77A0745BB14C850A521696073.__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/app/controllers/api/java_ws_controller.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.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.ActionController::Base$$perform_action_DA0FC0A901DD1257EC969DB0C482DD8514B8F04B521696073.__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/actionpack-2.3.15/lib/action_controller/base.rb:1333) [jruby-complete-1.7.9.jar:na]
        at rubyjit.ActionController::Base$$perform_action_DA0FC0A901DD1257EC969DB0C482DD8514B8F04B521696073.__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/actionpack-2.3.15/lib/action_controller/base.rb) [jruby-complete-1.7.9.jar:na]
        at org.jruby.internal.runtime.methods.JittedMethod.call(JittedMethod.java:141) [jruby-complete-1.7.9.jar:na]
        at org.jruby.internal.runtime.methods.DefaultMethod.call(DefaultMethod.java:185) [jruby-complete-1.7.9.jar:na]
        at org.jruby.internal.runtime.methods.AliasMethod.call(AliasMethod.java:56) [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 rubyjit.ActionController::Filters::InstanceMethods$$call_filters_A7E1D3FFBF56E3CB7C0EBA850688505249A05AE9521696073.__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/actionpack-2.3.15/lib/action_controller/filters.rb:617) [jruby-complete-1.7.9.jar:na]
        at rubyjit.ActionController::Filters::InstanceMethods$$call_filters_A7E1D3FFBF56E3CB7C0EBA850688505249A05AE9521696073.__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/actionpack-2.3.15/lib/action_controller/filters.rb) [jruby-complete-1.7.9.jar:na]
        at org.jruby.internal.runtime.methods.JittedMethod.call(JittedMethod.java:261) [jruby-complete-1.7.9.jar:na]
        at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:366) [jruby-complete-1.7.9.jar:na]
        at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:238) [jruby-complete-1.7.9.jar:na]
        at rubyjit.ActionController::Filters::InstanceMethods$$perform_action_with_filters_4C7C67B4A5564FF5DC76344AF2372660F608839C521696073.__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/actionpack-2.3.15/lib/action_controller/filters.rb:610) [jruby-complete-1.7.9.jar:na]
        at rubyjit.ActionController::Filters::InstanceMethods$$perform_action_with_filters_4C7C67B4A5564FF5DC76344AF2372660F608839C521696073.__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/actionpack-2.3.15/lib/action_controller/filters.rb) [jruby-complete-1.7.9.jar:na]
        at org.jruby.internal.runtime.methods.JittedMethod.call(JittedMethod.java:141) [jruby-complete-1.7.9.jar:na]
        at org.jruby.internal.runtime.methods.DefaultMethod.call(DefaultMethod.java:185) [jruby-complete-1.7.9.jar:na]
        at org.jruby.internal.runtime.methods.AliasMethod.call(AliasMethod.java:56) [jruby-complete-1.7.9.jar:na]
        at org.jruby.internal.runtime.methods.AliasMethod.call(AliasMethod.java:56) [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 rubyjit.ActionController::Benchmarking$$perform_action_with_benchmark_303676EADF39D1B66CBA6FF2131B0D6C74E04345521696073.block_0$RUBY$__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/actionpack-2.3.15/lib/action_controller/benchmarking.rb:68) [jruby-complete-1.7.9.jar:na]
        at rubyjit$ActionController::Benchmarking$$perform_action_with_benchmark_303676EADF39D1B66CBA6FF2131B0D6C74E04345521696073$block_0$RUBY$__file__.call(rubyjit$ActionController::Benchmarking$$perform_action_with_benchmark_303676EADF39D1B66CBA6FF2131B0D6C74E04345521696073$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.Module$$ms_A9C6E2920290A1221EDA9CE357DE380BBA9B1BD9521696073.block_0$RUBY$__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/activesupport-2.3.15/lib/active_support/core_ext/benchmark.rb:17) [jruby-complete-1.7.9.jar:na]
        at rubyjit$Module$$ms_A9C6E2920290A1221EDA9CE357DE380BBA9B1BD9521696073$block_0$RUBY$__file__.call(rubyjit$Module$$ms_A9C6E2920290A1221EDA9CE357DE380BBA9B1BD9521696073$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$$realtime_D80759D5ED3DED92A37F972B3598DFDF9CC64E2A521696073.__file__(jar:file:/usr/sonar3/sonarqube-5.5/lib/server/jruby-complete-1.7.9.jar!/META-INF/jruby.home/lib/ruby/1.8/benchmark.rb:308) [jruby-complete-1.7.9.jar:na]
        at rubyjit.Benchmark$$realtime_D80759D5ED3DED92A37F972B3598DFDF9CC64E2A521696073.__file__(jar:file:/usr/sonar3/sonarqube-5.5/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.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.Module$$ms_A9C6E2920290A1221EDA9CE357DE380BBA9B1BD9521696073.__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/activesupport-2.3.15/lib/active_support/core_ext/benchmark.rb:17) [jruby-complete-1.7.9.jar:na]
        at rubyjit.Module$$ms_A9C6E2920290A1221EDA9CE357DE380BBA9B1BD9521696073.__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/activesupport-2.3.15/lib/active_support/core_ext/benchmark.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 rubyjit.ActionController::Benchmarking$$perform_action_with_benchmark_303676EADF39D1B66CBA6FF2131B0D6C74E04345521696073.__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/actionpack-2.3.15/lib/action_controller/benchmarking.rb:68) [jruby-complete-1.7.9.jar:na]
        at rubyjit.ActionController::Benchmarking$$perform_action_with_benchmark_303676EADF39D1B66CBA6FF2131B0D6C74E04345521696073.__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/actionpack-2.3.15/lib/action_controller/benchmarking.rb) [jruby-complete-1.7.9.jar:na]
        at org.jruby.internal.runtime.methods.JittedMethod.call(JittedMethod.java:141) [jruby-complete-1.7.9.jar:na]
        at org.jruby.internal.runtime.methods.DefaultMethod.call(DefaultMethod.java:185) [jruby-complete-1.7.9.jar:na]
        at org.jruby.internal.runtime.methods.AliasMethod.call(AliasMethod.java:56) [jruby-complete-1.7.9.jar:na]
        at org.jruby.internal.runtime.methods.AliasMethod.call(AliasMethod.java:56) [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 rubyjit.ActionController::Rescue$$perform_action_with_rescue_C881D7FD614DB6154FDE67AADAA1B18CFBA9E44D521696073.chained_0_rescue_1$RUBY$SYNTHETIC__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/actionpack-2.3.15/lib/action_controller/rescue.rb:160) [jruby-complete-1.7.9.jar:na]
        at rubyjit.ActionController::Rescue$$perform_action_with_rescue_C881D7FD614DB6154FDE67AADAA1B18CFBA9E44D521696073.__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/actionpack-2.3.15/lib/action_controller/rescue.rb) [jruby-complete-1.7.9.jar:na]
        at rubyjit.ActionController::Rescue$$perform_action_with_rescue_C881D7FD614DB6154FDE67AADAA1B18CFBA9E44D521696073.__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/actionpack-2.3.15/lib/action_controller/rescue.rb) [jruby-complete-1.7.9.jar:na]
        at org.jruby.internal.runtime.methods.JittedMethod.call(JittedMethod.java:141) [jruby-complete-1.7.9.jar:na]
        at org.jruby.internal.runtime.methods.DefaultMethod.call(DefaultMethod.java:185) [jruby-complete-1.7.9.jar:na]
        at org.jruby.internal.runtime.methods.AliasMethod.call(AliasMethod.java:56) [jruby-complete-1.7.9.jar:na]
        at org.jruby.internal.runtime.methods.AliasMethod.call(AliasMethod.java:56) [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 rubyjit.ActionController::Flash::InstanceMethods$$perform_action_with_flash_00190F39E4A509D41D1870DF577ADEFF4F2D86E0521696073.__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/actionpack-2.3.15/lib/action_controller/flash.rb:151) [jruby-complete-1.7.9.jar:na]
        at rubyjit.ActionController::Flash::InstanceMethods$$perform_action_with_flash_00190F39E4A509D41D1870DF577ADEFF4F2D86E0521696073.__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/actionpack-2.3.15/lib/action_controller/flash.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.internal.runtime.methods.DefaultMethod.call(DefaultMethod.java:193) [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.runtime.callsite.CachingCallSite.callVarargs(CachingCallSite.java:103) [jruby-complete-1.7.9.jar:na]
        at rubyjit.ActionController::Base$$process_0CD993B4C06E435A5AD30338E2A0816E50206655521696073.chained_0_ensure_1$RUBY$__ensure__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/actionpack-2.3.15/lib/action_controller/base.rb:532) [jruby-complete-1.7.9.jar:na]
        at rubyjit.ActionController::Base$$process_0CD993B4C06E435A5AD30338E2A0816E50206655521696073.__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/actionpack-2.3.15/lib/action_controller/base.rb) [jruby-complete-1.7.9.jar:na]
        at rubyjit.ActionController::Base$$process_0CD993B4C06E435A5AD30338E2A0816E50206655521696073.__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/actionpack-2.3.15/lib/action_controller/base.rb) [jruby-complete-1.7.9.jar:na]
        at org.jruby.ast.executable.AbstractScript.__file__(AbstractScript.java:50) [jruby-complete-1.7.9.jar:na]
        at org.jruby.internal.runtime.methods.JittedMethod.call(JittedMethod.java:261) [jruby-complete-1.7.9.jar:na]
        at org.jruby.internal.runtime.methods.DefaultMethod.call(DefaultMethod.java:233) [jruby-complete-1.7.9.jar:na]
        at org.jruby.internal.runtime.methods.AliasMethod.call(AliasMethod.java:71) [jruby-complete-1.7.9.jar:na]
        at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:366) [jruby-complete-1.7.9.jar:na]
        at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:238) [jruby-complete-1.7.9.jar:na]
        at org.jruby.runtime.callsite.CachingCallSite.callVarargs(CachingCallSite.java:105) [jruby-complete-1.7.9.jar:na]
        at rubyjit.ActionController::Filters::InstanceMethods$$process_with_filters_77F73D0F3CFC9652FC1D8F99FD6ECB9ACFAEB2BE521696073.__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/actionpack-2.3.15/lib/action_controller/filters.rb:606) [jruby-complete-1.7.9.jar:na]
        at rubyjit.ActionController::Filters::InstanceMethods$$process_with_filters_77F73D0F3CFC9652FC1D8F99FD6ECB9ACFAEB2BE521696073.__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/actionpack-2.3.15/lib/action_controller/filters.rb) [jruby-complete-1.7.9.jar:na]
        at org.jruby.ast.executable.AbstractScript.__file__(AbstractScript.java:46) [jruby-complete-1.7.9.jar:na]
        at org.jruby.internal.runtime.methods.JittedMethod.call(JittedMethod.java:221) [jruby-complete-1.7.9.jar:na]
        at org.jruby.internal.runtime.methods.DefaultMethod.call(DefaultMethod.java:217) [jruby-complete-1.7.9.jar:na]
        at org.jruby.internal.runtime.methods.AliasMethod.call(AliasMethod.java:66) [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 rubyjit.ActionController::Base$$process_D1BAE9F2F7D6D00DAEDE9A175F15297655D71871521696073.__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/actionpack-2.3.15/lib/action_controller/base.rb:391) [jruby-complete-1.7.9.jar:na]
        at rubyjit.ActionController::Base$$process_D1BAE9F2F7D6D00DAEDE9A175F15297655D71871521696073.__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/actionpack-2.3.15/lib/action_controller/base.rb) [jruby-complete-1.7.9.jar:na]
        at org.jruby.internal.runtime.methods.JittedMethod.call(JittedMethod.java:221) [jruby-complete-1.7.9.jar:na]
        at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:202) [jruby-complete-1.7.9.jar:na]
        at rubyjit.ActionController::Base$$call_8944B8D4A6D3AF4F57DE7885AE3EA09ADFDAED2A521696073.__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/actionpack-2.3.15/lib/action_controller/base.rb:386) [jruby-complete-1.7.9.jar:na]
        at rubyjit.ActionController::Base$$call_8944B8D4A6D3AF4F57DE7885AE3EA09ADFDAED2A521696073.__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/actionpack-2.3.15/lib/action_controller/base.rb) [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 rubyjit.ActionController::Routing::RouteSet$$call_426E45DA86B30E16B94E5379DB9F140F78AE4BF4521696073.__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/actionpack-2.3.15/lib/action_controller/routing/route_set.rb:450) [jruby-complete-1.7.9.jar:na]
        at rubyjit.ActionController::Routing::RouteSet$$call_426E45DA86B30E16B94E5379DB9F140F78AE4BF4521696073.__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/actionpack-2.3.15/lib/action_controller/routing/route_set.rb) [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 rubyjit.ActionController::Dispatcher$$dispatch_8AA750B78C06FEA2C9269E628FA684BF9C301479521696073.chained_1_rescue_1$RUBY$SYNTHETIC__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/actionpack-2.3.15/lib/action_controller/dispatcher.rb:87) [jruby-complete-1.7.9.jar:na]
        at rubyjit.ActionController::Dispatcher$$dispatch_8AA750B78C06FEA2C9269E628FA684BF9C301479521696073.chained_0_ensure_1$RUBY$__ensure__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/actionpack-2.3.15/lib/action_controller/dispatcher.rb) [jruby-complete-1.7.9.jar:na]
        at rubyjit.ActionController::Dispatcher$$dispatch_8AA750B78C06FEA2C9269E628FA684BF9C301479521696073.__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/actionpack-2.3.15/lib/action_controller/dispatcher.rb:85) [jruby-complete-1.7.9.jar:na]
        at rubyjit.ActionController::Dispatcher$$dispatch_8AA750B78C06FEA2C9269E628FA684BF9C301479521696073.__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/actionpack-2.3.15/lib/action_controller/dispatcher.rb) [jruby-complete-1.7.9.jar:na]
        at org.jruby.internal.runtime.methods.JittedMethod.call(JittedMethod.java:141) [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.ActionController::Dispatcher$$_call_CD38443163AC875A33B6E9F44AC41E096715B208521696073.__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/actionpack-2.3.15/lib/action_controller/dispatcher.rb:121) [jruby-complete-1.7.9.jar:na]
        at rubyjit.ActionController::Dispatcher$$_call_CD38443163AC875A33B6E9F44AC41E096715B208521696073.__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/actionpack-2.3.15/lib/action_controller/dispatcher.rb) [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.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:210) [jruby-complete-1.7.9.jar:na]
        at org.jruby.internal.runtime.methods.DynamicMethod.call(DynamicMethod.java:206) [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 rubyjit.ActiveRecord::QueryCache$$call_A14988755E65051CA93890DA44DDBD1292F52201521696073.block_0$RUBY$__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/activerecord-2.3.15/lib/active_record/query_cache.rb:29) [jruby-complete-1.7.9.jar:na]
        at rubyjit$ActiveRecord::QueryCache$$call_A14988755E65051CA93890DA44DDBD1292F52201521696073$block_0$RUBY$__file__.call(rubyjit$ActiveRecord::QueryCache$$call_A14988755E65051CA93890DA44DDBD1292F52201521696073$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.ActiveRecord::ConnectionAdapters::QueryCache$$cache_A633D695A7F60465017E9EF9D11E22D24BBB2F4C521696073.chained_0_ensure_1$RUBY$__ensure__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/activerecord-2.3.15/lib/active_record/connection_adapters/abstract/query_cache.rb:34) [jruby-complete-1.7.9.jar:na]
        at rubyjit.ActiveRecord::ConnectionAdapters::QueryCache$$cache_A633D695A7F60465017E9EF9D11E22D24BBB2F4C521696073.__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/activerecord-2.3.15/lib/active_record/connection_adapters/abstract/query_cache.rb) [jruby-complete-1.7.9.jar:na]
        at rubyjit.ActiveRecord::ConnectionAdapters::QueryCache$$cache_A633D695A7F60465017E9EF9D11E22D24BBB2F4C521696073.__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/activerecord-2.3.15/lib/active_record/connection_adapters/abstract/query_cache.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.call(CachingCallSite.java:149) [jruby-complete-1.7.9.jar:na]
        at rubyjit.ActiveRecord::QueryCache::ClassMethods$$cache_F67A1FFCC8AF52449A8884B5FC24C1FD70A7AFD2521696073.__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/activerecord-2.3.15/lib/active_record/query_cache.rb:9) [jruby-complete-1.7.9.jar:na]
        at rubyjit.ActiveRecord::QueryCache::ClassMethods$$cache_F67A1FFCC8AF52449A8884B5FC24C1FD70A7AFD2521696073.__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/activerecord-2.3.15/lib/active_record/query_cache.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 rubyjit.ActiveRecord::QueryCache$$call_A14988755E65051CA93890DA44DDBD1292F52201521696073.__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/activerecord-2.3.15/lib/active_record/query_cache.rb:28) [jruby-complete-1.7.9.jar:na]
        at rubyjit.ActiveRecord::QueryCache$$call_A14988755E65051CA93890DA44DDBD1292F52201521696073.__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/activerecord-2.3.15/lib/active_record/query_cache.rb) [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 rubyjit.ActiveRecord::ConnectionAdapters::ConnectionManagement$$call_90D2EFA9453A4B4B189AB976C186F4E8E3F4ECFD521696073.chained_0_ensure_1$RUBY$__ensure__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/activerecord-2.3.15/lib/active_record/connection_adapters/abstract/connection_pool.rb:361) [jruby-complete-1.7.9.jar:na]
        at rubyjit.ActiveRecord::ConnectionAdapters::ConnectionManagement$$call_90D2EFA9453A4B4B189AB976C186F4E8E3F4ECFD521696073.__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/activerecord-2.3.15/lib/active_record/connection_adapters/abstract/connection_pool.rb) [jruby-complete-1.7.9.jar:na]
        at rubyjit.ActiveRecord::ConnectionAdapters::ConnectionManagement$$call_90D2EFA9453A4B4B189AB976C186F4E8E3F4ECFD521696073.__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/gems/gems/activerecord-2.3.15/lib/active_record/connection_adapters/abstract/connection_pool.rb) [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 rubyjit.SecurityHeaders$$call_EEE721D5B3F5D38F8F526D73D043C0B10A696587521696073.__file__(/usr/sonar3/sonarqube-5.5/web/WEB-INF/config/environment.rb:67) [jruby-complete-1.7.9.jar:na]
        at 

Please, assist to solve the issue.


(Nicolas Bontoux) #2

Hi there,

Did you check that Oracle sequences were well taken care of during this export/import ? Because if Oracle sequences are not up-to-date (pure DB consideration here), then it can very well explain why you’d be hitting a unicity constraint violation afterwards.

Double-check that with your Oracle DB owner. FYI some simple queries like the following could help pinpoint the sequence -related issue:

SELECT MAX(ID) FROM resource_index;
SELECT * FROM ALL_SEQUENCES WHERE SEQUENCE_OWNER = 'SONAR3';