activemq-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Anuj Khandelwal (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (AMQ-6671) ActiveMQ with PostgreSQL: Not deleting persistent messages sent to a topic
Date Thu, 11 May 2017 05:06:04 GMT

    [ https://issues.apache.org/jira/browse/AMQ-6671?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16005891#comment-16005891
] 

Anuj Khandelwal commented on AMQ-6671:
--------------------------------------

[~gtully] Thanks for sharing this info. Indeed , this was the reason. 

I didn't ran the broker for required time and keep stopping it in between, that's why those
messages were not getting cleared, I retested it and ran it for long time, it was automatically
cleaning up the data. 

Thanks again for your help Gary.

>  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)

Mime
View raw message