Sonarqube 6.7.1 with MySql
Upgrade To
Sonarqube 6.7.1 with PostgreSql
Upgrade To
Sonarqube 7.9.1 with PostgreSql
Migration to Postgresql is OK, but upgration to 7.9.1 got this:
2019.12.08 21:14:36 INFO web[org.sonar.INFO] Security realm started
2019.12.08 21:14:36 WARN web[o.s.a.s.w.WebService$Action] The response example is not set on action api/plugins/download
2019.12.08 21:14:36 WARN web[o.s.a.s.w.WebService$Action] The response example is not set on action api/permissions/search_templates
2019.12.08 21:14:36 INFO web[o.s.s.t.TelemetryDaemon] Sharing of SonarQube statistics is enabled.
2019.12.08 21:14:36 INFO web[o.s.s.n.NotificationDaemon] Notification service started (delay 60 sec.)
2019.12.08 21:14:36 INFO web[o.s.s.s.GeneratePluginIndex] Generate scanner plugin index
2019.12.08 21:14:36 INFO web[o.s.s.s.RegisterPlugins] Register plugins
2019.12.08 21:14:36 ERROR web[o.s.s.p.Platform] Background initialization failed. Stopping SonarQube
java.lang.IllegalStateException: Default organization with uuid ‘AW7ko_Zanyo54cSbimhF’ does not exist
at com.google.common.base.Preconditions.checkState(Preconditions.java:197)
at org.sonar.server.organization.DefaultOrganizationProviderImpl.getDefaultOrganization(DefaultOrganizationProviderImpl.java:56)
at org.sonar.server.organization.DefaultOrganizationProviderImpl.get(DefaultOrganizationProviderImpl.java:48)
at org.sonar.server.organization.DefaultOrganizationEnforcer.start(DefaultOrganizationEnforcer.java:34)
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.PlatformLevelStartup.access$001(PlatformLevelStartup.java:47)
at org.sonar.server.platform.platformlevel.PlatformLevelStartup$1.doPrivileged(PlatformLevelStartup.java:83)
at org.sonar.server.user.DoPrivileged.execute(DoPrivileged.java:46)
at org.sonar.server.platform.platformlevel.PlatformLevelStartup.start(PlatformLevelStartup.java:80)
at org.sonar.server.platform.Platform.executeStartupTasks(Platform.java:196)
at org.sonar.server.platform.Platform.access$400(Platform.java:46)
at org.sonar.server.platform.Platform$1.lambda$doRun$1(Platform.java:121)
at org.sonar.server.platform.Platform$AutoStarterRunnable.runIfNotAborted(Platform.java:371)
at org.sonar.server.platform.Platform$1.doRun(Platform.java:121)
at org.sonar.server.platform.Platform$AutoStarterRunnable.run(Platform.java:355)
at java.base/java.lang.Thread.run(Thread.java:834)
2019.12.08 21:14:36 INFO web[o.s.p.ProcessEntryPoint] Hard stopping process
2019.12.08 21:14:37 WARN web[o.s.p.ProcessEntryPoint$HardStopperThread] Can not stop in 1000ms
2019.12.08 21:15:44 WARN web[o.a.c.u.SessionIdGeneratorBase] Creation of SecureRandom instance for session ID generation using [SHA1PRNG] took [71,428] milliseconds.
2019.12.08 21:15:44 INFO web[o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.ws.WebServiceFilter@53ace67d [pattern=UrlPattern{inclusions=[/api/system/migrate_db., …], exclusions=[/api/properties, …]}]
2019.12.08 21:15:44 INFO web[o.s.s.a.EmbeddedTomcat] HTTP connector enabled on port 9000
2019.12.08 21:15:44 INFO web[o.s.s.n.NotificationDaemon] Notification service stopped
2019.12.08 21:15:44 WARN web[o.a.c.l.WebappClassLoaderBase] The web application [ROOT] appears to have started a thread named [Thread-2] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
java.base@11.0.3/java.net.SocketInputStream.socketRead0(Native Method)
java.base@11.0.3/java.net.SocketInputStream.socketRead(SocketInputStream.java:115)
java.base@11.0.3/java.net.SocketInputStream.read(SocketInputStream.java:168)
java.base@11.0.3/java.net.SocketInputStream.read(SocketInputStream.java:140)
I check organizations TABLE , uuid is still the old one.
Hello,
Have you used the mysql-migrator tool to migrate from MySQL to Postgres ?
If so, are you 100% sure that the migration went well ? do you still have the logs ?
Alex.
Indeed it is a prerequisite to have a properly migrated database before running the upgrade.
Can you describe how you proceeded to migrate from MySql to Postgres ?
I am facing issue below error when trying for migration.
FATAL: password authentication failed for user “sonar”
Command use by me is below
./mysql-migrator -source /opt/sonar_backup_7.6/sonarqube-7.6/conf/sonar.properties -target /opt/sonar/sonarqube-7.8/conf/sonar.properties
Can you please help me with my error message.