Bug #86053 MySQL 1062 –Duplicate entry for key without duplicate value
Submitted: 24 Apr 2017 9:20 Modified: 24 May 2017 9:42
Reporter: Yong Lv Lv Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.7.11 OS:Any
Assigned to: Assigned Account CPU Architecture:Any
Tags: unique index

[24 Apr 2017 9:20] Yong Lv Lv
I am trying to insert a new record into table Message in MySQL DB with InnoDB engine. Table Message has a unique index idx_appid_seed(appid, seed). When my java program try to insert a new record, I got error message Error: Duplicate entry '2678-1' for key 'idx_appid_seed', the column seed is not null.

But I am sure the entry 2678-1 is a new entry, there is no row that has value 2678 in column appid.

I have use delete clause to remove the duplicate entry, but there is no sense. I have tried tools like pt-duplcate-key-checker, but I can`t find anything.

How to repeat:
I can't repeat this problem
[24 Apr 2017 9:42] Chiranjeevi Battula
Hello  Yong,

Thank you for the bug report.
Could you please provide repeatable test case (exact steps, sample test case, database/create table statements, full stack trace  etc. - please make it as private if you prefer) to confirm this issue at our end?

[25 May 2017 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".