MySQL connection closed using poolConnection

Question

my node.js file is interacting with a MySQL database through the MySQL module. For now I basically just create a pool

var connection = mysql.createPool(dataConnection);

then I make simple queries using connection.query().

Sometimes I get an error saying Error: Connection lost: The server closed the connection. From what I've understood, whenever I call the query method a brand new connection is created from the pool, then it is closed immediately after it is done. Hence I am quite puzzled: how can the connection be closed since the server should explicitly create one for this query? And, most importantly, is there a way I can actually avoid this issue (which doesn't happen too often, fortunately, but still).

Thanks for your help!

Noël.

Ankit Deshpande · Accepted Answer · 2019-07-06 18:13:25Z

2

Since you haven't shared a lot of details and code related to connection pool creation, I'll try to ans as best as I can.

    var pool = mysql.createPool(dataConnection);
    // check if you have configured any timeouts etc for the pool

I'm not sure about the exact code, but it should look something like this:

connection = pool.GetConnection();
result = connection.query();
// now instead of closing the connection, it should be returned/released back to the pool
connection.release();

How do I create a MySQL connection pool while working with NodeJS and Express?

edited Jul 6, 2019 at 18:13

answered Jul 5, 2019 at 8:59

Ankit Deshpande

3,6321 gold badge32 silver badges42 bronze badges

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

Collectives™ on Stack Overflow

MySQL connection closed using poolConnection

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related