var assert = require('assert'); var common = require('../../common'); var crypto = require('crypto'); common.getTestConnection(function (err, connection) { assert.ifError(err); getMaxAllowedPacket(connection); }); var oldMaxAllowedPacket; function getMaxAllowedPacket(connection) { connection.query('SHOW VARIABLES WHERE Variable_name = ?', ['max_allowed_packet'], function (err, rows) { assert.ifError(err); oldMaxAllowedPacket = Number(rows[0].Value); increaseMaxAllowedPacketIfNeeded(connection); }); } function increaseMaxAllowedPacketIfNeeded(connection) { // Our test generates a SQL query a few bytes larger than 16 MB, but lets // leave a little margin: var minMaxAllowedPacket = 20 * 1024 * 1024; var newMaxAllowedPacket = (oldMaxAllowedPacket < minMaxAllowedPacket) ? minMaxAllowedPacket : oldMaxAllowedPacket; connection.query('SET GLOBAL max_allowed_packet = ?', [newMaxAllowedPacket], function (err) { assert.ifError(err); // We need to re-connect for this change to take effect, bah connection.end(); connection = common.createConnection(); // We need to wait for the re-connect to happen before starting the actual // test. That's because our buffer to hex shim in 0.4.x takes ~12 sec on // TravisCI, causing a MySQL connection timeout otherwise. connection.connect(function (err) { assert.ifError(err); triggerLargeQueryAndResponsePackets(connection); }); }); } var length = (Math.pow(256, 3) / 2) + 10; // Half, because of hex encoding var random = crypto.pseudoRandomBytes || crypto.randomBytes; // Depends on node.js version var table = 'large_packet_test'; function triggerLargeQueryAndResponsePackets(connection) { random(length, function (err, buf) { assert.ifError(err); assert.equal(buf.length, length); common.useTestDb(connection); connection.query([ 'CREATE TEMPORARY TABLE ?? (', '`id` int(11) unsigned NOT NULL AUTO_INCREMENT,', '`bb` longblob NOT NULL,', 'PRIMARY KEY (`id`)', ') ENGINE=InnoDB DEFAULT CHARSET=utf8' ].join('\n'), [table], assert.ifError); connection.query('INSERT INTO ?? SET ?', [table, {bb: buf}], function (err) { if (err && err.code === 'ER_TOO_BIG_ROWSIZE') { common.skipTest('storage engine unable to store ' + buf.length + ' byte blob value'); } assert.ifError(err); }); connection.query('SELECT `id`, `bb` FROM ??', [table], function (err, rows) { assert.ifError(err); connection.query('SET GLOBAL max_allowed_packet = ?', [oldMaxAllowedPacket], assert.ifError); connection.end(function (err) { assert.ifError(err); assert.equal(rows.length, 1); assert.equal(rows[0].bb.length, buf.length); assert.equal(rows[0].bb.toString('base64'), buf.toString('base64')); }); }); }); }