AQ Based ESB_CONTROL Topic Queue Tables Grow (Doc ID 784898.1)

Last updated on SEPTEMBER 01, 2016

Applies to:

Oracle ESB - Version 10.1.3.4 and later
Information in this document applies to any platform.

Symptoms

Having set up the AQ based persistence for JMS queues for ESB (as described in the Enterprise Deployment Guide), when the SOA services are shut down and do not stop gracefully, the AQ subscribers are not removed and new subscribers are registered when the system is restarted.

To reproduce/verify the issue:

  1. Setup AQ based persistence for JMS queues following the sections 3.23, 3.24, and 3.25 from the Oracle Application Server Enterprise Deployment Guide 10g Release 3 (10.1.3.3.0) using SOA Suite 10.1.3.4 with MLR#1 to MLR#4.
  2. Deploy any ESB Project.
  3. Connect to sqlplus as the oraesb user.
  4. In another terminal window, shutdown the services using: 
    $ORACLE_HOME/opmn/bin/opmnctl shutdown
  5. Do a count on the table aq$esb_control_s in the sqlplus session while starting and stopping the server in another terminal window (see steps below):
    (Numbers of subscribers will vary, for this example assume 12 to start)
    1. Perform the initial count when the SOA Services are down.
      select count(*) of table aq$esb_control_s;
      result = 12
    2. Start the SOA Services using
      $ORACLE_HOME/opmn/bin/opmnctl startall
    3. Perform another count:
      select count(*) of table aq$esb_control_s;
      result = 14;
    4. Shutdown the SOA Services again and perform another count:
      result = 13;
    5. Start the SOA Services agaun and perform the last count to verify:
      select count(*) of table aq$esb_control_s;
      result=15;

Instead of shutting down you also can shut down only the JVM, this can be done doing a kill -9 of all the java processes, the instances will restart automatically and the number of subscribers will be increased every time it is restarted.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms