Connections don't close

[vixa2012]

Hello everyone. Yesterday I used "sequelize": "~3.24.1", "sequelize-cli": "~2.4.0"
I have script which started by cron each 5 minutes and load some statistics to database.
Each query open new mysql connection and never close it.

After I saw that bug I downloaded "sequelize": "~4.0.0-2", "sequelize-cli": "~2.5.1"

Now I have new bug.
Count of connection is less then yesterday, but this connections never close too.

On my script finish I make sequelize.close(); but all connections is also open in mysql.

Please help me, how I can close all connections after script finish?

This is my configuration

and this is my script

[sushantdhiman]

This comment will address your issue #7144 (comment)

As you are using v4-0-2, you still want to use destroyAllNow as pooling has been changed in master but not released yet.

[vixa2012]

Maybe I doing not right something, please help me. Write an example how I have to use method clear()

this is my update function

var promises = [];

for(var I = 0; I < items.lenght; I++) {
promises.push(getUpdate(items[i]))
}

Promise.all(promises).then().catch();

[sushantdhiman]

As I said in my comment, clear method is not available on v4-0-2

To use these methods you need to get connection manager object, like

sequelize.connectionManager.destroyAllNow();

[vixa2012]

Okay I did it. But also got error.

[sushantdhiman]

Which version v4 ?

[vixa2012]

Viktors-MBP:adserver_redis viktorchukhlov$ ./node_modules/.bin/sequelize -v

Sequelize [Node: 6.9.4, CLI: 2.5.1, ORM: 4.0.0-2]

[sushantdhiman]

connectionManager should be defined, hmm try console log sequelize.connectionManager

[vixa2012]

Please see my config, maybe I don't write something.

This is cron script

Also I can see console.log models.sequelize.connectionManager

[sushantdhiman]

IdleTime, is should be idle

[vixa2012]

Changed to idle but error also has

[sushantdhiman]

Now connection should automatically released no need to call close or anything else

[vixa2012]

No, if I don't close connection script don't finish.
And connections do not released(( As I can see count of connections increase with each script start

[sushantdhiman]

sequelize.connectionManager.pool.destroyAllNow();

[vixa2012]

Ok thats has not errors
models.sequelize.connectionManager.pool.destroyAllNow();

But connections count increase too((

I run my script

After finish

I tried every thing/))

[sushantdhiman]

Please use

show status where `variable_name` = 'Threads_connected';

which show actual connection connected at that time. The status you are currently using indicate connection thought the session, which will always increase.

This also means, there was actually no problem form the beginning. But also indicate v4 is far better in properly utilizing connections 😆