I’m replicating the content of a table with pt-table-sync. Everything was working nice until I found this error constantly:
pt-table-sync => Duplicate entry ‘2876’ for key ‘PRIMARY’ [for Statement "REPLACE INTO…
I checked the destination table, truncate it, deleting and recreating… and that error stills keeps showing even if there are no rows in the destination table.
What’s going on?