After SonarQube v6.7.6 to v7.9.5 SonarQube become too slow and issues page doesn't show up

Hi guys.

Must-share information (formatted with Markdown):

  • which versions are you using (SonarQube, Scanner, Plugin, and any relevant extension)
    ■EC2
    ・JDK 11
    ・SonarQube 7.9.5
    ・EC2 instance m5.large

■RDS
・RDS Postgresql db.m5.large
・RDS Postgresql 10.5

  • what are you trying to achieve
    ⇛ I’m trying to update my SonarQube which I actually already did but Sonar’s Project page take about 1 minute to show up and the issues pages just never show up.
    It seems that issues pages is loading forever, stucked loading.

At this point: SonarQube v6.7.6 ⇛ v6.7.6
I can access any pages with no problem.

After update v6.7.7 ⇛ v7.9.5, after click the migrate database button, it took 4.5 hours and when it finished, I upgrade my RDS Postgresql v9.6 ⇛ v10.15.
After that, the project’s pages become too slow and issues pages just stuck loading and any issues show up.
I look into my database and I could see that the issues were still there.

sonardb=> select count(*) from issues;
count

548987
(1 line)
sonardb=> select count(*) from issue_changes;
count

1598

  • what have you tried so far to achieve this
    (1 line)

And I checked the used of RDS Postgresql on AWS RDS, and it appears that CPU is 99% used.

Any help is really welcome!
Thank you in advance!

Hi @Walker_Fifth ,

did you already have a look at the additional database maintenance in our docs?
I think a vacuum(full, analyze); on your SonarQube database should increase the performance

Hi Tobias,

Thank you for your guidance.
I did only ANALYZE command and its resolved my problem.

Thank you very very much!