BugZero | F5 BugID 652258 - Mysqld tries to open too many files, ASM internal ...

F5 - Defect ID: 652258

Mysqld tries to open too many files, ASM internal processes have issues

F5 - Defect ID: 652258

Mysqld tries to open too many files, ASM internal processes have issues

Last updated on December 31st, 2025

BugZero Risk Score
6.7 Medium

Overall: 6.7

Severity: 7.3

Community: 4.2

Lifecycle: 7.0

What is the BugZero Risk Score?

F5 Integration

Learn more about where this data comes from

F5 Integration

Learn more

Bug Scrub Advisor

Streamline upgrades with automated vendor bug scrubs

Bug Scrub Advisor

Learn more

BugZero Enterprise

Wish you caught this bug sooner? Get proactive today.

BugZero Enterprise

Learn more

Bug Details

Priority: 3-Major
Status: Verified
Impact Category: Application Visibility and Reporting
Views: 10

Description

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

Change history

2025-04-28 Added: 12.1.0, 12.1.0 HF1, 12.1.0 HF2, 12.1.1, 12.1.1 HF1, 12.1.1 HF2, 12.1.2, 12.1.2 HF1, 12.1.2 HF2, 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

Relevant Products

Click on a version to see all relevant bugs

Affected versions:12.1.0, 12.1.0 HF1, 12.1.0 HF2, 12.1.1, 12.1.1 HF1, 12.1.1 HF2, 12.1.2, 12.1.2 HF1, 12.1.2 HF2, 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

Fixed versions: No known fixed versions

Relevant Products

Click on a version to see all relevant bugs

Fixed versions: No known fixed versions

Top F5 Defects

9.6Defect ID: 2141205
Tpm-status returns: "System Integrity: Invalid" for some Engineering Hotfixes
9.6Defect ID: 546260
TMM can crash if using the v6rd profile
9.6Defect ID: 1496269
VCMP guest on version 16.1.4 or above might experience constant TMM crashes.
9.6Defect ID: 740969
Menu visibility issue with newly activated license.
9.4Defect ID: 1785385
Intermittent traffic failures when tenant is running BIG-IP v17.1.2 or above and host is on version prior to F5OS-A 1.8.0 or F5OS-C 1.8.0

Ready to prevent the next vendor outage?

Get a demo

F5 - Defect ID: 652258

Mysqld tries to open too many files, ASM internal processes have issues

F5 - Defect ID: 652258

Mysqld tries to open too many files, ASM internal processes have issues

Last updated on December 31st, 2025

BugZero Risk Score6.7 Medium

Bug Details

Symptoms

Impact

Conditions

Workaround

Fix Information

Top F5 Defects

Ready to prevent the next vendor outage?

Links

BugZero Risk Score
6.7 Medium