Wikipedia workload: GetPageAnonymous transaction

[arunmarathe]

This refers to Wikipedia benchmark's code in the file src/com/oltpbenchmark/wikipedia/procedures/GetPageAnonymous.java

The purpose of that transaction seems to issue a sequence of five SELECT statements. The behavior I am observing is that after the first SELECT (called selectPage in code), the transaction rolls back. The backend is MySQL.

Reading the code, I didn't get the impression that rollback was an intended effect, but if it was, then this is no longer a bug report; it's intended behavior. Otherwise, why does this transaction always (or at least very frequently) rolls back? I understand why a transaction that rolls back is a good addition to a toolkit such as OLTPBench, but the OLTPBench paper didn't mention that that was the case either.

The wikipedia database is a freshly created one.

[apavlo]

Can you provide more information? How many terminals? What is the MySQL abort message?