MySQL Forums :: Replication :: Error Duplicate entry - Master-Slave replication


Advanced Search

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.

Options: ReplyQuote


Subject Views Written By Posted
Error Duplicate entry - Master-Slave replication 8711 Sree Mal 01/04/2012 05:02PM
Re: Error Duplicate entry - Master-Slave replication 3837 Rick James 01/05/2012 07:46PM
Re: Error Duplicate entry - Master-Slave replication 3974 Sree Mal 01/10/2012 10:06AM
Re: Error Duplicate entry - Master-Slave replication 4125 Rick James 01/11/2012 10:16AM
Re: Error Duplicate entry - Master-Slave replication 3378 Sree Mal 01/18/2012 01:46PM
Re: Error Duplicate entry - Master-Slave replication 2892 Rob Lansu 02/21/2012 07:13AM
Re: Error Duplicate entry - Master-Slave replication 3158 Irfan Ali 02/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.