Every time after about an hour ( more or less ) node red stops reacting. Some nodes still work like the gui input buttons but others like MYSQL stop working.
i tried to solve it with the mysqlReconnectTime at 15000,30000,60000 in settings.js but still stops...
even i tried with 1800000 (30 mins) then 1200000 (20mins) but still the same problem . Also i tried to keep alive the connection with doing select 1 every 5 mins but nothing changed.
the mysql node is still green with the message connected.
the only way to solve it is to restart node-red or doing a deploy.
Hi, there is a new beta version you could try. It has to be installed manually by going into your user directory and then running. npm i node-red-node-mysql@next and then restarting node-red. Any feedback much appreciated
Just to clarify Dave's comment, it is the folder where your flows file, settings.js etc are that you need to run the command from, that is usually the .node-red folder
thanks @dceejay for the quick answer , it will solve the problem ? . the version wich i'm using is not the correct one ? I mean that version of node mysql has this bug ?
Hi,.... I don't know.... the current latest version does appear to have memory leak so that over time it may either hang Node-RED or fail in some way... the new beta uses a different library and also fixes that bug... so it may fix your problem but I don't know... I am trying to get feedback as the underlying library is a different one so we want to be sure it is as near to 100% compatible as possible before releasing it widely... but if it helps fix your issue then that is extra good.
I will test the beta version as soon as possible and go back with good news but i need to find let's call it a " temporary solution " to keep the node alive.
Hello , like i said i updated to version 1.0.0beta5 and it seems no disconnection from the database, the node is working about 24hours , but i had too much disconnection from the wifi network, its about every 2, 3 mins !! .
So my question : is that disconnection caused by node mysql ???
when i did the update , the problem appeared !!
Hello it is me again after the update the node is working without stop, but this errors appeared 2 days ago and appeared again Today : TypeError: Cannot read property 'release' of undefined. As we see in the screenshot node red restarded. Also sometimes he does it again successively.
It seems he is trying to get the connexion if he didn't succeed it will fill the err variable and release the connexion.
Hi - I do have a beta that should fix this problem - you can load it manually by going into your node-red user directory cd ~/.node-red and running npm i node-red-node-mysql@next . This should fix the memory leak but uses a different underlying library so I'm trying to get as much feedback as possible before releasing it fully.