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

XMLWordPrintableJSON

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

      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
              Reporter:
              Dan Larkin-York
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Created:
                Updated:
                Resolved: