Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.3.0
    • Fix Version/s: 5.4.2
    • Component/s: None
    • Labels:
      None

      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"/>

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                gtully Gary Tully
                Reporter:
                dejanb Dejan Bosanac
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: