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
