“POOL IS CLOSED” Error in mysql2 Node

General
1

Hi everyone,

I recently came across an error in Node-RED related to the mysql2 node:

"POOL IS CLOSED"

This is what i saw in the debug window....

{
  "__enc__": true,
  "type": "error",
  "data": {
    "name": "Error",
    "message": "Pool is closed.",
    "stack": "Error: Pool is closed.\n    at C:\\Users\\IIoT-PC\\.node-red\\node_modules\\mysql2\\lib\\base\\pool.js:37:40\n    at process.processTicksAndRejections (node:internal/process/task_queues:85:11)"
  }
}

How i came across this eroor:
I had stopped the MySQL service for about 30minutes(approx). After that i restarted MySQL service, I began seeing this error in the Node-RED debug window (coming from mysql node). Interestingly, even though the error appeared, data was still being successfully pushed to the SQL server.

The error disappeared once I restarted the Node-RED service.

So my questions are:

  • Can anyone tell me what does “POOL IS CLOSED” pertaining to node-red? And Should I be concerned about it?

Thanks in advance for your help!

2

nevermind, i got the answer @ errror-pool-is-closed