connection.query do not callback about node-mysql2

[jiiijkkk]

There is my schema:

CREATE TABLE IF NOT EXISTS `tab` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `a` varchar(8) COLLATE utf8_unicode_ci NOT NULL,
  `b` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `c` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
  `d` varchar(12) COLLATE utf8_unicode_ci NOT NULL,
  `e` varchar(12) COLLATE utf8_unicode_ci NOT NULL,
  `f` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `g` varchar(12) COLLATE utf8_unicode_ci NOT NULL,
  `h` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `i` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `j` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `k` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `l` tinyint(1) NOT NULL COMMENT 'ffff',
  `m` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `analyze` (`f`,`timestamp`),
  KEY `independency` (`f`(4)),
  KEY `f` (`group_id`),
  KEY `guest_service` (`a`,`c`(8),`f`(4))
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

and there is the sql:

SELECT `c`, `k`  FROM `tab`  WHERE TIME_TO_SEC(TIMEDIFF(NOW(), `k`)) > 70  AND `b` = BINARY "abcdef" AND `c` = "L3lqVaqXbaJb9TFHH75B"

[sidorares]

thanks, I'll try to reproduce

[sidorares]

Are you sure there is no typo here:

pool.getConnection(function(err, connection){
            if ( err ) {
                log(3, '[Pool][getConnection][Error] sql: ' + sql + ' err: ' + err);
                connection.release();
                selectCb(err);
                return;
            }

// you are getting "connection" from pool but using db
           db.query(sql, function dbQuery(err, rows, fields){

[jiiijkkk]

Yes. It's connection. They were 'db' in my original code. I thought you might use 'connection' much well so I change that. I miss.

[sidorares]

could be difficult to debug, it works just fine in simple example. Are you getting any errors before there is no call to callback?

[jiiijkkk]

There are no error or unexpection caught even from kernel or other modules.
But we try [email protected] with the same code it work fine til now.
The NodeJS version is v0.10.21. Hoping it will be helpful.

[sidorares]

Could you try again from master? #70 should make pool behaviour consistent with node-mysql