Solved

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

Posted on 2003-11-28
8
25,450 Views
Last Modified: 2008-03-10


 

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

 
 
0
Comment
Question by:Jasbir21
8 Comments
 
LVL 7

Accepted Solution

by:
jconde earned 100 total points
ID: 9839020
Have you tried running the following query:

REPAIR TABLE your_table

?
0
 
LVL 7

Expert Comment

by:jconde
ID: 9839037
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.
0
 

Author Comment

by:Jasbir21
ID: 9840709
it is 1.4, and i never have used the ALTER TABLE before
thanks
0
 
LVL 7

Expert Comment

by:jconde
ID: 9841090
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.
0
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

Author Comment

by:Jasbir21
ID: 9841664
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
0
 

Expert Comment

by:nitcom
ID: 13224242
Did solve my prob also thanks-nitcom
0
 

Expert Comment

by:NXS
ID: 13261052
Also solved mine.  Thanx
0
 

Expert Comment

by:slb5146
ID: 14112538
This message fixed my problem in short order.  Thanks

Steve Brown
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now