Solve null equality in BBM that deduplicates lfs_objects_projects
requested to merge 495649-solve-null-equality-in-bbm-that-deduplicates-lfs_objects_projects into master
What does this MR do and why?
- We previously ran a batched background migration to deduplicate lfs_objects_projects in preparation for adding a unique index over
lfs_object_id
,project_id
andrepository_type
. - We added an advisory lock to ensure the uniqueness of new LFS objects projects Add advisory lock to ensure uniqueness of LFS o... (!159264 - merged)
- After the migration finished we found examples of new duplicate rows
- We mitigate those in Check for existing LfsObjectProject before copying (!163992 - merged)
- We found one last case where duplicates have the
repository_type
column as NULL and the fix for it (#472750 (comment 2132395356)). Before finalizing it, we need to include that fix in the batched background migration.
This MR re-enqueues the batched background migration while providing a fix for those records with repository_type
NULL.
MR acceptance checklist
Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.
Related to #495649 (closed)
Edited by Javiera Tapia