Description of problem:
The JBoss ON server will accumulate 1000s of rows in RHQ_CONFIG and RHQ_CONFIG_PROPERTIES which do not seem to be referenced by a resource or other dependent object. This results in poor database performance and system degradation over time.

Version-Release number of selected component (if applicable):
3.1, 3.2, 3.3

How reproducible:
Always, over time.

Steps to Reproduce:
1. Install, configuration, and start a JBoss ON system.
2. Allow the system to run for a few hours/days/weeks/months

Actual results:
Over time, the RHQ_CONFIG table grows in size and the ID column of some of the rows are no longer referenced.

Some of these RHQ_CONFIG entries do not have corresponding RHQ_CONFIG_PROPERTY entries.

Expected results:
All RHQ_CONFIG rows should be referenced by one or more resources, operations, or other JBoss ON components/subsystems.

Additional info:
The following SQL query can be used to determine that the RHQ_CONFIG row is not referenced:

    SELECT RHQ_CONFIG.ID FROM RHQ_CONFIG
    LEFT JOIN RHQ_CONFIG_PROPERTY ON RHQ_CONFIG.ID = RHQ_CONFIG_PROPERTY.CONFIGURATION_ID
    WHERE NOT EXISTS (
        SELECT RHQ_ALERT_NOTIFICATION.SENDER_CONFIG_ID FROM RHQ_ALERT_NOTIFICATION
        WHERE RHQ_ALERT_NOTIFICATION.SENDER_CONFIG_ID = RHQ_CONFIG.ID
    ) AND NOT EXISTS (
        SELECT RHQ_ALERT_NOTIFICATION.EXTRA_CONFIG_ID FROM RHQ_ALERT_NOTIFICATION
        WHERE RHQ_ALERT_NOTIFICATION.EXTRA_CONFIG_ID = RHQ_CONFIG.ID
    ) AND NOT EXISTS (
        SELECT RHQ_BUNDLE_DEPLOYMENT.CONFIG_ID FROM RHQ_BUNDLE_DEPLOYMENT
        WHERE RHQ_BUNDLE_DEPLOYMENT.CONFIG_ID = RHQ_CONFIG.ID
    ) AND NOT EXISTS (
        SELECT RHQ_CONFIG_GROUP_UPDATE.CONFIGURATION_ID FROM RHQ_CONFIG_GROUP_UPDATE
        WHERE RHQ_CONFIG_GROUP_UPDATE.CONFIGURATION_ID = RHQ_CONFIG.ID
    ) AND NOT EXISTS (
        SELECT RHQ_CONFIG_TEMPLATE.CONFIG_ID FROM RHQ_CONFIG_TEMPLATE
        WHERE RHQ_CONFIG_TEMPLATE.CONFIG_ID = RHQ_CONFIG.ID
    ) AND NOT EXISTS (
        SELECT RHQ_CONFIG_UPDATE.CONFIGURATION_ID FROM RHQ_CONFIG_UPDATE
        WHERE RHQ_CONFIG_UPDATE.CONFIGURATION_ID = RHQ_CONFIG.ID
    ) AND NOT EXISTS (
        SELECT RHQ_CONTENT_SOURCE.CONFIGURATION_ID FROM RHQ_CONTENT_SOURCE
        WHERE RHQ_CONTENT_SOURCE.CONFIGURATION_ID = RHQ_CONFIG.ID
    ) AND NOT EXISTS (
        SELECT RHQ_CREATE_RES_HIST.CONFIGURATION_ID FROM RHQ_CREATE_RES_HIST
        WHERE RHQ_CREATE_RES_HIST.CONFIGURATION_ID = RHQ_CONFIG.ID
    ) AND NOT EXISTS (
        SELECT RHQ_DASHBOARD.CONFIGURATION_ID FROM RHQ_DASHBOARD
        WHERE RHQ_DASHBOARD.CONFIGURATION_ID = RHQ_CONFIG.ID
    ) AND NOT EXISTS (
        SELECT RHQ_DASHBOARD_PORTLET.CONFIGURATION_ID FROM RHQ_DASHBOARD_PORTLET
        WHERE RHQ_DASHBOARD_PORTLET.CONFIGURATION_ID = RHQ_CONFIG.ID
    ) AND NOT EXISTS (
        SELECT RHQ_DRIFT_DEFINITION.CONFIG_ID FROM RHQ_DRIFT_DEFINITION
        WHERE RHQ_DRIFT_DEFINITION.CONFIG_ID = RHQ_CONFIG.ID
    ) AND NOT EXISTS (
        SELECT RHQ_DRIFT_DEF_TEMPLATE.CONFIG_ID FROM RHQ_DRIFT_DEF_TEMPLATE
        WHERE RHQ_DRIFT_DEF_TEMPLATE.CONFIG_ID = RHQ_CONFIG.ID
    ) AND NOT EXISTS (
        SELECT RHQ_INSTALLED_PKG_HIST.DEPLOYMENT_CONFIG_ID FROM RHQ_INSTALLED_PKG_HIST
        WHERE RHQ_INSTALLED_PKG_HIST.DEPLOYMENT_CONFIG_ID = RHQ_CONFIG.ID
    ) AND NOT EXISTS (
        SELECT RHQ_OPERATION_HISTORY.PARAMETERS_CONFIG_ID FROM RHQ_OPERATION_HISTORY
        WHERE RHQ_OPERATION_HISTORY.PARAMETERS_CONFIG_ID = RHQ_CONFIG.ID
    ) AND NOT EXISTS (
        SELECT RHQ_OPERATION_HISTORY.RESULTS_CONFIG_ID FROM RHQ_OPERATION_HISTORY
        WHERE RHQ_OPERATION_HISTORY.RESULTS_CONFIG_ID = RHQ_CONFIG.ID
    ) AND NOT EXISTS (
        SELECT RHQ_PACKAGE_VERSION.CONFIG_ID FROM RHQ_PACKAGE_VERSION
        WHERE RHQ_PACKAGE_VERSION.CONFIG_ID = RHQ_CONFIG.ID
    ) AND NOT EXISTS (
        SELECT RHQ_PLUGIN.PLUGIN_CONFIG_ID FROM RHQ_PLUGIN
        WHERE RHQ_PLUGIN.PLUGIN_CONFIG_ID = RHQ_CONFIG.ID
    ) AND NOT EXISTS (
        SELECT RHQ_PLUGIN.JOBS_CONFIG_ID FROM RHQ_PLUGIN
        WHERE RHQ_PLUGIN.JOBS_CONFIG_ID = RHQ_CONFIG.ID
    ) AND NOT EXISTS (
        SELECT RHQ_RAW_CONFIG.CONFIG_ID FROM RHQ_RAW_CONFIG
        WHERE RHQ_RAW_CONFIG.CONFIG_ID = RHQ_CONFIG.ID
    ) AND NOT EXISTS (
        SELECT RHQ_RESOURCE_TYPE.BUNDLE_CONFIG_ID FROM RHQ_RESOURCE_TYPE
        WHERE RHQ_RESOURCE_TYPE.BUNDLE_CONFIG_ID = RHQ_CONFIG.ID
    ) AND NOT EXISTS (
        SELECT RHQ_RESOURCE.RES_CONFIGURATION_ID FROM RHQ_RESOURCE
        WHERE RHQ_RESOURCE.RES_CONFIGURATION_ID = RHQ_CONFIG.ID
    ) AND NOT EXISTS (
        SELECT RHQ_RESOURCE.PLUGIN_CONFIGURATION_ID FROM RHQ_RESOURCE
        WHERE RHQ_RESOURCE.PLUGIN_CONFIGURATION_ID = RHQ_CONFIG.ID
    ) AND NOT EXISTS (
        SELECT RHQ_SUBJECT.CONFIGURATION_ID FROM RHQ_SUBJECT
        WHERE RHQ_SUBJECT.CONFIGURATION_ID = RHQ_CONFIG.ID
    );

The rows which include a NULL RHQ_CONFIG_PROPERTY.ID value have no configuration properties.

The ones that doe have configuration properties seem to be drift related. Perhaps drift or resource importing is creating these unused configurations and properties?

In testing the counts are in the 10s or 100s of rows. But in production these counts are in the millions or hundreds of millions of rows.