mysql - DB 切换到 Idle 状态后出现错误 PROTOCOL_ENQUEUE_AFTER_FATAL_ERROR

Question

在非工作时间，数据库进入空闲状态。因此，我使用以下代码片段重新连接数据，

var mysql = require('mysql');
var settings = require('./config.js');

var connection;

function handleDisconnect() {

connection = mysql.createConnection({
    host: settings.dbhost,
    user: settings.user,
    password: settings.password,
    database: settings.database
});

connection.connect(function (err) {
    if (err) {
        console.log('Error when connecting to db:', err, settings.database);
        setTimeout(handleDisconnect, 2000);
    }
    else {
        console.log("Database is connected ...", settings.database);
    }
});

connection.on('error', function (err) {
    console.log('db error', err, settings.database);
    if (err.code === 'PROTOCOL_CONNECTION_LOST') {

        connection
        handleDisconnect();
    } else {
        throw err;
    }
});
}

handleDisconnect();

module.exports = connection;

执行数据库查询时，出现以下错误:

{
    "status": 500,
    "Error": {
        "code": "PROTOCOL_ENQUEUE_AFTER_FATAL_ERROR",
        "fatal": false
    }
} 

关于如何解决这个问题有什么想法吗？

Answer 1

一种可能但不完美的解决方案是使用sql.ConnectionPool()