Locking issue with MySQL InnoDB
-------------------------------
Key: AMQ-2551
URL: https://issues.apache.org/activemq/browse/AMQ-2551
Project: ActiveMQ
Issue Type: Bug
Affects Versions: 5.3.0
Reporter: Dejan Bosanac
Using jdbc with Mysql InnoDB, can lead to following errors
{code}Deadlock found when trying to get lock;try restarting transaction{code}
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
{code}<jdbcPersistenceAdapter dataSource="#mysql-ds" ...
cleanupPeriod="0"/>{code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
