Bug ID 773925: Sometimes MariaDB generates multiple error 24 (too many files open) for AVR DB tables files

Last Modified: Sep 16, 2019

Bug Tracker

Affected Product:  See more info
BIG-IP AVR(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, 15.0.0, 15.0.1

Opened: Apr 18, 2019
Severity: 3-Major

Symptoms

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)

Impact

Statistic reports stop working. In some cases DB becomes corrupted.

Conditions

-- 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.

Workaround

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.

Fix Information

None

Behavior Change