Troubleshooting MariaDB File Handle Limit for Assure1-DB: Resolving "Out of Filehandles" Error (Doc ID 3012160.1)

Last updated on APRIL 18, 2024

Applies to:

Symptoms

Customers may encounter issues with the Assure1-Database service, particularly when attempting pattern matching over multiple fields in a MySQL query. The error message "communication failure" or "out of filehandles" may indicate that the service has reached its default file handle limit. This issue can arise when trying to perform wildcard searches over several fields simultaneously, exceeding the default file handle capacity of MariaDB.

Below is an example query that might trigger the "out of filehandles" error when executed on the Assure1-Database service:

This query attempts to search for devices and metrics matching the criteria specified in various fields, including DI.IfAlias, using a wildcard search (LIKE '%CORE%'). Such wildcard searches over multiple fields simultaneously might strain the default file handle limit in MariaDB, leading to the reported errors.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.