Dead lock issue runing Wikipedia workload

Open xunzhang opened this issue 5 years ago • 3 comments

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

Feb 26 '20 05:02 xunzhang

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

Mar 12 '20 18:03 apavlo

Yes, every time in my environment.

Mar 12 '20 18:03 xunzhang

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

Mar 19 '20 01:03 apavlo