Solved

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

Posted on 2003-11-28
8
25,494 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

 
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
 

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

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

730 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