[SERVER-54955] Prohibit the use of multi-document write transactions on time-series collections Created: 04/Mar/21  Updated: 29/Oct/23  Resolved: 21/Apr/21

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: 5.0.0-rc0

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

Issue Links:
Depends
Related
is related to SERVER-53619 Verify that $lookup and $unionWith wo... Closed
Backwards Compatibility: Fully Compatible
Operating System: ALL
Sprint: Execution Team 2021-05-03
Participants:
Linked BF Score: 55

 Description   

We are not supporting multi-document write transactions for time-series collections.

There appear to be some liveness issues that need to be addressed. Notably, writers wait for their bucket to commit, and may do this while holding open a long-running transaction.

This appears to also interact poorly with TTL monitor, preventing it from deleting expired buckets.



 Comments   
Comment by Githook User [ 21/Apr/21 ]

Author:

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

Message: SERVER-54955 disallow time-series collection inserts within a multi-document transaction
Branch: master
https://github.com/mongodb/mongo/commit/80263b7df8c274fd54dc949032e0d25afbdc43e4

Comment by Githook User [ 21/Apr/21 ]

Author:

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

Message: SERVER-54955 add does_not_support_transactions to timeseries tests
Branch: master
https://github.com/mongodb/mongo/commit/693e042192e950f57f44493f43896a7331f5926e

Comment by Githook User [ 21/Apr/21 ]

Author:

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

Message: SERVER-54955 add js test for inserting into a time-series collection within a multi-document transaction
Branch: master
https://github.com/mongodb/mongo/commit/1eadaf115d098198845026aef15b0f24578b46b8

Comment by Benety Goh [ 16/Apr/21 ]

We should consider tagging the existing time-series tests in jstests/core/timeseries with the new does_not_support_transactions tag introduced in SERVER-53619.

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