AR potentially not closing DB connections on reload
GrahamJenkins opened this issue ยท 4 comments
I'm running AutoRank on a small network of 7 servers and had scheduled /ar reload every 10 minutes to try to alleviate some sync issues. (Probably not the best option, but that's a matter for another issue)
After some time my MySQL server stopped accepting new connections, complaining about maximum connections (ERROR 1040 (HY000): Too many connections)
I have since removed the scheduled reloads and the issue hasn't come up again which leads me to believe that AR is just creating new connections on load/reload and never closing them.
Oh god, be careful with the reload command. It is not meant to be used so regularly. It shouldn't really be used ever. One of the reasons you're getting the mysql 'maximum connections' error is due to the reloading.
I'm not sure what syncing issues you're running into, but we should fix them. What are they exactly?
Yeah, that was my thought, not using it anymore, about to post a second issue regarding the sync/time losses.
It's a good thing that you brought this to light though, as a developer you can't test everything on you're own.