I have a flow that does a dB query to obtain stored data from my weather stations. It does a SELECT using "node100" or "node101" to obtain the appropriate data. It works for some hours and then hangs up with this error message. [Screen Shot 03-26-21 at 07.41 AM] [Screen Shot 03-26-21 at 07.40 AM…

MySQL fails after an hour or so

dynamicdave 29 March 2021 08:54 17

Quick update to my test doing a SELECT query every 15-mins to see if MySQL connection remains active.

My Telegram bot has been working fine for over 38 hours doing dB queries when requested by a user.

I did try longer intervals (e.g. 30-mins and 45-mins) but settled on 15-mins for no real reason.

Database connection but not a connection?

Topic		Replies	Views
Mysql etimedout General	18	2795	30 June 2020
Node-red-node-mysql stops working after some time General database	14	996	14 February 2022
Mysql lost connection after INSERT General	17	585	18 August 2021
Uncaught exception from mysql nodes General	19	581	29 April 2021
Mysql ER_PARSE_ERROR until flow is redeployed or restarted General	19	496	4 August 2021