Kevin, Wednesday, July 10, 2002, 10:36:06 PM, you wrote: KF> One of our servers (of many running the same software and mysql version) is KF> frequently getting KF> "ERROR 1030: Got error 127 from table handler"
KF> on two of its tables. KF> mysql version is 3.23.49. KF> We can not recover with myisamchk -r, but instead have to use "myisamchk -o" KF> which ends up wiping out the offending record(s). KF> We've tried to correlate this to some unix process which might interrupt KF> writing to the file, KF> but can't find any pattern. Does anyone have a good methodology for KF> diagnosing these corruptions? KF> We can possibly suspect hardware problems (old rack-mount server) but having KF> done a lowlevel filesystem check, no errrors come up. KF> The two tables involved are almost exclusively used with INSERT statements, KF> and they do contain around 250000 rows, KF> What else can lead to such frequent errors on the same tables? There are many possible causes of corruption ... Description some of them you can find at: http://www.mysql.com/doc/C/o/Corrupted_MyISAM_tables.html I also suggest you to look in these section of the manual, they may help you: http://www.mysql.com/doc/C/r/Crashing.html http://www.mysql.com/doc/R/e/Reproduceable_test_case.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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