Bug ID 746682: ASM unable to display *any* event logs, unless they are searched for by support ID

Last Modified: Feb 25, 2019

Bug Tracker

Affected Product:  See more info
BIG-IP ASM(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

Opened: Oct 12, 2018
Severity: 3-Major

Symptoms

After an upgrade, ASM is unable to display *any* event logs, unless they are searched for by support ID.

Impact

ASM is unable to display *any* event logs, unless they are searched for by support ID.

Conditions

Either the numerical value returned from this query: mysql> SELECT request_log_id FROM PRX.REQUEST_LOG_CLEARED; Or the numerical value returned from this query: mysql> SELECT MAX(request_log_id) FROM PRX.REQUEST_LOG_PROPERTIES WHERE flg_is_deleted = 1; Are larger than the numerical value returned from this query: mysql> SELECT MAX(id) FROM PRX.REQUEST_LOG;

Workaround

mysql> UPDATE PRX.REQUEST_LOG_CLEARED SET PRX.REQUEST_LOG_CLEARED.request_log_id = (SELECT MAX(PRX.REQUEST_LOG.id) FROM PRX.REQUEST_LOG); mysql> DELETE FROM PRX.REQUEST_LOG_PROPERTIES WHERE PRX.REQUEST_LOG_PROPERTIES.request_log_id NOT IN (SELECT PRX.REQUEST_LOG.id FROM PRX.REQUEST_LOG);

Fix Information

None

Behavior Change