Hi, i try to upgrade from 8.9.10 LTS to 9.7.1 I got this DB Migration error , any hints? org.sonar.server.platform.db.migration.step.MigrationStepExecutionException: Execution of migration step #6006 'Drop 'user_managed' column from 'metrics' table' failed at org.sonar.server.platform.db.migratio…

After manually deleting the constraint - it does work ALTER TABLE dbo.metrics DROP CONSTRAINT DF__metrics__user_ma__084B3915; GO

Migration error when upgrading to 9.7.1

pierreguillot (Pierre Guillot) February 28, 2023, 9:40am 10

We identified the issue, more details in this post.

1 Like

Topic		Replies	Views
Database upgrade failed SonarQube Server / Community Build migration	3	1238	January 21, 2022
Sonarqube upgrade from 7.9. to 8.9.6.50800 -- 'Drop 'ISSUES' table' failed SonarQube Server / Community Build sonarqube	2	161	March 27, 2024
DBMigration failed 7.9.1 -> 8.5.1 SonarQube Server / Community Build sonarqube , migration	7	852	December 11, 2020
DB migration failed when upgrading from Enterprise edition version 8.5.1.38104 to version 8.7.0.41497 SonarQube Server / Community Build	14	1076	April 14, 2021
Problem during db migration from LTS 6.7.4 to LTS 7.9 SonarQube Server / Community Build upgrade , mssql , migration	11	1186	July 4, 2019