node-mysql内爆而不做任何事情

Question

我试图简单地连接到mysql db，然后关闭连接。我的代码基本上是直接从节点-mysql的指南。

require('fs').readFile('/etc/mysql/mysql-ssl-ca-cert.pem','utf8',function(err,caFile){
    if(err){
        console.error(err);
    }else{
        var connection = require('mysql').createConnection({
            host     : 'localhost',
            user     : 'root',
            password : 'password',
            ssl      : { ca : caFile }
        });
        connection.connect(function(err){
            if(err){
                console.error(err);
            }else{
                console.log('connected');
            }
        });
        connection.end(function(err) { if(err) console.error('Error On DB Close.'); });
    }
});

我得到了“连接”的信息，但随后所有的崩溃，由一个不明确的错误异常触发，我做错了什么？

回溯：

events.js:85
      throw er; // Unhandled 'error' event
            ^
Error: shutdown ENOTCONN
    at exports._errnoException (util.js:746:11)
    at Socket.onSocketFinish (net.js:232:26)
    at Socket.emit (events.js:104:17)
    at finishMaybe (_stream_writable.js:484:14)
    at endWritable (_stream_writable.js:493:3)
    at Socket.Writable.end (_stream_writable.js:459:5)
    at Socket.end (net.js:407:31)
    at Protocol.<anonymous> (/Users/camdennarzt/Developer/JS/barcoding/node_modules/mysql/lib/Connection.js:85:27)
    at Protocol.emit (events.js:129:20)
    at Protocol.end (/Users/camdennarzt/Developer/JS/barcoding/node_modules/mysql/lib/protocol/Protocol.js:99:10)

Answer 1

原来是节点或节点-mysql中的一个bug。请参阅https://github.com/felixge/node-mysql/issues/1027