Database Archives - Webx Networks

MySQL Replication Error: Duplicate Entry for Key


MySQL Server

MySQL Server

On one MySQL slave server we maintain, we noticed this error

A quick fix was to issue this command:

Some say that there could be a data entry in the slave server and then it was being written again generating the duplicate error. Some others are of the opinion that if myisamchk was executed in the master server, it may have removed some entries and tried to create those again. The slave then attempts to write the same entry, but since myisamchk was not executed on the slave, the entry exists hence the duplication error.

Customer Review

“P.S. Impressive response time, thanks!”

Clayton
Back to Top

© 2018 Webx Networks.