[mythtv-users] Backend loses the database
Kevin Kuphal
kuphal at dls.net
Sat Oct 22 18:19:48 EDT 2005
Nick Rosier wrote:
>On 10/22/05, Michael T. Dean <mtdean at thirdcontact.com> wrote:
>
>
>>Nick Rosier wrote:
>>
>>
>>
>>>On 10/21/05, Nick Rosier <nick.rosier at gmail.com> wrote:
>>>
>>>
>>>
>>>
>>>>On 10/21/05, Mickey Chandler <mickc at whizardries.com> wrote:
>>>>
>>>>
>>>>
>>>>
>>>>>I've had a peculiar problem pop up lately. About once a day, my
>>>>>recorded programs listing goes away and starts reading "No recorded
>>>>>programs available." Restarting the back end gets the listing back.
>>>>>
>>>>>The only error I'm seeing in the log is this:
>>>>>
>>>>>2005-10-21 11:00:00.082 DB Error (KickDatabase):
>>>>>Query was:
>>>>>SELECT NULL;
>>>>>Driver error was [2/2006]:
>>>>>QMYSQL3: Unable to execute query
>>>>>Database error was:
>>>>>MySQL server has gone away
>>>>>
>>>>>Of course, the MySQL server hasn't gone away since restarting the
>>>>>backend (not the MySQL server) re-establishes that connection.
>>>>>
>>>>>Any ideas?
>>>>>
>>>>>
>>>>>
>>>>>
>>>>Strangely enough I had the same problem about 2h ago. Coincidence?
>>>>
>>>>
>>>>
>>>>
>>>This morning it happened again; restarted the backend en frontend and
>>>everything worked again. So it's not MySQL that's causing the problem.
>>>
>>>2005-10-22 11:07:41.148 DB Error (KickDatabase):
>>>Query was:
>>>SELECT NULL;
>>>Driver error was [2/2006]:
>>>QMYSQL3: Unable to execute query
>>>Database error was:
>>>MySQL server has gone away
>>>
>>>2005-10-22 11:07:41.202 DB Error (KickDatabase):
>>>Query was:
>>>SELECT NULL;
>>>Driver error was [2/2006]:
>>>QMYSQL3: Unable to execute query
>>>Database error was:
>>>MySQL server has gone away
>>>
>>>
>>>
>>Network problems?
>>
>>
>
>FE/BE combo so I would doubt it. I'm recompiling Qt and kdelibs right
>now. Maybe some fluke library issue...
>
>
I was going to say maybe a mysql-client issue where the client library
bails leaving myth high and dry.
Kevin
More information about the mythtv-users
mailing list