-
Type:
Bug
-
Resolution: Fixed
-
Priority:
Low
-
Affects Version/s: None
-
Component/s: None
-
None
The cs_indexer_state table (which represents InternalChangesetIndexerState) does not have a uniqueness constraint on its primary key.
Customers have reported duplicate rows in the table, which causes issues with deleting repositories.
- Write a liquibase patch to delete duplicate rows in cs_indexer_state
- Must be run before adding the uniqueness constraint!
- Ideally the liquibase patch should first find all duplicate rows, then delete them and reconstruct 1 row for each set of duplicates.
- Write liquibase patch to add a constraint for unique primary key
- Track down the cause of duplicate rows