Mysql - "Pool closed" error

I have a Node RED app running on IBM cloud and are using the “node-red-node-mysql” to make queries to a MySql server running on a Windows Server VM in Azure cloud. For long periods of time it works fine, but then at irregular intervals, I get the “pool closed” error on the MySql node.
What is the reason for this error and what kind of steps can I make to avoid this from happening?

Hi @stefandersen

I have this same issue. It happens when the DB is inaccessible for some reason. Unfortunately I cannot catch the error using the Catch node, so have not been able to deal with it within NR. It seems the error is produced by the mysql configuration rather than the mysql node itself.

Regards

Ashfaak

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.