[SERVER-42231] planner returned error: unable to find index for $geoNear query at Connection Ask Question Created: 15/Jul/19 Updated: 10/Sep/19 Resolved: 10/Sep/19 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Geo |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Question | Priority: | Major - P3 |
| Reporter: | Siddhartha Singh | Assignee: | Dmitry Agranat |
| Resolution: | Incomplete | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Participants: |
| Description |
|
I haven't use the $geoNear in my query instead I have used $near. But this is showing the error of $geoNear. And the error create the interruption in processing the query. Not always but once in every hour. scheduleRideSchema.index({ source: '2dsphere' }); }, { pickupEnd: { $lte: pickupStartTime }}] },{ $and: [{ pickupStart: { $gte: pickupStartTime }}, { pickupEnd: { $lte: pickupEndTime }}] }]}, { $or: [{ $and: [{ pickupStart: { $lte: pickupStartTime }}, { pickupEnd: { $gte: pickupStartTime }}] },{ $and: [{ pickupStart: { $lte: pickupStartTime }}, { pickupEnd: { $gte: pickupEndTime }}] }]}]}, { $and:[{ source:{ $near:{ $geometry: { type: "Point", coordinates: sourceCord.coordinates }, $maxDistance: 4000}}},{$and:[ {cancel:false}, { complete:false}]}]}]});}} |
| Comments |
| Comment by Dmitry Agranat [ 10/Sep/19 ] |
|
We haven’t heard back from you for some time, so I’m going to mark this ticket as resolved. If this is still an issue for you, please provide additional information and we will reopen the ticket. Regards, |
| Comment by Dmitry Agranat [ 17/Jul/19 ] |
|
In order for us to investigate, please upload to this secure location:
Thank you, |