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

ActiveMQ with PostgreSQL: Not deleting persistent messages sent to a topic

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Not A Bug
    • 5.11.1
    • None
    • Broker, JDBC
    • None

    Description

      Using ActiveMQv5.11.1

      I ran a test case where a durable subscriber was listening from a topic and a publisher is publishing persistent messages. I observed that the messages were stored in the DB (ACTIVEMQ_MSGS table) but even after successful consumption by the consumer, these messages were not deleted from the backend DB. However I have seen that this doesn't happen in case of queue. Persistent messages sent to a queue are automatically deleted from the DB once successfully consumed by the consumer.

      More details:

      1. 1 producer 1 durable subscriber. Subscriber is in auto_ack mode.
      2. Producer sent 100 persistent messages to consumer
      3. Consumer successfully consumed them.
      4. DB still has those messages.
      5. Stop producer and consumer both, but messages are still there.
      6. Even after restarting broker, message does not get deleted.

      This is a very generic use case which should never happen. It is also reproducible.

      Thanks,
      Anuj

      Attachments

        Activity

          People

            Unassigned Unassigned
            anujkhandelwal90 Anuj Khandelwal
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: