MySQL Bugs: #72726: Table name for duplicate entry error

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:	None
Category:	MySQL Server: Errors	Severity:	S2 (Serious)
Version:	5.5.28	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
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

Related bug reported in 2009 http://bugs.mysql.com/bug.php?id=47207&thanks=3&notify=195

I'll make this a duplicate of http://bugs.mysql.com/bug.php?id=47207 .