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

Timeseries filtering can miss extended-range events when sharded

    • Type: Icon: Bug Bug
    • Resolution: Unresolved
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • Query Integration
    • ALL
    • Execution Team 2024-02-19, Execution Team 2024-03-04
    • 29

      In SERVER-66469 we fixed timeseries filtering of extended-range data by disabling some predicate pushdown optimizations for collections that have the "requires extended range support" in-memory flag set.

      However, this flag is per-process, so any time one node plans a query to be executed on another, we need to know the value of the flag where the query will execute.

      SERVER-66469 attempts to fix this by checking the flag during view resolution, which in a sharded cluster happens on the primary shard. So if the collection contains extended-range data, but none of it is on the primary shard, mongos will push down more predicates than it should, and the query can miss events outside the 32-bit range.

      We need some mechanism for mongos to know whether extended-range events exist anywhere in the collection.

            Assignee:
            backlog-query-integration [DO NOT USE] Backlog - Query Integration
            Reporter:
            david.percy@mongodb.com David Percy
            Votes:
            0 Vote for this issue
            Watchers:
            11 Start watching this issue

              Created:
              Updated: