Bug ID 1182761: PostgresDB bloat results in software upgrade failure

Last Modified: Feb 24, 2025

Affected Product(s):
BIG-IQ Platform(all modules)

Known Affected Versions:
8.2.0, 8.2.0.1

Opened: Oct 20, 2022

Severity: 3-Major

Symptoms

The upgrade process is unsuccessful due to repeated errors found in the postgres/bootstrap logs. PostgresDB bloat can lead to software upgrade failure

Impact

The upgrade can fail, if the disk fills up during an upgrade or post-successful upgrade, the device is left in an inoperable state.

Conditions

This can happen when certain Role-based access control (RBAC) configurations (in postgresDB) are present prior to the upgrade. For example, a large number of custom roles.

Workaround

Perform the following steps on problematic BIG-IQ node 1. Move update-top-pg-tables.cron-d to /etc/cron.d/update-top-pg-tables on the BIG-IQ. This needs to be done in order for the crontab to work #chmod 600 /etc/cron.d/update-top-pg-tables 2. Re-run RBAC-RESET (assuming that is the original operation that filled /var) #rbac-reset 3. Confirm RBAC-RESET completes without errors"

Fix Information

None

Behavior Change

Guides & references

K10134038: F5 Bug Tracker Filter Names and Tips