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.

  • This is the KGB

    The question of from whence came KGB-FM finally popped into my head again while I was sitting in front of the computer, so I went looking for its…

  • Heineken? Fuck that shit!

    Raise a glass, noted San Diego brewmaster Karl Strauss has died in Milwaukee. Especially if you're Dennis Hopper, for Karl reformulated PABST BLUE…

  • Various Sorts of Hell

    Vendor Hell: At work, a vendor said they would sell us a chassis with an Intel shelf manager. Except they didn't say their definition of "with" is…

  • 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.