Uploaded image for project: 'AMQ Broker'
  1. AMQ Broker
  2. ENTMQBR-7988

Paging doesn't work with JDBC persistence

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • None
    • AMQ 7.11.0.GA
    • jdbc
    • False
    • None
    • False
    • Hide
      The performance on paging in JDBC is improved by a signifant factor in this release

      We now batch writes in JDBC for paging allowing faster performance.
      Also, there was introduced a new option <jdbc-max-page-size-bytes>. under <database-configuration> to max out the page sizes, defaulted at 100K bytes.
      Show
      The performance on paging in JDBC is improved by a signifant factor in this release We now batch writes in JDBC for paging allowing faster performance. Also, there was introduced a new option <jdbc-max-page-size-bytes>. under <database-configuration> to max out the page sizes, defaulted at 100K bytes.
    • Critical

      When using JDBC persistence, paging seems to be ineffective. If an amount of data greater than `global-max-size` is stored to a queue, a message is shown in the log showing that paging has started. However, regardless how much data is stored, no files are written to the paging directory (which may not even be configured), nor is any additional data stored in the database.

      The JDBC database schema includes a table which seems to be related to paging. The schema is as follows:

      QL> desc mp;
       Name                       Null?    Type
       ----------------------------------------- -------- ----------------------------
       ID                       NOT NULL NUMBER(19)
       FILENAME                        VARCHAR2(255)
       EXTENSION                        VARCHAR2(10)
       DATA                            BLOB
       

      It is not clear whether the table should store the actual paging data, or just references to files on disk. However, the number of records in this table do not increase, however much data is stored.

      The consequence is that broker fails to start, if there is too much data in the message store to load into the heap at start-up.

       

       

              csuconic@redhat.com Clebert Suconic
              rhn-support-kboone Kevin Boone
              Roman Vais Roman Vais (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Created:
                Updated:
                Resolved: