Anuj Khandelwal created AMQ-6671:
------------------------------------
Summary: ActiveMQ with PostgreSQL: Not deleting persistent
messages sent to a topic
Key: AMQ-6671
URL: https://issues.apache.org/jira/browse/AMQ-6671
Project: ActiveMQ
Issue Type: Bug
Components: Broker, JDBC
Affects Versions: 5.11.1
Reporter: Anuj Khandelwal
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
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
