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

Tom Jenkinson (JIRA) issues at jboss.org
Wed Nov 9 09:08:00 EST 2016

     [ https://issues.jboss.org/browse/JBTM-2786?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Tom Jenkinson updated JBTM-2786:
              Status: Pull Request Sent  (was: Open)
    Git Pull Request: https://github.com/jbosstm/narayana/pull/1087

> 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

More information about the jbossts-issues mailing list