[mythtv-users] Backend loses the database

[Michael T. Dean]

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?

Mike