connection doesn't closes

[habi4ek]

Hi use OrientDB 2.1.7 and orientjs 2.1.0

if I use "db.close()" and then "server.close()"
there appear two connection that have never disappear in the database

function(req,res) {
    var Oriento =  require('orientjs');

    var server = Oriento({
                    host: 'localhost',
                    port: 2424,
                    username: 'root',
                    password: 'password',
                    transport: 'binary'
                });

    var db = server.use({
                name: 'esalgyt4',
                username: 'admin',
                password: 'admin'
            });

    db.query('Select from Ouser')
        .then(function(ress){
            db.close();
            server.close();
            res.send(ress);
        })
        .catch(function(ress){
            db.close();
            server.close();
            res.send(ress);
        });

[MathildeLemee]

Any news ?

Thanks

[wolf4ood]

Hi @MathildeLemee I will check it tomorrow

[MathildeLemee]

Thanks a lot !

[MathildeLemee]

It makes my production server crashes ...

The connection stay open and begins to stack. After a moment, they can't handle new connection (even a stop doesn't work). I guess it's when there is 1000 ...

Is there a way to close a connection ? Can you give me a version number that can handle the close ?

I do that for each request that came to my server :

        var server = OrientDB({
            host: 'blaba',
            "port": x,
            "httpPort": y,
            username: 'z',
            password: ''
        });
        var db = server.use({
            name: 'db',
            username: 'user',
            password: 'user'
        });
        db.update('Person').set(data.body).where({id: data.id}).one().then(function (temp) {
            console.log("UPDATED" + temp)
        }).catch(function (e) {
            console.log(e);
        }).done(function () {
            db.close();
            server.close();
        });

[wolf4ood]

hi @MathildeLemee

i was not able to reproduce it.
All the connections are released correctly.

Do you have a test case that helps me reproduce this issue?

[MathildeLemee]

I try it using remote orientdb or local still have the problem. I'm on the 2.16.

var OrientDB = require('orientjs');

function test() {
var server = OrientDB({
host: '127.0.0.1',
"port": 2424,
"httpPort": 2480,
username: 'x',
password: 'y'
});
var db = server.use({
name: 'db',
username: 'x',
password: 'y'
});
query = 'select * from OIdentity ';
db.query(query
).then(function (response) {
}).catch(function (e) {
console.log(e);
}).done(function () {
db.close();
server.close();
console.log("CLOSE")
});

}
for (i = 0; i < 15; i++) {
test();
}

[wolf4ood]

hi @MathildeLemee

thanks i will let you know ASAP

[MathildeLemee]

Thanks ! I've tried a lot of things, like declaring the server out of the function, using a pool ... And I still have this connection!
Maybe it's something obvious on my code.

[wolf4ood]

@MathildeLemee

can you try to handle the close in this way?

var OrientDB = require('orientjs');

function test() {
    var server = OrientDB({
        host: '127.0.0.1',
        "port": 2424,
        "httpPort": 2480,
        username: 'root',
        password: 'root'
    });
    var db = server.use({
        name: 'db',
        username: 'admin',
        password: 'admin'
    });
    query = 'select * from OIdentity ';
    db.query(query)
    .then(function (response) {
    }).catch(function (e) {
        console.log(e);
    }).done(function () {
        db.close().then(function(){
            server.close();
            console.log('CLOSE');
        });
    });

}
for (i = 0; i < 15; i++) {
    test();
}

[wolf4ood]

@MathildeLemee tell me if this solve your prolem

[MathildeLemee]

Yes ! Thanks a lot !

And if you can also give the piece of code to make pooling working, that will be perfect (#89)

[lvca]

@maggiolo00 can we add it to the documentation?