I was running into this all the time.
I actually had myisamchk running on a regular basis (live) via cron
which I think was actually causing the corruption.
By chance are you running myisamchk on the live tables?? I ran the
REPAIR TABLE... on each table, shut down mysql THEN ran myisamchk
again and my 127 errors seem o be gone (so far).
What OS are you running BTW?
Dan T
On Jul 28, 2005, at 8:45 AM, Chris McKeever wrote:
MySQL 4.0.16
I am having this annoying persistent corruption issue, and am
wondering if anyone has any suggestions. I have two tables that
refuse to stay clean. After a myisamchk (below) they show corruption.
I run a myisamchk -r, they get fixed, and the next day, they are once
again corrupt.
Finally, I did a mysqldump, dropped the tables, imported the data from
the dump, and the next day - corrupt.
I am at a loss, I thought the brute force method should clean it.
I dont think it is the applicaiton itself, since there are an
identical 24 tables (alphabet) that do not have this issue.
Any help would be appreciated - Chris
Checking MyISAM file: EmailMessage_c.MYI
Data records: 79196 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 record links
myisamchk: error: Record-count is not ok; is 79197 Should
be: 79196
myisamchk: warning: Found 457872 deleted space. Should be 459588
myisamchk: warning: Found 79507 parts Should
be: 79506 parts
MyISAM-table 'EmailMessage_c.MYI' is corrupted
Fix it using switch "-r" or "-o"
Checking MyISAM file: EmailMessage_j.MYI
Data records: 39907 Deleted blocks: 91
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 record links
myisamchk: error: Record-count is not ok; is 39909 Should
be: 39907
myisamchk: warning: Found 719032 deleted space. Should be 742328
myisamchk: warning: Found 89 deleted blocks Should
be: 91
myisamchk: warning: Found 40195 parts Should
be: 40193 parts
MyISAM-table 'EmailMessage_j.MYI' is corrupted
Fix it using switch "-r" or "-o"
--
----------------------------------
please respond to the list .. if you need to contact me direct
cgmckeever is the account
prupref.com is the domain
<A href="http://www.prupref.com";>Simply Chicago Real Estate</A>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
