[mythtv-users] Mythfrontend QUERY_RECORDINGS timeout - hangs frontend

Michael T. Dean mtdean at thirdcontact.com
Sat Sep 22 04:57:41 UTC 2007


On 09/20/2007 08:18 PM, Craig Ghareeb wrote:
>>> From: Michael Kurtz <myth at friendz.de>
>>>
>>> recently I had the same problem too.Here frontend and backend reside on the 
>>> same machine. I know this is not an opitimal solution but deleting the entire 
>>> database and setting it up again solved this issue.
>>>       
>> I've had the same problem intermittently for close to 6 months.
>>     
...
>> Deleting the entire database sounds painful.
>> I have over 1700 recordings (records in recorded table).
>> I wonder if it's something specific in the database, or
>> is it just the sheer size of the database?
>>     
> I had the same problem after migration of a 0.19 database to 0.20.2.  The fix for me, strangely, was:
>
> 1.  Backup the mysql database
> 2.  Drop mythconverg
> 3.  Create mythconverg from .../database/mc.sql
> 4.  Run mythtvsetup
> 5.  Create a restore.sql and restore the database using the info in http://www.mythtv.org/docs/mythtv-HOWTO-23.html#ss23.7 
>   

You should /not/ use mc.sql (or run mythtv-setup before the restore) if
you're doing a restore as described in the HOWTO.

> I can't figure out how this would've solved the problem (or what the cause really was), but with the 'fix' only being a week old, I haven't been inclined to try to recreate the problem.
>   

That's what I call the MythTV "Spring Cleaning."  It gets rid of the
garbage for you.

Mike


More information about the mythtv-users mailing list