Mysql2 Pool takes a 10-minute break after inquiring for information. The second inquiry will be reported to read ECONNRESET.

[wadezha]

Test

results of execution

first query, Pool value:

Execute the second time without rest:

Take a 10-minute break and execute again:

Other:
const mysqlConfig = {
host: ‘localhost’,
user: ‘root’,
password: ‘root’,
database: ‘my_db’,
port: 3306,
};

mysql version：5.6.31
use mysql + co running the same code is OK，No database settings have been made, wait_timeout is 28800

[wadezha]

@sidorares Can you help solve this problem?

[anthonywebb]

I am having the same issue with mysql 8.0.13 @wadecha

[wadezha]

@sidorares Can you help us ?

[sidorares]

It feels like for whatever reason idle connections are not removed from pool when server closes them after wait_timeout. Can you check this line is called after 10 minutes?

node-mysql2/lib/connection.js

Line 94 in 821b2bc

this._notifyError(this._protocolError);

Maybe not with pool but with one single persistent connection:

const conn = mysql.createConnection(config);
conn.on('error', err => {
   console.log('Connection error:', err'); // this line is expected to be called when server terminates connection
});
conn.query('select 1+1');