Sonarqube upgrade DB issue from 8.5-community to 8.9.5

SonarQube Server / Community Build
1

we were trying to upgrade from 8.5-community to 8.9.5 and there is an issue poppping in db upgrade saying

2022.03.21 05:08:30 INFO  web[][o.s.s.a.EmbeddedTomcat] HTTP connector enabled on port 9000
2022.03.21 05:09:02 INFO  web[][o.s.s.p.d.m.DatabaseMigrationImpl] Starting DB Migration and container restart
2022.03.21 05:09:03 INFO  web[][DbMigrations] Executing DB migrations...
2022.03.21 05:09:03 INFO  web[][DbMigrations] #4204 'Drop organizations in table 'webhooks''...
2022.03.21 05:09:03 ERROR web[][DbMigrations] #4204 'Drop organizations in table 'webhooks'': failure | time=12ms
2022.03.21 05:09:03 ERROR web[][DbMigrations] Executed DB migrations: failure | time=14ms
2022.03.21 05:09:03 ERROR web[][o.s.s.p.d.m.DatabaseMigrationImpl] DB migration failed | time=398ms
2022.03.21 05:09:03 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 #4204 'Drop organizations in table 'webhooks'' 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 com.google.common.collect.ImmutableList.forEach(ImmutableList.java:405)
        at org.sonar.server.platform.db.migration.step.MigrationStepsExecutorImpl.execute(MigrationStepsExecutorImpl.java:52)
        at org.sonar.server.platform.db.migration.engine.MigrationEngineImpl.execute(MigrationEngineImpl.java:68)
        at org.sonar.server.platform.db.migration.DatabaseMigrationImpl.doUpgradeDb(DatabaseMigrationImpl.java:105)
        at org.sonar.server.platform.db.migration.DatabaseMigrationImpl.doDatabaseMigration(DatabaseMigrationImpl.java:80)

can anyone help me here

2

Hey there.

It doesn’t look like you’ve posted the full stack trace here (it’s missing some info at the end, which should say more about why the migration failed).