Hi all, My slave has been working fine up until now. Here is the error message.
030730 11:32:28 Slave: connected to master '[EMAIL PROTECTED]: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/[EMAIL PROTECTED]
