[DOCS-16500] Investigate changes in SERVER-79864: TTL deleter does not correctly handle time series collections with extended range dates Created: 15/Nov/23  Updated: 08/Jan/24  Resolved: 01/Dec/23

Status: Closed
Project: Documentation
Component/s: manual, Server
Affects Version/s: None
Fix Version/s: 7.3.0-rc0, 7.2.0-rc2, 7.0.5, 6.0.13, 5.0.24, Server_Docs_[20240108]

Type: Task Priority: Minor - P4
Reporter: Backlog - Core Eng Program Management Team Assignee: Jason Price
Resolution: Done Votes: 0
Labels: feature
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Backports
backports DOCS-16517 [BACKPORT] [v7.0] TTL deleter does no... Closed
backports DOCS-16518 [BACKPORT] [v6.0] TTL deleter does no... Closed
Documented
documents SERVER-79864 TTL deleter does not correctly handle... Closed
Duplicate
is duplicated by DOCS-16515 [BACKPORT] [v7.2] TTL deleter does no... Closed
Participants:
Days since reply: 9 weeks, 6 days ago
Story Points: 3

 Description   
Original Downstream Change Summary

If a time-series collection contains any measurements whose time field is either before 1970-01-01T00:00:00.000Z or after 2038-01-19T03:14:07.000Z, TTL deletes will not be performed on that collection.

Description of Linked Ticket

Our issues with extended-range dates was first surfaced via SERVER-66469, and addressed by a series of follow-up tickets. The end state is correct, but slow query behavior when these dates are present. However, we did not properly address the impact of extended-range dates on TTL behavior, which still uses the bucket _id (OID) for sorting and filtering.

Until we introduce a new bucket _id format that can represent the full date range in properly sorted order, we should disable TTL deletion for time series collections with extended range dates.



 Comments   
Comment by Jason Price [ 30/Nov/23 ]

https://github.com/10gen/docs-mongodb-internal/pull/5429

Generated at Thu Feb 08 08:15:31 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.