MySQL Forums
Forum List  »  MyISAM

mysqldump: Error 1030: Got error 127 from storage engine when dumping table `xxxx` at row: 116773
Posted by: Mario Neto
Date: August 16, 2007 05:28AM

Hi there,

Since yesterday I started to notice a slowdown in one of my servers. After finding out that it was related to mysql I ran a myisamchk and found some tables marked as crashed even tough there has been no evidence of problem (uptime 30+ days).

Even tough I use -a, -o, -r or -e and they run when I try to dump the database I get the error message

mysqldump: Error 1030: Got error 127 from storage engine when dumping table `xxxx` at row: 116773

The 116773 is the last row according to the myisamchk -a also.

I am using MySQL server 4.1.20 from Centos 4.

Any ideas?

myisamchk -a /var/lib/mysql/mydb/table.MYI
Checking MyISAM file: /var/lib/mysql/mydb/table.MYI
Data records: 116773 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
- check data record references index: 3
- check data record references index: 4
- check record links

mysqldump mydb table > mydb.def
mysqldump: Error 1030: Got error 127 from storage engine when dumping table `table` at row: 116773

Options: ReplyQuote


Subject
Views
Written By
Posted
mysqldump: Error 1030: Got error 127 from storage engine when dumping table `xxxx` at row: 116773
10667
August 16, 2007 05:28AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.