Bug ID 499036: Rare cases of errors when loading data into mysql

Last Modified: Sep 13, 2023

Affected Product(s):
BIG-IP AFM, ASM, AVR, PEM, PSM, SWG(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.5.2 HF1, 11.5.3 HF1, 11.5.3 HF2, 11.5.4 HF1, 11.5.4 HF2, 11.5.4 HF3, 11.5.4 HF4

Fixed In:
11.6.0 HF4

Opened: Dec 31, 2014

Severity: 3-Major

Symptoms

In some cases, some AVR data was formed with duplicated rows, causing errors when inserting saving the data in mysql. You will see the following in monpd.log: "Some rows of load_stat_ip_1420015200.1 not loaded (22670 rows affected).".

Impact

Loss of some statistical data.

Conditions

This can occur when avr loads.

Workaround

None

Fix Information

We fixed an issue where in some cases, some AVR data was formed with duplicated rows, and triggered errors when saving the data in mysql.

Behavior Change

Guides & references

K10134038: F5 Bug Tracker Filter Names and Tips