$near error - planner returned error: unable to find index for $geoNear query

[asalria]

Do you want to request a feature or report a bug?
Report a bug

What is the current behavior?
I get this message every time I try to use find $near - planner returned error: unable to find index for $geoNear query

If the current behavior is a bug, please provide the steps to reproduce.

Example of a document
{ "_id" : ObjectId("5aef5d75d9a9f6943566c201"), "type" : "VULCO", "name" : "Foscar motor", "address" : "Tetuán, Madrid, España", "email" : "foscar@mail.com", "locat" : { "type" : "Point", "coordinates" : [ 40.45883510000001, -3.69782639999994 ] }, "createdAt" : ISODate("2018-05-06T19:54:29.660Z"), "updatedAt" : ISODate("2018-05-06T19:54:29.660Z"), "img" : "https://maps.googleapis.com/maps/api/staticmap?center=40.45883510000001,-3.69782639999994&size=600x300&zoom=15&key=AIzaSyD2Lu_1IfLUoyfzyhUP_HNfGuy9KGQnZoM", "__v" : 0 }

Find function:
Dealer.find({locat: {
$near: {
$geometry:{
type: "Point",
coordinates: coords
},
$maxDistance : 2000
}
}})

What is the expected behavior?
Retrieve near locations from database

Please mention your node.js, mongoose and MongoDB version.
"mongoose": "^5.0.17"
node.js 9.4.9
mongodb 3.4.7

@asalria did you create a 2dSphere index on the collection?

There's an example in issue #4917, you need to create the index and wait for it to build before using it.

[asalria]

@lineus thanks for the answer. I create the 2d index in the model

dealerSchema.index({locat:"2dsphere"});

if I try the approach on issue #4917, I get a timeout error when trying to create the dealer. The dealer is created, but the issue is still there..

@asalria can you create a minimally complete reproducible example like the one in 4917 that demonstrates the behavior you are experiencing and add it here?

[vkarpov15]

@asalria can you clarify what you mean by "I get a timeout error when trying to create the dealer."?

[asalria]

This was the fix for issue #4917:

function waitForIndex() {
  return new Promise((resolve, reject) => {
    User.on('index', error => error ? reject(error) : resolve());
  });
}

user.save()
  .then(waitForIndex)
  .then(getUserLocation)
  .then(myAwesomeFunction)
  .then(docs => console.log('docs', docs))
  .catch(error => console.error('error', error));

And I get a timeout error when doing the first then, the one that waits. The doc is created but the error shows up, it does not reach the second then which is where I take the output from save and do a redirect.

[asalria]

@lineus https://github.com/asalria/dealers

[vkarpov15]

@asalria Presumably you want to do waitForIndex().then(() => user.save()), no? If you wait for save, the index build might already be finished. You might also want to try User.init(), which gives you back a promise that resolves when the index build is done, so you don't have to worry about potentially missing an event.

[asalria]

@vkarpov15 It never goes into .on("index"... so it is never created

[vkarpov15]

@asalria that's because your code might not start listening for the on('index') event until after the 'index' event is already fired because of your save().then(waitForIndex) call. Try save().then(() => User.init()).then(getUserLocation)

[asalria]

@vkarpov15 Sorry, I don't know how to apply your example in my code.

What should I change?

waitForIndex().then(() => {
dealer2.save()
.then(() => {
res.redirect('/list');
});
}).catch(error => console.log(error));

[vkarpov15]

Replace waitForIndex() with User.init()

[asalria]

I created the indexes manually in the collection and it seems to work.

Thanks @vkarpov15