I would like to suggest that SonarQube documentation could benefit from a page that is specifically dedicated to database upgrade and migration (and titled along those lines).
I am sure that such a page could contain tips for aiding safe upgrade/migration but my real concern is to have a prominent link to Actions that will invalidate your license key
This is something that really bit me last week.
I had looked at the documentation and had no inkling that I was heading for problems.
With SQ EE 8.6 on live and SQ EE 8.8 on test, we performed a migration of Azure PostgreSQL to use Geo-Redundant Storage and thus (for each server) there was a database export/import and a change to DNS. Boom! Everything broke (“Analyses suspended”).
We got everything sorted out (new license keys provided) with the help of our reseller and Sonarsource Support. However, we had lost half a day during which we were unable to perform any releases.
It’s easy enough to find the documentation explaining the issue (link above) but only if you start off by searching the docs for license. If you search the docs for “upgrade” or “database” then it’s not clear at all. Hence the suggestion for an addition to documentation.
Separate from documention improvement… it seems that a license key can only be generated when the server ID is known… and you can only know the new server ID after the changes are complete. So downtime seems unavoidable. How can this be acceptable? Or am I missing something?