Errcode: 24 “Too many open files

  • Resolved tolkadot

    (@tolkadot)


    3 years, 3 months ago

    This error is coming up in error log, site is unreachable while this happens, resolves itself after a few minutes, happening frequently. Please advise.

    [19-Aug-2021 01:46:39 UTC] WordPress database error Out of resources when opening file '/var/lib/mysqltmp/#sql_11c1b_0.MAI' (Errcode: 24 "Too many open files") for query SHOW FULL COLUMNS FROMwp_wfBlocks7 made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), include_once('/plugins/wordfence/wordfence.php'), wordfence::install_actions, wfBlock::lockoutForIP
[19-Aug-2021 01:46:39 UTC] WordPress database error Out of resources when opening file '/var/lib/mysqltmp/#sql_11c1b_0.MAI' (Errcode: 24 "Too many open files") for query SHOW FULL COLUMNS FROM wp_wfBlocks7 made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), include_onc`e('/plugins/wordfence/wordfence.php'), wordfence::install_actions, wfBlock::lockoutForIP
[19-Aug-2021 01:46:42 UTC] WordPress database error Out of resources when opening file '/var/lib/mysqltmp/#sql_11c1b_0.MAI' (Errcode: 24 "Too many open files") for query SHOW FULL COLUMNS FROM wp_wfLiveTrafficHuman made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('wp_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, wfLog->actionSetRequestJSEnabled, wfLog::isHumanRequest
[19-Aug-2021 01:46:42 UTC] WordPress database error Out of resources when opening file '/var/lib/mysqltmp/#sql_11c1b_0.MAI' (Errcode: 24 "Too many open files") for query SHOW FULL COLUMNS FROM wp_wfLiveTrafficHuman made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('wp_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, wfLog->actionSetRequestJSEnabled, wfLog::isHumanRequest
[19-Aug-2021 01:46:42 UTC] WordPress database error Out of resources when opening file '/var/lib/mysqltmp/#sql_11c1b_1.MAI' (Errcode: 24 "Too many open files") for query SHOW FULL COLUMNS FROM wp_options made by wp_reschedule_event, wp_schedule_event, _set_cron_array, update_option
[19-Aug-2021 01:46:42 UTC] WordPress database error Out of resources when opening file '/var/lib/mysqltmp/#sql_11c1b_0.MAI' (Errcode: 24 "Too many open files") for query SHOW FULL COLUMNS FROM wp_options made by wp_unschedule_event, _set_cron_array, update_option
    • This topic was modified 3 years, 3 months ago by tolkadot.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support wfpeter

    (@wfpeter)

    Hi @tolkadot, thanks for reaching out to us!

    A Too many open files error is almost always an issue that your host needs to fix. Each request should only hold open a handful of files. PHP naturally opens and closes a lot of files while your site is in use, but doesn’t hold a lot open at once. Either a process is getting stuck and holding open files, the server itself is hitting a set limit, or it might just be a misconfiguration causing a bottleneck.

    I’d firstly get in touch with your host’s support channels and see if they can investigate the source of the issue.

    Let me know how you get on,

    Peter.

    Thread Starter tolkadot

    (@tolkadot)

    Thanks Peter, I’ll follow up and get back to you.

    Plugin Support wfpeter

    (@wfpeter)

    No worries @tolkadot,

    Topics are usually held open for around 7 days without response so I’m resetting that now by replying. Feel free to either let me know what your host finds out, or mark the topic as resolved if they are able to fix the issue without further input from us.

    Thanks again,

    Peter.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Errcode: 24 “Too many open files’ is closed to new replies.