[SERVER-66566] Optimize scanning SessionCatalog when refreshing retryable writes from storage Created: 18/May/22  Updated: 29/Oct/23  Resolved: 19/May/22

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

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

Issue Links:
Backports
Backwards Compatibility: Fully Compatible
Operating System: ALL
Backport Requested:
v6.0
Sprint: Sharding NYC 2022-05-30
Participants:

 Description   

To support retryable writes that execute statements as transactions, when refreshing a retryable write from storage, we scan the session catalog for the highest txnNumber for that session. Scanning the catalog locks it, so we should optimize this scan to leverage the changes from SERVER-62479 to store all child sessions with their parent to either only scan those children or to scan no sessions by caching the highest txnNumber of any child directly with each parent session.



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

Author:

{'name': 'Cheahuychou Mao', 'email': 'mao.cheahuychou@gmail.com', 'username': 'cheahuychou'}

Message: SERVER-66566 Optimize scanning SessionCatalog when refreshing retryable writes from storage

(cherry picked from commit c08864097934c74da40ffff9ea46176fb471ead5)
Branch: v6.0
https://github.com/mongodb/mongo/commit/9059aa49eb671b272051b21237ec04db43794ad8

Comment by Githook User [ 19/May/22 ]

Author:

{'name': 'Cheahuychou Mao', 'email': 'mao.cheahuychou@gmail.com', 'username': 'cheahuychou'}

Message: SERVER-66566 Optimize scanning SessionCatalog when refreshing retryable writes from storage
Branch: master
https://github.com/mongodb/mongo/commit/c08864097934c74da40ffff9ea46176fb471ead5

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