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
