[NodeJS] MySQL2 Error: Can't add new command when connection is in closed state. 해결

공식 답변

• https://github.com/sidorares/node-mysql2/issues/1302

 

 

we should probably make it default option. Currently when remote side closes the socket the client might not see it, see net.setKeepAlive

 

 

AS-IS	TO-BE
{     "host": "aa.bb.cc.dd,     "port": 100,     "user": "test_user",     "password": "test_password",     "database": "100",     "connectionLimit": 100,     "queueLimit": 0,     "waitForConnections": true,     "dateStrings": "date",     "multipleStatements": true,     "charset": "utf8_general_ci" }	{     "host": "aa.bb.cc.dd",     "port": 100,     "enableKeepAlive":true     "user": "test_user",     "password": "test_passvword!",     "database": "100,v     "connectionLimit": 100,     "queueLimit": 0,     "waitForConnections": true,     "dateStrings": "date",     "multipleStatements": true,     "charset": "utf8_general_ci" }