ActiveMQ
  1. ActiveMQ
  2. AMQ-1780

ActiveMQ broker does not automatically reconnect if the connection to the database is lost

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 5.0.0
    • Fix Version/s: 5.5.0
    • Component/s: Broker
    • Labels:
      None
    • Environment:

      Windows 2003 Server

      Description

      hi

      We are noticing that after any SQL Server restart or network blip between ActiveMQ and the database, after the connection or the database comes back online activeMQ broker needs to be restarted as well i.e it doesn't automatically re-establish connection to the database as result any message send fails because the broker is still using the stale connection to the database.

      Is this designed behaviour or a bug? we are using ActiveMQ 5.0.0 and the latest version of the JSQLConnect database driver: version 5.7. The database we are using is MS SQL Server 2005

      Right now, in our production environment any time we have network maintenance or database restart we also have to restart the ActiveMQ broker which is not a good option for us.

      Also, We are using a single ActiveMQ broker and not the JDBC(Master/Slave) set up.

      Issue details in

      http://www.nabble.com/Database-connection-between-ActiveMQ-and-broker-td17321330s2354.html

      Please let me know if I need to give more information

      thanks
      jaya

        Issue Links

          Activity

          Timothy Bish made changes -
          Link This issue is duplicated by AMQ-2497 [ AMQ-2497 ]
          Gary Tully made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Assignee Gary Tully [ gtully ]
          Fix Version/s 5.5.0 [ 12315626 ]
          Fix Version/s NEEDS_REVIEWED [ 12315630 ]
          Resolution Fixed [ 1 ]
          Jeff Turner made changes -
          Project Import Fri Nov 26 22:32:02 EST 2010 [ 1290828722158 ]
          Rob Davies made changes -
          Fix Version/s 5.4.0 [ 12110 ]
          Fix Version/s NEEDS_REVIEWED [ 12186 ]
          Gary Tully made changes -
          Fix Version/s 5.3.0 [ 11914 ]
          Fix Version/s 5.4.0 [ 12110 ]
          Rob Davies made changes -
          Field Original Value New Value
          Fix Version/s 5.3.0 [ 11914 ]
          Jaya Srinivasan created issue -

            People

            • Assignee:
              Gary Tully
              Reporter:
              Jaya Srinivasan
            • Votes:
              3 Vote for this issue
              Watchers:
              11 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development