Bug ID 652258: Mysqld tries to open too many files, ASM internal processes have issues

Last Modified: Sep 13, 2023

Affected Product(s):
BIG-IP ASM(all modules)

Known Affected Versions:
12.1.0, 12.1.1, 12.1.2, 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, 12.1.4.1, 12.1.5, 12.1.5.1, 12.1.5.2, 12.1.5.3, 12.1.6, 13.0.0, 13.0.0 HF1, 13.0.0 HF2, 13.0.0 HF3, 13.0.1, 13.1.0, 13.1.0.1, 13.1.0.2, 13.1.0.3, 13.1.0.4, 13.1.0.5, 13.1.0.6, 13.1.0.7, 13.1.0.8, 13.1.1, 13.1.1.2, 13.1.1.3, 13.1.1.4, 13.1.1.5, 13.1.3, 13.1.3.1, 13.1.3.2, 13.1.3.3, 13.1.3.4, 13.1.3.5, 13.1.3.6, 13.1.4, 13.1.4.1, 13.1.5, 13.1.5.1

Opened: Mar 20, 2017

Severity: 3-Major

Symptoms

The system reports errors: # perror 24 OS error code 24: Too many open files 011d0004:3: Disk partition /var/asmdata1 has only 11% free Disk partition /var/lib/mysql has only 11% free There are also failures logged to /var/lib/mysql/mysqld.err when attempting to open files: ---------------------------------------------------------------------- 170301 3:20:08 [ERROR] /usr/sbin/mysqld: Can't open file: './AVR/AVR_STAT_ASM_MEMORY_INFO_T.frm' (errno: 24) 170301 3:20:09 [ERROR] /usr/sbin/mysqld: Can't open file: './PRX/REQUEST_LOG.frm' (errno: 24)

Impact

MySQL ISAM tables becomes corrupted after MySQL exceeds the maximum number of allowed open file handles, and becomes nonfunctional.

Conditions

ASM and AVR are enabled.

Workaround

Run the following commands: 1. tmsh save sys ucs /var/tmp/last_good.ucs 2. /usr/share/ts/bin/recover_db.pl

Fix Information

None

Behavior Change

Guides & references

K10134038: F5 Bug Tracker Filter Names and Tips