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

[Andrew Dodson]

Indeed, i have a backup. The website runs from one of two databases and i switch them around to make alterations and include the updates supplied from an external supply.


I ran 'myisamchk tablename' on the table after the steps i wrote in the previous message. Here's the output

[drew@linux ~]$ myisamchk /var/lib/mysql/booksharp/book_allmedia
Checking MyISAM file: /var/lib/mysql/booksharp/book_allmedia
Data records: 2336264 Deleted blocks: 0
- check file-size
myisamchk: error: Size of datafile is: 778043084 Should be: 1351314772
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
myisamchk: error: Found key at page 1024 that points to record outside datafile
- check record links
myisamchk: error: Record-count is not ok; is 1342426 Should be: 2336264
myisamchk: warning: Found 1342426 parts Should be: 2336264 parts
MyISAM-table '/var/lib/mysql/booksharp/book_allmedia' is corrupted
Fix it using switch "-r" or "-o"
[drew@linux ~]

... it gets better.

I deleted and re-coppied the files for the fouth time, but did not run "REPAIR TABLE tablename" - i usually do run REPAIR TABLE. Instead i ran myisamchk again... the results were pleasing.

[drew@linux ~]$ myisamchk /var/lib/mysql/booksharp/book_allmedia
Checking MyISAM file: /var/lib/mysql/booksharp/book_allmedia
Data records: 2336264 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
- check data record references index: 3
- check data record references index: 4
- check data record references index: 5
- check record links
[drew@linux ~]


:)

So either this was a network problem 3 times out of 4. Or there is problem with 'REPAIR TABLE'.

Perplexing. Alas i haven't the time to find out which or if any reason it is.

Cheers people!