After trying to troubleshoot some MythTV and system issues this afternoon, I managed to loose my storage raid array. It was really quite stupid. I forgot that you don\u2019t need to make a partition for an md0 device\u2026<\/p>\n
For those of you needing further clarification, once a raid array (md device) is created, there is no need to make a partition on it. It _is_ the partition!<\/p>\n
When mkfs.jfs \/dev\/md0 was used, it corrected the \u2018partition\u2019 that I created.<\/p>\n
So, I destroyed the data on \/dev\/md0 by creating a partition and then formatting it. No big deal, it\u2019s just TV. Oh wait. The new series of the Simpson\u2019s and Doctor Who were in there. Plus three episodes of the best Saturday night comedy show Almost Live!<\/p>\n
Doctor Who is the only one that I\u2019m worried about. The guide data shows that the first two episodes won\u2019t be airing for the next three weeks!<\/p>\n
After all my troubles this afternoon, what else could go wrong? Well, this evening while trying to troubleshoot why I can no longer fast forward or rewind while watching live TV or recorded shows, I zeroed out the first megabyte of the raid array trying to determine the SCSI raid array performance.<\/p>\n
Knowing that I just toasted the partition table and anything else that might have been important, I tried to copy off the shows that I was able to record from this afternoon – after destroying the raid array the _first_ time. Well, almost on queue, MythTV locked up the system while I was in the middle of copying the data from the raid array. Damn it! Throw me a fricken bone here!<\/p>\n
What I did was:<\/p>\n
dd \u2039 \/dev\/zero \u203a \/dev\/md0 bs=1k count=1024<\/p>\n
What I thought I was doing and meant to do was:<\/p>\n
dd \u2039 \/dev\/zero \u203a \/mnt\/store bs=1k count=1048576<\/p>\n
This would create a 1GB file with zero\u2019s in it. Basically, a quick way to calculate disk transfer speed. I thought that the reason I couldn\u2019t FF or REW was because of slow disk performance. Well, with 119 MB per second transfer, it wasn\u2019t the disks.<\/p>\n
In the process of killing the raid array – twice, hard resetting, soft resetting, and replacing hardware, my MythTV databases got mangled and because of this I could not watch live TV or watch saved recordings. However, recordings that were underway, we’re still recording just fine, mythbackend couldn’t insert the information about the recording into the mythconverge database.<\/p>\n
Here\u2019s what the mythtv was reporting when the database was corrupt:<\/p>\n
2006-04-02 22:04:44.554 DB Error (delta position map insert):<\/p>\n
Query was:<\/p>\n
INSERT INTO recordedmarkup (chanid, starttime, mark, type, offset) VALUES ( ‘105<\/p>\n
4’ , ‘2006-04-02T22:04:43’ , ‘1’ , 6 , ‘0’ );<\/p>\n
Driver error was [2\/1016]:<\/p>\n
QMYSQL3: Unable to execute query<\/p>\n
To fix the problem I had to use these commands to repair the tables in the database:<\/p>\n
myisamchk -r \/var\/lib\/mysql\/mythconverg\/recordedmarkup.MYI<\/p>\n
I tried myisamchk \/var\/lib\/mysql\/mythconverg\/recorded.MYI which also had errors…<\/p>\n
So I figured it wouldn’t hurt to just:
\nmyisamchk -r \/var\/lib\/mysql\/mythconverg\/*.MYI<\/p>\n
Seemed to fix a lot of problems \u2013 including my original problem of FF and REV!!!<\/p>\n","protected":false},"excerpt":{"rendered":"
After trying to troubleshoot some MythTV and system issues this afternoon, I managed to loose my storage raid array. It was really quite stupid. I forgot that you don\u2019t need to make a partition for an md0 device\u2026<\/p>\n
For those of you needing further clarification, once a raid array (md device) is created, there is no need to make a partition on it. It _is_ the partition!<\/p>\n
When mkfs.jfs \/dev\/md0 was used, it corrected the \u2018partition\u2019 that I created.<\/p>\n
So, I destroyed the data on \/dev\/md0 by creating a partition and then formatting it. No big deal, it\u2019s just TV. Oh wait. The new series of the Simpson\u2019s and Doctor …<\/p>\n [Continue reading]<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/11h.net\/blog\/wp-json\/wp\/v2\/posts\/41"}],"collection":[{"href":"https:\/\/11h.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/11h.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/11h.net\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/11h.net\/blog\/wp-json\/wp\/v2\/comments?post=41"}],"version-history":[{"count":0,"href":"https:\/\/11h.net\/blog\/wp-json\/wp\/v2\/posts\/41\/revisions"}],"wp:attachment":[{"href":"https:\/\/11h.net\/blog\/wp-json\/wp\/v2\/media?parent=41"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/11h.net\/blog\/wp-json\/wp\/v2\/categories?post=41"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/11h.net\/blog\/wp-json\/wp\/v2\/tags?post=41"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}