ActiveMQ
  1. ActiveMQ
  2. AMQ-1958

JDBC master/slave deadlock when connection is lost

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Duplicate
    • Affects Version/s: 4.1.2, 5.0.0, 5.1.0, 5.2.0
    • Fix Version/s: 5.6.0
    • Component/s: Broker, Message Store
    • Labels:
      None
    • Environment:

      oracle 10, mysql 5

      Description

      In a pure JDBC failover scenario with one master and one slave: when the master loses its network connection to the database, the lock in the database will not be released. As such the slave will not know that the master isn't able to perform its work and it will continue to attempt to acquire a lock (which will never be released), when the master is restarted (after its connection is restored), it will become slave too, ending up with two slaves.

      This behavior was encountered on Oracle 10 and Mysql 5.

        Issue Links

          Activity

          Guy Veraghtert created issue -
          Rob Davies made changes -
          Field Original Value New Value
          Fix Version/s 5.4.0 [ 12110 ]
          Rob Davies made changes -
          Fix Version/s 5.4.0 [ 12110 ]
          Fix Version/s NEEDS_REVIEWED [ 12186 ]
          Jeff Turner made changes -
          Project Import Fri Nov 26 22:32:02 EST 2010 [ 1290828722158 ]
          Timothy Bish made changes -
          Link This issue relates to AMQ-3654 [ AMQ-3654 ]
          Hide
          Johno Crawford added a comment -

          A lot of talk over @ AMQ-3654 . Can we close this ticket as duplicate?

          Show
          Johno Crawford added a comment - A lot of talk over @ AMQ-3654 . Can we close this ticket as duplicate?
          Gary Tully made changes -
          Status Open [ 1 ] Closed [ 6 ]
          Fix Version/s 5.6.0 [ 12317974 ]
          Fix Version/s NEEDS_REVIEWED [ 12315630 ]
          Resolution Duplicate [ 3 ]
          Transition Time In Source Status Execution Times Last Executer Last Execution Date
          Open Open Closed Closed
          1296d 1h 45m 1 Gary Tully 17/Apr/12 16:56

            People

            • Assignee:
              Unassigned
              Reporter:
              Guy Veraghtert
            • Votes:
              3 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development