Jason Lindquist (jlindquist) wrote,
Jason Lindquist

MythTV database corruption

I'm still running MythTV 0.15, as I either haven't had time to upgrade, or it's the middle of a busy TV season and I won't chance fucking things up.

There are some bugs in how it handles its MySQL database. Some of the frequently-used tables can develop corruption over time and need to be repaired. This script should be run periodically out of cron to repair the damage. It should be run at a time when you expect not to be watching or recording anything, as the repair operations cause some kind of mutex hang if MythTV is reading or writing them at the same time.

My recordedmarkup table was badly damaged, leading to bizarre playback behavior. Jumping more than a minute would lag. The total-time field of the status window would show over 1200 hours. Searching would sometimes cause the front end to hang. I don't even want to imagine how badly corrupted an extraction would have been.

  • Aurora reference

    For reference, the only two links I could find on Aurora shooter (and Westview '06 grad) James Holmes, prior to his attendance at Westview being…

  • Your friend, FunnyJunk.com

    If you've never heard of funnyjunk.com, it's run by a content thief. It's a haven for incompetence, stupidity, and douchebaggery. Site owner…

  • X-header crap

    It is ridiculous how big this section of my .muttrc has gotten. Every goddamned special snowflake mailer has to have its own collection of…

  • Post a new comment


    default userpic

    Your reply will be screened

    Your IP address will be recorded 

    When you submit the form an invisible reCAPTCHA check will be performed.
    You must follow the Privacy Policy and Google Terms of use.