Re: Error code 127: Record-file is crashed.

[Andrew Dodson]

I have now copied and repaired the table for a third time, without joy.
The REPAIR command returns

mysql> repair table book_allmedia;
+-------------------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+-------------------------+--------+----------+----------+
| booksharp.book_allmedia | repair | status | OK |
+-------------------------+--------+----------+----------+
1 row in set (12 min 44.55 sec)


I took information of the directory files during and after the repair operation.

[root@linux ~]# ls /var/lib/mysql/booksharp/book_allmedia* -l
-rwxrwxrwx 1 mysql mysql 9920 Sep 5 13:28 /var/lib/mysql/booksharp/book_allmedia.frm
-rwxrwxrwx 1 mysql mysql 1351314772 Sep 5 13:33 /var/lib/mysql/booksharp/book_allmedia.MYD
-rwxrwxrwx 1 mysql mysql 315920384 Sep 5 13:34 /var/lib/mysql/booksharp/book_allmedia.MYI
-rw-rw---- 1 mysql mysql 778043084 Sep 5 13:39 /var/lib/mysql/booksharp/book_allmedia.TMD
[root@linux ~]# ls /var/lib/mysql/booksharp/book_allmedia* -l
-rwxrwxrwx 1 mysql mysql 9920 Sep 5 13:28 /var/lib/mysql/booksharp/book_allmedia.frm
-rwxrwxrwx 1 mysql mysql 778043084 Sep 5 13:39 /var/lib/mysql/booksharp/book_allmedia.MYD
-rwxrwxrwx 1 mysql mysql 315920384 Sep 5 13:34 /var/lib/mysql/booksharp/book_allmedia.MYI

.... it appears to be getting half way and then falling over, The database is on a live webserver, whislt this table is not being accessed the CPU sits at 99.9 during the repair operation.

Presumably it could be a problem with the network copying, the data in the file or something else i haven't thought of.

Help, even if it seems trivial, chance might be i haven't tried it. :)