Got error 127 from table handler

I recently came upon this error message when deleting a large number
of rows from a MyISAM table on MySQL 4.1.0: ERROR 1030 at line 1: Got
error 127 from table handler.

Searching the list archives, I found out that this was a bug which
was fixed on 4.0.18 (http://lists.mysql.com/mysql/164250).

Do any of you know if this is still an issue with 4.1.0? Upgrading
to 4.1.1 shouldn't be a problem for me, but I was just curious about the
nature of the error.

Thank you,

--
Thiago Figueiró Gerência de Operações
thiago@ntime.com.br Cel.: (21) 9329-0308



--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: Got error 127 from table handler

Hello Thiago,

Thursday, May 6, 2004, 5:35:00 PM, you wrote:

TCFn> I recently came upon this error message when deleting a large number
TCFn> of rows from a MyISAM table on MySQL 4.1.0: ERROR 1030 at line 1: Got
TCFn> error 127 from table handler.

Think, "mysqlcheck -r " can help you.

--
Best regards, Victor mailto:mrlomax@mail.ru


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: Got error 127 from table handler

Hi!

On May 06, Thiago Conde Figueir? - nTime wrote:
> I recently came upon this error message when deleting a large number
> of rows from a MyISAM table on MySQL 4.1.0: ERROR 1030 at line 1: Got
> error 127 from table handler.

error 127 means a table is corrupted.
If you're sure it wasn't corrupted before your delete operation, than
you hit a bug. Try the latest MySQL version and try to create repeatable
test case. See also http://dev.mysql.com/doc/mysql/en/Bug_reports.html

Regards,
Sergei

--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org