MySQL Forums
Forum List  »  MyISAM

URGENT, myisamchk error
Posted by: Santoni Arnaud
Date: September 15, 2005 05:31AM

Hi all,

We've got some important trouble with some tables.
we are working under linux redhat with mysql 3.23.47

When we try to repair this problem we've got:

>myisamchk -e domaineinstances.MYI

Checking MyISAM file: domaineinstances.MYI
Data records: 365096 Deleted blocks: 0
- check file-size
myisamchk: error: Size of datafile is: 17524388 Should be: 17524580
- check key delete-chain
- check record delete-chain
- check index reference
- check data record references index: 1
myisamchk: error: Found key at page 17312768 that points to record outside datafile
- check records and index references
myisamchk: error: Record-count is not ok; is 365092 Should be: 365096
myisamchk: warning: Found 365092 parts Should be: 365096 parts
MyISAM-table 'domaineinstances.MYI' is corrupted
Fix it using switch "-r" or "-o"

when we perform this command one more time, we have resolved the problem, but it comes back a few time later...
When have too, this kind of problem, alternatively

> myisamchk -e domaineinstances.MYI

Checking MyISAM file: domaineinstances.MYI
Data records: 365107 Deleted blocks: 22
myisamchk: warning: 1 clients is using or hasn't closed the table
properly
- check file-size
- check key delete-chain
- check record delete-chain
- check index reference
- check data record references index: 1
- check records and index references
myisamchk: error: Record-count is not ok; is 365105 Should be: 365107
myisamchk: warning: Found 24 deleted blocks Should be: 22
MyISAM-table 'domaineinstances.MYI' is corrupted
Fix it using switch "-r" or "-o"

Someone to help me, pls

thanks in advance

Arnaud

Options: ReplyQuote


Subject
Views
Written By
Posted
URGENT, myisamchk error
5075
September 15, 2005 05:31AM
2348
September 16, 2005 03:40AM


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.