Build_Ports_Queue_Id reused?

[Joe Marcus Clarke]

On Sat, 2009-03-21 at 12:15 +0200, Ion-Mihai Tetcu wrote:
> On Fri, 20 Mar 2009 23:33:57 -0400
> Joe Marcus Clarke <marcus at marcuscom.com> wrote:
> 
> > 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
> 
> I know, that's why I asked.
> 
> > If the table is recreated, however, then an id could be reused.
> 
> Like during an upgrade?

The upgrade from 2.x to 3.x, yes.  Any other upgrade, no.

Joe

> 
> > > 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.
> 
> I'm keeping an aye on it, but I don't see any reason/indication.
> 
> 
-- 
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/20090321/28f2afa6/attachment.bin>