[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.
I have used '2dsphere' index already---

scheduleRideSchema.index({ source: '2dsphere' });
 
{{ $or: [{ $or: [{ $and: [{ pickupStart:

{ $gte: pickupStartTime }

}, { 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 ]

Hi shibu.siddharth@gmail.com

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,
Dima

Comment by Dmitry Agranat [ 17/Jul/19 ]

Hi shibu.siddharth@gmail.com,

In order for us to investigate, please upload to this secure location:

Thank you,
Dima

Generated at Thu Feb 08 04:59:56 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.