activemq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dejan Bosanac (JIRA)" <j...@apache.org>
Subject [jira] Created: (AMQ-2551) Locking issue with MySQL InnoDB
Date Wed, 23 Dec 2009 15:33:40 GMT
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.


Mime
View raw message