Bug #41881 Stopped inserting new records
Submitted: 5 Jan 2009 18:25 Modified: 6 Feb 2009 10:01
Reporter: Pavel Baranov Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.1.30 OS:Linux (64Bit)
Assigned to: CPU Architecture:Any
Tags: inserts

[5 Jan 2009 18:25] Pavel Baranov
Description:
All of a sudden insertions to a table stopped.

mysql> insert into profiles set first_name = 1517976, last_name = 89702, middle_name = 2, created = now(), status = 1, active = 1, links = 1, locked = 0, age = 57;
ERROR 1022 (23000): Can't write; duplicate key in table 'profiles'

How to repeat:
NO CLUE

Suggested fix:
insert into profiles set id = 166261149, first_name = 1517976, last_name = 89702, middle_name = 2, created = now(), status = 1, active = 1, links = 1, locked = 0, age = 57;
Query OK, 1 row affected (0.03 sec)

FIXED IT!!!

after that queries like this:
insert into profiles set first_name = 2457, last_name = 205662, middle_name = 16, created = now(), status = 1, active = 1, links = 1, locked = 0;
worked just fine.
[5 Jan 2009 18:27] Pavel Baranov
table create, indexes

Attachment: mysql-bug-insert.txt (text/plain), 7.80 KiB.

[6 Jan 2009 10:01] Valeriy Kravchuk
Thank you for a problem report. Please, send the entire error log. 

Is it possible that server was restarted before that INSERT or you had a deadlock/long running transaction at the moment?
[7 Feb 2009 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".