Sonarqube Database Migration from 6.7.7 to 7.9.4 takes forever to complete

SonarQube
,
1

]* which versions are you using (SonarQube, Scanner, Plugin, and any relevant extension)
===> Sonarqube version: 7.9.4 (LTS)

  • what are you trying to achieve
    ====> Hello Team, We are trying to upgrade our sonarqube instance from 6.7.7 to latest enterprise edition of sonarqube. After making a version upgrade to intermediate LTS version (7.9.4), Database migration is taking forever. There are no errors in the logs that looked suspicious. It’s been 16 hours and it’s still going on. Atatched is the web.log

Sonar.log had these statements at the end which seems to be fine:
2020.08.06 00:00:28 WARN app[][startup] ################################################################################ 2020.08.06 00:00:28 WARN app[][startup] The database must be manually upgraded. Please backup the database and browse /setup. For more information: https://docs.sonarqube.org/latest/setup/upgrading 2020.08.06 00:00:28 WARN app[][startup] ################################################################################

web.log (192.6 KB)

Request your help on the same.
Thank you.

3

Hello, did the migration completed eventually?

4

Hello, @pierreguillot Thank you for your response. Yes eventually it got completed but it took more than 56 hours to complete. Is there a way we can speed it up?

5

Not really. If you are on postgres, you can run a vaccum before running the upgrade. But don’t expect an incredible speedup.

6

Thank you for your response.

7

Last night, we upgraded SonarQube from 6.7.6 to 7.9.6, and the Database Migration took us around 7-8 hours.
As additional information, our database size was around 215GBs and hosted MSSQL server.

8

Hi @Tomas_Lazo,

Welcome to the community & thanks for reporting your experience!

I do hope you migrated to 7.9.6 on the way to the current LTS, 8.9.1…?

 
Ann

9

Hi @ganncamp , yes indeed.

1 Like