[jbossts-issues] [JBoss JIRA] (JBTM-2786) MySQL JDBCStore occasionally gets deadlock exception
Tom Jenkinson (JIRA)
issues at jboss.org
Tue Nov 8 08:51:00 EST 2016
Tom Jenkinson created JBTM-2786:
Summary: MySQL JDBCStore occasionally gets deadlock exception
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