[jbossts-issues] [JBoss JIRA] (JBTM-2786) MySQL JDBCStore occasionally gets deadlock exception

MySQL JDBCStore occasionally gets deadlock exception ---------------------------------------------------- Key: JBTM-2786 URL: https://issues.jboss.org/browse/JBTM-2786 Project: JBoss Transaction Manager Issue Type: Enhancement Components: Transaction Core Reporter: Tom Jenkinson Assignee: Tom Jenkinson Fix For: 5.4.1.Final Occasionally in QA tests we see the MySQL CI job fail with messages about deadlocks. From what I can see from http://stackoverflow.com/questions/2332768/how-to-avoid-mysql-deadlock-fo... it can be because the where clauses are not ordered the same so a table lock can happen. Reordering the where clauses would hopefully fix this.