[mythtv-users] Scheduling new recordings requires mythtv restart

[Michael T. Dean]

On 04/24/2009 04:57 AM, Joel wrote:
> Ah.  Now I see what's happening.  mysql is refusing to respond to 
> mythbackend's queries in a timely fashion while mythfilldatabase is 
> running, and for a period of about 22 seconds (apparently) afterwards. 
> once it's freed up to respond, mythbackend is able to catch up and 
> respond to the socket. 

This sounds like a problem with a MySQL version/configuration that's 
becoming relatively common on several distros.  I don't know what the 
misconfiguration (or solution) is, but it seems that for some reason, 
Myth's attempt to detect dead connections is taking a long time, causing 
issues.

Greg Estabrooks was looking into the problem back in January, but I 
don't know if he's found a solution, yet.  If you'd like to see if this 
is the problem you're having, just set your MySQL timeouts to something 
ridiculously low and see if you can get repeat behaviors after the 
timeout interval.  To do this, just set wait_timeout and 
interactive_timeout (in your my.cnf) to something like 120 (for 2 minutes).

Mike