Uploaded image for project: 'ActiveMQ Classic'
  1. ActiveMQ Classic
  2. AMQ-8542

ACTIVEMQ_MSGS Table fills up but all messages are processed

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 5.16.1
    • None
    • Broker, JDBC, JMS client
    • None

    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?

      Attachments

        Activity

          People

            Unassigned Unassigned
            sventurowski Sven Turowski
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: