Bug ID 507905: Saving Policy History during UCS load causes db deadlock/timeout

Last Modified: Sep 13, 2023

Affected Product(s):
BIG-IP ASM, Install/Upgrade(all modules)

Known Affected Versions:
11.5.1 HF1, 11.5.1 HF2, 11.5.1 HF3, 11.5.1 HF4, 11.5.1 HF5, 11.5.1 HF6, 11.5.1 HF7, 11.5.1 HF8, 11.5.1 HF9, 11.5.1 HF10, 11.5.1 HF11, 11.6.2 HF1, 11.4.0, 11.4.1, 11.6.0, 11.6.1, 11.6.2, 11.6.3, 11.6.3.1, 11.6.3.2, 11.6.3.3, 11.6.3.4, 11.6.4, 11.6.5, 11.6.5.1, 11.6.5.2, 11.6.5.3

Fixed In:
11.6.0 HF5, 11.5.2 HF1

Opened: Feb 19, 2015

Severity: 3-Major

Symptoms

Loading a UCS from an older version might cause db timeouts. /var/log/ltm contains errors similar to the followind: DBD::mysql::db do failed: Lock wait timeout exceeded; try restarting transaction at /usr/lib/perl5/site_perl/F5/DbUtils.pm.

Impact

UCS load fails and multiple error messages are logged. This is a rarely occurring issue.

Conditions

-- Devices running different software versions are configured in a device group. -- A sync operation is triggered from the device running the older version. -- The device group is in the middle of an upgrade, the newer version being pre-11.6.0 HF5 or pre-11.5.2 HF1.

Workaround

Make sure all BIG-IP systems in a device group are running the same version of the software.

Fix Information

This release corrects an intermittent issue where an error state was received during the upgrade of a DSC device group.

Behavior Change

Guides & references

K10134038: F5 Bug Tracker Filter Names and Tips