Completed

Problema de desconexión del servidor con aplicación web activa

Published on the June 25, 2016 in IT & Programming

About this project

Open

Se levanto un servidor usando Node.js utilizando Express y como gestor de base de datos MySQL.
Cada día parece perder la conexión a base de datos y lanzar una excepción que detiene el servidor.

La conexión se realiza usando un PoolConnection: var connection = mysql.createPool(dbconfig.connection);

Y la excepción es:


events.js:141
      throw er; // Unhandled 'error' event
      ^

Error: Connection lost: The server closed the connection.
    At Protocol.end (\node_modules\mysql\l
ib\protocol\Protocol.js:109:13)
    at Socket.<Anonymous> (\node_modules\m
ysql\lib\Connection.js:102:28)
    at emitNone (events.js:72:20)
    at Socket.emit (events.js:166:7)
    at endReadableNT (_stream_readable.js:913:12)
    at nextTickCallbackWith2Args (node.js:442:9)
    at process._tickCallback (node.js:356:17)

npm ERR! Windows_NT 6.3.9600
npm ERR! argv "C:\\Program Files\\nodejs\\node.exe" "C:\\Program Files\\nodejs\\
node_modules\\npm\\bin\\npm-cli.js" "start"
npm ERR! node v4.4.2
npm Err! npm  v2.15.0
npm err! code elifecycle
npm err! i@0.0.0 start: `node ./Bin/www`
npm ERR! Exit status 1
npm err!
npm err!  start script 'node ./Bin/www'.
Npm ERR! This is most likely a problem with the I package,
npm ERR! not with npm itself.
Npm ERR! Tell the author that this fails on your system:
npm ERR!    node ./Bin/www
npm ERR! You can get information on how to open an issue for this project with:
npm ERR!    npm bugs I
npm ERR! Or if that isn't available, you can get their info via:
npm err!
npm err!    npm owner ls i
npm err! there is likely additional logging output above.

Npm ERR! Please include the following file with any support request:
npm ERR!    C:\Program Files\iisnode\www\I\npm-debug.log


Si tienen experiencia con este tipo de problemas quisiera  una solución simple y estable, escucho propuestas. Saludos

Category IT & Programming
Subcategory Web development
Is this a project or a position? Project
I currently have Not applicable
Required availability As needed
Experience in this type of projects Yes (I have managed this kind of project before)
API Integrations Other (Other APIs)
Roles needed Developer

Delivery term: June 30, 2016

Skills needed