Dashboard: crash after a long run (Express 500 Error: Statement not prepared)

jortizcs / Pangia

Anomaly detection in buildings

greenpangia.com

Other

0 stars 0 forks source link

Dashboard: crash after a long run (Express 500 Error: Statement not prepared) #19

Closed romain-fontugne closed 11 years ago

romain-fontugne commented 11 years ago

Yesterday it was running fine, but today I couldn't access the dashboard unless I reboot nodejs... I had similar issue before: 500 Error: Statement not prepared, I will look at it..

romain-fontugne commented 11 years ago

This one was easy :-)

The MySQL connection was open only once and for all. I changed it the connection is now open/close before/after the SQL requests. I also changed it in getalarms.js