• The backup is failing because allowed memory size is exhausted. The amount of memory being requested is very big (1.9GB!).

    This is just doing a DB backup. Reduce server load is set to Maximum (and other settings tried too). Not sure what else I can try? Thanks for any help.

    See job log:

    [INFO] BackWPup 3.4.4; A project of Inpsyde GmbH
    [INFO] WordPress 4.9.2 on ...
    [INFO] Log Level: Normal 
    [INFO] BackWPup job: Weekly Backup
    [INFO] Logfile is: backwpup_log_51b21b_2018-02-04_03-00-19.html
    [INFO] Backup file is: backwpup_WBI3EG2201_2018-02-04_03-00-19.tar.gz
    [04-Feb-2018 03:00:19] 1. Try to backup database …
    [04-Feb-2018 03:00:19] Connected to database ... on localhost
    [04-Feb-2018 03:00:20] ERROR: Allowed memory size of 268435456 bytes exhausted (tried to allocate 1920296320 bytes)
    [04-Feb-2018 03:00:20] 2. Try to backup database …
    [04-Feb-2018 03:00:21] Connected to database ... on localhost
    [04-Feb-2018 03:00:21] ERROR: Allowed memory size of 268435456 bytes exhausted (tried to allocate 1768189800 bytes)
    [04-Feb-2018 03:00:22] 3. Try to backup database …
    [04-Feb-2018 03:00:22] Connected to database ... on localhost
    [04-Feb-2018 03:05:27] ERROR: Maximum execution time of 300 seconds exceeded
    [04-Feb-2018 03:05:28] 4. Try to backup database …
    [04-Feb-2018 03:05:29] Connected to database ... on localhost
    [04-Feb-2018 03:05:29] ERROR: Allowed memory size of 268435456 bytes exhausted (tried to allocate 1768189800 bytes)
    [04-Feb-2018 03:05:30] 5. Try to backup database …
    [04-Feb-2018 03:05:30] Connected to database ... on localhost
    [04-Feb-2018 03:05:30] ERROR: Allowed memory size of 268435456 bytes exhausted (tried to allocate 1768189800 bytes)
    [04-Feb-2018 03:05:31] 6. Try to backup database …
    [04-Feb-2018 03:05:31] Connected to database ... on localhost
    [04-Feb-2018 03:05:31] ERROR: Allowed memory size of 268435456 bytes exhausted (tried to allocate 980630336 bytes)
    [04-Feb-2018 03:05:32] 7. Try to backup database …
    [04-Feb-2018 03:05:32] Connected to database ... on localhost
    [04-Feb-2018 03:05:32] ERROR: Allowed memory size of 268435456 bytes exhausted (tried to allocate 1851877264 bytes)
    [04-Feb-2018 03:05:33] 8. Try to backup database …
    [04-Feb-2018 03:05:34] Connected to database ... on localhost
    [04-Feb-2018 03:05:34] ERROR: Allowed memory size of 268435456 bytes exhausted (tried to allocate 1635149128 bytes)
    [04-Feb-2018 03:05:35] 9. Try to backup database …
    [04-Feb-2018 03:05:35] Connected to database ... on localhost
    [04-Feb-2018 03:05:35] ERROR: Allowed memory size of 268435456 bytes exhausted (tried to allocate 1768189800 bytes)
    [04-Feb-2018 03:05:36] 10. Try to backup database …
    [04-Feb-2018 03:05:36] Connected to database ... on localhost
    [04-Feb-2018 03:05:36] ERROR: Allowed memory size of 268435456 bytes exhausted (tried to allocate 573710936 bytes)
    [04-Feb-2018 03:05:37] ERROR: Step aborted: too many attempts!

    Debug info:

    WordPress version: 4.9.2
    BackWPup version: 3.4.4
    PHP version: 7.0.27  (64bit)
    MySQL version: 10.2.12-MariaDB
    cURL version: 7.54.0
    cURL SSL version: OpenSSL/1.0.2k
    Server self connect: Response Test O.K.
    Server: LiteSpeed
    Operating System: Linux
    PHP SAPI: litespeed
    Maximum execution time: 300 seconds
    Alternative WP Cron: Off
    Disabled WP Cron: Off
    CHMOD Dir: 0755
    Server Time: 22:17
    Blog Time: 09:17
    Blog Timezone: Australia/Sydney
    Blog Time offset: 11 hours
    Blog language: en-US
    MySQL Client encoding: utf8mb4
    PHP Memory limit: 256M
    WP memory limit: 40M
    WP maximum memory limit: 256M
    Memory in use: 46.00 MB
    Loaded PHP Extensions:: Core, PDO, Phar, Reflection, SPL, SimpleXML, bcmath, bz2, calendar, ctype, curl, date, dom, exif, fileinfo, filter, ftp, gd, gettext, gmp, hash, iconv, imap, intl, ionCube Loader, json, libxml, litespeed, mbstring, mcrypt, mysqli, mysqlnd, openssl, pcntl, pcre, pdo_mysql, pdo_sqlite, posix, readline, session, shmop, soap, sockets, sqlite3, standard, tidy, timezonedb, tokenizer, uploadprogress, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib
    
Viewing 10 replies - 1 through 10 (of 10 total)
  • @here,
    there is a memory problem with MariaDB version 10.2.12, you can read it in here: https://jira.mariadb.org/browse/MDEV-13403
    For now, if possible, try to use another MariaDB version, we will try to make a workaround for this problem.
    Thank you for understand!

    Thread Starter tate33

    (@tate33)

    Thanks for letting me know. Downgrading is not an option unfortunately, so I’ll wait for your workaround or for MariaDB to fix the bug.

    @here,
    Please help me to do this:
    Enable ALTERNATE_WP_CRON:
    modify wp-config.php ( you can find this file in your root directory ), and before the line:
    /* That’s all, stop editing! Happy blogging. */
    add this line:
    define('ALTERNATE_WP_CRON' , true );
    Save the file and then try to run the job again, is there is any diferent ?

    Thank you guys 🙂

    • This reply was modified 8 years, 4 months ago by happyAnt.
    Thread Starter tate33

    (@tate33)

    Hi,

    I made the change but issue remains, sorry 🙁

    ERROR: Allowed memory size of 268435456 bytes exhausted (tried to allocate 792473680 bytes)

    Moderator Jan Dembowski

    (@jdembowski)

    Forum Moderator and Brute Squad

    Side note @duongcuong96 Please stop using @ here. When you do that you are pinging someone whose account is here and has nothing to do with this topic.

    For everyone else: per the forum guideline please start your own topic.

    https://ww.wp.xz.cn/support/guidelines/#post-in-the-best-place

    @jdembowski
    oops, thank you!
    Sorry about that 🙂

    Thread Starter tate33

    (@tate33)

    Still failing for me 🙁

    Hi @tate33
    MariaDB 10.2.12 stable released, could you please contact your hosting provider and ask them to upgrade to this version?
    After that, please try to run the job again.
    Thank you!

    @tate33
    there is a working solution in here:
    https://ww.wp.xz.cn/support/topic/allowed-memory-size-of-xxx-exhausted-tried-to-allocate/#post-10100334
    so could you please try to enable nd_pdo and nd_mysql extensions instead of pdo and mysql? and then try to run again?
    Normally, these extensions could be changed from your cPanel PHP extension setting 🙂
    Hope that help 😀

    Thread Starter tate33

    (@tate33)

    I don’t have those exact extensions available to me in cpanel.

    I have “nd_pdo_mysql” which I have now enabled (and turned off “pdo_mysql”), but I don’t have “nd_pdo”. If I try to turn off “pdo” then it’s automatically turned back on when I save. Problem still same.

    btw. on MySQL version: 10.2.13-MariaDB

Viewing 10 replies - 1 through 10 (of 10 total)

The topic ‘Backup failed: Allowed memory size exhausted’ is closed to new replies.