MySQL Forums
Forum List  »  Replication

Advanced Search
New Topic

Reason for Duplicate Entries and its Resolution
Posted by: Muhammad Omair Siddiqui
Date: December 30, 2020 06:34AM

Hi,

I'm new to MySQL and currently facing an issue with duplicate entries. I want to know the reason why do we see duplicate entries in the database and how we can prevent it? Whenever duplicate entries occur replication fails. What is the connection between a duplicate entry and replication failure?

Sample Error:

Error 'Duplicate entry '24.78.3.64-0462348ddc7eac5f045bfe380fb6a7' for key 'countername'' on query. Default database: 'ssg'. Query: 'insert into counters (countername, goid) values ('24.78.3.64-0462348ddc7eac5f045bfe380fb6a7', x'C7D3A91D5933B65D6BF176765F3654')'

Any explanation of the above questions would be appreciated.

Thanks.
Regards,
Omair S.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Reason for Duplicate Entries and its Resolution
523
Muhammad Omair Siddiqui
December 30, 2020 06:34AM
Re: Reason for Duplicate Entries and its Resolution
223
Peter Brawley
December 30, 2020 09:50AM


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.