Last Modified: Sep 14, 2023
Affected Product(s):
BIG-IP AFM, APM, ASM, AVR, CGN, PEM, SWG, vCMP
Known Affected Versions:
14.1.2, 14.1.2.1, 14.1.2.2, 14.1.2.3, 14.1.2.4, 14.1.2.5, 14.1.2.6, 14.1.2.7, 14.1.2.8, 14.1.3, 14.1.3.1, 14.1.4, 14.1.4.1, 14.1.4.2, 14.1.4.3, 14.1.4.4, 14.1.4.5, 14.1.4.6, 14.1.5, 14.1.5.1, 14.1.5.2, 14.1.5.3, 14.1.5.4, 14.1.5.6
Fixed In:
15.0.0
Opened: Feb 15, 2019 Severity: 2-Critical
AVR database is not functioning at all. Error messages in /var/log/avr/monpd.log indicate numerous types of errors, including table does not exist errors.
AVR database is not initialized and monpd does not start.
This occurs after provisioning any of the modules which makes monpd run, or after restarting monpd.
Edit file /var/avr/avr.sql: 1. Search for 'INSERT INTO AVR_CONF_NON_STAT_TABLES_EXPORT_DIR' commands (may appear more than once). 2. The following value should be inserted only one time (across all INSERT commands found) to this table: ('AVR_DIM_ENFORCEMENT_ACTION','/shared/avr') Delete the duplicates and make it appear only one time. * Afterwards restart DB: 1. touch /var/avr/init_avrdb 2. bigstart restart monpd
Removing duplicate row that causes the problem