Mongoose Trying to open unclosed connection

Question

This is a simplified version of the problem, but basically I'm trying to open 2 mongodb connections with mongoose and it's giving me "Trying to open unclosed connection." error.

Code sample:

var db1 = require('mongoose');
db1.connect('my.db.ip.address', 'my-db');

var db2 = require('mongoose');
db2.connect('my.db.ip.address', 'my-db');

db2.connection.close();
db1.connection.close();

Any idea how to make it work?

Answer 1

connect() opens the default connection to the db. Since you want two different connections, use createConnection().

API link: http://mongoosejs.com/docs/api.html#index_Mongoose-createConnection

Answer 2

To add on Raghuveer answer :

I would also mention that instead of using mongoose directly (you are probably using it this way you end up on this post) :

require('mongoose').model(...);

You would use the returned connection :

var db = require('mongoose').connect('xxx', 'yyy');
db.model(...);

Answer 3

I get this issue while running my tests.

This is what I did to solve it.

//- in my app.js file.
try {
    mongoose.connect('mongodb://localhost/userApi2'); //- starting a db connection
}catch(err) {
    mongoose.createConnection('mongodb://localhost/userApi2'); //- starting another db connection
}