We are actually testing migration from VM-based deployment to Kubernetes deployment.
And we faced performance issues when the new server started with test data imported from the original DB.
-
What version are you upgrading from?
- 9.9.1to 9.9.6
- maybe also some plugin upgrade, like rust plugin from 0.1.0 to 2.1.0
-
System information (Operating system, Java version, Database provider/version)
- Docker image “sonarqube:9.9.6-enterprise”
- Database PostgreSQL 12.0 on Cloud
-
What’s the issue you’re facing?
- during the first startup with test data prepared/imported from prod sonarqube
- there is no error log or obviously indication saying why it’s so slow, in the log, the web container is: “RegisterQualityProfiles”
- we found slow queries after a while and then in code sonarqube/server/sonar-db-dao/src/main/java/org/sonar/db/project/ProjectMapper.java at 65a4363d09ad035edcb934b97c34cd69a85fbbf2 · SonarSource/sonarqube · GitHub
- this query seems to run for certain languages that may be impacted by the update which require schema or configuration upgrade, it seems to have scan a big full set of joined results, which can last 30-40 minutes at our scale (~1300 projects)
- this seems to be obvious performance issues in the query, would you help to check or suggest what we can do to help
Best Regards
Johnie