[mythtv-users] recorded database is short over 300 programs all of a sudden

[Michael T. Dean]

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