Build_Ports_Queue_Id reused?

[Joe Marcus Clarke]

On Wed, 2009-03-18 at 14:47 +0200, Ion-Mihai Tetcu wrote:
> Hi,
> 
> 
> Is there any case when build_ports_queue.build_ports_queue_id is being
> reused?

No, this should be impossible as build_ports_queue_id is declared as a
serial, and should increment on each insertion.  Additionally, this is
the tables primary key, and at least in MySQL, SERIAL is an alias for:

BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE

If the table is recreated, however, then an id could be reused.

> 
> I'm using an extra table for QAT where I keep build_ports_queue_id and
> it happens that I have the same id twice (the reason for the QATMails
> with duplicate Subject and Cc). I limited the select to the last entry
> but I don't understand why I have those duplicates.

This may point to some database corruption.

Joe

-- 
PGP Key : http://www.marcuscom.com/pgp.asc
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: This is a digitally signed message part
URL: <http://marcuscom.com/pipermail/tinderbox-list/attachments/20090320/b0470181/attachment.bin>