[
https://issues.apache.org/jira/browse/AMQ-5581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14323140#comment-14323140
]
Brandon Davis commented on AMQ-5581:
------------------------------------
We are having the same problem. The database that we were using for persistence
failed over, but out message queues remained unavailable until we restarted the
ActiveMQ service.
> Failover with jdbcPersistenceAdapter/PGPoolingDataSource doesn't fail over
> properly when DB server changes IP
> -------------------------------------------------------------------------------------------------------------
>
> Key: AMQ-5581
> URL: https://issues.apache.org/jira/browse/AMQ-5581
> Project: ActiveMQ
> Issue Type: Bug
> Affects Versions: 5.10.0
> Environment: Linux, 1 master, 2 slaves, PostgreSQL persistence layer
> Reporter: Brian Jackson
>
> We had a cloud instance reboot over the weekend. When it came back up it had
> a different IP address. The master seems like it had given up trying to
> reconnect and the slaves were stuck repeating "failed to acquire lease.
> Sleeping for 10000 milli(s) before trying again...".
> At the very least if the master is going to stop retrying it seems like at
> some point the slaves should try a full reconnect instead of just repeating
> the same message for days on end.
> Let me know what other info you need?
> Config snippets below.
> {code:xml}
> <persistenceAdapter>
> <jdbcPersistenceAdapter dataSource="#postgres-ds"
> lockKeepAlivePeriod="5000">
> <locker>
> <lease-database-locker lockAcquireSleepInterval="10000"/>
> </locker>
> </jdbcPersistenceAdapter>
> </persistenceAdapter>
> <bean id="postgres-ds" class="org.postgresql.ds.PGPoolingDataSource">
> <property name="serverName" value="{{ salt['mine.get']('G@tags:mqdb
> and G@tags:primary', 'network.get_hostname', 'compound')|first }}" />
> <property name="databaseName" value="mqdb" />
> <property name="portNumber" value="5432" />
> <property name="user" value="mqdb" />
> <property name="password" value="{{
> salt['pillar.get']('postgres:users:mqdb:password', 'password') }}" />
> <property name="dataSourceName" value="postgres" />
> <property name="initialConnections" value="1" />
> <property name="maxConnections" value="30" />
> </bean>
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
