Sonarqube `issues` page loading very slowly after upgrade database

SonarQube
1

Must-share information (formatted with Markdown):

  • SonarQube * Developer Edition Version 9.9.2 (build 77730)

  • Helm

  • The issues tab should load as quickly as possible

  • We are using AWS RDS PostgreSQL as the database for our Sonarqube instance. Sonarqube running in an EKS cluster and we deployed the application using Helm. Recently, we upgraded the DB from 13.x to 15.5. The upgrade went well and we didn’t face any issues.

While doing the QA, we noticed that the issues tab is loading very very slowly (after 5+ minutes). The issues count is 41,455. We are not able to see any errors in the sonar logs.

The DB is also performing well ( Memory and connection are fine).

Could someone please guide us, what will be the issue or some hints about the same?

sonar_issues_ui
sonar_issues_ui1820×787 27.5 KB

2

I was also going through the sonar docs and find SonarQube becomes slow after PostgreSQL upgrade. I will try this also

1 Like
3

The issue was fixed once we executed the DB commands mentioned in the doc Upgrade guide

1 Like
4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.