Dead lock issue runing Wikipedia workload

[xunzhang]

When I run the Wikipedia workload with more than 1 terminals under MySQL, I got the dead lock error. Any suggestions? Thanks.

(WikipediaWorker.java:111) ERROR - 
Caught SQL Exception in WikipediaWorker for procedurecom.oltpbenchmark.benchmarks.wikipedia.procedures.GetPageAuthenticated:com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: 
Deadlock found when trying to get lock; try restarting transaction com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; 
try restarting transaction

[apavlo]

This is not bad thing. This is just how 2PL works. Are you always getting this error?

[xunzhang]

Yes, every time in my environment.

[apavlo]

What happens if you only run the benchmark with the GetPageAuthenticated txn?