Solved

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

Posted on 2003-11-28
8
25,486 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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we have this network schema (see atachment). We need to replicate EVERY executed SQL query on server 1 to…
Creating and Managing Databases with phpMyAdmin in cPanel.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
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 …

856 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