[AMQ-1780] ActiveMQ broker does not automatically reconnect if the connection to the database is lost

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

Environment

Windows 2003 Server

• Assignee: Gary Tully
• Reporter: Jaya Srinivasan
• Created: 06/Jun/08 20:44
• Updated: 19/Jun/15 17:01
• Resolved: 28/Mar/11 11:08

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

• is duplicated by: AMQ-2497 Message broker won't come back when the databse goes offline and comes back online