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

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

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Not A Bug
    • Affects Version/s: 5.11.1
    • Fix Version/s: None
    • Component/s: Broker, JDBC
    • Labels:
      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

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

              Dates

              • Created:
                Updated:
                Resolved: