[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