[SERVER-43692] enable two phase index builds by default Created: 27/Sep/19  Updated: 29/Oct/23  Resolved: 02/Dec/19

Status: Closed
Project: Core Server
Component/s: Storage
Affects Version/s: None
Fix Version/s: 4.3.3

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

Issue Links:
Depends
depends on SERVER-43323 replicated index builds not writing s... Closed
depends on SERVER-43353 index_stepdown_init.js must handle er... Closed
depends on SERVER-43403 Index creation may be allowed to star... Closed
depends on SERVER-43415 indexbg_killop_primary.js crashes whe... Closed
depends on SERVER-43612 secondary fails to start index build ... Closed
depends on SERVER-44250 startIndexBuild oplog write and threa... Closed
depends on SERVER-44329 update dbtest suite StorageTimestampT... Closed
depends on SERVER-44344 legacy map reduce fails to recreate i... Closed
depends on SERVER-44393 indexu.js fails in replica_set_passth... Closed
depends on SERVER-44397 index build continues to enforce cons... Closed
depends on SERVER-44526 Deadlock in ConfigServerTestFixture::... Closed
depends on SERVER-44544 IndexBuildsCoordinator::_buildIndexTw... Closed
depends on SERVER-43822 db_catalog_test RenameCollectionTest ... Closed
depends on SERVER-43869 aborted index build cleanup on mobile... Closed
depends on SERVER-44742 inconsistent checks for two phase ind... Closed
depends on SERVER-39002 killOp against a primary index build ... Closed
depends on SERVER-39451 Add recover to a stable timestamp log... Closed
depends on SERVER-39484 Add step-up and step-down state trans... Closed
depends on SERVER-43301 add no_passthrough to two phase index... Closed
depends on SERVER-43635 Enable backup_cursor_extend_waiting_l... Closed
depends on SERVER-43636 Enable characterize_index_builds_on_r... Closed
depends on SERVER-43637 Enable hybrid_unique_index_with_updat... Closed
depends on SERVER-43638 Do not block prepared transactions on... Closed
depends on SERVER-43639 Two phase index build completion shou... Closed
depends on SERVER-43932 add sharding to two phase index build... Closed
depends on SERVER-43935 Enable change_streams_primary_shard_u... Closed
depends on SERVER-44040 add replica_sets to two phase index b... Closed
depends on SERVER-44041 Enable prepare_transaction_index_buil... Closed
depends on SERVER-44042 Enable reconstruct_prepared_transacti... Closed
depends on SERVER-44043 Enable secondary_as_sync_source.js wh... Closed
depends on SERVER-44350 write rollback tests for two phase in... Closed
depends on SERVER-44408 Persist index build UUID to the durab... Closed
depends on SERVER-44467 Implement startup recovery for two-ph... Closed
depends on SERVER-44784 disable two phase index builds when m... Closed
depends on SERVER-44785 replace two_phase_index_builds_unsupp... Closed
depends on SERVER-43315 extend abortIndexBuild oplog entry to... Closed
depends on SERVER-43419 remove unnecessary FCV check from Mul... Closed
depends on SERVER-43837 remove RSTL unlocking logic from Mult... Closed
depends on SERVER-44121 allow Index builds to opt out of the ... Closed
depends on SERVER-44186 allow index builds to continue runnin... Closed
depends on SERVER-44436 IndexBuildsCoordinatorMongod should a... Closed
depends on SERVER-44437 remove DBDirectClient reference from ... Closed
depends on SERVER-44439 add js helper function to check suppo... Closed
is depended on by SERVER-38961 Remove override for causally consiste... Closed
Duplicate
is duplicated by SERVER-14746 IndexRebuilder should only restart in... Closed
Problem/Incident
Related
related to SERVER-21307 Replicated DDL (catalog) operation du... Closed
related to SERVER-44859 plan_cache_index_create.js is blocked... Closed
is related to SERVER-43259 add server parameter for enabling two... Closed
Backwards Compatibility: Fully Compatible
Sprint: Execution Team 2019-12-02
Participants:
Linked BF Score: 40

 Description   

The server parameter enableTwoPhaseIndexBuild controls whether two phase index builds are in effect. Currently in a replica set, index builds are represented by a single createIndexes oplog entry. When this feature is enabled, every index build will be represented by a pair of oplog entries

  • startIndexBuild
  • commitIndexBuild (or abortIndexBuild)


 Comments   
Comment by Githook User [ 02/Dec/19 ]

Author:

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

Message: SERVER-43692 enable two phase index builds by default
Branch: master
https://github.com/mongodb/mongo/commit/74ed36565b863574489ea05fe22ee7d5ec78ab8d

Comment by Githook User [ 02/Dec/19 ]

Author:

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

Message: SERVER-43692 disable two phase index build in flow control tests with low ticket limits
Branch: master
https://github.com/mongodb/mongo/commit/1f453b97b2cda21ba67efad05345b81f09eba862

Comment by Githook User [ 27/Nov/19 ]

Author:

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

Message: Revert "SERVER-43692 enable two phase index builds by default"

This reverts commit 1de4865c270a064b6c833a44a54248ee69dcd8ab.
Branch: master
https://github.com/mongodb/mongo/commit/22c12339cdc32058fe2bb79bea881fc1690e5d2f

Comment by Githook User [ 26/Nov/19 ]

Author:

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

Message: SERVER-43692 enable two phase index builds by default
Branch: master
https://github.com/mongodb/mongo/commit/1de4865c270a064b6c833a44a54248ee69dcd8ab

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