[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