[
https://issues.apache.org/jira/browse/AMQ-6671?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16002721#comment-16002721
]
Timothy Bish commented on AMQ-6671:
-----------------------------------
The best way (and probably fastest) to get it fixed is to do it yourself. The
code is open and you can dive in with a debugger and see what's going on for
your case. Most folks don't have access to a running PostgreSQL instance and
aren't going to be able to investigate where you can, so dive in.
> 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)
