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

[Tom Jenkinson (JIRA)]

Tom Jenkinson created JBTM-2786:
-----------------------------------

             Summary: MySQL JDBCStore occasionally gets deadlock exception
                 Key: JBTM-2786
                 URL: https://issues.jboss.org/browse/JBTM-2786
             Project: JBoss Transaction Manager
          Issue Type: Task
          Components: Transaction Core
            Reporter: Tom Jenkinson
            Assignee: Tom Jenkinson
             Fix For: 5.next


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-found-when-trying-to-get-lock-try-restarting-trans 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.



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)