Upgrade issue from 7.0 to 7.9 LTS

We are attempting an upgrade on SonarQube from version 7.0 to 7.9 LTS within a docker image on Azure. When working through the upgrade process we received an error for schema issues on the Azure SQL database. We are currently going to work on creating a new database for our 7.9 LTS upgrade, but wanted to understand the best process available for the upgrade process that will not require us to provision a new Azure SQL database, and be able to retain the historical data.

Thank you,

Nicholas Dunlap

Hey Nichloas,

A great start would be including the exact error you’re receiving.

Colin

Hi Colin,

I was able to work with the team on the warning and error message that was produced:

2019.09.25 09:48:06 WARN web[o.s.s.p.DatabaseServerCompatibility] The database must be manually upgraded. Please backup the database and browse /setup. For more information: https://docs.sonarqube.org/latest/setup/upgrading
2019.09.25 09:48:06 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

When we went to the SonarQube dashboard, we also received a maintenance message stating:
SonarQube is under maintenance.
While waiting, you might want to investigate new plugins to extend the current functionality. If you are the administrator and have no idea why this message is being shown, you should read the upgrade guide.

When checking into the upgrade guide, there isn’t a mention of an issue between the two versions or how migration could occur for the databases.

Best Regards,

Nicholas

Hmm…

Have you tried this?

https://docs.sonarqube.org/latest/setup/upgrading/
(…)
7. Browse to http://yourSonarQubeServerURL/setup and follow the setup instructions

1 Like