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

    • Icon: Bug Bug
    • Resolution: Not a Bug
    • Icon: Major Major
    • None
    • AMQ 7.7.0.GA
    • jdbc
    • None
    • False
    • False
    • Undefined
    • 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.

      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 

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

                Created:
                Updated:
                Resolved: