Due to a rouge file filling my MySQL partition I have a broken table. According to Mythweb the "recordedseek" table says "Table is marked as crashed and last repair failed" .I found some answer about doing a commflag on the broken recordings but I have no idea which recordings are broken. How do I fix this so that I stop getting red errors from xymon? (that nagging thing has really saved my bacon)

The easy fix is to empty the table and run commflag on all your recordings to rebuild it.

The not so easy fix is to export the table using phpMyAdmin to a .SQL file, empty the table and import the .SQL file back again. This will restore the entries that weren't corrupted. After that, check each recording and commflag the ones that need their seek table rebuilt.

I discovered that same error on Tues 7/21 which I suspect was from power fluctuations over the weekend but don't know for sure. I ended up restoring the most recent Good backup dated 7/18 which corrected the error. Backups dated after 7/18 were corrupt and would not restore correctly.

ouch! that's a lot of commercial flagging.thanks for the answer I was looking for.

Similar issue when migrating to LinHES. I had to rebuild the jump tables and then rebuild commercial flagging. An issue I ran into was having too many jobs running at one time, some of the rebuilding/flagging did not work and I had to rerun the jobs.

Once I figured out the issue, what I did to mitigate some of this was to limit the hours that Jobs would be worked to hours I new the system would generally be idle (overnight and during the day with Jobs shut off during primetime).

Since I'm running Atom based boxes I limited the number of jobs running per backend to 1 each.

I went to each show and added all of the recordings for that show into a playlist and then ran the job on the playlist.

Sounds painful, but it worked really well and gave me a way to prioritize which shows to take care of the ones that my wife wanted to watch first.

Well that sucked! I ended up just dumping the Recordedseek table. I exported the table and dropped it but forgot to check and make sure there was something in the exported file. Nope, nothing but an error about the table being broken. OH WELLEverything seems to be working just fine now. I haven't been able to figure out how to tell Mythcommflag to re-run on all my recordings. The asterisk doesn't seem to be a wildcard for Mythcommflag. Now to figure out why zoneminder (an app I don't use) is filling up my mysql partition.

Who is online

Users browsing this forum: No registered users and 0 guests

You cannot post new topics in this forumYou cannot reply to topics in this forumYou cannot edit your posts in this forumYou cannot delete your posts in this forumYou cannot post attachments in this forum