Last Modified: Feb 14, 2024
Affected Product(s):
BIG-IP AVR
Known Affected Versions:
14.0.1, 14.0.1.1, 14.1.0, 14.1.0.1, 14.1.0.2, 14.1.0.3, 14.1.0.5, 14.1.0.6, 14.1.2, 15.0.0, 15.0.1, 15.0.1.1, 15.0.1.2, 15.0.1.3, 15.0.1.4
Fixed In:
15.1.0, 14.1.2.1
Opened: Apr 18, 2019 Severity: 3-Major
For unknown reasons, sometimes MariaDB generates multiple error 24 (too many files open) for AVR DB table files. MySQL starts reporting error 24 in its error log: 190228 8:21:17 [ERROR] mysqld: Can't open file: './AVR/AVR_STAT_FW_NAT_TRANS_DEST_H.frm' (errno: 24) 190228 8:45:36 [ERROR] mysqld: Can't open file: './AVR/AVR_STAT_ASM_NETWORK_T.frm' (errno: 24) 190228 9:12:22 [ERROR] mysqld: Can't open file: './AVR/AVR_STAT_ASM_NETWORK_T.frm' (errno: 24)
Statistic reports stop working. In some cases DB becomes corrupted.
-- Statistics are collected locally on the BIG-IP system (that is, the BIG-IP system is not associated with a BIG-IQ device). -- There is a considerable amount of traffic.
In /etc/my.cnf file: 1. Change the value of the 'open_files_limit' parameter from 2500 to 5000. 2. Add the following parameter (right after 'open_files_limit'): table_open_cache=2000 3. Restart MySQL: bigstart restart mysql Note: This workaround does not survive upgrade. It must be reapplied after every upgrade until the upgraded version contains a fix.
Embed MariaDB configuration change into the standard BIG-IP versions.