Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Blocker
-
Resolution: Fixed
-
Affects Version/s: 8.7
-
Component/s: Database
-
Labels:
-
Edition:Community
-
Production Notes:None
Description
Migration to SQ 8.7 includes step #4208, which is meant to delete the primary key of the `organizations` table.
The implementation relies on a hardcoded PK constraint name "pk_organizations". If the database was restored, or the table renamed in the past, the constraint name could be different for some users, failing the migration and preventing the upgrade.
Solution: Relies on the common pattern "DropPrimaryKeySqlGenerator" that queries the DB to retrieves the constraint name, before deleting it.
Attachments
Issue Links
- is related to
-
SONAR-14543 Migration 4209 fails if the PK constraint name is unexpected
-
- Closed
-
- relates to
-
SONAR-14335 Migration 4102 fails if the PK constraint name is unexpected
-
- Closed
-
-
SONAR-14541 Migration 4207 fails if the PK constraint name is unexpected
-
- Closed
-