Intermittently getting Quit inactivity timeout with Node.js 4.2.0

[ratneshdeepak]

Error: Quit inactivity timeout 
 at Quit.sequence.on.on.on.on.on.self._connection._startTLS.err.code (/var/task/node_modules/mysql/lib/protocol/Protocol.js:154:17) 
 at Quit.emit (events.js:92:17) 
 at Quit._onTimeout (/var/task/node_modules/mysql/lib/protocol/sequences/Sequence.js:116:8) 
 at Timer.listOnTimeout [as ontimeout] (timers.js:112:15)

@dougwilson I'm using node on aws lambda. The problem is not persistent it reoccurs after every few requests only.

Here is the test code

 var mysql      = require('mysql');
 var mycontext = null;
 var table = "tableName";

if(typeof context === 'undefined'){
 context = {};
 context.fail = function(err){};
 context.succeed = function(o){ console.log("Contect o/p is"); console.log(o);};
 mycontext = context;
}
var processRequest = function (macaddress){
 var connection = null;
     connection = mysql.createConnection({
       host  : '*******',
          user   : '******',
          password : '*****',
          database : '******'
    });
     connection.connect(function(err){
     if(!err) {
         console.log("Database is connected ... \n\n");
     } else {
         console.log("Error connecting database ... \n\n");
         handleError(err);
     }
     });

 var getConf = function(mac){
  connection.query('SELECT * from '+table+' where macaddress = ? ',[mac], function(err, rows, fields) {
   if (!err){
     console.log('The o/p is: ', rows);
     if(rows.length == 0){
        insertConfig(mac)
     }
     else{
        dispatchConfig(rows[0]);
     }
   }
   else{
     handleError(err);
   }
   });
 };

var insertConfig = function(mac){
 connection.query('INSERT into '+table+' set macaddress = ? ',[mac], function(err, rows, fields) {   
    if(!err){
       console.log('The o/p is: ', rows);
       getConf(mac);
    }
    else
    {
      handleError(err);
    }
 });
}

var dispatchConfig = function(cf){
   connection.end();
   var output = JSON.parse(cf.config);
   output.unshift(["name",cf.id,"i"]);
   mycontext.succeed(JSON.stringify(output));

}

var handleError = function(err){
   connection.end();
   mycontext.fail('Something went wrong '+err);
   console.log('Error while performing Query.');
}

getConf(macaddress);

}

exports.handler = function(event, context) {
   mycontext = context;
   processRequest(event.macaddress); 
};

[dougwilson]

Hi! The error of Quit inactivity timeout means one of two things:

1. Something on the network between AWS and your machine is broken. 99% of the time this is reported, it is determined that there is a bad rule on the machine's firewall. The error means that after sending the Quit packet to the MySQL server, nothing was never received from the MySQL server in response.
2. Something is going really slow. We wait for 30 seconds after connection.end(); is called and will throw that error if we don't hear anything back after that long. You can certainly try to increase the timeout, but it's likely that you'll just end up getting that error after a longer time. connection.end({ timeout: 60000 });

[ratneshdeepak]

Firewall issues can't explain intermittent behavior. Also I've setup mysql access open from all ip addresses.

Whenever this error occurs exception is thrown within few 100 milliseconds so 30 seconds timeout is also ruled out.

Can you suggest looking at anything else.

[dougwilson]

Interesting. I'll reopen as needs investigation, but I cannot think of anything to look into besides what was listed above. Perhaps there is a bug in this module or in Node.js core (which keeps track of the timeouts)?

I'm not able to reproduce, so without a way to reproduce the issue, there isn't much I can look into successfully. I can poke around at the code here, but it may not ever turn up anything of use. If you could debug your code and determine what is happening and issue up a PR, that's likely the best course of action :)

[dmtrs]

Had probably relevant issues like:

Error: Query inactivity timeout
      at Query.<anonymous> (node_modules/mysql/lib/protocol/Protocol.js:154:17)
      at Query._onTimeout (node_modules/mysql/lib/protocol/sequences/Sequence.js:116:8)
      --------------------
      at Pool.query (node_modules/mysql/lib/Pool.js:191:23)
      ....

when working with node v4.2.0 and moved to v4.2.1 to resolve it

[jczaplew]

I kept getting the same error too, but only with node v4.2.0, and upgrading to v4.2.1 also solved it for me.

[bahout]

Hi, more simple, this code was working for me on aws + lambda

/*--------------node mysql working example ------*/

var mysql = require('mysql');
var pool = mysql.createPool({
    "host": "captainleads-cluster.cluster-XXCCX.eu-west-1.rds.amazonaws.com",
    "user": "admin",
    "password": "XXXXXX",
    "database": "presta",
    "connectionLimit": 10
});

console.log('Loading function');

exports.handler = function(event, context) {
    pool.query('SELECT * FROM Go_users limit 1', function(err, rows, fields) {
        if (err) {
            throw err;
            context.fail(rows);
        }
        console.log('The solution is: ', rows[0]);

        context.succeed({user:rows[0],msg:'firstuser'});
    });

};

[shreyagarwal]

Just FYI : Working fine on 4.2.2 and 4.2.3 .. Not working on 4.2.0