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:
#mysql -u root -p
mysql> use mythconverg ;
mysql> REPAIR TABLE recordedmarkup;
Thanks to "How do you do that in Linux" for their great MythTV setup guide which included this fix.
