Bug #72726 Table name for duplicate entry error
Submitted: 23 May 2014 4:58 Modified: 23 May 2014 6:49
Reporter: Hong Zheng Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Server: Errors Severity:S2 (Serious)
Version:5.5.28 OS:Any
Assigned to: CPU Architecture:Any

[23 May 2014 4:58] Hong Zheng
We have been seeing error Duplicate entry 'xxx' for key 'PRIMARY' in our log files. Since we have many tables in our database, it's very difficult to determine which table that error is coming from. Since we cannot rename primary key constraint, may I suggest including table name in the error message?

This problem was first reported in 2009. Apparently it's still there...

How to repeat:
Insert a row with the same primary key
[23 May 2014 5:00] Hong Zheng
Related bug reported in 2009 http://bugs.mysql.com/bug.php?id=47207&thanks=3&notify=195
[23 May 2014 6:49] MySQL Verification Team
I'll make this a duplicate of http://bugs.mysql.com/bug.php?id=47207 .