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

Last Modified: Oct 10, 2018

Bug Tracker

Affected Product:  See more info
BIG-IP ASM, Install/Upgrade(all modules)

Known Affected Versions:
11.4.0, 11.4.1, 11.5.0, 11.5.1, 11.5.1 HF1, 11.5.1 HF10, 11.5.1 HF11, 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.2, 11.6.0, 11.6.0 HF1, 11.6.0 HF2, 11.6.0 HF3, 11.6.0 HF4

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