Bug ID 688813: Some ASM tables can massively grow in size.

Last Modified: Apr 10, 2019

Bug Tracker

Affected Product:  See more info
BIG-IP ASM, AVR(all modules)

Known Affected Versions:
12.1.0, 12.1.0 HF1, 12.1.0 HF2, 12.1.1, 12.1.1 HF1, 12.1.1 HF2, 12.1.2, 12.1.2 HF1, 12.1.2 HF2, 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, 13.0.0, 13.0.0 HF1, 13.0.0 HF2, 13.0.0 HF3, 13.0.1, 13.1.0, 13.1.0.1

Fixed In:
14.0.0, 13.1.0.2

Opened: Oct 15, 2017
Severity: 2-Critical
Related AskF5 Article:
K23345645

Symptoms

/var/lib/mysql mount point gets full.

Impact

While other dimensions are being collapsed correctly, the Device ID field is not being collapsed causing the growth in size. -- High disk usage. -- Frequent need to clear AVR data.

Conditions

Many combinations of IP addresses, Device IDs (and other ASM dimensions) in traffic over very long period of time (potentially weeks/months).

Workaround

Manually delete AVR mysql partitions located in /var/lib/mysql/AVR.

Fix Information

Over time, no of the AVR_STAT_ASM_HTTP_CLIENT_IP_X#...MYD file exceeds 300 MB, so this problem no longer occurs.

Behavior Change