调用退出后无法排队握手 [英] Cannot enqueue Handshake after invoking quit

问题描述

我已经实现了以下代码:

I have implemented the following code:

module.exports = {
    getDataFromUserGps: function(callback)
    {
        connection.connect();
        connection.query("SELECT * FROM usergps", 
            function(err, results, fields) {
                if (err) return callback(err, null);
                return callback(null, results);
            }
        ); 
        connection.end();
    },
    loginUser: function(login, pass, callback)
    {
        connection.connect();
        connection.query(
            "SELECT id FROM users WHERE login = ? AND pass = ?",
            [login, pass],
            function(err, results, fields) 
            {
                if (err) return callback(err, null);
                return callback(null, results);
            }
        ); 
        connection.end();
    },
    getUserDetails: function(userid, callback)
    {
        connection.connect();
        connection.query(
            "SELECT * FROM userProfilDetails LEFT JOIN tags ON userProfilDetails.userId = tags.userId WHERE userProfilDetails.userid = ?",
            [userid],
            function(err, results, fields)
            {
                if (err) return callback(err, null);
                return callback(null, results);
            }
        );
        connection.end();
    },
    addTags: function(userId, tags)
    {
        connection.connect();
        connection.query(
            "INSERT INTO tag (userId, tag) VALUES (?, ?)",
            [userId, tags],
            function(err, results, fields)
            {
                if (err) throw err;
            }
        )
        connection.end();
    }
}

一切都很好，只有第一次.如果我想使用"第二次查询时出现以下错误:

Everything works great only for the first time. If I want to "use" the query for the second time I get the following error:

Cannot enqueue Handshake after invoking quit

我尝试不使用 .end() 连接，但没有帮助.

I have tried not to .end() connections but it didn't help.

我该如何解决这个问题?

How can I fix this issue?

推荐答案

如果您使用 node-mysql 模块，只需删除 .connect 和 .end.刚刚自己解决了这个问题.显然，他们在最后一次迭代中插入了不必要的代码，这些代码也有问题.如果您已经运行了 createConnection 调用，则不需要连接

If you using the node-mysql module, just remove the .connect and .end. Just solved the problem myself. Apparently they pushed in unnecessary code in their last iteration that is also bugged. You don't need to connect if you have already ran the createConnection call

这篇关于调用退出后无法排队握手的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！