Comment 2 for bug 674588

I've seen instances of more than 2 per trx id.

On Fri, Nov 12, 2010 at 12:04 PM, Patrick Crews
<email address hidden>wrote:

> It should be noted that I haven't seen COUNT(transaction_id) > 2 when
> checking the log, even with high query count and concurrency.
>
> Please let me know if you would like a dumpfile, transaction log or
> whatever
> to assist.
>
> On Fri, Nov 12, 2010 at 11:38 AM, David Shrewsbury <
> <email address hidden>> wrote:
>
> > Public bug reported:
> >
> > When running randgen to look for bug 673105, I saw several messages in
> > the transaction log with the same transaction id number. They are not
> > part of a multi-message Transaction (they are rather small). Used the
> > following randgen command:
> >
> > ./gentest.pl
> >
> >
> --dsn=dbi:drizzle:host=localhost:port=9306:user=root:password="":database=test
> > --gendata=conf/drizzle/translog_drizzle.zz
> > --grammar=conf/drizzle/translog_concurrent3.yy --queries=50 --threads=10
> > --sqltrace --debug --Reporter=DrizzleConcurrentTransactionLog >
> > /tmp/randgen.out
> >
> > ** Affects: drizzle
> > Importance: Critical
> > Assignee: Joe Daly (skinny.moey)
> > Status: New
> >
> > ** Changed in: drizzle
> > Assignee: (unassigned) => Joe Daly (skinny.moey)
> >
> > ** Changed in: drizzle
> > Importance: Undecided => Critical
> >
> > --
> > Transaction ID not unique
> > https://bugs.launchpad.net/bugs/674588
> > You received this bug notification because you are a member of Drizzle-
> > developers, which is subscribed to Drizzle.
> >
> > Status in A Lightweight SQL Database for Cloud Infrastructure and Web
> > Applications: New
> >
> > Bug description:
> > When running randgen to look for bug 673105, I saw several messages in
> the
> > transaction log with the same transaction id number. They are not part of
> a
> > multi-message Transaction (they are rather small). Used the following
> > randgen command:
> >
> >
> ./gentest.pl--dsn=dbi:drizzle:host=localhost:port=9306:user=root:password="":database=test
> > --gendata=conf/drizzle/translog_drizzle.zz
> > --grammar=conf/drizzle/translog_concurrent3.yy --queries=50 --threads=10
> > --sqltrace --debug --Reporter=DrizzleConcurrentTransactionLog >
> > /tmp/randgen.out
> >
> >
> >
>
> --
> Transaction ID not unique
> https://bugs.launchpad.net/bugs/674588
> You received this bug notification because you are a member of Drizzle-
> developers, which is subscribed to Drizzle.
>