asked on

"Got error 127 from table handler"-URGENT!!

Hi,
This is really very funny.My application worked yesterday, and today it is not working the error iam getting is "Got..." and surprisingly to work the application again, i had delete the tables and redo it again.

Can i pls know why i got the error, i mean what mistake i did,i mean if i need to delete all the tables and then it work then if during my presentation i cannot do that.

Pls helpl

ASKER CERTIFIED SOLUTION

jconde

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

jconde

Which version of mysql are you using ?

Did by any chance anyone execute ALTER TABLE while someone else was using the table ?

if REPAIR TABLE didn't work, try doing the following:

mysqladmin flush-tables
cd /path/to/where/your/faulty/table/is/located/at
myisamchk -r your_table

If that doesn't work and *IF* you're using one of the latest mysql versions, please send a bug report. This is something that should never happen.

Jasbir21

ASKER

it is 1.4, and i never have used the ALTER TABLE before
thanks

jconde

1.4 ?

I assume you mean 4.1 correct ? ... if you're using 4.1 then its probably a bug. You shouldn't be using 4.1 unless you're just trying some of its new features out.

If it's not 4.1, see if you can repeat this using the latest version from www.mysql.com and in case you can, please send a bug report to MySQL AB.

Jasbir21

ASKER

sorry, i typed it fast,its 4.0-production version, I did try 4.1,but i had too many problems with it.

Anyway, i used tthe repair command and my table works fine now,

But after a while, i would need to use the command to repair the tables.

thanks for the help

nitcom

Did solve my prob also thanks-nitcom

NXS

Also solved mine. Thanx

slb5146

This message fixed my problem in short order. Thanks

Steve Brown

&quot;Got error 127 from table handler&quot;-URGENT!!

"Got error 127 from table handler"-URGENT!!