home :: technology :: linux :: MythTvRecordedMarkup.txt

Jul 18, 2004

Hunting a MythTV Bug

For MythTV users having trouble recording:

If MythTV starts behaving erratically when recording a show, especially after a crash, you may have a corrupt "recordedmarkup" table in your database. Symptoms include marked increase in hard drive usage during recording, choppy video, and mythfrontend freezes if attempting to watch anything while recording.

The recordedmarkup table can be corrupted at the database level (as in, the actual table structure is damaged, not just the data) if you have a system crash or hard power failure while recording a show. Simply running mysql and then switching to the mythconverg database may give an error about recordedmarkup.MYD, indicating that you do indeed have this problem.

The fix is simple:

#mysqldump -u root -p -a > backupBeforeFix.sql
#mysql -u root -p
mysql> use mythconverg ;
mysql> REPAIR TABLE recordedmarkup;
This makes a copy of the database in case something goes REALLY wrong during the fix, then attempts to repair the table corruption. Once this operation has completed, MythTV should return to normal.

Thanks to "How do you do that in Linux" for their great MythTV setup guide which included this fix.

6:22 pm | permalink | /technology/linux | 0 writebacks |