Solved

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

Posted on 2003-11-28
8
25,516 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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

I have been using r1soft Continuous Data Protection (http://www.r1soft.com/linux-cdp/) for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

718 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