[AMQ-6671] ActiveMQ with PostgreSQL: Not deleting persistent messages sent to a topic

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Not A Bug
• Affects Version/s: 5.11.1
• Component/s: Broker, JDBC
• Assignee: Unassigned
• Reporter: Anuj Khandelwal
• Created: 08/May/17 07:26
• Updated: 11/May/17 05:06
• Resolved: 11/May/17 05:06

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