[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: |
|
||||||||||||||||||||||||||||||||
| 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: |
| 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 " This reverts commit 52edfc95120356042ad9d749d422ba5b6a6005ed. |
| Comment by Githook User [ 10/Jul/23 ] |
|
Author: {'name': 'Malik Endsley', 'email': 'malik.endsley@mongodb.com', 'username': 'malikendsley'}Message: |
| Comment by Githook User [ 03/Jul/23 ] |
|
Author: {'name': 'Malik Endsley', 'email': 'malik.endsley@mongodb.com', 'username': 'malikendsley'}Message: Revert " This reverts commit fbc461766ed7eb68065fb182f54210e5f819b43a. |
| Comment by Githook User [ 03/Jul/23 ] |
|
Author: {'name': 'Malik Endsley', 'email': 'malik.endsley@mongodb.com', 'username': 'malikendsley'}Message: |
| 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 " This reverts commit fbc461766ed7eb68065fb182f54210e5f819b43a. |
| Comment by Githook User [ 28/Jun/23 ] |
|
Author: {'name': 'Malik Endsley', 'email': 'malik.endsley@mongodb.com', 'username': 'malikendsley'}Message: |