|
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.
|