Broker goes down when database is restarted or goes down
--------------------------------------------------------
Key: AMQ-2498
URL: https://issues.apache.org/activemq/browse/AMQ-2498
Project: ActiveMQ
Issue Type: Bug
Components: Broker
Affects Versions: 5.3.0
Reporter: Partha
Priority: Critical
When I database is idle for too long or I manually restart database, broker is
shutting down. Does it not automatically try to reconnect? Am I missing
anything?
I am setting validationQuery and testOnBorrow to true in broker-config.xml
datasource bean.
Do I need to do anything else to tell broker for keep trying for database
connection?
error
=========================
Failed to checkpoint a message store: java.util.concurrent.ExecutionException:
java.io.IOException: The TCP/IP connection to the host has failed.
java.net.ConnectException: Connection refused: connect
java.util.concurrent.ExecutionException: java.io.IOException: The TCP/IP
connection to the host has failed. java.net.ConnectException: Connection
refused: connect
at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:222)
at java.util.concurrent.FutureTask.get(FutureTask.java:83)
at
org.apache.activemq.store.journal.JournalPersistenceAdapter.doCheckpoint(JournalPersistenceAdapter.java:421)
at
org.apache.activemq.store.journal.JournalPersistenceAdapter$1.iterate(JournalPersistenceAdapter.java:124)
at
org.apache.activemq.thread.PooledTaskRunner.runTask(PooledTaskRunner.java:122)
at org.apache.activemq.thread.PooledTaskRunner$1.run(PooledTaskRunner.java:43)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.io.IOException: The TCP/IP connection to the host has failed.
java.net.ConnectException: Connection refused: connect
at
org.apache.activemq.util.IOExceptionSupport.create(IOExceptionSupport.java:45)
at
org.apache.activemq.store.jdbc.TransactionContext.getConnection(TransactionContext.java:61)
at
org.apache.activemq.store.jdbc.TransactionContext.begin(TransactionContext.java:151)
at
org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.beginTransaction(JDBCPersistenceAdapter.java:406)
at
org.apache.activemq.store.journal.JournalPersistenceAdapter.beginTransaction(JournalPersistenceAdapter.java:216)
at
org.apache.activemq.util.TransactionTemplate.run(TransactionTemplate.java:41)
at
org.apache.activemq.store.journal.JournalMessageStore.checkpoint(JournalMessageStore.java:258)
at
org.apache.activemq.store.journal.JournalTopicMessageStore.checkpoint(JournalTopicMessageStore.java:171)
at
org.apache.activemq.store.journal.JournalPersistenceAdapter$5.call(JournalPersistenceAdapter.java:408)
at
org.apache.activemq.store.journal.JournalPersistenceAdapter$5.call(JournalPersistenceAdapter.java:407)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
... 3 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP
connection to the host has failed. java.net.ConnectException: Connection
refused: connect
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown
Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at
org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:974)
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at
org.apache.activemq.store.jdbc.TransactionContext.getConnection(TransactionContext.java:54)
... 13 more
2009-11-12 14:30:12,705 INFO [STDOUT] 2009-11-12 14:30:12,705 [Q Cleanup
Timer] INFO BrokerService - ActiveMQ JMS Message Broker
(ess.broker1, ID:VR1Server-8183-1258064801205-0:0) stopped
============
Thanks,
PG
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.