duplicate entry issue with large mysql database table
From here - take a dump of the table, drop it and recreate it. Reload your dump - that solved the issue here. If this doesn't solve the issue, then please post SHOW CREATE TABLE my_table\G and also the contents of my.cnf.