[AMQ-2551] Locking issue with MySQL InnoDB

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 5.3.0
• Fix Version/s: 5.4.2
• Assignee: Gary Tully
• Reporter: Dejan Bosanac
• Created: 23/Dec/09 15:31
• Updated: 20/Jul/16 21:15
• Resolved: 04/Nov/10 13:21

Description

Using jdbc with Mysql InnoDB, can lead to following errors

Deadlock found when trying to get lock;try restarting transaction

and messages stuck in database.

The problem is described here http://dev.mysql.com/doc/refman/5.0/en/innodb-lock-modes.html and is caused by unsynced cleanup task.

Current workaround is to turn off cleanup task like this

<jdbcPersistenceAdapter dataSource="#mysql-ds"  ... cleanupPeriod="0"/>

Issue Links

• breaks: AMQ-6370 JDBC message store - jdbc connection pool - potential deadlock with cleanup task when pool exhausted