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

[Andrew Dodson]

Its not that it crashes, it occasionaly max's out the CPU. The table is completely recreated and coppied over from a another server, the table works fine on the other server. And i have coppied it over successfully before but twice now, i have encountered this error.

This is one of my queries.

mysql> SELECT DISTINCT ISBN, authors, title, volume_title, sub_title, descr_brief, format_names FROM book_allmedia WHERE isbn = '0224071262';
ERROR 1030 (HY000): Got error 127 from storage engine

However I have just noticed permissions are set for root on table files, i'll report back on findings, takes 20 minutes to run the repair on this monster dataset!