[mythtv] Too many connections to database

[Thomas Mueller]

I'm getting this problem as well with CVS from a few days ago. 
Restarting mysqld and/or mythbackend solves it (until it happens again). 
  I'm also getting a lot of these in the frontend log:

Error loading image file: 
/usr/share/mythtv/themes/default/1076_20040409205900_20040409213000.nuv.png
Error loading image file: 
/usr/share/mythtv/themes/default/1076_20040409205900_20040409213000.nuv.png
Error loading image file: 
/usr/share/mythtv/themes/default/1076_20040409205900_20040409213000.nuv.png
Error loading image file: 
/usr/share/mythtv/themes/default/1076_20040409205900_20040409213000.nuv.png
Error loading image file: 
/usr/share/mythtv/themes/default/1076_20040409205900_20040409213000.nuv.png


(over and over and over) and this in the backend log:


File not found: 
/home/mythtv/recordings/1076_20040409205900_20040409213000.nuv
File not found: 
/home/mythtv/recordings/1076_20040409205900_20040409213000.nuv
File not found: 
/home/mythtv/recordings/1076_20040409205900_20040409213000.nuv
File not found: 
/home/mythtv/recordings/1076_20040409205900_20040409213000.nuv
File not found: 
/home/mythtv/recordings/1076_20040409205900_20040409213000.nuv


(also over and over and over) and some of these:


2004-04-13 19:28:22 MainServer::HandleAnnounce FileTransfer
2004-04-13 19:28:22 adding: localhost.localdomain as a remote file transfer
2004-04-13 19:28:22 MainServer::HandleAnnounce FileTransfer
2004-04-13 19:28:22 adding: localhost.localdomain as a remote file transfer
2004-04-13 19:28:22 MainServer::HandleAnnounce FileTransfer
2004-04-13 19:28:22 adding: localhost.localdomain as a remote file transfer
2004-04-13 19:28:22 MainServer::HandleAnnounce FileTransfer
2004-04-13 19:28:22 adding: localhost.localdomain as a remote file transfer
2004-04-13 19:28:22 MainServer::HandleAnnounce FileTransfer
2004-04-13 19:28:22 adding: localhost.localdomain as a remote file transfer


Perhaps it's in an infinite loop trying to load the preview image (not 
recording) on the "watch recordings" screen and opening a connection 
each try?  Just a guess.  That's an optional setting, no?  I'll see what 
happens if I shut it off.



Bruce Markey wrote:
> Joseph A. Caputo wrote:
> ...
> 
>> That's 4 separate reports of a problem, and not one of them mentioned 
>> what version they were running...
> 
> 
> ...or if they were using mythweb, what happens if they restart
> mythbackend, mythfrontend or apache, etc. Also no mention of
> looking at the mysql docs for how to diagnose this error.
> 
> http://www.mysql.com/doc/en/Too_many_connections.html
> 
> --  bjm
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> mythtv-dev mailing list
> mythtv-dev at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev