# Error: Pool is closed (mysql)

**URL:** <https://discourse.nodered.org/t/error-pool-is-closed-mysql/61226>\
**Category:** General\
**Created:** [13 April 2022 08:19 UTC](https://discourse.nodered.org/t/error-pool-is-closed-mysql/61226 "2022-04-13T08:19:55Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hunter](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/hunter/32/60045_2.png) [@Hunter](https://discourse.nodered.org/u/Hunter)\
**Post date:** [13 April 2022 08:19 UTC](https://discourse.nodered.org/t/error-pool-is-closed-mysql/61226/1 "2022-04-13T08:19:55Z")

</div>

Hello,

My NodeRED reads from an SQL database. I recently moved to a different host, so a new IP to connect to, etc. I had 2 database I could choose in the mysql node, I recently removed the old one but now I'm getting this annoying error. It references to node 12f36887.561cb7 and when I search in an old backup, this was the old MySQLdatabase. I can't find any more references to this old DB and when I export the flows to a json file, I can't find this 12f36887.561cb7 anymore.

Any suggestions how to get rid of this error? I already restarted NodeRED.

BR, Peter Hunt.

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [13 April 2022 08:32 UTC](https://discourse.nodered.org/t/error-pool-is-closed-mysql/61226/2 "2022-04-13T08:32:19Z")

</div>

try searching for `12f36887.561cb7` inside the node-red editor that has this issue (CTRL-F)

---

<div class="post-metadata">

**Author:** ![Hunter](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/hunter/32/60045_2.png) [@Hunter](https://discourse.nodered.org/u/Hunter)\
**Post date:** [13 April 2022 08:35 UTC](https://discourse.nodered.org/t/error-pool-is-closed-mysql/61226/3 "2022-04-13T08:35:40Z")

</div>

> [@Steve-Mcl](#):
>
> 12f36887.561cb7

Already done that, returns "No matches found"

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [13 April 2022 08:46 UTC](https://discourse.nodered.org/t/error-pool-is-closed-mysql/61226/4 "2022-04-13T08:46:40Z")

</div>

Assuming you are using `node-red-node-mysql`, what do you see if you search "mysql"

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/9/f/9f6817694fcd0a035990d948211288aa6dac4ac5.png)

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [12 June 2022 08:46 UTC](https://discourse.nodered.org/t/error-pool-is-closed-mysql/61226/5 "2022-06-12T08:46:44Z")

</div>

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