Uploaded image for project: 'Documentation'
  1. Documentation
  2. DOCS-16500

Investigate changes in SERVER-79864: TTL deleter does not correctly handle time series collections with extended range dates

    • 3

      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.

            Assignee:
            jason.price@mongodb.com Jason Price
            Reporter:
            backlog-server-pm Backlog - Core Eng Program Management Team
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved:
              22 weeks, 4 days ago