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.
Sree.
Subject
Views
Written By
Posted
Error Duplicate entry - Master-Slave replication
10369
January 04, 2012 05:02PM
4171
January 05, 2012 07:46PM
4430
January 10, 2012 10:06AM
4682
January 11, 2012 10:16AM
3923
January 18, 2012 01:46PM
3358
February 21, 2012 07:13AM
3719
February 22, 2012 09:44PM
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.