baboom09 / sma-bluetooth

Automatically exported from code.google.com/p/sma-bluetooth
0 stars 0 forks source link

MySQL error - Too many connections #31

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
* What steps will reproduce the problem?
1. Running the smatool from cron job (every 15 mins)

* What do you see instead?
Everything worked fine for around 12 runs (from 7:30 - 10:30), then smatool 
started failing.  It was failing with "Too many connections" error.  I guessed 
that the error message was a MySQL error and coming from MySQL server, so I 
restarted MySQL and then smatool started working again.

* What version of the product are you using? On what operating system?
V0.13, Ubuntu 10.10

* Please provide any additional information below.
Is it possible that smatool is leaving connections open on MySQL?  This is the 
first day that I have tried smatool on a cron job.  Will keep an eye on it to 
see if it fails again.  It is possible that something else on my system is 
leaving connection open on MySQL but I haven't noticed this problem until today 
(when I started running smatool regularly).

Original issue reported on code.google.com by chris.le...@gmail.com on 1 Jul 2011 at 4:43

GoogleCodeExporter commented 8 years ago
After monitoring for an hour the problem doesn't seem to be reappearing.
I will keep monitoring.

Original comment by chris.le...@gmail.com on 1 Jul 2011 at 5:02

GoogleCodeExporter commented 8 years ago
Can't seem to replicate the problem.  Did a quick code walk through and looks 
like all DB connections are closed properly.  Might have been a remnant of the 
Seg. Faults I was having before leaving connections open.

Please close this defect, it is not an issue.

Original comment by chris.le...@gmail.com on 3 Jul 2011 at 8:11