Sigh, sanity check. I did set a skip counter, and you were correct, it was on a newer version ( on a different slave ) That slave server crashed, when we did the reinstall, i reverted back to 3.23.32 ( the same as the rest of or slaves were running ) So that threw me for a loop seeing now that all our slaves are running at that older version I checked back about 12000 messages (2/21/02) and then realized what went down.
-----Original Message----- From: Luc Foisy Sent: Tuesday, May 28, 2002 11:53 AM To: MYSQL-List (E-mail) Subject: RE: SET SQL_SLAVE_SKIP_COUNTER= I am sure I did something to set the skip counter, it might not have been that command, but I am sure I did it somehow at the direction of someone else on the list when I had problems before -----Original Message----- From: Harald Fuchs [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 10:56 AM To: [EMAIL PROTECTED] Subject: Re: SET SQL_SLAVE_SKIP_COUNTER= In article <[EMAIL PROTECTED]>, "Luc Foisy" <[EMAIL PROTECTED]> writes: >> MySQL version too old? > It is kinda old (3.23.32), but I did set some kind of skip counter before, just >can't remeber how I did it. Are you sure? The manual says that SQL_SLAVE_SKIP_COUNTER was added in release 3.23.33. --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
