Hello, We have Sonar deployed with a helm chart. After upgrading to version 9.9-developer it seems there was an issue w/ the database migration. The sonar instance is stuck in a crash loop. Running a db restore has been ineffective. Reverting the version in values.yaml to 9.4 did not fix this. Wha…

Hi, Welcome to the community! It’s not clear to me what the sonarqube-lts.txt file is. It seems to be all the SonarQube application logs concatenated into one file? This: 2023.03.04 18:39:15 INFO app[][o.s.a.SchedulerImpl] Stopping SonarQube 2023.03.04 18:39:15 INFO app[][o.s.a.SchedulerImpl] …

Hi Ann, By crash loop I meant that it would continuously crash after ArgoCD tried to deploy the pods again. After troubleshooting, we found that we were unable to properly restore the postgresql db to the backed up version (see Unable to restore sonar DB ) because the default sonarUser does not ha…

Related to: Sonarqube Crashes after upgrade from 9.4 to 9.9 After a failed upgrade to version 9.9-developer, I tried restoring a postgres backup taken on version 9.3-developer. This is for a kuberentes deployment of sonar. I used this documentation for reference: Backup and restore I ran pg_dump…

Hi, This is a bit out of scope for this community. Perhaps the Postgres folks can help? Ann

Hi Ann, We are not able to dump the DB to begin the restore b/c the default ‘sonarUser’ set in the postgresql server doesn’t not have permissions to do do. If you are able to provide the password for the ‘postgres’ user we can try it again. Due to this blocker, we created a new DB and restored our…

Hi Austin, I’ve combined your two threads since they appear to be about the same thing. [image] Austin: the default sonarUser does not have permissions to drop sonarDB which is required for the restore process. That’s outside the scope of this community. The SonarQube DB user needs to have …

Hi Ann, This thread was created to discuss why the upgrade from 9.4 to 9.9 was unsuccessful. The second thread was created to get help for restoring our production Sonarqube instance. The default sonarUser account is the only user account we have access to in the postgresdb. This user account was …

Hello @pengcakes , thanks a lot for taking the time to participate in the community. Regarding the backup and restore part, we tried replicating your issue locally, and we ended up in the same situation when the database was already populated. What we did locally with docker-compose that mimick the…

Hi Jeremy, Thanks for replicating this locally. We were able to find a way around this issue with a similar solution to the one you provided. Unfortunately, we ran into project and issue loading problems in 9.9. We’re currently looking at reverting to an earlier version and including the new memory…

Hello @pengcakes , i am happy to ear that you found a workaround. Have you been able to test the memory increase ?

Sonarqube Crashes after upgrade from 9.4 to 9.9

SonarQube Server / Community Build

Topic		Replies	Views
Migrating Sonarqube - Database Upgrade Error SonarQube Server / Community Build sonarqube , kubernetes , helm	3	2394	February 28, 2022
SonarQube Startup fails after migration from EC2 setup to Helm with Db connection issues SonarQube Server / Community Build sonarqube , bump	9	223	January 29, 2025
Upgraded SonarQube stopping automatically SonarQube Server / Community Build helm	28	1937	June 6, 2023
Sonarqube(9.9) installation failed on kubernetes using helm charts from sonarqube itself SonarQube Server / Community Build sonarqube	19	1175	July 17, 2023
Need to Upgrade 7.9.2 Sonarqube version deployed to EKS using stable/helmchart to 9.9 or latest now SonarQube Server / Community Build sonarqube , 8-9-lts-upgrade	13	607	August 2, 2023

Sonarqube Crashes after upgrade from 9.4 to 9.9

Related topics