MySQL Forums
Forum List  »  MyISAM

replication problem / myisamchk: error
Posted by: olli
Date: June 16, 2005 03:33AM

Hi,

we are running one Master Server with 4 Slaves (MySQL 4.1.12) with master/slave replikation.

after a short period of time (3-4 hours) our databases at the master will be messed up a little bit like this:

master:/var/lib/mysql # myisamchk dbl/gebuehr.MYI
Checking MyISAM file: db/gebuehr.MYI
Data records: 44954 Deleted blocks: 8
myisamchk: warning: 1 client is using or hasn't closed the table properly
- 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 data record references index: 5
- check data record references index: 6
- check data record references index: 7
- check record links
MyISAM-table 'db/gebuehr.MYI' is usable but should be fixed

at the same time all slaves get corrupted in the same table like this:

slave1:/var/lib/mysql # myisamchk db/gebuehr.MYI
Checking MyISAM file: db/gebuehr.MYI
Data records: 44954 Deleted blocks: 8
myisamchk: warning: 1 client is using or hasn't closed the table properly
- check file-size
myisamchk: error: Size of indexfile is: 2854912 Should be: 2991104
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
myisamchk: error: Found 44900 keys of 44954
- check record links
myisamchk: error: Keypointers and record positions doesn't match
MyISAM-table 'db/gebuehr.MYI' is corrupted
Fix it using switch "-r" or "-o"

if i run myisamchek with -r on the master, all master tables are ok again.
i can now reload the slaves and there will be everthing all right also, but i
have to to this a few times a day - this can´t be right :)

we didn´t have this problem only at one table - most of our tables are corrupt like this - some after a few hours - some after days.

could anybode help ?

cheers,
oliver

Options: ReplyQuote


Subject
Views
Written By
Posted
replication problem / myisamchk: error
5185
June 16, 2005 03:33AM


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.