MySQL Forums
Forum List  »  Replication

replication error
Posted by: niraj vara
Date: May 01, 2014 02:34AM

Hi

I have setup the mysql master slave replication. I have mysql Server version: 5.1.73.

now since last six month my replication broken two times. now I would like to diagnosh due to which reason it was broken.

Please guide so I can avoid the replication broken in future.

Error is just like

Last_Errno: 1062
Last_Error: Error 'Duplicate entry '1833' for key 'PRIMARY'' on query. Default database: 'Ahm_123'. Query: 'INSERT INTO
random_number_link(sessionid,randomid,link_detail)
VALUES
('1398433792135510.174655936795116','54018613984341521402079986852460','coded_type=coded')'

Options: ReplyQuote


Subject
Views
Written By
Posted
replication error
1646
May 01, 2014 02:34AM
719
May 02, 2014 11:42AM
733
May 05, 2014 04:47AM


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.