Uploaded image for project: 'ActiveMQ Artemis'
  1. ActiveMQ Artemis
  2. ARTEMIS-3830

Lots of large messages prevent startup when using JDBC backend

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 2.19.0
    • 2.23.0
    • Broker
    • None

    Description

      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.

      Attachments

        Activity

          People

            Unassigned Unassigned
            cborealis Corona Borealis
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 10m
                10m