Bug ID 685741: DoS Overview is very slow to load data, to the point of timeout

Last Modified: Apr 26, 2024

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

Known Affected Versions:
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

Fixed In:
12.1.3.7

Opened: Sep 27, 2017

Severity: 3-Major

Symptoms

When logs contains more than 1 million records, loading of attacks data is extremely slow and requires many SQL queries.

Impact

DoS Overview page is unusable

Conditions

N/A

Workaround

N/A

Fix Information

The fix revolved around combining all the required data into a couple of queries instead of sending distinct queries for every attack.

Behavior Change

Guides & references

K10134038: F5 Bug Tracker Filter Names and Tips