I'm having more and more errors with my MySQL (latest 5.1) replication, in a master-slaves (one master, two slaves). A couple of times in the last couple of days, I'm getting duplicate entry, like this:
Error 'Duplicate entry '4818122-74' for key 'PRIMARY'' on query. Default database: 'xxxxx'. Query: 'INSERT INTO `xxxxxx` (`xxxx`, `xxxxx`, `xxxx`, `xxxxx`, `xxxx`) VALUES ('4818122', '74', '566.29411764706', '34', '10')'
It happens 99% of the time on the same table. All databases are replicated.
What can cause this?