[SERVER-46601] createIndexes on local database collections should not use two phase index build + commit quorum for building indexes. Created: 04/Mar/20  Updated: 29/Oct/23  Resolved: 04/Mar/20

Status: Closed
Project: Core Server
Component/s: Storage
Affects Version/s: None
Fix Version/s: 4.4.0-rc0, 4.7.0

Type: Bug Priority: Major - P3
Reporter: Suganthi Mani Assignee: Benety Goh
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Backports
Depends
Related
related to SERVER-47182 Single-phase index builds should run ... Closed
Backwards Compatibility: Fully Compatible
Operating System: ALL
Backport Requested:
v4.4
Sprint: Execution Team 2020-03-09
Participants:
Linked BF Score: 25

 Description   

When the commit quorum is turned on for the index build, the primary will always wait for secondaries "ready to commit" votes before committing the index build. Since the index build was built on local collection, we don't replicate the startIndexBuild oplog entry to secondaries. As a result, secondaries won't be able to build the index build and participate in voting process. This can lead to index build on primary to get hang forever.

I would expect this ticket to make sure that index build on local db collections/non-replicated databases should not use commit quorum. And, should throw an error to user if the user tries to run createIndexes cmd on non-replicated databases with commit quorum options set.



 Comments   
Comment by Githook User [ 04/Mar/20 ]

Author:

{'name': 'Benety Goh', 'username': 'benety', 'email': 'benety@mongodb.com'}

Message: SERVER-46601 disallow two phase index builds for non-replicated collections

(cherry picked from commit c752f2b20efee7de94123787950415723c38b91f)
Branch: v4.4
https://github.com/mongodb/mongo/commit/56d733a5c6ecf7c44ee797fad9e400ceac0badd6

Comment by Githook User [ 04/Mar/20 ]

Author:

{'username': 'benety', 'name': 'Benety Goh', 'email': 'benety@mongodb.com'}

Message: SERVER-46601 disallow two phase index builds for non-replicated collections
Branch: master
https://github.com/mongodb/mongo/commit/c752f2b20efee7de94123787950415723c38b91f

Comment by Benety Goh [ 04/Mar/20 ]

Code review url: https://mongodbcr.appspot.com/554830037/

Generated at Thu Feb 08 05:11:56 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.