Bug ID 758862: AVR database not initialized

Last Modified: Jan 06, 2020

Bug Tracker

Affected Product:  See more info
BIG-IP AFM, APM, ASM, AVR, CGN, PEM, SWG, vCMP(all modules)

Known Affected Versions:
14.1.0, 14.1.0.1, 14.1.0.2, 14.1.0.3, 14.1.0.4, 14.1.0.5, 14.1.0.6, 14.1.2, 14.1.2.1, 14.1.2.2, 14.1.2.3

Fixed In:
15.0.0

Opened: Feb 15, 2019
Severity: 2-Critical

Symptoms

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.

Impact

AVR database is not initialized and monpd does not start.

Conditions

This occurs after provisioning any of the modules which makes monpd run, or after restarting monpd.

Workaround

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

Fix Information

Removing duplicate row that causes the problem

Behavior Change