What type of column is the id field? If it is a tinyint maybe you simply ran out of
numbers?
Also are you using replication and inserting on two different servers at the same time? If
so a race condition can occur where duplicate id's get inserted if you do not take extra
precautions.
Please give us more details like the CREATE TABLE statement used for the table (you can
get this by doing SHOW CREATE TABLE table_name;) and any information about the general
environment, replication, how inserts are occurring (ie multithreaded? Coming from a web
server? Etc).
John A. McCaskey
-----Original Message-----
From: KSTrainee [mailto:KSTrainee@stripped]
Sent: Monday, August 30, 2004 9:55 AM
To: Rui Monteiro
Cc: mysql@stripped
Subject: AW: Duplicate Keys when auto-increment??
i had the same problem with myisam tables where some started to produce duplicate entries
on the auto increment field at random values.
to be more specific:
show table status like "mytable";
auto_increment: 12345
insert into mytable (field) values ('XYZ');
show table status like "mytable";
auto_increment: 12345
i had to copy the table's content into a temp table, TRUNCATE the original one and then
re-insert the table's content so that the auto_increment column is being flushed.
i could not reproduce the problem or think of anything that might have caused it ....
-----Ursprüngliche Nachricht-----
Von: Rui Monteiro [mailto:RuiSMonteiro@stripped]
Gesendet: Montag, 30. August 2004 16:59
An: mysql@stripped
Betreff: Duplicate Keys when auto-increment??
Hello there,
Does anyone ever had this problem:
Table Hello ***********
id - (PK) auto-increment
name - text
.
**************************
After some insert's, the table starts to getting erros due to "Duplicate
entry" for the ID.
But the ID is been auto-incremented!
I do something like this:
Insert into hello values ('','wedmwe')
Or
Insert into hello (name) values ('werio')
Why is the error happening now? It started at the 127th entry.
Thanks for the help.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1
