[jbossts-issues] [JBoss JIRA] (JBTM-2786) MySQL JDBCStore occasionally gets deadlock exception
Tom Jenkinson (JIRA)
issues at jboss.org
Wed Nov 30 09:08:24 EST 2016
[ https://issues.jboss.org/browse/JBTM-2786?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tom Jenkinson updated JBTM-2786:
--------------------------------
Fix Version/s: 5.next
> 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)
More information about the jbossts-issues
mailing list