Duplicate entry '12924' for key 'PRIMARY'' on query. Default database:

[Hema v]

Hi,

We have master-master replication configured. I have got below error Duplicate entry '12924' for key 'PRIMARY'' on query. Default database: and replication stopped. Please let me why this happening and this is now fixed. But need a permanent fix for this. as this is happening more.

details of table on which error occured:

CREATE TABLE `head` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`custom_gp` varchar(255) DEFAULT NULL,
`metta` varchar(255) NOT NULL,
`par_id` bigint(20) DEFAULT NULL,
`pri` int(11) DEFAULT NULL,
`tab_id` varchar(255) DEFAULT NULL,
`fld_n` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13317 DEFAULT CHARSET=utf8
CREATE TABLE `head` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`custom_gp` varchar(255) DEFAULT NULL,
`metta` varchar(255) NOT NULL,
`par_id` bigint(20) DEFAULT NULL,
`pri` int(11) DEFAULT NULL,
`tab_id` varchar(255) DEFAULT NULL,
`fld_n` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13317 DEFAULT CHARSET=utf8