[AMQ-8542] ACTIVEMQ_MSGS Table fills up but all messages are processed

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 5.16.1
• Component/s: Broker, JDBC, JMS client
• Assignee: Unassigned
• Reporter: Sven Turowski
• Created: 11/Mar/22 12:07
• Updated: 11/Mar/22 12:07

Description

We are using ActiveMQ with persistence in an oracle DB. 

Our producer and consumer are some java processes. If we are looking on the ActiveMQ Website we can see that the number of enqueued and dequeued message is equal and there are no pending messages.

The problem is, that the ACTIVEMQ_MSGS table in our DB is not getting empty. It still fills up, slowly but constant. The number of messages in the table is less then the number of enqueued messages. Last night the number of entries in the table was 16k and we truncated the table.

This is our bean configuration for the listener:

 <bean id="listenerContainer" class="org.springframework.jms.listener.DefaultMessageListenerContainer" destroy-method="shutdown">
  <property name="concurrentConsumers" ref="concconsumer"/>
  <property name="connectionFactory" ref="jmsFactory" />
  <property name="destination">
      <bean class="some.path.queue.QueueBuilder">
                <constructor-arg value="queuename"></constructor-arg>
      </bean>
  </property>     
  <property name="messageListener" ref="messageListener" />
  <property name="sessionTransacted" value="true" />
  <!--<property name="messageSelector" value="true" />-->     
</bean>    
    
<bean id="messageListener" class="some.path.queue.OurListener">
    <property name="propholder" ref="propholder" />
</bean> 

We know that all messages we put in the queue are dequeued and processed, but we don't know why there are table entries.

Can you help?