[
https://issues.apache.org/jira/browse/ARTEMIS-975?focusedWorklogId=408247&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-408247
]
ASF GitHub Bot logged work on ARTEMIS-975:
------------------------------------------
Author: ASF GitHub Bot
Created on: 23/Mar/20 20:19
Start Date: 23/Mar/20 20:19
Worklog Time Spent: 10m
Work Description: jbertram commented on issue #3042: ARTEMIS-975: Add
transactional records to deletedRecords to check for committed transactions
that also hold references to
URL: https://github.com/apache/activemq-artemis/pull/3042#issuecomment-602832587
This really needs a test in order to validate the fix and also to mitigate
against regressions in the future.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
Issue Time Tracking
-------------------
Worklog Id: (was: 408247)
Time Spent: 20m (was: 10m)
> 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
> Priority: Major
> Attachments: screenshot-1.png
>
> Time Spent: 20m
> Remaining Estimate: 0h
>
> 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):
> {code}
> 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)
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
