• Resolved oozzyy

    (@oozzyy)


    Since the last or next-to-last update I often get the following error message:

    “Fatal error: Allowed memory size of xyz bytes exhausted (tried to allocate xyz bytes) in /www/htdocs/xxxxxxx/xx/wp-includes/wp-db.php on line 2221”
    Also when I edit pages.

    I changed my .htaccess to “php_value memory_limit 512M” (which is very high) and same with wp-config.php but the error messages are still there.
    And today I’ve realizied that I’ve not received my scheduled backups (every day 1 backup via email and local storing) since June 30, 2015. I.e. since the update to 4.7.0 or 4.8.0?

    The error message described above is shown too when I try to make a backup manually with “Create Database Backup”. Then I can see that there is a directory called “backup.lock”. If I click on “Create Database Backup” again I get this:

    “Something went wrong with your backup. It looks like another process might already be trying to backup your database. Please try again in a few minutes. If the problem persists please contact support.”

    Can I get some help?
    Thank you!

    https://www.ads-software.com/plugins/better-wp-security/

Viewing 8 replies - 1 through 8 (of 8 total)
  • I have similar problem. Maybe try to change your PHP version in your environment. PHP-5.2.17 works fine for me.

    Thread Starter oozzyy

    (@oozzyy)

    It doesn’t work, still same problems :/

    oozzyy, here is some old topic https://www.ads-software.com/support/topic/memory-limit-reached-error I believe this is related, as I first got similar error message as you, but after some investigation the real error that casue this is.

    PHP Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 15466470 bytes) in /www/wp-content/plugins/better-wp-security/core/modules/backup/class-itsec-backup.php on line 205

    So from that topic it looks like its scheduled database backup that is a problem. You should check if simply your database isnt too big. Maybe try using also some cleaning plugin like https://www.ads-software.com/plugins/wp-clean-up/ just note, that it will delete your revisions.

    Other related topic https://www.ads-software.com/support/topic/fatal-error-out-of-memory-is-caused-by-scheduled-backup-of-db-in-this-plugin?replies=2

    Thread Starter oozzyy

    (@oozzyy)

    Thank you, kokers. But still same problems.. ??
    Am I the only one who have problems like this?

    In the Exclude Tables setting of the Database Backups section on the iTSec plugin Settings page make sure the:

    [prefix]_itsec_temp,
    [prefix]_itsec_lockouts,
    [prefix]_itsec_log

    tables are excluded from the backup.
    (Where [prefix] should be substituted with your database tables prefix).

    If the Schedule Database Backups setting is enabled, disable it.

    Then check for the presence of wp-content/uploads/ithemes-security/backup.lock folder. Delete the folder manually if it exists.

    Now login to your database using phpMyAdmin and if necessary select your database.

    To view your database structure, click the Structure tab at the top of your phpMyAdmin window. In the Structure window, you can view the table names, the number of records in each table, the size of each table etc.

    Identify the table(s) with 10000s or 100000s records.
    Exclude that (those) table(s) from the iTSec plugin Database Backup.

    Then try and create a backup manually. Click on the Create Database Backup button. If the manual Database Backup completes successfully study the excluded tables. Ask yourself: what data is stored in that (those) table(s) ? Is there any point in including the data of those tables in a backup ? Can I delete all records from this (those) table(s)?

    In other words try and reduce the database footprint(size) if possible.

    Once you are confident the database footprint is minimized and a manual Database Backup works you can try and enable the Scheduled Database Backups setting again …

    dwinden

    Thread Starter oozzyy

    (@oozzyy)

    MAAAAAAAAAAAAAAAAAAAAANY THANKS to you, @dwinden!
    Logs-tables and entries like “Relevanssi logs” and “Redirection logs” of both plugins are excluded now and it works fine!

    @kokers, you’re also right! ??

    How can I disable Scheduled backup on iThemes Sec if I can’t access WP login page when the plugin is enabled? I always get the memory limit error on the login page.

    @rodav

    Next time please open your own topic instead of posting to a resolved topic …

    Login to the database using phpMyAdmin and then execute the following
    SQL command:

    select * from [prefix]options where option_name = ‘itsec_backup’;

    (where [prefix] must be substituted with your table prefix. eg: wp_).

    Doubleclick on the resulting option_value cell to edit.
    Look for:

    s:7:”enabled”;b:1;

    and change it to:

    s:7:”enabled”;b:0;

    Click anywhere outside the cell to save changes.
    Scheduled backups is now disabled.

    dwinden

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘"Fatal Error: Allowed memory size exhausted" since last or next-to-last update’ is closed to new replies.