[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?
cheers
Dunc
I
More information about the mythtv-users
mailing list