Comment 1 for bug 674588

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
>
>
>