Comment 4 for bug 644760

Revision history for this message
Patrick Crews (patrick-crews) wrote : Re: Transaction log appears to lose data on implicit commit after a large number of queries have been executed.

I tried to cook up a test case based on my filtered randgen output, but for whatever reason, the bug didn't present itself.
I will try to make a test-suite .test file based on all of the executed queries, but in the mean time you can duplicate this via the randgen command line:
perl ./gentest.pl --dsn=dbi:drizzle:host=localhost:port=9306:user=root:password="":database=test --gendata=conf/drizzle/translog.zz --grammar=conf/drizzle/transaction_log_single_thread_drizzle.yy --queries=50 --threads=1 --debug --Validator=DrizzleTransactionLog

To use the Validator, you will need another drizzle server up and running. The Validator expects the server to be listening on port 9307, but you can edit randgen/lib/GenTest/Validator/DrizzleTransactionLog.pm and set the $validator_port variable to whatever you would like.

You can expect to see output like:
# 2010-09-22T17:42:34 Differences between the two servers were found after comparing dumpfiles
# 2010-09-22T17:42:34 diff command: diff --unified /tmp//translog_rpl_dump_9484_9306.sql /tmp//translog_rpl_dump_9484_9307.sql
# 2010-09-22T17:42:34 Master dumpfile: /tmp//translog_rpl_dump_9484_9306.sql
# 2010-09-22T17:42:34 Slave dumpfile: /tmp//translog_rpl_dump_9484_9307.sql
# 2010-09-22T17:42:35 Killing periodic reporting process with pid 9483...
# 2010-09-22T17:42:35 Kill GenTest::ErrorFilter(9482)
# 2010-09-22T17:42:35 Test completed with failure status STATUS_REPLICATION_FAILURE (103)