Backup failed: Allowed memory size exhausted

(@tate33)

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)

happyAnt
(@duongcuong96)

8 years, 3 months ago

@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)

8 years, 3 months ago

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.
happyAnt
(@duongcuong96)

8 years, 3 months ago
@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, 3 months ago by happyAnt.
Thread Starter tate33
(@tate33)

8 years, 3 months ago

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

8 years, 3 months ago

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://wordpress.org/support/guidelines/#post-in-the-best-place

happyAnt
(@duongcuong96)

8 years, 3 months ago

@jdembowski
oops, thank you!
Sorry about that 🙂

Thread Starter tate33
(@tate33)

8 years, 2 months ago

Still failing for me 🙁

happyAnt
(@duongcuong96)

8 years, 2 months ago

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!

happyAnt
(@duongcuong96)

8 years, 1 month ago

@tate33
there is a working solution in here:
https://wordpress.org/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)

8 years, 1 month ago

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.