Joe Marcus Clarke
marcus at marcuscom.com
Sat Mar 21 13:31:58 EDT 2009
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.
> > > 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
Size: 195 bytes
Desc: This is a digitally signed message part
More information about the tinderbox-list