server.listen(common.fakeServerPort, function(err) { assert.ifError(err); cluster.getConnection('MASTER', function (err) { assert.ok(err); assert.equal(err.code, 'POOL_NOEXIST'); assert.equal(connCount, 5); cluster.end(function (err) { assert.ifError(err); server.destroy(); }); }); });
constructor() { super(); mysqlPool.query('SELECT 1 + 1 AS two', (error) => { if (error) { console.log(chalk.bgYellow.bold('Warning:') + ' Cannot connect to the MySQL server. Error Code: ' + error.code); return; } this.init(); }); }
connection.connect(function (err) { if (err && err.code === 'ECONNREFUSED') { if (process.env.CI) { throw err; } common.skipTest('cannot connect to MySQL server'); } if (err) { callback(err); return; } callback(null, connection); });
pool.getConnection(function (err) { assert.ok(err); assert.ok(err.fatal); assert.equal(err.code, 'ECONNREFUSED'); pool.end(function (err) { assert.ifError(err); }); });
server.listen(common.fakeServerPort, function (err) { assert.ifError(err); var pool = cluster.of('SLAVE*', 'ORDER'); pool.query('SELECT 1', function (err) { assert.ok(err, 'got error'); assert.equal(err.code, 'POOL_NOEXIST'); server.destroy(); }); });
// Ping database to check for common exception errors. pool.getConnection((err, connection) => { if (err) { if (err.code === 'PROTOCOL_CONNECTION_LOST') { console.error('Database connection was closed.'); } if (err.code === 'ER_CON_COUNT_ERROR') { console.error('Database has too many connections.'); } if (err.code === 'ECONNREFUSED') { console.error('Database connection was refused.'); } } if (connection) connection.release(); return })
server.listen(common.fakeServerPort, function (err) { assert.ifError(err); pool.getConnection(function (err, conn) { assert.ifError(err); conn.release(); pool.getConnection(function (err) { assert.ok(err); assert.equal(err.message, 'Pool is closed.'); assert.equal(err.code, 'POOL_CLOSED'); }); pool.end(function (err) { assert.ifError(err); server.destroy(); }); }); });
server.listen(common.fakeServerPort, function (err) { assert.ifError(err); pool.end(function (err) { assert.ifError(err); pool.getConnection(function(err, connection) { assert.ok(err); assert.equal(err.code, 'POOL_CLOSED'); assert.equal(connection, undefined); server.destroy(); }); }); });
server.listen(common.fakeServerPort, function (err) { assert.ifError(err); var query = pool.query('SELECT 1'); query.on('error', function (err) { assert.ok(err, 'got error'); assert.equal(err.code, 'ER_HOST_NOT_PRIVILEGED'); assert.equal(err.fatal, true); server.destroy(); }); });
server.listen(common.fakeServerPort, function(err) { assert.ifError(err); cluster.getConnection('MASTER', function (err) { assert.ok(err); assert.equal(err.code, 'ER_HOST_NOT_PRIVILEGED'); assert.equal(err.fatal, true); assert.equal(connCount, 1); cluster.end(function (err) { assert.ifError(err); server.destroy(); }); }); });
server.listen(common.fakeServerPort, function(err){ assert.ifError(err); pool.getConnection(function (err, connection) { assert.ifError(err); assert.ok(connection); pool.getConnection(function (err) { assert.ok(err); assert.equal(err.message, 'No connections available.'); assert.equal(err.code, 'POOL_CONNLIMIT'); connection.destroy(); server.destroy(); }); }); });
server.listen(common.fakeServerPort, function (err) { assert.ifError(err); pool.query('SELECT 1', function (err) { assert.ok(err, 'got error'); assert.equal(err.code, 'ER_HOST_NOT_PRIVILEGED'); assert.equal(err.fatal, true); server.destroy(); }); });
server.listen(common.fakeServerPort, function (err) { assert.ifError(err); var pool = cluster.of('*', 'RR'); pool.getConnection(function (err) { assert.ok(err, 'got error'); assert.equal(err.code, 'POOL_NOEXIST'); cluster.end(function (err) { assert.ifError(err); server.destroy(); }); }); });
server.listen(common.fakeServerPort, function (err) { assert.ifError(err); pool.getConnection(function (err) { assert.ok(err, 'got error'); assert.equal(err.code, 'PROTOCOL_SEQUENCE_TIMEOUT'); assert.equal(err.fatal, true); assert.equal(err.message, 'Handshake inactivity timeout'); server.destroy(); }); });
// cluster.add('SLAVE2', poolConfig); server.listen(common.fakeServerPort, function (err) { assert.ifError(err); var pool = cluster.of('SLAVE*', 'ORDER'); pool.query('SELECT 1', function (err) { assert.ok(err, 'got error'); assert.equal(err.code, 'POOL_NOEXIST'); server.destroy(); }); });