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 observed few queries on db , please see attached screenshots )
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 showing the massage loading.and DB CPU hits 100% ,I’m using 64GB Ram and 4cpus.
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.