[
https://issues.apache.org/jira/browse/ARTEMIS-975?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Benjamin Graf updated ARTEMIS-975:
----------------------------------
Description:
Consuming messages from pages with a db as persistence backend leaves commit
records in message_table which doesn't get cleaned up. Seems that depaging does
not add txids to internal map.
SQL script for cleanup (no known side effect):
DELETE
FROM MESSAGE_TABLE
WHERE txid IN
(SELECT txid
FROM
(SELECT count(*) AS cnt,
txid
FROM MESSAGE_TABLE
WHERE txid IN
(SELECT txid
FROM MESSAGE_TABLE
WHERE recordtype = 18)
GROUP BY txid)AS m
WHERE m.cnt=1)
was:Consuming messages from pages with a db as persistence backend leaves
commit records in message_table which doesn't get cleaned up. Seems that
depaging does not add txids to internal map.
> Reading messages from page causes lost entries in db backend
> ------------------------------------------------------------
>
> Key: ARTEMIS-975
> URL: https://issues.apache.org/jira/browse/ARTEMIS-975
> Project: ActiveMQ Artemis
> Issue Type: Bug
> Components: Broker
> Affects Versions: 2.0.0
> Reporter: Benjamin Graf
> Attachments: screenshot-1.png
>
>
> Consuming messages from pages with a db as persistence backend leaves commit
> records in message_table which doesn't get cleaned up. Seems that depaging
> does not add txids to internal map.
> SQL script for cleanup (no known side effect):
> DELETE
> FROM MESSAGE_TABLE
> WHERE txid IN
> (SELECT txid
> FROM
> (SELECT count(*) AS cnt,
> txid
> FROM MESSAGE_TABLE
> WHERE txid IN
> (SELECT txid
> FROM MESSAGE_TABLE
> WHERE recordtype = 18)
> GROUP BY txid)AS m
> WHERE m.cnt=1)
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
