Thanks! I was hoping it was something that had already been found. I'll upgrade as soon as I can.
Thanks, Brian -----Original Message----- From: Sasha Pachev [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 24, 2004 10:47 PM To: Stanton, Brian Cc: '[EMAIL PROTECTED]' Subject: Re: Replication errors... Stanton, Brian wrote: > Shortly after the MySQL 4.0 line went to production, I upgraded to mysql > 4.0.12. Since then my slave has been getting corrupted tables 2 to 3 times > every month. I've also seen this problem in mysql 4.0.13. When I run a > check table on the table in question it gives the following results: > > +-----------------+-------+----------+-------------------------------------- > -------------------+ > | Table | Op | Msg_type | Msg_text > | > +-----------------+-------+----------+-------------------------------------- > -------------------+ > | database.table | check | warning | Table is marked as crashed > | > | database.table | check | warning | 2 clients is using or hasn't closed > the table properly | > | database.table | check | warning | Not used space is supposed to be: > 526688 but is: 522768 | > | database.table | check | error | record delete-link-chain corrupted > | > | database.table | check | error | Corrupt > | > +-----------------+-------+----------+-------------------------------------- > -------------------+ > 5 rows in set (0.01 sec) > > It repairs just fine and then replication continues, but I never ran into > this issue in the 3.23.xx line. Has anyone else been seeing this problem? > Has it been fixed in a later 4.0.x version? > > > ERROR: 1030 Got error 127 from table handler > 040207 3:44:03 Slave: error 'Got error 127 from table handler' on query > ... > 040207 3:44:03 Error running query, slave SQL thread aborted. Fix the > problem, > and restart the slave SQL thread with "SLAVE START". We stopped at log ... I've seen it on my systems. The problem is a bug in DELETE in 4.0 that was fixed in 4.0.18. -- Sasha Pachev Create online surveys at http://www.surveyz.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]