Bug ID 1183549: In the monpd.log file, an error occurs while executing SQL string "CALL AggregateAndDropOld"

Last Modified: Apr 17, 2024

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

Known Affected Versions:
15.1.0, 15.1.0.1, 15.1.0.2, 15.1.0.3, 15.1.0.4, 15.1.0.5, 15.1.1, 15.1.2, 15.1.2.1, 15.1.3, 15.1.3.1, 15.1.4, 15.1.4.1, 15.1.5, 15.1.5.1, 15.1.6, 15.1.6.1, 15.1.7, 15.1.8, 15.1.8.1, 15.1.8.2, 15.1.9, 15.1.9.1, 15.1.10, 15.1.10.2, 15.1.10.3, 15.1.10.4

Opened: Oct 25, 2022

Severity: 3-Major

Symptoms

Access the monpd.log file and verify the following log messages: DB table AVR_STAT_SIP_DOS_T DB|ERROR|May 09 11:21:15.162|15694|../src/db/MonpdDbAPI.cpp:mysql_query_safe:0209| Error (err-code 1136) executing SQL string : CALL AggregateAndDropOld('AVR_STAT_SIP_DOS', 'medium', @parts_removed)

Impact

No impact on the functionality.

Conditions

- Navigate to Security > Reporting > DoS > Dashboard. or - Run the SQL string "CALL AggregateAndDropOld('AVR_STAT_SIP_DOS', 'medium', @parts_removed);" from Maria DB.

Workaround

None

Fix Information

None

Behavior Change

Guides & references

K10134038: F5 Bug Tracker Filter Names and Tips