-
Type: Task
-
Resolution: Done
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
-
Execution Team 2021-10-04, Execution Team 2021-10-18, Execution Team 2021-11-01, Execution Team 2021-11-15, Execution Team 2021-11-29
Investigate the work required to use collMod on a non-unique index to make it unique.
Considerations:
- Should we introduce a "dry-run" mode so that we don't reinforce uniqueness immediately? This could help return conflicts iteratively.
- It's unacceptable for collMod to block all writes to the collection being modified. For unique indexes, we should only have to block incoming inserts that violate the uniqueness constraint.
- Two phase collMod? First phase: Block new inserts that would violate the uniqueness constraint. Second phase: Actually do an index scan to see if an index is consistent.
- is related to
-
SERVER-60314 Investigate adding collMod command options and response fields
- Closed
-
SERVER-34263 Make new format unique index creation dependent on WT specific data format version
- Closed
-
SERVER-46865 collMod should not take database MODE_X lock
- Closed
- related to
-
SERVER-61486 Investigate work needed to track duplicate key violations before unique index conversion time
- Closed