-
Type: Task
-
Resolution: Done
-
Priority: Minor - P4
-
Affects Version/s: None
-
Labels:
-
3
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.
- backports
-
DOCS-16517 [BACKPORT] [v7.0] TTL deleter does not correctly handle time series collections with extended range dates
- Closed
-
DOCS-16518 [BACKPORT] [v6.0] TTL deleter does not correctly handle time series collections with extended range dates
- Closed
- documents
-
SERVER-79864 TTL deleter does not correctly handle time series collections with extended range dates
- Closed
- is duplicated by
-
DOCS-16515 [BACKPORT] [v7.2] TTL deleter does not correctly handle time series collections with extended range dates
- Closed