Duplicate entry error on an auto_increment PRIMARY KEY field

--Boundary_(ID_TTp6i+Cu0/5e/fGcL3/Spw)
Content-type: text/plain; charset=iso-8859-1
Content-transfer-encoding: 7BIT


MySQL Version: 3.23.53a
Apache Version: 1.3.27 (Unix)

Duplicate entry error on an auto_increment PRIMARY KEY field


Field: trans_id
Type: int(32)
Attributes: UNSIGNED
Null: No
Default:
Extra: auto_increment

Action: Change Drop Primary Index Unique Fulltext

This field is listed as the Primary Key

Problem:
When the index reached 240810, auto_increment appeard to have stopped and
a "Duplicate entry" error was being generated.


Fix:
I changed the field type to mediumint(12) and left all other attributes
the same. Auto_increment is once again working.


Not sure if this is a bug or just something I did improperly.

Rudy


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.489 / Virus Database: 288 - Release Date: 6/10/03

--Boundary_(ID_TTp6i+Cu0/5e/fGcL3/Spw)--

Re: Duplicate entry error on an auto_increment PRIMARY KEY field

Rudy Gamberini writes:
>
> MySQL Version: 3.23.53a
> Apache Version: 1.3.27 (Unix)
>
> Duplicate entry error on an auto_increment PRIMARY KEY field
>
>
> Field: trans_id
> Type: int(32)
> Attributes: UNSIGNED
> Null: No
> Default:
> Extra: auto_increment
>
> Action: Change Drop Primary Index Unique Fulltext
>
> This field is listed as the Primary Key
>
> Problem:
> When the index reached 240810, auto_increment appeard to have stopped and
> a "Duplicate entry" error was being generated.
>
>
> Fix:
> I changed the field type to mediumint(12) and left all other attributes
> the same. Auto_increment is once again working.
>
>
> Not sure if this is a bug or just something I did improperly.
>
> Rudy
>

Hi!

Have you checked first for table corruption with CHECK TABLE ??

--

Regards,

--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB
/_/ /_/\_, /___/\___\_\___/ Fulltime Developer and Support Coordinator
<___/ www.mysql.com Larnaca, Cyprus


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org