[SERVER-77586] Consider allowing capped collections to have TTL indexes Created: 30/May/23  Updated: 29/Oct/23  Resolved: 13/Jul/23

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

Type: Task Priority: Major - P3
Reporter: Cheahuychou Mao Assignee: Malik Endsley (Inactive)
Resolution: Fixed Votes: 0
Labels: auto-reverted
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
is depended on by SERVER-76477 Cap the size of the collections stori... Open
is depended on by COMPASS-6985 Investigate changes in SERVER-77586: ... Closed
Documented
is documented by DOCS-16225 [Server] Investigate SERVER-77586: Co... Closed
Problem/Incident
Related
related to SERVER-79318 Re-merge collmod_convert_capped_to_tt... Open
Assigned Teams:
Storage Execution
Backwards Compatibility: Fully Compatible
Sprint: Execution NAMR Team 2023-06-26, Execution NAMR Team 2023-07-10, Execution NAMR Team 2023-07-24
Participants:
Linked BF Score: 164

 Description   

MongoDB doesn't currently allow capped collections to have TTL indexes. The reason dated back to when capped collections used to not replicate explicitly and so it wasn't possible to delete from them and get consistent results. In PM-1858, we want the collections for storing sampled queries (config.sampledQueries and config.sampledQueriesDiff) to be both capped and have a TTL index. These collections currently have TTL indexes but are not capped because of the aforementioned restriction.



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

Author:

{'name': 'Malik Endsley', 'email': 'malik.endsley@mongodb.com', 'username': 'malikendsley'}

Message: SERVER-77586 Allow capped collections and TTL indexes simultaneously
Branch: master
https://github.com/mongodb/mongo/commit/82c72dfc1825f05978fbf8b2db659ce3f83114aa

Comment by xgen-buildbaron-user [ 11/Jul/23 ]

Ticket re-opened due to revert. replica_sets_max_mirroring_large_txns_format_ese_gcm began a consistent failure of jstests/replsets/ttl_index_with_capped_collection.js

Comment by Githook User [ 11/Jul/23 ]

Author:

{'name': 'auto-revert-processor', 'email': 'dev-prod-dag@mongodb.com', 'username': ''}

Message: Revert "SERVER-77586 Allow capped collections and TTL indexes simultaneously"

This reverts commit 52edfc95120356042ad9d749d422ba5b6a6005ed.
Branch: master
https://github.com/mongodb/mongo/commit/a6510e3a7f25bddcf91fd944db24c1951d84b0d2

Comment by Githook User [ 10/Jul/23 ]

Author:

{'name': 'Malik Endsley', 'email': 'malik.endsley@mongodb.com', 'username': 'malikendsley'}

Message: SERVER-77586 Allow capped collections and TTL indexes simultaneously
Branch: master
https://github.com/mongodb/mongo/commit/52edfc95120356042ad9d749d422ba5b6a6005ed

Comment by Githook User [ 03/Jul/23 ]

Author:

{'name': 'Malik Endsley', 'email': 'malik.endsley@mongodb.com', 'username': 'malikendsley'}

Message: Revert "SERVER-77586 Allow capped collections and TTL indexes simultaneously"

This reverts commit fbc461766ed7eb68065fb182f54210e5f819b43a.
Branch: EVG-17874-taskgen-test
https://github.com/mongodb/mongo/commit/e12eb853c9855880ab1e6385494ca0d3768e7678

Comment by Githook User [ 03/Jul/23 ]

Author:

{'name': 'Malik Endsley', 'email': 'malik.endsley@mongodb.com', 'username': 'malikendsley'}

Message: SERVER-77586 Allow capped collections and TTL indexes simultaneously
Branch: EVG-17874-taskgen-test
https://github.com/mongodb/mongo/commit/fbc461766ed7eb68065fb182f54210e5f819b43a

Comment by Malik Endsley (Inactive) [ 30/Jun/23 ]

my bad

Comment by Githook User [ 29/Jun/23 ]

Author:

{'name': 'Malik Endsley', 'email': 'malik.endsley@mongodb.com', 'username': 'malikendsley'}

Message: Revert "SERVER-77586 Allow capped collections and TTL indexes simultaneously"

This reverts commit fbc461766ed7eb68065fb182f54210e5f819b43a.
Branch: master
https://github.com/mongodb/mongo/commit/e12eb853c9855880ab1e6385494ca0d3768e7678

Comment by Githook User [ 28/Jun/23 ]

Author:

{'name': 'Malik Endsley', 'email': 'malik.endsley@mongodb.com', 'username': 'malikendsley'}

Message: SERVER-77586 Allow capped collections and TTL indexes simultaneously
Branch: master
https://github.com/mongodb/mongo/commit/fbc461766ed7eb68065fb182f54210e5f819b43a

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