Bug ID 662272: ASM MySQL persistent query causing GUI to hang.

Last Modified: Sep 13, 2023

Affected Product(s):
BIG-IP ASM(all modules)

Known Affected Versions:
12.0.0, 12.0.0 HF1, 12.1.0 HF1, 12.0.0 HF2, 12.1.0 HF2, 12.0.0 HF3, 12.0.0 HF4, 12.1.1 HF1, 12.1.1 HF2, 12.1.2 HF1, 12.1.2 HF2, 12.1.0, 12.1.1, 12.1.2, 12.1.3, 12.1.3.1, 12.1.3.2, 12.1.3.3, 12.1.3.4, 12.1.3.5, 12.1.3.6, 12.1.3.7, 12.1.4, 12.1.4.1, 12.1.5, 12.1.5.1, 12.1.5.2, 12.1.5.3, 12.1.6, 13.0.0, 13.0.0 HF1, 13.0.0 HF2, 13.0.0 HF3, 13.0.1

Fixed In:
13.1.0

Opened: Apr 30, 2017

Severity: 3-Major

Symptoms

GUI access is slow.

Impact

Slow GUI and access to the ASM device.

Conditions

This occurs when the following conditions are met: -- Automatic Policy Builder is running with Parameter learning in Selective mode. -- The system has already learned 10000 parameters for metachar violations. -- There are then another 7500 pending suggestions at 100% that are not being accepted as the max has already been reached.

Workaround

Delete all the pending suggestions for the 'Illegal metachar in value' violation.

Fix Information

MySQL query optimizations, so that ASM MySQL persistent query no longer causes GUI to hang.

Behavior Change

Guides & references

K10134038: F5 Bug Tracker Filter Names and Tips