CODEWITHSUNDEEP
node.jsmongodbmongoose
yfrite
yfrite

Reputation: 103

Node.js + mongoose find freezes node when more than 100 results

I have a simple mongoose model on which I call find with limit max 100 it calls the done callback:

this.find({}).limit(100).exec(done);

The callback is never called If I modify this line into (or any higher number)

this.find({}).limit(101).exec(done);

There is no error anywhere, the database keeps working, but this node app freezes and must be restarted.

If I ssh into the server to connect to the same database and connect to mongo shell, on the same collection find({}) returns all ~700 collections in less than a sec. When I cloned the same database to my local PC and run the app to connect to local database it worked, but the app freezes on the server if its connect to the database on the same server.

Any idea how to debug this one?

Edit1: Added model file:

Model file:

'use strict';

let mongoose = require('mongoose');
let Schema = mongoose.Schema;

let foodSchema = new Schema(
    {
        name: Object,
        type: String,
        description: Object,
        price: Number,
        priceBig: Number,
        active: Boolean
    },
    {
        collection: 'foods'
    }
);

let model = mongoose.model('food', foodSchema);

model.getAllFoods = function (done) {
    this.find({}, done);
};

model.getActiveFoods = function (done) {
    this.find({active: true}, done);
};

model.getFoodById = function (id, done) {
    this.findOne({_id: id}, done);
};

module.exports = model;

Usage:

foodModel.getAllFoods(function (err, docs) {
    if (err) {
        res.sendStatus(500);
        return;
    }

    res.send(docs);
});

getActiveFoods works just fine (returns 96 docs)

Upvotes: 3

Views: 1046

Answers (1)

yfrite
yfrite

Reputation: 103

After the tip from JohnnyK I updated Mongoose from 4.1.11 to 4.3.7 and that fixed the issue.

Upvotes: 3

Related Questions