One of our servers (of many running the same software and mysql version) is
frequently getting
"ERROR 1030: Got error 127 from table handler"
on two of its tables.
mysql version is 3.23.49.
We can not recover with myisamchk -r, but instead have to use "myisamchk -o"
which ends up wiping out the offending record(s).
We've tried to correlate this to some unix process which might interrupt
writing to the file,
but can't find any pattern. Does anyone have a good methodology for
diagnosing these corruptions?
We can possibly suspect hardware problems (old rack-mount server) but having
done a lowlevel filesystem check, no errrors come up.
The two tables involved are almost exclusively used with INSERT statements,
and they do contain around 250000 rows,
What else can lead to such frequent errors on the same tables?
Thanks for your suggestions,
Kevin
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
