Sonar versions used (SonarQube 7.9.3) and DB is 9.6.18 , we tried to upgrade AWS RDS postgras engine version from 09.5 to 9.6 after that the sonarqube is not loading and I tried to run some queries and geeting some long run queries. How do we resolve this issue in sonar error observed (we observ…

Hi, the VACUUM FULL recommendation does hold for PostgreSQL version upgrade as well.

Hi, Welcome to the community! There are some DB maintenance steps that we recommend after upgrading your SonarQube version. At a guess, they may be helpful here too. Ann

HI @ganncamp , Thanks for looking into this issue. I didn’t upgrade sonarqube version,i tried to upgrade the database(postgres) version from 9.5 to 9.6 after that i removed the complete es6 folded and tried to index again, indexing is complete .but still sonarqube is not loaded .in that UI showin…

HI @pierreguillot , I started VACUUM FULL ANALYZE. it’s started 6hous ago, but still not completed. may I know how much time it will take? Thanks, Koteswara

Hi, I can’t say, it’s PostgreSQL specific commands. But basically, it’s re-writing your all database, table by table, to benefits from sequential reads from your disk. So it very much depends on your disk speed, and database size.

Thank you @pierreguillot VACUUM FULL is resolved my Sonarqube issue.

Upgrading postgres version 9.5.16 to 9.6.18 version getting CPU hits 100%

SonarQube Server / Community Build

pierreguillot (Pierre Guillot) January 19, 2021, 4:50pm 5

Topic		Replies	Views
SonarQube upgrade from 9.9.3 to 9.9.4 issue with stuck queries SonarQube Server / Community Build	2	181	June 5, 2024
SonarQube version 8.9LTS stopped loading after PostgresSQL RDS upgraded 11.20v SonarQube Server / Community Build sonarqube	1	296	September 7, 2023
Upgrading SonarServer from 9.9.1 to 9.9.6 is very slow the first time server start SonarQube Server / Community Build sonarqube	1	54	September 2, 2024
SonarQube upgrade Process (upgrade RDS Postgresql) SonarQube Server / Community Build sonarqube	1	679	September 13, 2023
Sonarqube analysis taking 1+hr after DB upgrade to postgres10 SonarQube Server / Community Build sonarqube , postgres	2	811	January 14, 2021

Upgrading postgres version 9.5.16 to 9.6.18 version getting CPU hits 100%

Related topics