[SERVER-78855] Use snapshot isolation for Queryable Encryption transactions Created: 11/Jul/23  Updated: 29/Oct/23  Resolved: 14/Jul/23

Status: Closed
Project: Core Server
Component/s: Queryable Encryption
Affects Version/s: 7.0.0-rc7
Fix Version/s: 7.1.0-rc0, 7.0.0-rc8

Type: Task Priority: Major - P3
Reporter: Tyler Brock Assignee: Mark Benvenuto
Resolution: Fixed Votes: 0
Labels: server-rapid-response-resolved
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: Microsoft Word perf_criteria.xlsx    
Issue Links:
Backports
Depends
is depended on by SERVER-78952 Revert SERVER-78855 after SERVER-77506 Closed
Documented
is documented by DOCS-16264 [Server] Investigate changes in SERVE... Closed
Related
related to SERVER-77506 Sharded multi-document transactions c... Closed
Backwards Compatibility: Minor Change
Backport Requested:
v7.0
Sprint: Security 2023-07-24
Participants:

 Description   

Use of distributed transactions involving multiple collections makes it more likely that users of QE will hit SERVER-77506. Until it's resolved we should upgrade transactions used as part of QE to use snapshot read concern.



 Comments   
Comment by Githook User [ 14/Jul/23 ]

Author:

{'name': 'Mark Benvenuto', 'email': 'mark.benvenuto@mongodb.com', 'username': 'markbenvenuto'}

Message: SERVER-78855 Use snapshot isolation for Queryable Encryption transactions

(cherry picked from commit 6af0418e8f557f76e195b4a0aca5acb4d0372312)
Branch: v7.0
https://github.com/mongodb/mongo/commit/1455d3e1b0450ae95d20b2fa37da011030d9f69c

Comment by Mark Benvenuto [ 13/Jul/23 ]

*Rapid Response Update
Estimated Date of Completion:
July 14, 2023

On Track? Y/N
Y

Overall status summary:
Code merged into master. Diagnosis 50/50 perf test show performance was also acceptable (1-2% slower).
Will do BACKPORT-16596 on July 14 after code as baked for ~24 hours in master.
cynthia.braund@mongodb.com, QE PM, said performance was acceptable in slack.
Meeting with security on July 14 to discuss any security concerns they may have.

Current team members assigned:
mark.benvenuto@mongodb.com

Resources requested:
None

FTS contacts:
None

Where is this issue being discussed?
This ticket

Comment by Githook User [ 13/Jul/23 ]

Author:

{'name': 'Mark Benvenuto', 'email': 'mark.benvenuto@mongodb.com', 'username': 'markbenvenuto'}

Message: SERVER-78855 Use snapshot isolation for Queryable Encryption transactions
Branch: master
https://github.com/mongodb/mongo/commit/6af0418e8f557f76e195b4a0aca5acb4d0372312

Comment by Mark Benvenuto [ 12/Jul/23 ]

*Rapid Response Update
Estimated Date of Completion:
July 14, 2023

On Track? Y/N
Y

Overall status summary:
PRs approved. Re-run of performance criteria mostly complete. Performance impact ranges from negligible to 38% in P95 Latency. 100% writes (i.e. just inserts) show 14% slow down. For operations per second, the impact ranges from negligible to 8%. See attached excel spreadsheet. Waiting on more test to be run for diagnosis 50/50.

Current team members assigned:
mark.benvenuto@mongodb.com

Resources requested:
None

FTS contacts:
None

Where is this issue being discussed?
This ticket

Comment by PM Bot [ 11/Jul/23 ]

This issue has been flagged for rapid response!

Assignees of rapid response tickets are responsible for providing a daily update on this issue using the 'Server Rapid Response' canned comment template.

Any questions about this ticket can be directed to the #server-rapid-response Slack channel and more information on the Server Rapid Response process can be found on the Wiki 

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