Hey sonar experts,
I am trying to upgrade from 7.6 to 7.9.x LTS but I’m getting many DB issues.
Either I tried going through 7.7 , 8.0, 8.1 no matter what I do, I have always the same exact error with that index.
As a workaround the database admin in my team tried to create the index missing but it doesn’t work as expected, after the creation of the index we have after many issues with some constraints, issue after issue.
We need to upgarde asap.
Any news or solution for this??
I see there is a similar post some months ago but nothing posted as a solution.
I have this error:
2020.02.17 10:21:17 ERROR web[o.s.s.p.d.m.DatabaseMigrationImpl] DB migration failed | time=262ms
2020.02.17 10:21:17 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 #2606 ‘Drop DATA_TYPE column from FILE_SOURCES table’ failed
Caused by: java.lang.IllegalStateException: Fail to execute DROP INDEX file_sources_uuid_type ON file_sources
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot drop the index ‘file_sources.file_sources_uuid_type’, because it does not exist or you do not have permission.