Connection closed by server

[Federico Razzoli]

Hello.

My Node application always exits with the error below. It seems to be triggered by the net_wait_timeout setting, in MySQL.

1) Any hints about what causes this error?

2) What is the best way to handle the error?

The error is this:

events.js:141

      throw er; // Unhandled 'error' event

      ^

Error: Connection lost: The server closed the connection.

    at Protocol.end (/home/federico/mobile-sync-backend/node_modules/mysql/lib/protocol/Protocol.js:109:13)

    at Socket.<anonymous> (/home/federico/mobile-sync-backend/node_modules/mysql/lib/Connection.js:102:28)

    at emitNone (events.js:72:20)

    at Socket.emit (events.js:166:7)

    at endReadableNT (_stream_readable.js:905:12)

    at doNTCallback2 (node.js:441:9)

    at process._tickCallback (node.js:355:17)

Bye

Federico

[Christopher Newhouse]

Hi Frederico,

From all the things I've read about problems like this, the suggested solution is:

- Use Connection Pools, even if you only set the 'connectionLimit' option to 1.

Various parts of the documentation and responses from Doug Wilson to similar issues all point to using Connection Pool as the solution.  They apparently will handle re-connecting upon disconnect for you behind the scenes:

https://github.com/felixge/node-mysql#server-disconnects

Hope this helps,

  Chris