Replication Issue?

[Roger Davis]

Hi all,
My slave has been working fine up until now. Here is the error message.

030730 11:32:28 Slave: connected to master 'r***@xxxx.xxx.org:3306',
replication started in log 'SQLServer1-bin.034' at position 77571524
ERROR: 1062 Duplicate entry '120816' for key 1
030730 11:32:28 Slave: error running query 'INSERT INTO Assignments (
..........

Key 1 is CaseID

Database changed
mysql> select CaseID from Assignments Order by CaseID DESC Limit 3;
+--------+
| CaseID |
+--------+
| 120815 |
| 120814 |
| 120813 |
+--------+
3 rows in set (0.02 sec)

mysql> DELETE FROM Assignments WHERE CaseID = 120816;
Query OK, 0 rows affected (0.04 sec)

If I try to restart the slave I get the error all over again.

Anyone have any Ideas????
Roger
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.504 / Virus Database: 302 - Release Date: 7/24/2003
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw