node js mysql Cannot Enqueue a query after calling quit

Question

I am using node.js and mysql, to run sql commands frequently.

I am getting this error: Cannot enqueue Handshake after invoking quit.

This is when I do

connection = mysql.createConnection(sqlDetails);
connection.connect();

and

connection.end();

If I comment the .connect and .end lines, then I get the error ER_CON_COUNT_ERROR: Too many connections.

Does anyone know how to fix this problem?

Thanks

have you seen this: stackoverflow.com/questions/14087924/… — knowbody
– knowbody, Commented Apr 27, 2014 at 20:34
According to this github.com/felixge/node-mysql#error-handling, it says to define your connection one, then just use that always. I did that, but now I'm not sure where to put my connection.end(). It says You can listen on the error event to handle server disconnection and for reconnecting purposes. but im not sure which function to put it in... — omega
– omega, Commented Apr 27, 2014 at 20:43
you should close one global connection the first request done, do not use a connection pool and grab a connection for each request separately or dont close the connection in the request handlers — knowbody
– knowbody, Commented Apr 27, 2014 at 20:48

Andrey Sidorov · Accepted Answer · 2014-04-28 02:05:44Z

2

If you actually want to close connection (why? if you 'run sql commands frequently' you probably want to reuse it, or even better - use connection pool) you need to do that in query result callback. All commands are put into commands queue and processed sequentially.

This is what you are doing:

open connection stream to mysql
add Handshake command to queue
add Query command to queue
add Quit command to queue, mark connection as closing
start processing commands
now Handshake is processed when connection in 'closing' state

answered Apr 28, 2014 at 2:05

Andrey Sidorov

25.6k5 gold badges65 silver badges78 bronze badges

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

Comments

keerthee · Accepted Answer · 2014-10-17 12:24:49Z

2

Since node js is asynchronous , connection.connect() and connection.end() gets executed parallely,

If you want to specify sequence of execution, use callbacks like

connection = mysql.createConnection(sqlDetails);
connection.connect(function(err,callback){
    connection.query(function(err,callback){
         connection.end();
 });
});

answered Oct 17, 2014 at 12:24

keerthee

8904 gold badges18 silver badges41 bronze badges

Collectives™ on Stack Overflow

node js mysql Cannot Enqueue a query after calling quit

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related