Joe Marcus Clarke
marcus at marcuscom.com
Fri Mar 20 23:33:57 EDT 2009
On Wed, 2009-03-18 at 14:47 +0200, Ion-Mihai Tetcu wrote:
> Is there any case when build_ports_queue.build_ports_queue_id is being
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.
PGP Key : http://www.marcuscom.com/pgp.asc
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Size: 195 bytes
Desc: This is a digitally signed message part
More information about the tinderbox-list