Jasbir21
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
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
it is 1.4, and i never have used the ALTER TABLE before
thanks
thanks
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.
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.
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
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
Did solve my prob also thanks-nitcom
Also solved mine. Thanx
This message fixed my problem in short order. Thanks
Steve Brown
Steve Brown
MySQL Server
MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.
49K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
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
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.