[SERVER-79599] Geospatial Query Error on MongoDB Version 6.3.2 Created: 02/Aug/23 Updated: 29/Oct/23 Resolved: 10/Aug/23 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | 6.3.2 |
| Fix Version/s: | 7.1.0-rc0, 7.0.2 |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | APURV VINUBHAI BRAHMBHATT | Assignee: | Irina Yatsenko (Inactive) |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Attachments: |
|
||||||||
| Issue Links: |
|
||||||||
| Assigned Teams: |
Query Integration
|
||||||||
| Backwards Compatibility: | Fully Compatible | ||||||||
| Operating System: | ALL | ||||||||
| Backport Requested: |
v7.0
|
||||||||
| Steps To Reproduce: | Use sample_geospatial.shipwrecks collection and perform attach query operation on the sample data. |
||||||||
| Sprint: | QI 2023-08-07, QI 2023-08-21 | ||||||||
| Participants: | |||||||||
| Description |
|
We have encountered an issue while executing geospatial queries on MongoDB version 6.3.2. The error message "Union requires two index intervals" is being thrown, and this seems to be specific to instances running MongoDB 6.3.2 with a 2D sphere index created. It's important to note that this error does not occur when the query performs a COLLSCAN operation. Furthermore, we have identified that the issue arises when the query involves a compound operation of geospatial and other equality operations. However, if we remove the non-geospatial condition from the query, it executes successfully without any errors. The problem is observed on both Atlas serverless and dedicated instances running MongoDB version 6.3.2. Notably, we have verified that this error is not present in MongoDB versions 6.0.8 and 5.0.19. |
| Comments |
| Comment by Githook User [ 31/Aug/23 ] | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Author: {'name': 'Irina Yatsenko', 'email': 'irina.yatsenko@mongodb.com', 'username': 'IrinaYatsenko'}Message: (cherry picked from commit 27232edfa918dc843b4f46991a98623e7d4aece7) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Comment by Githook User [ 10/Aug/23 ] | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Author: {'name': 'Irina Yatsenko', 'email': 'irina.yatsenko@mongodb.com', 'username': 'IrinaYatsenko'}Message: | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Comment by Irina Yatsenko (Inactive) [ 09/Aug/23 ] | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Note: the same assert would fire for a query that has a top-level $or with 2+ geo expressions and any "parameterizable" expression such as $eq.
|