ERROR: Allowed memory size of XXXXX bytes exhausted – Multisite

Oh – I should add – that this happens when its trying to back up the database as part of a JOB.

If I back up the database manually using the 1-click-backup button…that works fine!

I should also add, I’ve tried using the reduce server load to maximum…no effect.

• This reply was modified 3 years, 10 months ago by rob098.
• This reply was modified 3 years, 10 months ago by rob098.

@rob098
Please increase your WP memory limit to at least 250MB:
https://docs.woocommerce.com/document/increasing-the-wordpress-memory-limit/
After that, run the job again and I think it should works ^^

I tried these methods but it didn’t help.

I don’t think this is the issue, as i have done the following test:

** Created a scheduled job of just database which fails to backup.

** Manually pressing back up 1-click database button works flawlessly.

** Non-multisite installation with MUCH bigger database works perfectly. (Exact same server)

Could it be something wrong with scheduled backups on multisite?

Hello @rob098
Could you please give me the server information on BackWPUp -> Settings -> Infomation tab?
Thank you!

Closed because of inactivity

Sorry, I’m not getting notifications for this thread.

I do still have the problem tho – and the server info is:

WordPress version 	5.7.2
BackWPup version 	3.9.0 Get pro.
PHP version 	7.4.21 (64bit)
MySQL version 	5.7.33-log
cURL version 	7.64.0
cURL SSL version 	OpenSSL/1.1.1d
WP-Cron URL 	https://www.******.com/wp-cron.php
Server self connect 	Response Test O.K.
Document root 	*******
Temp folder 	********/wp-content/uploads/backwpup-71b1f7-temp/
Log folder 	******/wp-content/uploads/backwpup-71b1f7-logs/
Server 	Apache
Operating System 	Linux
PHP SAPI 	cgi-fcgi
Current PHP user 	*******
Maximum execution time 	50000 seconds
BackWPup maximum script execution time 	30 seconds
Alternative WP Cron 	Off
Disabled WP Cron 	Off
CHMOD Dir 	0755
Server Time 	21:34
Blog Time 	22:34
Blog Timezone 	Europe/London
Blog Time offset 	1 hours
Blog language 	en-GB
MySQL Client encoding 	utf8mb4
PHP Memory limit 	-1
WP memory limit  256M
WP maximum memory limit 	-1
Memory in use 	136.18 MB
Loaded PHP Extensions: 	Core, PDO, Phar, Reflection, SPL, SimpleXML, bcmath, bz2, calendar, cgi-fcgi, ctype, curl, date, dba, dom, exif, fileinfo, filter, ftp, gd, gettext, gmp, hash, iconv, imap, intl, json, libxml, mbstring, mysqli, mysqlnd, openssl, pcre, pdo_mysql, pdo_sqlite, posix, session, shmop, soap, sodium, sqlite3, standard, tidy, tokenizer, xml, xmlreader, xmlwriter, xsl, zip, zlib

If the error log is helpful…..

[INFO] BackWPup 3.9.0; A project of Inpsyde GmbH
[INFO] WordPress 5.7.2 on https://www.*****.com/
[INFO] Log Level: Normal (translated)
[INFO] BackWPup job: database only
[INFO] Logfile is: backwpup_log_****_2021-07-17_22-52-45.html
[INFO] Backup file is: 2021-07-17_22-52-45_*****.zip
[17-Jul-2021 22:52:45] 1. Try to backup database …
[17-Jul-2021 22:52:45] Connected to database *****8 on d**********io
[17-Jul-2021 22:53:07] ERROR: Allowed memory size of 97517568 bytes exhausted (tried to allocate 16777240 bytes)
[17-Jul-2021 22:53:09] 2. Try to backup database …
[17-Jul-2021 22:53:09] Connected to database db****8 on d**********io
[17-Jul-2021 22:53:10] ERROR: Allowed memory size of 95420416 bytes exhausted (tried to allocate 16777240 bytes)
[17-Jul-2021 22:53:11] 3. Try to backup database …
[17-Jul-2021 22:53:12] Connected to database d*********o
[17-Jul-2021 22:53:12] ERROR: Allowed memory size of 95420416 bytes exhausted (tried to allocate 16777240 bytes)
[17-Jul-2021 22:53:13] ERROR: Step aborted: too many attempts!
[17-Jul-2021 22:53:13] 1. Trying to generate a manifest file …
[17-Jul-2021 22:53:13] Added manifest.json file with 1.63 KB to backup file list.
[17-Jul-2021 22:53:13] 1. Trying to create backup archive …
[17-Jul-2021 22:53:14] Compressing files as ZipArchive. Please be patient, this may take a moment.
[17-Jul-2021 22:53:14] Backup archive created.
[17-Jul-2021 22:53:14] Archive size is 953.00 B.
[17-Jul-2021 22:53:14] 2 Files with 1.85 KB in Archive.
[17-Jul-2021 22:53:14] ERROR: Job has ended with errors in 29 seconds. You must resolve the errors for correct execution.