Hi community,
Im in the process to migrate sonarqube from 6.7 to 7.9.2, when starting sonarqube process Im getting database error:
The following is the web.log, in other logs we had no errors.
Sonarqube is in Linux server, database is MS SQL
ERROR web[o.s.s.p.Platform] Web server startup failed
java.lang.IllegalStateException: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot drop the index ‘analysis_properties.ix_snapshot_uuid’, because it does not exist or you do not have permission.
at org.sonar.server.platform.db.migration.charset.DatabaseCharsetChecker.check(DatabaseCharsetChecker.java:67)
at org.sonar.server.platform.db.CheckDatabaseCharsetAtStartup.start(CheckDatabaseCharsetAtStartup.java:48)
at org.sonar.core.platform.StartableCloseableSafeLifecyleStrategy.start(StartableCloseableSafeLifecyleStrategy.java:40)
at org.picocontainer.injectors.AbstractInjectionFactory$LifecycleAdapter.start(AbstractInjectionFactory.java:84)
at org.picocontainer.behaviors.AbstractBehavior.start(AbstractBehavior.java:169)
at org.picocontainer.behaviors.Stored$RealComponentLifecycle.start(Stored.java:132)
at org.picocontainer.behaviors.Stored.start(Stored.java:110)
at org.picocontainer.DefaultPicoContainer.potentiallyStartAdapter(DefaultPicoContainer.java:1016)
at org.picocontainer.DefaultPicoContainer.startAdapters(DefaultPicoContainer.java:1009)
at org.picocontainer.DefaultPicoContainer.start(DefaultPicoContainer.java:767)
at org.sonar.core.platform.ComponentContainer.startComponents(ComponentContainer.java:135)
at org.sonar.server.platform.platformlevel.PlatformLevel.start(PlatformLevel.java:90)
at org.sonar.server.platform.platformlevel.PlatformLevel2.start(PlatformLevel2.java:113)
at org.sonar.server.platform.Platform.start(Platform.java:211)
at org.sonar.server.platform.Platform.startLevel2Container(Platform.java:177)
at org.sonar.server.platform.Platform.init(Platform.java:87)
at org.sonar.server.platform.web.PlatformServletContextListener.contextInitialized(PlatformServletContextListener.java:43)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4817)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5283)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1423)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1413)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:834)
Actions performed:
1-manually created an index with name ix_snapshot_uuid on table analysis_properties
2- Restarted sonarqube (/opt/sonarqube-7.9.2/bin/linux-x86-64/sonar.sh restart)
Results:
After restarting sonar service, the index dropped from the database, we created the index twice and the index got dropped. Sonar instance is in 1 server and database is in a different server.
I’ve created a support case with sonar but its workaround doesnt work, the issue link is https://jira.sonarsource.com/browse/SONAR-12464
This is a show stopper for our migration, until this is resolved we are stuck and the risk is that version 6.7 is EOL