Bug #26276 Duplicate entry
Submitted: 12 Feb 2007 6:07 Modified: 12 Mar 2007 8:40
Reporter: JongSe Park Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Errors Severity:S2 (Serious)
Version:5.0.26 OS:Linux (linux)
Assigned to: Assigned Account CPU Architecture:Any
Tags: Duplicate entry, key

[12 Feb 2007 6:07] JongSe Park 
Description:
When I insert some data into table, I get an error message of duplicate entry.
This is table schema.
---
CREATE TABLE `logm_work_log` (
  `WORK_LOG_KID` varchar(32) NOT NULL,
  `WORK_DATA1` varchar(100) default NULL,
  `WORK_DATA2` varchar(100) default NULL,
  `WORK_DATA3` varchar(100) default NULL,
  `WORK_DATA4` varchar(100) default NULL,
  `WORK_DATA5` varchar(100) default NULL,
  `WORK_DATA6` varchar(100) default NULL,
  `WORK_DATA7` varchar(100) default NULL,
  `WORK_DATA8` varchar(100) default NULL,
  `WORK_DATA9` varchar(100) default NULL,
  `WORK_DATA10` varchar(100) default NULL,
  `WORK_DATA11` varchar(100) default NULL,
  `WORK_DATA12` varchar(100) default NULL,
  `WORK_DATA13` varchar(100) default NULL,
  `WORK_DATA14` varchar(100) default NULL,
  `WORK_DATA15` varchar(100) default NULL,
  `WORK_DATA16` varchar(100) default NULL,
  `WORK_DATA17` varchar(100) default NULL,
  `WORK_DATA18` varchar(100) default NULL,
  `WORK_DATA19` varchar(100) default NULL,
  `WORK_DATA20` varchar(500) default NULL,
  `WORK_STATE` varchar(1) NOT NULL default '0',
  `SESSION_ID` varchar(32) NOT NULL,
  `WORK_LOG_DATE` varchar(14) NOT NULL,
  PRIMARY KEY  (`WORK_LOG_KID`),
  KEY `LOGM_WORK_LOG_IDX01` (`SESSION_ID`),
  KEY `LOGM_WORK_LOG_IDX02` (`WORK_LOG_DATE`),
  KEY `LOGM_WORK_LOG_IDX03` (`WORK_DATA1`),
  KEY `LOGM_WORK_LOG_IDX04` (`WORK_DATA2`),
  KEY `LOGM_WORK_LOG_IDX05` (`WORK_STATE`)
) ENGINE=MyISAM DEFAULT CHARSET=euckr
----
During I am inserting several data.
Error message occurred.
--------
Mysql>insert into logm_work_log (work_log_kid, work_data1, work_data2, work_state, session_id, work_log_date) value ('2A6EE1107B3677F9DE70686213CC0A7', 'aa', 'aa', '0', '000400007b1f52b9000000144f45ef4a', '20070201112612');
ERROR 1062 (23000): Duplicate entry '0' for key 6
-------
I think that KEY `LOGM_WORK_LOG_IDX05` (`WORK_STATE`) is not unique key.
I can’t understand why duplicate entry error occurred.
Mysql version is 5.0.26
Is this bug?

Thanks

How to repeat:
This is table schema.
---
CREATE TABLE `logm_work_log` (
  `WORK_LOG_KID` varchar(32) NOT NULL,
  `WORK_DATA1` varchar(100) default NULL,
  `WORK_DATA2` varchar(100) default NULL,
  `WORK_DATA3` varchar(100) default NULL,
  `WORK_DATA4` varchar(100) default NULL,
  `WORK_DATA5` varchar(100) default NULL,
  `WORK_DATA6` varchar(100) default NULL,
  `WORK_DATA7` varchar(100) default NULL,
  `WORK_DATA8` varchar(100) default NULL,
  `WORK_DATA9` varchar(100) default NULL,
  `WORK_DATA10` varchar(100) default NULL,
  `WORK_DATA11` varchar(100) default NULL,
  `WORK_DATA12` varchar(100) default NULL,
  `WORK_DATA13` varchar(100) default NULL,
  `WORK_DATA14` varchar(100) default NULL,
  `WORK_DATA15` varchar(100) default NULL,
  `WORK_DATA16` varchar(100) default NULL,
  `WORK_DATA17` varchar(100) default NULL,
  `WORK_DATA18` varchar(100) default NULL,
  `WORK_DATA19` varchar(100) default NULL,
  `WORK_DATA20` varchar(500) default NULL,
  `WORK_STATE` varchar(1) NOT NULL default '0',
  `SESSION_ID` varchar(32) NOT NULL,
  `WORK_LOG_DATE` varchar(14) NOT NULL,
  PRIMARY KEY  (`WORK_LOG_KID`),
  KEY `LOGM_WORK_LOG_IDX01` (`SESSION_ID`),
  KEY `LOGM_WORK_LOG_IDX02` (`WORK_LOG_DATE`),
  KEY `LOGM_WORK_LOG_IDX03` (`WORK_DATA1`),
  KEY `LOGM_WORK_LOG_IDX04` (`WORK_DATA2`),
  KEY `LOGM_WORK_LOG_IDX05` (`WORK_STATE`)
) ENGINE=MyISAM DEFAULT CHARSET=euckr
----
During I am inserting several data.
Error message occurred.
--------
Mysql>insert into logm_work_log (work_log_kid, work_data1, work_data2, work_state, session_id, work_log_date) value ('2A6EE1107B3677F9DE70686213CC0A7', 'aa', 'aa', '0', '000400007b1f52b9000000144f45ef4a', '20070201112612');
ERROR 1062 (23000): Duplicate entry '0' for key 6
-------
[12 Feb 2007 8:40] Sveta Smirnova 
Thank you for the report.

I can not repeat it with current development sources and 2 queries:

insert into logm_work_log (work_log_kid, work_data1, work_data2,
work_state, session_id, work_log_date) value ('2A6EE1107B3677F9DE70686213CC0A7',
'aa', 'aa', '0', '000400007b1f52b9000000144f45ef4a', '20070201112612');

insert into logm_work_log (work_log_kid, work_data1, work_data2,
work_state, session_id, work_log_date) value ('2A6EE1107B3677F9DE70686213CC0A8',
'aa', 'aa', '0', '000400007b1f52b9000000144f45ef4a', '20070201112612');

Please, upgrade to version 5.0.33, try again and if you can repeat the error, send us content of the table logm_work_log with which error happens.
[13 Mar 2007 0: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".