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

AMQ broker with jdbc persistence adds random number to the table name specified in <page-store-table-name>

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Explained
    • AMQ 7.7.0.GA
    • None
    • jdbc
    • None
    • Hide

      1.  Start a broker with oracle jdbc persistence.

      2. Make sure that the global size bytes is extremely low (to trigger instant paging) like 500 KB

      3. Send few messages to trigger paging.

      4. You'll notice that another page store table is created with a similar name with some numbers appended. (select * from all_tables where table_name like 'PAGE_STORE%' )

      This query will give multiple results after the paging starts.

      Show
      1.  Start a broker with oracle jdbc persistence. 2. Make sure that the global size bytes is extremely low (to trigger instant paging) like 500 KB 3. Send few messages to trigger paging. 4. You'll notice that another page store table is created with a similar name with some numbers appended. (select * from all_tables where table_name like 'PAGE_STORE%' ) This query will give multiple results after the paging starts.

    Description

      AMQ broker running on Openshift and using oracle database for persistence is showing strange behavior.  Suppose the page store table name is configured as follows:

      <page-store-table-name>PAGE_STORE</page-store-table-name>

      It is observed that often when the paging starts, the broker appends some numbers at the end of PAGE_STORE and creates a new table with that name:

      CREATE TABLE  PAGE_STORE4294967301 (ID NUMBER(19) GENERATED BY DEFAULT ON NULL AS IDENTITY, FILENAME VARCHAR(255), EXTENSION VARCHAR(10), DATA BLOB, PRIMARY KEY(ID))

      It seems  this is where the id is appended to the table:

      https://github.com/apache/activemq-artemis/blob/master/artemis-server/src/main/java/org/apache/activemq/artemis/core/paging/impl/PagingStoreFactoryDatabase.java#L279

      https://github.com/apache/activemq-artemis/blob/master/artemis-server/src/main/java/org/apache/activemq/artemis/core/paging/impl/PagingStoreFactoryDatabase.java#L173 

      Attachments

        Activity

          People

            rhn-support-jbertram Justin Bertram
            rhn-support-adongre Avinash Dongre
            Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: