MySQL Forums
Forum List  »  Replication

Error Duplicate entry - Master-Slave replication
Posted by: Sree Mal
Date: January 04, 2012 05:02PM

I have a Master-Slave replication running well for almost week. Slave is read-only and Master is high-transaction db and its the only source pushing DML statements to Slave. Suddenly, I see a error on slave status:

Last_Error: Error 'Duplicate entry '12345' for key 'Tablebname'' on query. Default database: 'test_me' Query: 'insert into rep_info (rep_name, create_time, update_time, count) values ('12345', '2012-01-04 01:13:12', '2012-01-04 01:13:12', 1)';

I see that the record already exists on slave db, just wondering why would this happen considering slave db is read-only.


Options: ReplyQuote

Written By
Error Duplicate entry - Master-Slave replication
January 04, 2012 05:02PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.