Re: sonarqube upgrade failed after 2-3 hours of database migration

Message has been deleted

Julien Lancelot

unread,

Jun 5, 2017, 2:45:00 AM6/5/17

to sri...@gmail.com, SonarQube

Hi Srikanth,

From the logs, I can see the following error : "Realm 'LDAP' not found. Please check the property 'sonar.security.realm' in conf/sonar.properties".

I suppose that you've keep LDAP settings in sonar.properties in SonarQube 6.3.1, but you didn't add the LDAP plugin (As reported in the upgrading doc you need to add all compatible plugin with new version of SonarQube).

To fix your issue you need to add the LDAP plugin.

Regards,

On Mon, 5 Jun 2017 at 06:31 <sri...@gmail.com> wrote:

Hi,

we tried to upgrade sonarqube from 5.6 to 6.3.1 (DB- MsSql-2014) database migration went for around 3-4 hours and ended up with below error. Any help is appreciated.

Error logged:

2017.06.02 18:03:14 INFO web[][DbMigrations] #1515 'Unset user root flags'...
2017.06.02 18:03:14 INFO web[][DbMigrations] #1515 'Unset user root flags': success | time=11ms
2017.06.02 18:03:14 INFO web[][DbMigrations] #1516 'Add ORGANIZATIONS.USER_ID'...
2017.06.02 18:03:14 INFO web[][DbMigrations] #1516 'Add ORGANIZATIONS.USER_ID': success | time=6ms
2017.06.02 18:03:14 INFO web[][DbMigrations] #1517 'Delete PROJECT_MEASURES rows having no value'...
2017.06.02 18:04:14 INFO web[][o.s.s.p.d.m.s.MassUpdate] 0 measures processed (0 items/sec)
2017.06.02 18:04:25 INFO web[][o.s.s.p.d.m.s.MassUpdate] 0 measures processed (0 items/sec)
2017.06.02 18:04:25 INFO web[][DbMigrations] #1517 'Delete PROJECT_MEASURES rows having no value': success | time=70850ms
2017.06.02 18:04:25 INFO web[][DbMigrations] #1518 'Make index on ORGANIZATIONS.KEE unique'...
2017.06.02 18:04:25 INFO web[][DbMigrations] #1518 'Make index on ORGANIZATIONS.KEE unique': success | time=13ms
2017.06.02 18:04:25 INFO web[][DbMigrations] Executed DB migrations: success | time=5391814ms
2017.06.02 18:04:25 INFO web[][o.s.s.p.UpdateCenterClient] Update center: https://update.sonarsource.org/update-center.properties (no proxy)
2017.06.02 18:04:25 ERROR web[][o.s.s.p.d.m.DatabaseMigrationImpl] Container restart failed | time=5392316ms
2017.06.02 18:04:25 ERROR web[][o.s.s.p.d.m.DatabaseMigrationImpl] Container restart failed
java.lang.IllegalStateException: Unable to load component class org.sonar.server.platform.ws.SystemWs
at org.sonar.core.platform.ComponentContainer$ExtendedDefaultPicoContainer.getComponent(ComponentContainer.java:70)
at org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContainer.java:621)
at org.picocontainer.parameters.CollectionComponentParameter.getArrayInstance(CollectionComponentParameter.java:334)
at org.picocontainer.parameters.CollectionComponentParameter.access$100(CollectionComponentParameter.java:49)
at org.picocontainer.parameters.CollectionComponentParameter$1.resolveInstance(CollectionComponentParameter.java:139)
at org.picocontainer.parameters.ComponentParameter$1.resolveInstance(ComponentParameter.java:141)
at org.picocontainer.injectors.SingleMemberInjector.getParameter(SingleMemberInjector.java:78)
at org.picocontainer.injectors.ConstructorInjector$CtorAndAdapters.getParameterArguments(ConstructorInjector.java:309)
at org.picocontainer.injectors.ConstructorInjector$1.run(ConstructorInjector.java:335)
at org.picocontainer.injectors.AbstractInjector$ThreadLocalCyclicDependencyGuard.observe(AbstractInjector.java:270)
at org.picocontainer.injectors.ConstructorInjector.getComponentInstance(ConstructorInjector.java:364)
at org.picocontainer.injectors.AbstractInjectionFactory$LifecycleAdapter.getComponentInstance(AbstractInjectionFactory.java:56)
at org.picocontainer.behaviors.AbstractBehavior.getComponentInstance(AbstractBehavior.java:64)
at org.picocontainer.behaviors.Stored.getComponentInstance(Stored.java:91)
at org.picocontainer.DefaultPicoContainer.instantiateComponentAsIsStartable(DefaultPicoContainer.java:1034)
at org.picocontainer.DefaultPicoContainer.addAdapterIfStartable(DefaultPicoContainer.java:1026)
at org.picocontainer.DefaultPicoContainer.startAdapters(DefaultPicoContainer.java:1003)
at org.picocontainer.DefaultPicoContainer.start(DefaultPicoContainer.java:767)
at org.sonar.core.platform.ComponentContainer.startComponents(ComponentContainer.java:142)
at org.sonar.server.platform.platformlevel.PlatformLevel.start(PlatformLevel.java:88)
at org.sonar.server.platform.platformlevel.PlatformLevel4.start(PlatformLevel4.java:529)
at org.sonar.server.platform.Platform.start(Platform.java:203)
at org.sonar.server.platform.Platform.startLevel34Containers(Platform.java:177)
at org.sonar.server.platform.Platform.doStart(Platform.java:100)
at org.sonar.server.platform.Platform.doStart(Platform.java:79)
at org.sonar.server.platform.db.migration.DatabaseMigrationImpl.doRestartContainer(DatabaseMigrationImpl.java:137)
at org.sonar.server.platform.db.migration.DatabaseMigrationImpl.doDatabaseMigration(DatabaseMigrationImpl.java:106)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.IllegalStateException: Unable to load component class org.sonar.server.platform.ws.InfoAction
at org.sonar.core.platform.ComponentContainer$ExtendedDefaultPicoContainer.getComponent(ComponentContainer.java:70)
at org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContainer.java:621)
at org.picocontainer.parameters.CollectionComponentParameter.getArrayInstance(CollectionComponentParameter.java:334)
at org.picocontainer.parameters.CollectionComponentParameter.access$100(CollectionComponentParameter.java:49)
at org.picocontainer.parameters.CollectionComponentParameter$1.resolveInstance(CollectionComponentParameter.java:139)
at org.picocontainer.parameters.ComponentParameter$1.resolveInstance(ComponentParameter.java:141)
at org.picocontainer.injectors.SingleMemberInjector.getParameter(SingleMemberInjector.java:78)
at org.picocontainer.injectors.ConstructorInjector$CtorAndAdapters.getParameterArguments(ConstructorInjector.java:309)
at org.picocontainer.injectors.ConstructorInjector$1.run(ConstructorInjector.java:335)
at org.picocontainer.injectors.AbstractInjector$ThreadLocalCyclicDependencyGuard.observe(AbstractInjector.java:270)
at org.picocontainer.injectors.ConstructorInjector.getComponentInstance(ConstructorInjector.java:364)
at org.picocontainer.injectors.AbstractInjectionFactory$LifecycleAdapter.getComponentInstance(AbstractInjectionFactory.java:56)
at org.picocontainer.behaviors.AbstractBehavior.getComponentInstance(AbstractBehavior.java:64)
at org.picocontainer.behaviors.Stored.getComponentInstance(Stored.java:91)
at org.picocontainer.DefaultPicoContainer.getInstance(DefaultPicoContainer.java:699)
at org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContainer.java:647)
at org.sonar.core.platform.ComponentContainer$ExtendedDefaultPicoContainer.getComponent(ComponentContainer.java:68)
... 29 common frames omitted
Caused by: java.lang.IllegalStateException: Unable to load component class org.sonar.server.platform.monitoring.SonarQubeMonitor
at org.sonar.core.platform.ComponentContainer$ExtendedDefaultPicoContainer.getComponent(ComponentContainer.java:70)
at org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContainer.java:621)
at org.picocontainer.parameters.CollectionComponentParameter.getArrayInstance(CollectionComponentParameter.java:334)
at org.picocontainer.parameters.CollectionComponentParameter.access$100(CollectionComponentParameter.java:49)
at org.picocontainer.parameters.CollectionComponentParameter$1.resolveInstance(CollectionComponentParameter.java:139)
at org.picocontainer.parameters.ComponentParameter$1.resolveInstance(ComponentParameter.java:141)
at org.picocontainer.injectors.SingleMemberInjector.getParameter(SingleMemberInjector.java:78)
at org.picocontainer.injectors.ConstructorInjector$CtorAndAdapters.getParameterArguments(ConstructorInjector.java:309)
at org.picocontainer.injectors.ConstructorInjector$1.run(ConstructorInjector.java:335)
at org.picocontainer.injectors.AbstractInjector$ThreadLocalCyclicDependencyGuard.observe(AbstractInjector.java:270)
at org.picocontainer.injectors.ConstructorInjector.getComponentInstance(ConstructorInjector.java:364)
at org.picocontainer.injectors.AbstractInjectionFactory$LifecycleAdapter.getComponentInstance(AbstractInjectionFactory.java:56)
at org.picocontainer.behaviors.AbstractBehavior.getComponentInstance(AbstractBehavior.java:64)
at org.picocontainer.behaviors.Stored.getComponentInstance(Stored.java:91)
at org.picocontainer.DefaultPicoContainer.getInstance(DefaultPicoContainer.java:699)
at org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContainer.java:647)
at org.sonar.core.platform.ComponentContainer$ExtendedDefaultPicoContainer.getComponent(ComponentContainer.java:68)
... 45 common frames omitted
Caused by: java.lang.IllegalStateException: Unable to load component class org.sonar.server.user.SecurityRealmFactory
at org.sonar.core.platform.ComponentContainer$ExtendedDefaultPicoContainer.getComponent(ComponentContainer.java:70)
at org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContainer.java:632)
at org.picocontainer.parameters.BasicComponentParameter$1.resolveInstance(BasicComponentParameter.java:118)
at org.picocontainer.parameters.ComponentParameter$1.resolveInstance(ComponentParameter.java:136)
at org.picocontainer.injectors.SingleMemberInjector.getParameter(SingleMemberInjector.java:78)
at org.picocontainer.injectors.ConstructorInjector$CtorAndAdapters.getParameterArguments(ConstructorInjector.java:309)
at org.picocontainer.injectors.ConstructorInjector$1.run(ConstructorInjector.java:335)
at org.picocontainer.injectors.AbstractInjector$ThreadLocalCyclicDependencyGuard.observe(AbstractInjector.java:270)
at org.picocontainer.injectors.ConstructorInjector.getComponentInstance(ConstructorInjector.java:364)
at org.picocontainer.injectors.AbstractInjectionFactory$LifecycleAdapter.getComponentInstance(AbstractInjectionFactory.java:56)
at org.picocontainer.behaviors.AbstractBehavior.getComponentInstance(AbstractBehavior.java:64)
at org.picocontainer.behaviors.Stored.getComponentInstance(Stored.java:91)
at org.picocontainer.DefaultPicoContainer.getInstance(DefaultPicoContainer.java:699)
at org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContainer.java:647)
at org.sonar.core.platform.ComponentContainer$ExtendedDefaultPicoContainer.getComponent(ComponentContainer.java:68)
... 61 common frames omitted
Caused by: org.sonar.api.utils.SonarException: Realm 'LDAP' not found. Please check the property 'sonar.security.realm' in conf/sonar.properties
at org.sonar.server.user.SecurityRealmFactory.<init>(SecurityRealmFactory.java:51)
at org.sonar.server.user.SecurityRealmFactory.<init>(SecurityRealmFactory.java:75)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at org.picocontainer.injectors.AbstractInjector.newInstance(AbstractInjector.java:145)
at org.picocontainer.injectors.ConstructorInjector$1.run(ConstructorInjector.java:342)
at org.picocontainer.injectors.AbstractInjector$ThreadLocalCyclicDependencyGuard.observe(AbstractInjector.java:270)
at org.picocontainer.injectors.ConstructorInjector.getComponentInstance(ConstructorInjector.java:364)
at org.picocontainer.injectors.AbstractInjectionFactory$LifecycleAdapter.getComponentInstance(AbstractInjectionFactory.java:56)
at org.picocontainer.behaviors.AbstractBehavior.getComponentInstance(AbstractBehavior.java:64)
at org.picocontainer.behaviors.Stored.getComponentInstance(Stored.java:91)
at org.picocontainer.DefaultPicoContainer.getInstance(DefaultPicoContainer.java:699)
at org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContainer.java:647)
at org.sonar.core.platform.ComponentContainer$ExtendedDefaultPicoContainer.getComponent(ComponentContainer.java:68)
... 75 common frames omitted

Thanks,
srikanth

--
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/871fdb4b-b0eb-4076-9357-5d8290fdc156%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Julien Lancelot | SonarSource

http://sonarsource.com

Message has been deleted

sri...@gmail.com

unread,

Jun 5, 2017, 11:13:13 AM6/5/17

to SonarQube, sri...@gmail.com

If i receive the same error again. can i comment out the LDAP configuration in sonar.properties file? This helps?

On Monday, June 5, 2017 at 11:05:34 AM UTC-4, sri...@gmail.com wrote:

Hi Julien,

I appreciate your response. what is the compatible version of LDAP plugin for sonarqube 6.3.1? I have copied sonar-ldap-plugin-2.0.jar from old sonarqube home to new sonarqube home. will this work?

please guide.

Thanks,
Srikanth

Julien Lancelot

unread,

Jun 5, 2017, 11:25:19 AM6/5/17

to SonarQube

Hi Srikanth,

As written in the Upgrade guide, you need to check the Compatibility Matrix to see which version of a plugin is compatible with a SonarQube version.

You'll see then than you need LDAP 2.1 with SonarQube 6.3.

Regards

On Mon, 5 Jun 2017 at 17:05 <sri...@gmail.com> wrote:

Hi Julien,

I appreciate your response. what is the compatible version of LDAP plugin for sonarqube 6.3.1? I have copied sonar-ldap-plugin-2.0.jar from old sonarqube home to new sonarqube home. will this work?

please guide.

Thanks,
Srikanth

On Monday, June 5, 2017 at 2:45:00 AM UTC-4, Julien Lancelot wrote:

To view this discussion on the web visit https://groups.google.com/d/msgid/sonarqube/f33b7283-729a-46b7-bac9-bf76e199d4cf%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

sri...@gmail.com

unread,

Jun 5, 2017, 3:21:03 PM6/5/17

to SonarQube

Perfect!! Installed LDAP plugin it worked. Thanks for the suggestion Julien.

you are awesome.

Thanks,

Srikanth

Message has been deleted

Julien Lancelot

unread,

Jun 6, 2017, 5:27:56 AM6/6/17

to sri...@gmail.com, SonarQube

Hi Srikanth,

I'm glad that you've solved your issue to migrate to SonarQube 6.3.

About the issue during the build, please open another thread (with complete complete configuration and logs).

Regards,

On Mon, 5 Jun 2017 at 23:18 <sri...@gmail.com> wrote:

Hi Julien,
We also upgraded sonar-scanner from 2.6.1 to 2.8. Builds are failing after the upgrade. can you please help me on this?

Below is the error after initiating the build with sonar scanner-2.8
/apps/jenkins/workspace/repo_march2017-CCOU2E5SY2VKNA4EOLFVNSOR3CL3R7M5RX45WSOZSLECAEYCNBZQ@tmp/durable-60aba918/script.sh: line 2: /apps/jenkins/tools/sonar-scanner-2.8/bin/sonar-scanner: No such file or directory
Thanks,
Srikanth 

To view this discussion on the web visit https://groups.google.com/d/msgid/sonarqube/f39911f1-0a97-47b5-a622-0e6d13cf5343%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

Reply all

Reply to author

Forward