天天看点

mysql etimedout_Node.js MySQL ETIMEDOUT error

After running node for a long time I get this error.

My program itself works perfectly fine.

What does it really mean? I can't find anything about it.

And most importantly how to prevent it?

Error: read ETIMEDOUT

at errnoException (net.js:901:11)

at TCP.onread (net.js:556:19)

--------------------

at Query.Sequence (/nodejs/node_modules/mysql/lib/protocol/sequences/Sequence.js:15:20)

at new Query (/nodejs/node_modules/mysql/lib/protocol/sequences/Query.js:12:12)

at Function.Connection.createQuery (/nodejs/node_modules/mysql/lib/Connection.js:48:10)

at Connection.query (/nodejs/node_modules/mysql/lib/Connection.js:100:26)

at Socket. (/nodejs/server.js:23:12)

at Socket.EventEmitter.emit [as $emit] (events.js:95:17)

at SocketNamespace.handlePacket (/nodejs/node_modules/socket.io/lib/namespace.js:335:22)

at Manager.onClientMessage (/nodejs/node_modules/socket.io/lib/manager.js:488:38)

at WebSocket.Transport.onMessage (/nodejs/node_modules/socket.io/lib/transport.js:387:20)

at Parser. (/nodejs/node_modules/socket.io/lib/transports/websocket/hybi-16.js:39:10)

I guess it has to do something with the mysql I'm using in my program because it refers to Query.sequence or something.

https://github.com/felixge/node-mysql

The only line I can refer to that causes this error is where I create a query:

database.query("SELECT * FROM `...