Improve error message emitted by mongos when 'QueryExceededMemoryLimitNoDiskUseAllowed' is thrown, but 'allowDiskUseByDefault' is set to 'true'

XMLWordPrintableJSON

    • Type: Task
    • Resolution: Unresolved
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Execution
    • QE 2025-08-18, QE 2025-09-01
    • None
    • 3
    • TBD
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      As the title describes, his ticket tracks the work to improve error message emitted by mongos when 'QueryExceededMemoryLimitNoDiskUseAllowed' is thrown, but 'allowDiskUseByDefault' is set to 'true'. 

      Following the decision to not pursue SERVER-87735 given that the performance hit of this change (from executing merging $groups/spilling stages on the shards instead of on the router) is to significant, we should improve the error mentioned above to clarify that 'allowDiskUseByDefault' is ignored on mongos when 'QueryExceededMemoryLimitNoDiskUseAllowed'. 

              Assignee:
              Mihai Andrei
              Reporter:
              Mihai Andrei
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated: