Info

DDL locks acquired outside ShardingDDLCoordinator infrastructure does not properly synchronize with other DDL operations in case of failovers/stepdowns. Recovery of DDL locks for Sharding DDL coordinator works in the following way: Some sharding DDL coordinators starts and acquire their respective DDL locks The primary shard of the database stepdown A new primary of the primary shard is elected and starts the recovery of the interrupted Sharding DDL coordinators The ShardingDDLCoordinator service enters into RECOVERY state All attempt to create new coordinators will wait until the service complete the recovery Once all the coordinators have been recovered and reacquired their DDL locks, the ShardingDDLCoordinator service move to RECOVERED state. Creation of new coordinators is unblocked. DDL locks acquired outside the ShardingDDLCoordinator infrastructure does not wait for the recovery of DDL locks acquired before the stepdown. We should ensure that DDL locks can be acquired only after all DDL locks acquired from the previous primary node have been recovered.

Top User Comments

xgen-internal-githook commented on Fri, 9 Feb 2024 08:09:24 +0000: Author: {'name': 'Silvia Surroca', 'email': 'silvia.surroca@mongodb.com', 'username': 'silviasuhu'} Message: SERVER-76463 SERVER-81534 Ensure Sharding DDL locks acquired outside a coordinator wait for DDL recovery (cherry picked from commit 4954cb44e1ceeda02db1902ffd7ea89d08c7b04c) (cherry picked from commit 1b6505db86852401a5ecddf43afc6945a03fbcc1) GitOrigin-RevId: 44d3d4cc583b161da7da7b810786a015f4a868e0 Branch: v7.0 https://github.com/mongodb/mongo/commit/7c85cb76b0e5dc099d8f8402a0c20ea5ecf4a94b JIRAUSER1260430 commented on Tue, 26 Sep 2023 16:06:31 +0000: Requesting a backport for this ticket, since SERVER-76626 which originally caused this ticket to be filed was just backported to 7.0. This change will be backported by BACKPORT-16706. xgen-internal-githook commented on Tue, 30 May 2023 16:45:28 +0000: Author: {'name': 'Silvia Surroca', 'email': 'silvia.surroca@mongodb.com', 'username': 'silviasuhu'} Message: SERVER-76463 Ensure Sharding DDL locks acquired outside a coordinator wait for DDL recovery Branch: master https://github.com/mongodb/mongo/commit/4954cb44e1ceeda02db1902ffd7ea89d08c7b04c

Steps to Reproduce