-
Type: Task
-
Resolution: Unresolved
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
Labels:None
-
Catalog and Routing
-
CAR Team 2024-04-15, CAR Team 2024-04-29, CAR Team 2024-05-13
-
1
MigrationDestinationManager::cloneCollectionIndexesAndOptions takes a database MODE_X lock if the collection does not exist or is missing required indexes. This can cause stalls on transactions that involve other collections from the same database. This DB-level MODE_X lock seems excessive: Collection creation only needs collection/db in MODE_IX; and createIndexesOnEmptyCollection needs collection in MODE_X (so DB in MODE_IX).
This ticket is to consider relaxing at least the db-level exclusive lock to IX.
- related to
-
SERVER-38285 Only acquire database X-lock on the recipient if the collection does not exist
- Closed