After upgrading from 8.9.4 Enterprise Edition to 9.4 Enterprise Edition, almost all the Scans takes a lot longer than before.
Scans that took between 15-30 seconds, now takes more than 30 minutes (sometimes more than an hour).
Our Sonarqube VM has 64GB of RAM, and our PSQL has also plenty of free memory.
After the upgrade, we performed the “VACUUM FULL” suggestion on the upgrade guide here: Upgrade Guide | SonarQube Docs but the results are the same…
After changing the logs to DEBUG, this is what it shows:
being the IntegrateIssuesVisitor the one that takes 99% of the time.
Do you guys have any suggestion as what else might be missing here so the scans go back to last what they used to?
Were having this same issue.
Scans go from 1-3 minutes to 30 minutes after migrating the database (postgres 9.6 to postgres 11).
We have run VACUUM FULL ANALYZE Is there any test queries that we can bench?
If we had a slow query we could bench we can then verify that VACUUM FULL ANALYZE worked or if another problem is effecting us.
We are having the very same issue. We need to upgrade from Sonar 9.5 to 9.8 Developer edition and it requires to migrate sonarDB from postgres 9.6 to postgres11, so we are trying to do db migration and test if that works with existing SQ 9.5. After migration, SQ comes ups and we can see all the projects, but every scan takes extra long and times out.
We have run VACUUM FULL ANALYZE, but not sure how to verify that it was successful and if we not having different kind of issue causing scans taking much longer and failing with a timeout error.
Please advice on how to verify VACUUM FULL ANALYZE success and/or what else to try.