今天使用nodejs开发mysql程序时，发现了如下bug提示：

{ Error: write EPIPE
    at WriteWrap.afterWrite [as oncomplete] (net.js:782:14)
    --------------------
    at Protocol._enqueue (/root/doctracing/node_modules/mysql/lib/protocol/Protocol.js:144:48)
    at PoolConnection.query (/root/doctracing/node_modules/mysql/lib/Connection.js:200:25)
    at /root/doctracing/mysql.js:22:22
    at Ping.onOperationComplete (/root/doctracing/node_modules/mysql/lib/Pool.js:110:5)
    at Ping.<anonymous> (/root/doctracing/node_modules/mysql/lib/Connection.js:502:10)
    at Ping._callback (/root/doctracing/node_modules/mysql/lib/Connection.js:468:16)
    at Ping.Sequence.end (/root/doctracing/node_modules/mysql/lib/protocol/sequences/Sequence.js:83:24)
    at Ping.Sequence.OkPacket (/root/doctracing/node_modules/mysql/lib/protocol/sequences/Sequence.js:92:8)
    at Protocol._parsePacket (/root/doctracing/node_modules/mysql/lib/protocol/Protocol.js:278:23)
    at Parser.write (/root/doctracing/node_modules/mysql/lib/protocol/Parser.js:76:12) errno: 'EPIPE', code: 'EPIPE', syscall: 'write', fatal: true }

简单的来说就是访问数据库出问题了，遇到这个问题，解决方式如下：

再my.ini中添加

max_allowed_packet = 1024M

然后重启mysql即可。

文章作者：沃航科技