Always broadcast queries using read concern level "available" to avoid missing unowned documents when filter includes equality on shard key fields

XMLWordPrintableJSON

    • Type: Improvement
    • Resolution: Won't Fix
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: Distributed Query Planning
    • None
    • Query Optimization
    • QE 2023-02-06, QE 2023-02-20, QE 2023-03-06, QE 2023-03-20, QE 2023-04-03
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None

      Read concern level "available" is used to find unowned documents in a sharded cluster. Allowing these queries be targeted to a subset of the shards is counterproductive because it means unowned documents within a particular chunk range cannot be easily searched for.

      One workaround is to do an aggregation pipeline with {$replaceWith: "$$ROOT"} as it'll prevent the shard targeting optimization.

            Assignee:
            Nicholas Zolnierz
            Reporter:
            Max Hirschhorn
            Votes:
            0 Vote for this issue
            Watchers:
            10 Start watching this issue

              Created:
              Updated:
              Resolved: