Transaction ID not unique
Bug #674588 reported by
David Shrewsbury
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Drizzle |
Fix Released
|
Critical
|
Joe Daly | ||
7.0 |
Fix Released
|
Critical
|
Joe Daly |
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:
Related branches
lp:~skinny.moey/drizzle/transaction_log_674588
- Drizzle Developers: Pending requested
-
Diff: 61 lines (+12/-4)3 files modifieddrizzled/statement/alter_table.cc (+2/-0)
drizzled/transaction_services.cc (+2/-1)
plugin/innobase/handler/ha_innodb.cc (+8/-3)
Changed in drizzle: | |
assignee: | nobody → Joe Daly (skinny.moey) |
importance: | Undecided → Critical |
To post a comment you must log in.
It should be noted that I haven't seen COUNT(transacti on_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: drizzle: host=localhost: port=9306: user=root: password= "":database= test conf/drizzle/ translog_ drizzle. zz conf/drizzle/ translog_ concurrent3. yy --queries=50 --threads=10 DrizzleConcurre ntTransactionLo g > /bugs.launchpad .net/bugs/ 674588 pl--dsn= dbi:drizzle: host=localhost: port=9306: user=root: password= "":database= test conf/drizzle/ translog_ drizzle. zz conf/drizzle/ translog_ concurrent3. yy --queries=50 --threads=10 DrizzleConcurre ntTransactionLo g >
>
> 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:
> --gendata=
> --grammar=
> --sqltrace --debug --Reporter=
> /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:/
> 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.
> --gendata=
> --grammar=
> --sqltrace --debug --Reporter=
> /tmp/randgen.out
>
>
>