Previous versions of EAP 6 or EAP 7 Deployment or Domain Deployment resource content continues to use space in JBoss ON back-end database

Environment

• Red Hat JBoss Operations Network (ON) 3.3
• Red Hat JBoss Enterprise Application Platform (EAP) 6, 7 management plug-in for JBoss ON
• JBoss EAP Deployment or Domain Deployment resource was uploaded using Create Child workflow
• New version of Deployment or Domain Deployment resource content was uploaded using Upload New Package or deployed from subscribed Content Repository

Issue

• File system /var/lib/pgsql/data reached 100% utilization
• Keep having to extend table or database space
• Clean older or no longer used content from back-end database
• Previous versions of content that are no longer reachable or being used remain in back-end database

Resolution

This issue has been captured in This content is not included.Red Hat Bugzilla 1386913.

The only known resolution at this time is to extend the available space to the JBoss ON back-end database.

Root Cause

Once a new version of resource content is uploaded and deployed, it makes the previous version unreachable. This issue has been reported in This content is not included.Red Hat Bugzilla 1386913 and will be investigated and considered for a future release.

Diagnostic Steps

    SELECT    rhq_package.name AS pkg_name, rhq_package.classification AS pkg_class, 
              rhq_package.package_type_id AS pkg_type_id, rhq_package_version.*
    FROM      rhq_package_version
    LEFT JOIN rhq_package_bits
           ON rhq_package_version.package_bits_id = rhq_package_bits.id
    LEFT JOIN rhq_package
           ON rhq_package.id = rhq_package_version.package_id
    WHERE     rhq_package_version.package_bits_id IS NOT NULL
              AND NOT EXISTS (
                SELECT rhq_repo_pkg_version_map.package_version_id
                FROM   rhq_repo_pkg_version_map
                WHERE  rhq_package_version.id = rhq_repo_pkg_version_map.package_version_id
              )
              AND rhq_package_version.package_id IN (
                SELECT id
                FROM   rhq_package
                WHERE  rhq_package.package_type_id IN (
                         SELECT id
                         FROM   rhq_package_type
                         WHERE  category = 'DEPLOYABLE'
                                AND resource_type_id IN (
                                  SELECT id
                                  FROM   rhq_resource_type
                                  WHERE  category = 'SERVICE'
                                         AND (
                                           plugin IN ('JBossAS7','EAP7')
                                         )
                                         AND (
                                           name IN ('Deployment','DomainDeployment')
                                         )
                                )
                       )
              );

This solution is part of Red Hat’s fast-track publication program, providing a huge library of solutions that Red Hat engineers have created while supporting our customers. To give you the knowledge you need the instant it becomes available, these articles may be presented in a raw and unedited form.