[mythtv-users] MySQL server has gone away

Duncan Brown mythtv at duncb.co.uk
Fri Nov 6 10:05:34 UTC 2009

On 05/11/2009 15:15, Duncan Brown wrote:
> Andy Colson wrote:
>> Not with myth, but I have seen it before.  We fixed it by increasing 
>> the  max packet size:
>> [mysqld]
>> max_allowed_packet=16M
>> I've had to set it as high as 32M on one of our web servers.
>> -Andy
> Hi Andy
> Thanks for the ridiculously quick reply!
> Have added the option, will see how it goes
> cheers
> Dunc
Unfortunately it didnt appear to work, again last night it 'went away'

The logs were full of stuff like this again, but for all sorts of 
different queries:

2009-11-05 22:05:28.908 TVRec(6): Changing from Watching WatchingLiveTV 
to None
2009-11-05 22:05:28.971 Error preparing query: DELETE FROM eit_cache 
WHERE chanid  = :CHANID   AND       status  = :STATUS
2009-11-05 22:05:29.041 Driver error was [2/2006]:
QMYSQL3: Unable to prepare statement
Database error was:
MySQL server has gone away

It always seem to happen when i'm not home too, so the WAF is rapidly 
hitting breaking point!

I've never seen this before and have been using myth for many years now, 
the only change is the switch to 0.22

anyone got any other ideas?



More information about the mythtv-users mailing list