Drizzle

Bug #644760
Comment #1

Comment 1 for bug 644760

Revision history for this message

Patrick Crews (patrick-crews) wrote on 2010-09-21: Re: Transaction log appears to lose data on implicit commit after a large number of queries have been executed.

annotated randgen output of valid queries, listing what is in the transaction log and what is not Edit (27.7 KiB, text/plain)

Attached is trimmed randgen output. For clarity, I have removed all bad queries (impossible WHERE's, etc) and SELECT's (I doubt they contributed to this).

What I have tried to do is compare randgen queries to the SQL generated by transaction_reader when called against the server's transaction log.

From my analysis, it appears that a block of queries was somehow missed / ignored by the log as queries that came before and after this block are visible in the transaction_reader output.

I can provide assistance with running the randgen test if you are interested in duplicating things yourself that way. Otherwise, we can work on trying to produce a test-run'able test case.