According to perror, error 127 = Record-file is crashed. This is a symptom of a corrupted table.
Check out the MySQL manual, 4.4.6.9, How to Repair Tables. Specifically, try running myisamchk on the table. --Walt Weaver Bozeman, Montana -----Original Message----- From: Carter, Robert L (MN65) [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 7:31 AM To: '[EMAIL PROTECTED]' Subject: ERROR 1030: Got error 127 from table handler Can anyone shed some light on this? Have found that others have run into this (via Google) but no resolution and no hits at www.mysql.com. A count(*) query returns fine but trying to select the rows fails (see log snippet below). Regards, Bob mysql> select count(*) from event where sid=9 and cid > 694725; +----------+ | count(*) | +----------+ | 4925 | +----------+ 1 row in set (0.01 sec) mysql> select * from event where sid=9 and cid > 694725 LIMIT 0, 100000; ERROR 1030: Got error 127 from table handler mysql> select * from event where sid=9 and cid > 694725 LIMIT 0, 100000; ERROR 1030: Got error 127 from table handler mysql> select * from event where sid=9 and cid > 694725; ERROR 1030: Got error 127 from table handler --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
