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
Subject
Views
Written By
Posted
replication problem / myisamchk: error
5668
June 16, 2005 03:33AM
2372
June 17, 2005 02:43AM
4324
June 17, 2005 07:22AM
2594
June 20, 2005 07:32AM
2431
June 20, 2005 08:52AM
2059
July 01, 2005 08:54AM
1945
July 17, 2005 11:28AM
2123
July 03, 2006 02:15AM
1823
July 03, 2006 03:52AM
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.