Resolving handshake inactivity timeout error in Node.js's MYSQL module

Question

I'm using node-mysql and most of the queries work fine. But some queries don't work. I tried every version of Node (from 0.5... to 5.6.0), I also tried 4.0 and 4.1 but neither helped.

I tried changing it manually but it didn't work. I tried changing the sequence file to: this._idleTimeout = -1; but that didn't help either.

I read the issue and the stuff on GitHub but it didn't help.

I could try to fix it myself, but I need more information. Where does the timeout occur? Why? When did it happen? What type of message is this? Where does the timeout come from?

MYSQL_ERROR { [Error: Handshake inactivity timeout]
code: 'PROTOCOL_SEQUENCE_TIMEOUT', fatal: true,
timeout: 10000 }

Answer 1

For those deploying on AWS and encountering this error, you will need to make changes to the security group of the database/cluster, Add an inbound rule where source is the security group of the instance.

The inbound rules should look like this:

类型：MySQL/Aurora
协议：TCP（默认）
端口：3306（默认）
源：<实例的安全组>
描述：<可选>

Answer 2

Okay, the timeout is from line 162 of the Protocol.js file. If you look at node-mysql, you will see that the variable queried is "timeout". If you set the timeout to a much higher value than the default of 10000, the error should go away. An example is

pool = require('mysql').createPool({
    connectionLimit : 1000,
    connectTimeout  : 60 * 60 * 1000,
    acquireTimeout  : 60 * 60 * 1000,
    timeout         : 60 * 60 * 1000,
    host            : process.env.DB_HOST,
    user            : process.env.DB_USERNAME,
    password        : process.env.DB_PASSWORD,
    database        : process.env.DB_DATABASE
});

You can also edit the timeout in the Sequence.js file (node_modules/mysql/lib/protocol/sequences/Sequence.js)

this._timeout  = 100000;