activemq-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Benjamin Graf (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (ARTEMIS-975) Reading messages from page causes lost entries in db backend
Date Sat, 18 Feb 2017 19:12:44 GMT

     [ 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):
{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}

  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.

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)


> 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):
> {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
(v6.3.15#6346)

Mime
View raw message