[
https://issues.apache.org/jira/browse/ARTEMIS-975?focusedWorklogId=407871&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-407871
]
ASF GitHub Bot logged work on ARTEMIS-975:
------------------------------------------
Author: ASF GitHub Bot
Created on: 23/Mar/20 12:12
Start Date: 23/Mar/20 12:12
Worklog Time Spent: 10m
Work Description: graben commented on pull request #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
Especially needed for paging/depaging records that are hold in several
transactions not getting cleaned up completely.
----------------------------------------------------------------
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: 407871)
Remaining Estimate: 0h
Time Spent: 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: 10m
> 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)
