[mythtv-users] recorded database is short over 300 programs all
of a sudden
Michael T. Dean
mtdean at thirdcontact.com
Fri Jun 4 00:31:20 EDT 2004
Jeff wrote:
>The problem is fixed and here's what I found.
>
>
<snip>
>When I tried to execute these inserts with mysql it complained
>that every key was a duplicate. Now, there were 202 keys in
>this file and only 63 rows to start with...The insert commands
>were correct.
>
>At this point mysql decided the recorded table was corrupt and
>reported "#1016 - Can't open file: 'recorded.MYI'. (errno: 145)"
>
>mysql> check table recorded;
>+----------------------+-------+----------+--------------------------------------------------------+
>| Table | Op | Msg_type | Msg_text |
>+----------------------+-------+----------+--------------------------------------------------------+
>| mythconverg.recorded | check | warning | Table is marked as crashed |
>| mythconverg.recorded | check | warning | 3 clients is using or hasn't closed the table properly |
>| mythconverg.recorded | check | warning | Not used space is supposed to be: 4628 but is: 4600 |
>| mythconverg.recorded | check | error | record delete-link-chain corrupted |
>| mythconverg.recorded | check | error | Corrupt |
>+----------------------+--------+----------+-------------------------------------------------------+
>mysql> repair table recorded;
>+----------------------+--------+----------+-------------------------------------------------------+
>| Table | Op | Msg_type | Msg_text |
>+----------------------+--------+----------+-------------------------------------------------------+
>| mythconverg.recorded | repair | info | Wrong block with wrong total length starting at 12700 |
>| mythconverg.recorded | repair | warning | Number of rows changed from 281 to 280 |
>| mythconverg.recorded | repair | status | OK |
>+----------------------+--------+----------+-------------------------------------------------------+
>
>Now myth reports 280 recorded programs.
>
>
Maybe we should add a section to the docs on restoring the database by
corrupting the database. ;)
Mike
More information about the mythtv-users
mailing list