Integrate SonarQube with your AI agent, scan for secrets and dependency risks, and explore and manage issues—all from the command line.
Start using SonarQube CLI
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.