[SERVER-83519] $search inside $lookup is failing with a SBE-related error Created: 21/Nov/23 Updated: 14/Dec/23 Resolved: 05/Dec/23 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Query Execution |
| Affects Version/s: | None |
| Fix Version/s: | 7.3.0-rc0 |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | William Zhou | Assignee: | Zixuan Zhuang |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||||||
| Assigned Teams: |
Query Execution
|
||||||||||||
| Backwards Compatibility: | Fully Compatible | ||||||||||||
| Operating System: | ALL | ||||||||||||
| Backport Requested: |
v7.2
|
||||||||||||
| Participants: | |||||||||||||
| Description |
| Comments |
| Comment by Githook User [ 01/Dec/23 ] | |||||||||||
|
Author: {'name': 'Kevin Cherkauer', 'email': 'kevin.cherkauer@mongodb.com', 'username': 'kevin-cherkauer'}Message: | |||||||||||
| Comment by Kevin Cherkauer [ 28/Nov/23 ] | |||||||||||
|
The high-level problem is that a SlotId is referenced at execution time that cannot be found (may not exist, or may exist but not be visible). As all the failing queries have a $sort stage, the problem may be related to the recent addition of a new slot for sorts in support of $search: PlanStageMetadataSlots::sortKeySlot – sbe_stage_builder_plan_data.h This was added 2023-10-23 by | |||||||||||
| Comment by William Zhou [ 27/Nov/23 ] | |||||||||||
|
Hi kevin.cherkauer@mongodb.com, I attached the full patch build link to the description of the ticket. We are able to reproduce the error by running a evergreen patch on mongot-master against the mongo nightly build. Full steps below:
The JSON files provided are consumed by the mongot E2E test runner, which creates a collection of the documents specified in the test, creates a search index against that collection, then runs the specified aggregation pipeline against the collection. Let me know if any other information is needed. | |||||||||||
| Comment by William Zhou [ 21/Nov/23 ] | |||||||||||