php - mySQL auto increment problem: Duplicate entry '4294967295' for key 1 -

i have table of emails.

the last record in there auto increment id 3780, legit record. new record insert being inserted right there.

however, in logs have occasional:

query fail: insert mail.messages (timestamp_queue) values (:time); array (     [0] => 23000     [1] => 1062     [2] => duplicate entry '4294967295' key 1 ) 

somehow, autoincrement jumped int max of 4294967295

why on god's green earth jumped high? have no inserts id field.

the show status table, auto_increment table reads: 4294967296

how occur? realize id field should perhaps big int, worry have somehow thing jumps up.

josh

edit: update

mysql version 5.0.45 red hat patched

since set id bigint last few id's like:

3777 3778 3779 3780 4294967295 4294967296 4294967297 4294967298 4294967299 4294967300 

as can see, incremental, no gaps (so far). totally weird.

i had same problem exact same number. problem had field on int(10) when changed bigint(20) solved problem.

if others having problem. check field size first. :)