Currently initial sync ignores any in-progress 2 phase index builds. Only if it sees commitIndexBuild oplog entry during the initial sync oplog replay or during secondary oplog application, the index build gets started and committed. Now, the problem is that, for two phase index builds with commit quorum on, the primary can commit the index build only if my number of ready to commit votes satisfy commit quorum value.
Let's assume my commit quorum is "all" and its a 2 node replica set. To be noted, In our today's world, initial syncing nodes can vote, as a result. so consider the below scenario.
1) Node A is primary
2) Node B starts performing initial sync.
3) Primary(node A) starts the index build 'x_1' for collection foo.bar and votes for itself.
4) Node B ignores building/in-progress 'x_1' during initial sync.
5) Node B finishes initial sync.
6) Since Index build 'x_1' has received only one vote < ("all" = 2), so it can't commit the index build and keeps waiting for the votes from secondary(Node B) forever.
- causes
-
SERVER-47700 renameCollection should check if the target collection exists before accessing the collection object
-
- Closed
-
- depends on
-
-
- Closed
-
-
-
- Closed
-
-
SERVER-47155 Limit the number of simultaneous index builds running from user connections to 3
-
- Closed
-
- is depended on by
-
SERVER-46658 Implement commit quorum option "all"
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
- is related to
-
-
- Closed
-
-
-
- Closed
-
- related to
-
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-