• Resolved mariamino

    (@mariamino)


    Hola! Desde les agraedezco sus comentarios y sugerencias.

    Tengo instalado el plugin All In One WordPress Security and Firewall en mi web.
    Por ahora la web esta en mantenimiento.
    Tengo también instalado en el archivo wp-config.php el código para depuración de errores.Entonces revisando el archivo debug.log en el directorio wp-content me arroja un codigo de error este :

    PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 188416 bytes) in /home/mariamin/agenciaseolima.com/public_html/wp-includes/wp-db.php on line 2056
    [14-Sep-2021 06:35:20 UTC] PHP Stack trace:
    [14-Sep-2021 06:35:20 UTC] PHP 1. {main}() /home/mariamin/agenciaseolima.com/public_html/wp-cron.php:0
    [14-Sep-2021 06:35:20 UTC] PHP 2. do_action_ref_array($hook_name = ‘aiowps_hourly_cron_event’, $args = []) /home/mariamin/agenciaseolima.com/public_html/wp-cron.php:138
    [14-Sep-2021 06:35:20 UTC] PHP 3. WP_Hook->do_action($args = []) /home/mariamin/agenciaseolima.com/public_html/wp-includes/plugin.php:518
    [14-Sep-2021 06:35:20 UTC] PHP 4. WP_Hook->apply_filters($value = ”, $args = []) /home/mariamin/agenciaseolima.com/public_html/wp-includes/class-wp-hook.php:327
    [14-Sep-2021 06:35:20 UTC] PHP 5. AIOWPSecurity_Cronjob_Handler->aiowps_hourly_cron_event_handler() /home/mariamin/agenciaseolima.com/public_html/wp-includes/class-wp-hook.php:303
    [14-Sep-2021 06:35:20 UTC] PHP 6. do_action($hook_name = ‘aiowps_perform_scheduled_backup_tasks’) /home/mariamin/agenciaseolima.com/public_html/wp-content/plugins/all-in-one-wp-security-and-firewall/classes/wp-security-cronjob-handler.php:16
    [14-Sep-2021 06:35:20 UTC] PHP 7. WP_Hook->do_action($args = [0 => ”]) /home/mariamin/agenciaseolima.com/public_html/wp-includes/plugin.php:470
    [14-Sep-2021 06:35:20 UTC] PHP 8. WP_Hook->apply_filters($value = ”, $args = [0 => ”]) /home/mariamin/agenciaseolima.com/public_html/wp-includes/class-wp-hook.php:327
    [14-Sep-2021 06:35:20 UTC] PHP 9. AIOWPSecurity_Backup->aiowps_scheduled_backup_handler(”) /home/mariamin/agenciaseolima.com/public_html/wp-includes/class-wp-hook.php:303
    [14-Sep-2021 06:35:20 UTC] PHP 10. AIOWPSecurity_Backup->execute_backup() /home/mariamin/agenciaseolima.com/public_html/wp-content/plugins/all-in-one-wp-security-and-firewall/classes/wp-security-backup.php:314
    [14-Sep-2021 06:35:20 UTC] PHP 11. AIOWPSecurity_Backup->write_db_backup_file($handle = resource(1335) of type (stream), $tables = [0 => [0 => ‘wp_aiowps_events’], 1 => [0 => ‘wp_aiowps_failed_logins’], 2 => [0 => ‘wp_aiowps_global_meta’], 3 => [0 => ‘wp_aiowps_login_activity’], 4 => [0 => ‘wp_aiowps_login_lockdown’], 5 => [0 => ‘wp_aiowps_permanent_block’], 6 => [0 => ‘wp_commentmeta’], 7 => [0 => ‘wp_comments’], 8 => [0 => ‘wp_db7_forms’], 9 => [0 => ‘wp_e_submissions’], 10 => [0 => ‘wp_e_submissions_actions_log’], 11 => [0 => ‘wp_e_submissions_values’], 12 => [0 => ‘wp_links’], 13 => [0 => ‘wp_options’], 14 => [0 => ‘wp_postmeta’], 15 => [0 => ‘wp_posts’], 16 => [0 => ‘wp_smush_dir_images’], 17 => [0 => ‘wp_term_relationships’], 18 => [0 => ‘wp_term_taxonomy’], 19 => [0 => ‘wp_termmeta’], 20 => [0 => ‘wp_terms’], 21 => [0 => ‘wp_usermeta’], 22 => [0 => ‘wp_users’], 23 => [0 => ‘wp_wfblockediplog’], 24 => [0 => ‘wp_wfblocks7’], 25 => [0 => ‘wp_wfconfig’], 26 => [0 => ‘wp_wfcrawlers’], 27 => [0 => ‘wp_wffilechanges’], 28 => [0 => ‘wp_wffilemods’], 29 => [0 => ‘wp_wfhits’], 30 => [0 => ‘wp_wfhoover’], 31 => [0 => ‘wp_wfissues’], 32 => [0 => ‘wp_wfknownfilelist’], 33 => [0 => ‘wp_wflivetraffichuman’], 34 => [0 => ‘wp_wflocs’], 35 => [0 => ‘wp_wflogins’], 36 => [0 => ‘wp_wfls_2fa_secrets’], 37 => [0 => ‘wp_wfls_settings’], 38 => [0 => ‘wp_wfnotifications’], 39 => [0 => ‘wp_wfpendingissues’], 40 => [0 => ‘wp_wfreversecache’], 41 => [0 => ‘wp_wfsnipcache’], 42 => [0 => ‘wp_wfstatus’], 43 => [0 => ‘wp_wftrafficrates’], 44 => [0 => ‘wp_wpr_rucss_resources’], 45 => [0 => ‘wp_wpr_rucss_used_css’], 46 => [0 => ‘wp_yoast_indexable’], 47 => [0 => ‘wp_yoast_indexable_hierarchy’], 48 => [0 => ‘wp_yoast_migrations’], 49 => [0 => ‘wp_yoast_primary_term’], 50 => [0 => ‘wp_yoast_seo_links’]]) /home/mariamin/agenciaseolima.com/public_html/wp-content/plugins/all-in-one-wp-security-and-firewall/classes/wp-security-backup.php:186
    [14-Sep-2021 06:35:20 UTC] PHP 12. wpdb->get_results($query = ‘SELECT * FROM wp_postmeta;’, $output = ‘OBJECT’) /home/mariamin/agenciaseolima.com/public_html/wp-content/plugins/all-in-one-wp-security-and-firewall/classes/wp-security-backup.php:69
    [14-Sep-2021 06:35:20 UTC] PHP 13. wpdb->query($query = ‘SELECT * FROM wp_postmeta;’) /home/mariamin/agenciaseolima.com/public_html/wp-includes/wp-db.php:2695
    [14-Sep-2021 06:35:20 UTC] PHP 14. wpdb->_do_query($query = ‘SELECT * FROM wp_postmeta;’) /home/mariamin/agenciaseolima.com/public_html/wp-includes/wp-db.php:1945
    [14-Sep-2021 06:35:20 UTC] PHP 15. mysqli_query($link = class mysqli { public $affected_rows = -1; public $client_info = ‘mysqlnd 7.4.20’; public $client_version = 70420; public $connect_errno = 0; public $connect_error = NULL; public $errno = 0; public $error = ”; public $error_list = []; public $field_count = 4; public $host_info = ‘Localhost via UNIX socket’; public $info = NULL; public $insert_id = 0; public $server_info = ‘5.5.5-10.1.48-MariaDB’; public $server_version = 100148; public $sqlstate = ‘00000’; public $protocol_version = 10; public $thread_id = 426029; public $warning_count = 0 }, $query = ‘SELECT * FROM wp_postmeta;’) /home/mariamin/agenciaseolima.com/public_html/wp-includes/wp-db.php:2056
    [14-Sep-2021 06:35:20 UTC] Error Commands out of sync; you can’t run this command now de la base de datos de WordPress para la consulta SELECT *, CASE`

    He escrito al soporte de Elementor pro y me ha dicho esto:

    If you are referring to the “Fatal error: Allowed memory size” memory issue, based on the error log you’ve provided, it seems to be caused by a plugin, “All In One WP Security & Firewall”

    Nuevamente consulte al soporte de elementor pro y me han respondido esta otra cosa:

    You will need to bring this up to the plugin’s support (All In One WP Security & Firewall) since this is caused by their plugin’s code. Based on the error log, it’s likely an issue with the plugin’s backup feature.

    Necesito la ayuda de ustedes por favor. Como se soluciona esta situación.
    Muchísimas gracias.

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Contributor mbrsolution

    (@mbrsolution)

    Hi,

    If you are referring to the “Fatal error: Allowed memory size” memory issue, based on the error log you’ve provided, it seems to be caused by a plugin, “All In One WP Security & Firewall”

    You need to speak to your host about the memory size. Find out how much memory is allocated to your site. You need at least 256M or better still 512M.
    https://wordpress.org/support/article/editing-wp-config-php/#increasing-memory-allocated-to-php

    Kind regards.

    • This reply was modified 2 years, 8 months ago by mbrsolution.
    Thread Starter mariamino

    (@mariamino)

    Hi !
    thanks for your answer.
    Below I add information from the system of our website.
    I understand that our memory limit is 600M.

    Please could you review the other data to see if there would still be any memory limits increased.

    Server Environment
    Operating System: Linux
    Software: Apache/2.4.39 (Unix) OpenSSL/1.0.2k-fips
    MySQL version: MariaDB Server v5.6.49-89.0
    PHP Version: 7.4.20
    PHP Max Input Vars: 10000
    PHP Max Post Size: 200M
    GD Installed: Yes
    ZIP Installed: Yes
    Write Permissions: All right
    Elementor Library: Connected
    WordPress Environment
    Version: 5.8.1
    Site URL: https://www.agenciaseolima.com
    Home URL: https://www.agenciaseolima.com
    WP Multisite: No
    Max Upload Size: 200 MB
    Memory limit: 600M
    Permalink Structure: /%postname%/
    Language: es
    Timezone: America/Lima
    Admin Email: maria.mino@vehmaa.com
    Debug Mode: Active`

    Plugin Contributor mbrsolution

    (@mbrsolution)

    Hi, the above report looks okay to me. Try the following plugin.

    https://wordpress.org/plugins/health-check/

    Let me know if the above helps you. If you still have issues, then I suggest to carry out a plugin conflict test by deactivating all other plugins except AIOWPS. This will let you know if there is a conflict with another plugin.

    Kind regards.

    Thread Starter mariamino

    (@mariamino)

    Hi mbrsolution, thanks for your help. Before we had a memory limit of 600M and the error of out of memory was already present.
    Today I have 1024M as memory limit and this has not solved the problem at all.

    Thread Starter mariamino

    (@mariamino)

    Hi, the above report looks okay to me. Try the following plugin.

    https://wordpress.org/plugins/health-check/
    Thanks. About this plugin, I have installed and applied it to my website.
    The result has been that the health of the web is excellent.
    all very well according to this analysis.
    So the memory leak continues to occur even though I have updated everything both plugin and elementor core.
    I need the plugin support to help me with this issue.

    Thank you.

    Plugin Contributor mbrsolution

    (@mbrsolution)

    Hi, did you carry out a plugin/theme conflict test like I suggested above?

    Thank you.

    Thread Starter mariamino

    (@mariamino)

    Hi!
    Yes, of course. Now what I did is remove the plugin from the web. Then I reinstalled it but downloaded it to my computer and then compressed the plugin and reinstalled it. Now I no longer get that memory loss error.

    Plugin Contributor mbrsolution

    (@mbrsolution)

    Hi, I am happy to know that you managed to fix the issue 🙂

    However, I am a bit puzzled at your method but at least it worked for you.

    Kind regards

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to all’ is closed to new replies.