Make index on packages_packages unique
The index idx_packages_packages_on_project_id_name_version_package_type
on table packages_packages
is not unique for now. This is due to some data duplication found, see !20549 (comment 250345365).
Duplicated data should be analyzed to investigate how it was duplicated. Check also the UI, how duplicated data is presented.
The following discussion from !20549 (merged) should be addressed:
-
@ahegyi started a discussion: (+7 comments) I have some concerns regarding to this index. Looking at production DB, we have duplicated records in this table (
project_id, name, version, package_type
). The index creation will surely fail.To make this index work, first we must eliminate the duplication, which is quite tricky if we want to support rollbacks. @a_akgun, if I remember correctly, you had an MR with de-duplicating data migration under review. How did it go?