On Wed, 10 Jul 2002, Kevin Fries wrote: > 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?
Kevin, have you run memtest? Thomas --------------------------------------------------------------------- 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