I upgraded from docker container 5.6.6-alpine to 5.6.7-alpine, then to 6.7.5-alpine. I then started the upgrade to 7.9.4-community. It failed with the error:
2020.11.17 22:21:37 ERROR web[o.s.s.p.d.m.DatabaseMigrationImpl] DB migration ended with an exception
org.sonar.server.platform.db.migration.step.MigrationStepExecutionException: Execution of migration step #2506 ‘Migrate quality gate conditions using warning, period and no more supported operations’ failed
at org.sonar.server.platform.db.migration.step.MigrationStepsExecutorImpl.execute(MigrationStepsExecutorImpl.java:79)
at org.sonar.server.platform.db.migration.step.MigrationStepsExecutorImpl.execute(MigrationStepsExecutorImpl.java:67)
at java.base/java.lang.Iterable.forEach(Unknown Source)
I saw a Jira item which indicated that the fix for this is in 7.9.3. I then tried starting 7.9.5-community, and it attempts to migrate the DB again, but gives the same error.
This database was copied from my ‘production’ MSSQL database (running 5.6.6-alpine) and then immediately upgraded in another database instance using the upgrade path above. I saw the workaround in the jira ticket (SONAR-12663) about quality profiles that show “(outdated copy)” in the profile name, but I don’t see anything like it in our instance.