DB Issue while Migrating from SonarQube Community Edition 9.9.2 to 24.12

SonarQube Server / Community Build
1

Hi Team,

I am in the process of migrating our SonarQube Community Edition instance from version 9.9.2 to 25.4. As per the upgrade path recommendation, I am first upgrading from 9.9.2 to 24.12, and then I intend to proceed from 24.12 to 25.4.

However, while performing the upgrade to 24.12, during the database schema migration step, I encountered the following error:
Error

> Caused by: java.lang.IllegalStateException: Fail to execute ALTER TABLE components DROP COLUMN module_uuid
> 	at org.sonar.server.platform.db.migration.step.DdlChange$ContextImpl.execute(DdlChange.java:106)
> 	at org.sonar.server.platform.db.migration.step.DropColumnChange.execute(DropColumnChange.java:49)
> 	...
> Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The index 'missing_index_21_20' is dependent on column 'module_uuid'.

Environment details:

  • SonarQube Edition: Community
  • Current Version: 9.9.2 (LTS)
  • Intermediate Version: 24.12 (intermediate step)
  • Final Version: 25.4
  • Database: Microsoft SQL Server

How to resolve this? Looking forward to your inputs and suggestions.

2

Hi.

“missing_index_21_20” doesn’t seem to be an index created by SonarQube. I guess someone created it manually in your database, so, it must be dropped manually too.

3

Thank you so much. That issue has been resolved.

4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.