[ARTEMIS-975] Reading messages from page causes lost entries in db backend

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0.0
• Fix Version/s: 2.12.0
• Component/s: Broker
• Assignee: Unassigned
• Reporter: Benjamin Graf
• Created: 16/Feb/17 18:14
• Updated: 16/Apr/20 22:52
• Resolved: 24/Mar/20 14:42

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)

Issue Links

• is a parent of: ARTEMIS-2647 JDBC store query append-to-file not correct for mysql
• is a parent of: ARTEMIS-2668 Wrong formatting Strings in class LoggingResultSet
• links to: GitHub Pull Request #3042