Chad, this did not work. Though it did do something, the Position jumped ahead
mysql> show slave status\G *************************** 1. row *************************** Master_Host: 209.217.92.34 Master_User: repslave2 Master_Port: 3306 Connect_retry: 60 Log_File: QBSLXDB1-bin.029 Pos: 2596608 Slave_Running: No Replicate_do_db: qbslive Replicate_ignore_db: Last_errno: 1062 Last_error: error 'Duplicate entry '1376034' for key 1' on query 'INSERT INTO DISPATCHLOG (CreateStamp) VALUES (NOW())' Skip_counter: 1 1 row in set (0.00 sec) mysql> set sql_slave_skip_counter = 1; Query OK, 0 rows affected (0.01 sec) mysql> slave start; Query OK, 0 rows affected (0.00 sec) mysql> show slave status\G *************************** 1. row *************************** Master_Host: 209.217.92.34 Master_User: repslave2 Master_Port: 3306 Connect_retry: 60 Log_File: QBSLXDB1-bin.029 Pos: 2596630 Slave_Running: No Replicate_do_db: qbslive Replicate_ignore_db: Last_errno: 1062 Last_error: error 'Duplicate entry '1376034' for key 1' on query 'INSERT INTO DISPATCHLOG (CreateStamp) VALUES (NOW())' Skip_counter: 0 1 row in set (0.00 sec) -----Original Message----- From: chad kellerman [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 5:18 PM To: Luc Foisy Cc: [EMAIL PROTECTED] Subject: Re: MySQL replication error Luc, I new to this mailinglist ( this is my first posting) But I have worked a little with replication. Try if the replicator is still down. set sql_slave_skip_counter = 1; slave start on the slave as long as you are sure the master is ok. Let me know is this worked. -chad On Thu, 21 Feb 2002 15:48:08 -0500 Luc Foisy <[EMAIL PROTECTED]> wrote: > Would anyone be able to tell me why this happened, and how I could fix it? > > mysql> show slave status\G > *************************** 1. row *************************** > Master_Host: 209.217.92.34 > Master_User: repslave2 > Master_Port: 3306 > Connect_retry: 60 > Log_File: QBSLXDB1-bin.029 > Pos: 2596608 > Slave_Running: No > Replicate_do_db: qbslive > Replicate_ignore_db: > Last_errno: 1062 > Last_error: error 'Duplicate entry '1376034' for key 1' on query > 'INSERT INTO DISPATCHLOG (CreateStamp) VALUES (NOW())' > Skip_counter: 0 > > err_log > 020221 14:21:12 mysqld started > /usr/local/libexec/mysqld: ready for connections > 020221 14:21:14 Slave: connected to master '[EMAIL PROTECTED]:3306', > replication started in log 'QBSLXDB1-bin.029' at position > 2596608 > ERROR: 1062 Duplicate entry '1376034' for key 1 > 020221 14:21:14 Slave: error running query 'INSERT INTO DISPATCHLOG > (CreateStamp) VALUES (NOW())' > 020221 14:21:14 Error running query, slave aborted. Fix the problem, and > re-start the slave thread with "mysqladmin start-slave". We s > topped at log 'QBSLXDB1-bin.029' position 2596608 > 020221 14:21:14 Slave thread exiting, replication stopped in log > 'QBSLXDB1-bin.029' at position 2596608 > > > Luc Foisy > > Technical Magic - www.technical-magic.com > 1 Stafford Road, Suite 325, Nepean, Ontario, K2H 1B9 > Phone: (613) 829-7117 Fax: (613) 596-5096 > E-Mail: [EMAIL PROTECTED] > > <<<<< Fulfilling the Promise of Technology >>>>> > > > --------------------------------------------------------------------- > 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