Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-79864

TTL deleter does not correctly handle time series collections with extended range dates

    • Storage Execution
    • Fully Compatible
    • ALL
    • v7.2, v7.0, v6.0, v5.0
    • Execution Team 2023-11-13, Execution Team 2023-11-27

      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:
            gregory.noma@mongodb.com Gregory Noma
            Reporter:
            dan.larkin-york@mongodb.com Dan Larkin-York
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: