DB Migration error from SQ 8.1.0 to 8.9 with Microsoft SQL and Docker

SonarQube Server / Community Build
1

Hi!
We are trying to upgrade Sonarqube
SonarQube version:
From 8.1.0 to 8.9.0 (docker image used: sonarqube:8.9.0-developer)

DB is MSSQL:
Microsoft SQL Server 2016 (SP2-CU5) (KB4475776) - 13.0.5264.1 (X64)
Jan 10 2019 18:51:38
Copyright (c) Microsoft Corporation
Developer Edition (64-bit) on Windows Server 2016 Standard 10.0 (Build 14393: ) (Hypervisor)

Error observed:
upgrade-8-9-0-lts-error.log (4.7 KB)

Do you know what is the root cause of this error?
We are using the docker container for the sonarqube server.

Thanks!

2

Hey there.

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The index ‘IX_projects_enabled_project_uuid_copy_component_uuid_main_branch_project_uuid’ is dependent on column ‘tags’.

This IX_projects_enabled_project_uuid_copy_component_uuid_main_branch_project_uuid index is not one that was created by SonarQube itself (it may have been added by a well-meaning DBA) and should be removed.

Non-default Indexes should not be added to the SonarQube database.