On Friday 26 April 2002 10:11 am, Jeremy Zawodny wrote: > Hey Sasha, > > I recently wiped my 4.0.2 slave clean and installed the latest 4.0.2, > built from the BK tree. Then I synced it up with a nearby slave > running 3.23.47 (using rsync after I had flushed the tables on the > other slave and run a "SLAVE STOP"). > > I started it up and it ran for about a day before it ran into a > duplicate key error. The 3.23.47 slave hasn't hit the duplicate key > error, nor have any of our other slaves. So it is a 4.0.2 bug of some > sort. > > What can I do to help you debug this? > > It is currently "stuck". I haven't bumped the counter yet and > restarted the slave.
Jeremy: It indeed looks like a bug to me from your description. However, at this point I have no clue as to where it might be without some additionial information. Actually, having said "no clue" brought me into a humble state of mind, and one clue has just come. I suspect that somehow I/O thread manages to log the same event twice in the relay log under some circumstances. I looked at the code and could not think of a way how it could happen, though. So let's do two things: * use mysqlbinlog to check the current relay log in the SQL thread ( you can see it in SHOW SLAVE STATUS) at the current position and one event prior to see if this is the same query. You will probably want to do mysqlbinlog log-name > log.sql, search for the current position in a text editor, and then scroll back one entry * If you find a duplicate event in the relay log, check its originating master position, and then check the error log to see if there were any reconnects in the I/O thread around that position. Hope the above makes sense. If not, feel free to ask clarifying questions. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/?ref=mspa __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA <___/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
