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
• Status: No Feedback
• 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

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

Thanks,
Chiranjeevi.

[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".