Error in fetching data from MongoDB in Node.js

Question

I am trying to fetch data from MongoDB, where database connection is ok everytime, there isn't any error. But when I am trying to fetch data it gives me the error below:

 { [MongoError: connection 5 to c1669.candidate.18.mongolayer.com:11669 timed out]
   name: 'MongoError',
   message: 'connection 5 to c1669.candidate.18.mongolayer.com:11669 timed out' }

But first 10 to 11 attempts were good and was getting expected data from mongo, later I introduced by above error continuously.

For more info: Using mongodb npm module.

Sorry! I can't show my code segment. I am bound with an agreement. — Sunita S
– Sunita S, Commented Sep 26, 2016 at 14:04
Now, sometime getting error of "no primary found in replicaset". And mostly prior error with the only change of 7 instead of 5 ie. { [MongoError: connection 7 to c1669.candidate.18.mongolayer.com:11669 timed out] name: 'MongoError', message: 'connection 7 to c1669.candidate.18.mongolayer.com:11669 timed out' } — Sunita S
– Sunita S, Commented Sep 26, 2016 at 14:16

Sachin · Accepted Answer · 2016-09-28 13:20:28Z

1

I think its connection pool size problem as you are saying first 10-11 attempts are good so may be you have defined very limited pool size for connections so when you are creating connections, after exceeding to limit it is not allowing to query the database. Please check it as I am not sure without seeing the code but this might be the reason.

Update:

Try below options at the time of connecting to db.

var dbOptions = {
    server: {
        socketOptions: {
            keepAlive: 100,
            connectTimeoutMS: 30000
        }
    }
};

mongoose.connect('mongodb://localhost/db', dbOptions);

Please refer to this link as it seems that you are using replicaset. https://github.com/Automattic/mongoose/issues/2089

edited Sep 28, 2016 at 13:20

answered Sep 26, 2016 at 16:52

Sachin

2,93219 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Sunita S Over a year ago

Now I am using: var options = {native_parser: true, poolSize:50, server: {socketOptions: {connectTimeoutMS: 15000, socketTimeoutMS: 15000}}}; Still facing same error. Anything else?

Sunita S Over a year ago

Can anyone help? It's like nightmare for me.

Jakub Koral · Accepted Answer · 2016-10-01 11:44:20Z

0

Please update to mongodb driver 2.2.10+ version - because there were some minor issues with connection-pool refactoring between 2.1.11–2.2.4 versions.

See

answered Oct 1, 2016 at 11:44

Jakub Koral

3684 silver badges10 bronze badges

Collectives™ on Stack Overflow

Error in fetching data from MongoDB in Node.js

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related