[SERVER-66565] Create config.transactions partial index in setFCV Created: 18/May/22  Updated: 29/Oct/23  Resolved: 24/May/22

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: 6.0.0-rc8, 6.1.0-rc0

Type: Bug Priority: Major - P3
Reporter: Jack Mulrow Assignee: Jack Mulrow
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Backports
Depends
Problem/Incident
causes SERVER-66828 Coverity analysis defect 122257: Misu... Closed
Related
related to SERVER-67801 createIndexes should handle empty ind... Closed
related to SERVER-66755 Enable rollback_transaction_table.js ... Closed
Backwards Compatibility: Fully Compatible
Operating System: ALL
Backport Requested:
v6.0
Sprint: Sharding NYC 2022-05-30
Participants:
Linked BF Score: 169

 Description   

The partial secondary index needed for retryable transactions is created on step up to primary after creating the config.transactions collection for the first time, but this is skipped if the collection already exists. Thus if the collection already exists and the index wasn't initially created, the index will never be created. Creating an index on an existing collection is too expensive to do on transition to primary, and instead should be done as part of setFCV.



 Comments   
Comment by Githook User [ 25/May/22 ]

Author:

{'name': 'Jack Mulrow', 'email': 'jack.mulrow@mongodb.com', 'username': 'jsmulrow'}

Message: SERVER-66565 Use hint with config.transactions partial index and allow creating it
Branch: master
https://github.com/mongodb/mongo/commit/80e519f931ee0339b34e2546d274e21499e437b6

Comment by Githook User [ 24/May/22 ]

Author:

{'name': 'Jack Mulrow', 'email': 'jack.mulrow@mongodb.com', 'username': 'jsmulrow'}

Message: SERVER-66565 Create config.transactions partial index in setFCV
Branch: v6.0
https://github.com/mongodb/mongo/commit/222a559ce8c742b4170985979291fe563d888d17

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