[jira] [Created] (ARTEMIS-3830) Lots of large messages prevent startup when using JDBC backend

["Corona Borealis (Jira)" <ji...@apache.org>]

Corona Borealis created ARTEMIS-3830:
----------------------------------------

             Summary: Lots of large messages prevent startup when using JDBC backend
                 Key: ARTEMIS-3830
                 URL: https://issues.apache.org/jira/browse/ARTEMIS-3830
             Project: ActiveMQ Artemis
          Issue Type: Bug
          Components: Broker
    Affects Versions: 2.19.0
            Reporter: Corona Borealis


When using the JDBC backend and a lot of messages are stored in the table LARGE_MESSAGES (in my case > 1GB and > 1000 messages) and the broker is restarted, it is no longer able to complete the startup.

On startup, the broker tries to load all the messages one by one, but because there is no corresponding index on the table, this results in a timeout exception.

The query used is:

{{select-file-by-filename=SELECT ID, FILENAME, EXTENSION, DATA FROM %s WHERE fileName=?}}

but fileName does not have an index.



--
This message was sent by Atlassian Jira
(v8.20.7#820007)