Sonarqube upgrade DB issue from 8.5-community to 8.9.5

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(
        at org.sonar.server.platform.db.migration.step.MigrationStepsExecutorImpl.execute(
        at org.sonar.server.platform.db.migration.step.MigrationStepsExecutorImpl.execute(
        at org.sonar.server.platform.db.migration.engine.MigrationEngineImpl.execute(
        at org.sonar.server.platform.db.migration.DatabaseMigrationImpl.doUpgradeDb(
        at org.sonar.server.platform.db.migration.DatabaseMigrationImpl.doDatabaseMigration(

can anyone help me here

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).