NodeRed Pool closed and EHOSTUNREACH repetitive error #1115
Description
Which node are you reporting and issue on?
node-red-node-mysql: 2.0.0
What are the steps to reproduce?
No response
What happens?
Description
When connecting from Node-RED to remote MySQL servers that are intentionally powered off nightly, the node-red-node-mysql node starts emitting repetitive EHOSTUNREACH errors in the Debug pane. This is expected while the DB is down, but it’s excessively noisy.
More importantly, after the remote DB server comes back online and connections begin succeeding again, the node still intermittently emits pool closed errors in the Node-RED Debug pane—even though queries are succeeding. This creates false alarms and makes monitoring unreliable.
Proposed solutions in internet mention restarting the whole NodeRed container, but this is obviously not a solution.
Environment
Node-RED: v3.0.2
node-red-node-mysql: 2.0.0
What did you expect to happen?
Have fewer error messages, and them dissapearing after a proper connection
Example flow
[
{
"id": "1125078a23e3b0d0",
"type": "mysql",
"z": "c187ccce3b1d0ea3",
"g": "1ed6f19507dfa98b",
"mydb": "0fbd1cccf0ccdbf2",
"name": "",
"x": 630,
"y": 460,
"wires": [
[
"832e554eb8152e86"
]
]
},
{
"id": "0fbd1cccf0ccdbf2",
"type": "MySQLdatabase",
"name": "QS600 New",
"host": "172.16.10.252",
"port": "3306",
"db": "quicksun",
"tz": "",
"charset": "UTF8"
}
]
Environment
- Node-RED version: v3.0.2
- Node.js version: v16.16.0
- npm version: 8.11.0
- Platform/OS: Synology NAS & docker