[ https://issues.apache.org/jira/browse/AMQ-6986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17074808#comment-17074808 ]
Ryan commented on AMQ-6986: --------------------------- Blocking our ability to implement HA with SQL Server > Queues/Topics with no pending messages are lost when using > JDBCPersistenceAdapter > --------------------------------------------------------------------------------- > > Key: AMQ-6986 > URL: https://issues.apache.org/jira/browse/AMQ-6986 > Project: ActiveMQ > Issue Type: Bug > Components: JDBC > Affects Versions: 5.15.3 > Reporter: Davide Del Grande > Priority: Major > > With KahaDB, empty queues (0 pending messages) "survive" broker restarts. > Instead when using JDBC persistence, they just disappear (while queues with > pending messages work just fine). > It also seems that Topics are deleted (not sure about this). > My cfg is: > {{<persistenceAdapter>}} > {{ <jdbcPersistenceAdapter dataDirectory="activemq-data" > dataSource="#postgres-ds" lockKeepAlivePeriod="5000">}} > {{ <locker>}} > {{ <lease-database-locker leaseHolderId="i-03f2b8bfc2ff67a6d" > lockAcquireSleepInterval="10000"/>}} > {{ </locker>}} > {{ </jdbcPersistenceAdapter>}} > {{</persistenceAdapter>}} > {{<bean id="postgres-ds" class="org.postgresql.ds.PGPoolingDataSource">}} > {{ <property name="serverName" value="localhost"/>}} > {{ <property name="databaseName" value="activemq"/>}} > {{ <property name="portNumber" value="0"/>}} > {{ <property name="user" value="activemq"/>}} > {{ <property name="password" value="activemq"/>}} > {{ <property name="dataSourceName" value="postgres"/>}} > {{ <property name="initialConnections" value="1"/>}} > {{<property name="maxConnections" value="10"/>}} > {{</bean>}} > > This is pretty annoying because, at least in my use-case, a monitoring system > periodically polls queues to see if they are empty or not - and it fails if > it cannot find the queues that it was polling before broker restart. > And for topics, this can break the application, too. > > I can't understand if this is per-design (is it documented?) or I'm facing > some bugs. > > -- This message was sent by Atlassian Jira (v8.3.4#803005)