How do I set a timeout on a Mongoose query?

Question

I am using Mongoose with a very large Mongo database, and I want costly queries like MySet.find({}) to time out after 10 seconds.

I've tried setting a socket timeout on my connection, but the server crashes if the timeout is exceeded:

var options = {server: {socketOptions: {socketTimeoutMS: 10000}}};
var conn = mongoose.connect('mongodb://localhost/my_db', options);

I've tried passing the maxTimeMS option to the find function, but that doesn't have any effect at all:

MySet.find({}, {}, {timeout: true, maxTimeMS: 10000}, function(err, doc) {});

Any ideas?

Answer 1

You can do this with the Query#maxTime method.

So in your case, you would call it as:

MySet.find({}).maxTime(10000).exec(function(err, doc) { ... });

You can confirm it's correctly setting the maxTimeMS option by enabling Mongoose debugging via mongoose.set('debug', true); and then you'll see console output for this query that looks like:

Mongoose: myset.find({}) { maxTimeMS: 10000, safe: true, fields: {} }

Answer 2

TL;DR:

MySet.find({ $query: { /*Query here*/ }, $maxTimeMS: 10000 });

You can test with this query :

MySet.find({ $query: {"$where": "sleep(100) || true"}, $maxTimeMS: 10000 });

---

Why it works:

You can use Query modifiers

And especialy this one : $maxTimeMS

Be careful : this operator is deprecated in mongo Shell since v3.2