Hello.
> MySQL 4.0.16 You run an old MySQL. Upgrade to the latest release sometimes solves such issues. Check if the problem remains with MySQL 4.1.13 (or 4.0.25). Chris McKeever <[EMAIL PROTECTED]> 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" > > > =20 > 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" > > > --=20 > ---------------------------------- > please respond to the list .. if you need to contact me direct > cgmckeever is the account > prupref.com is the domain > > <A href=3D"http://www.prupref.com";>Simply Chicago Real Estate</A> > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
