"MySQL said: Got error 127 from table handler"

[stonix]

This issue just happend today: when query a certain table, mysql returns error message: "MySQL said: Got error 127 from table handler". Only one table got such an problem. We never touched it before. Anyone have an idear? Thanks!

Alex

[FZ]

This might help: http://forums.devshed.com/t101141/s3f423285f17bf5511ffdd4f05753da55.html

[stonix]

I tried repair but got following error message:

"error The handler for the table doesn't support check/repair"

Alex

[FZ]

Hmm, have you tried using PhpMyAdmin to see if you can browse the records in the thing? Maybe PhpMyAdmin will be able to guide you to a solution...

[wildjokerdesign]

PhpMyAdmin is reliant on Mod_php being installed and it well check and repair a table so maybe there is somethng that is installed when Mod_php is installed that handles the check and repair.

[stonix]

I tried PhpMyAdmin but no use. I placed an emergency ticket but nobody even reviewed it. I am thinking that the only way to resume it is to have westhost restore the table file from their backup tape - they do regular tape backup, do they?

[labi]

Same problem in my case.:( It happened few days ago, and westhost I think restarted mysqld but now again. I also have a table what is unaccessable (status="in use" ). I don't know but this Sql server is a disaster, almost every day is a problem... I already lose data. Or is my script?! I used the same scripts on old westhost server, where never happend anything like this... Hopefully westhost will do something or I have to looking for an other host...

[labi]

In my case the "repaire table" command (from phpMyAdmin) did the job, but unfortunately one of the table loose data...

[Barb54]

Hi,
Once you get your database fixed up why not "dump" your database every so often just in case? I do this because of past issues with other services. I'm new to WestHost but do they let you set up CronJobs? There could be an answer there as well. I back up my entire website at least weekly and more if there is a lot of activity.

HTH,
Barb

[jalal]

You can also turn on the mysql logging and have a look in the logs to see if there are any strange error messages.
And, as Barb suggests, its easy to setup a cron job to backup the database on a regular basis.
HTH

[labi]

You have right with backups, but when every day one or more of the tables get this error, something wrong with MySQL or with server . Now to be better I get this error : Too many connections.

[FZ]

I'm new to WestHost but do they let you set up CronJobs?

Yup...

editcron -e

(via SSH).

[labi]

I think we got the solution for my problem. I checked mysql logs and there was a log about a problem loading the innoDB tables. After I reported for westhost, they did something because now after mysqld reboot the message is not there and it seams to works fine.