Allowed memory size of XXX exhausted (tried to allocate)

@stefanp44
go to BackWPUp -> Settings -> Logs -> Logging Level -> Debug( not translated )
re-run it again and send us your debug log ( Get the latest log file at : BackWpUp -> Logs ).
Remember, please set Logging level to Debug, not translated

Hi,

Yes of course: here it is :


[INFO] BackWPup 3.4.4; A project of Inpsyde GmbH
[INFO] WordPress 4.9.4 on xxxxxxxxxxxxxxxxx
[INFO] Log Level: Normal
[INFO] BackWPup job: database-plugin.list
[INFO] Logfile is: backwpup_log_f01358_2018-03-15_16-55-44.html
[INFO] Backup file is: 2018-03-15_16-55-44_5TYBGWGD01.zip
[15-Mar-2018 16:55:44] 1. Try to backup database …
[15-Mar-2018 16:55:44] Connected to database ohvp_bdd on localhost
[15-Mar-2018 16:55:44] ERROR: Allowed memory size of 1073741824 bytes exhausted (tried to allocate 1701601920 bytes)
[15-Mar-2018 16:55:45] 2. Try to backup database …
[15-Mar-2018 16:55:45] Connected to database ohvp_bdd on localhost
[15-Mar-2018 16:55:46] ERROR: Allowed memory size of 1073741824 bytes exhausted (tried to allocate 1701601920 bytes)
[15-Mar-2018 16:55:47] 3. Try to backup database …
[15-Mar-2018 16:55:47] Connected to database ohvp_bdd on localhost
[15-Mar-2018 16:55:47] ERROR: Allowed memory size of 1073741824 bytes exhausted (tried to allocate 1701601920 bytes)
[15-Mar-2018 16:55:49] ERROR: Step aborted: too many attempts!
[15-Mar-2018 16:55:49] 1. Trying to make a list of folders to back up …
[15-Mar-2018 16:55:49] Added "wp-config.php" to backup file list
[15-Mar-2018 16:55:49] Added ".htaccess" to backup file list
[15-Mar-2018 16:55:49] Added "robots.txt" to backup file list
[15-Mar-2018 16:55:49] 1. Trying to generate a file with installed plugin names …
[15-Mar-2018 16:55:49] Added plugin list file "ohvp.pluginlist.txt" with 2,36 KB to backup file list.
[15-Mar-2018 16:55:49] 1. Trying to generate a manifest file …
[15-Mar-2018 16:55:49] Added manifest.json file with 5,80 KB to backup file list.
[15-Mar-2018 16:55:50] 1. Trying to create backup archive …
[15-Mar-2018 16:55:50] Compressing files as ZipArchive. Please be patient, this may take a moment.
[15-Mar-2018 16:55:50] Backup archive created.
[15-Mar-2018 16:55:50] Archive size is 9,80 KB.
[15-Mar-2018 16:55:50] 6 Files with 24,84 KB in Archive.
[15-Mar-2018 16:55:50] One backup file deleted
[15-Mar-2018 16:55:50] 1. Try to send backup file to an FTP server …
[15-Mar-2018 16:55:50] Connected to FTP server: xxxxxxxxxxxxxxxxxxx:21
[15-Mar-2018 16:55:50] FTP client command: USER perspective
[15-Mar-2018 16:55:50] FTP server response: User perspective logged in.
[15-Mar-2018 16:55:50] FTP client command: SYST
[15-Mar-2018 16:55:50] FTP server reply: UNIX
[15-Mar-2018 16:55:50] FTP current folder is: /xxxxxxxx/xxxxxxxxxx/
[15-Mar-2018 16:55:51] FTP client command: PASV
[15-Mar-2018 16:55:51] FTP server reply: Entering passive mode
[15-Mar-2018 16:55:51] Starting upload to FTP …
[15-Mar-2018 16:55:51] Backup transferred to FTP server: /xxxxxxxxxx/2018-03-15_16-55-44_5TYBGWGD01.zip
[15-Mar-2018 16:55:51] One file deleted on FTP server
[15-Mar-2018 16:55:52] One old log deleted
[15-Mar-2018 16:55:52] ERROR: Job has ended with errors in 8 seconds. You must resolve the errors for correct execution.

@stefanp44
Give me your debug info at BackWPUp-> Settings -> Infomation tab -> press Get Debug Info.
Thanks!

Hi,

I had trouble finding it, I couldn’t understand the translation in French ??

Here it is:


WordPress version: 4.9.4
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
WP-Cron url: https://ohvp.fr/wp-cron.php
Server self connect: Response Test O.K.
Document root: /home/ohvp/public_html
Temp folder: /home/ohvp/public_html/wp-content/uploads/backwpup-f01358-temp/
Log folder: /home/ohvp/backup-ohvp/logs/
Server: Apache
Operating System: Linux
PHP SAPI: litespeed
Current PHP user: ohvp
Maximum execution time: 600 seconds
Alternative WP Cron: Off
Disabled WP Cron: Off
CHMOD Dir: 0755
Server Time: 14:48
Blog Time: 15:48
Blog Timezone:
Blog Time offset: 1 hours
Blog language: fr-FR
MySQL Client encoding: utf8
PHP Memory limit: 1G
WP memory limit: 40M
WP maximum memory limit: 1G
Memory in use: 62,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, igbinary, imagick, imap, intl, ionCube Loader, json, libxml, litespeed, mbstring, mcrypt, memcached, mysqli, mysqlnd, openssl, pcntl, pcre, pdo_mysql, pdo_sqlite, posix, readline, redis, session, shmop, sockets, sqlite3, standard, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib


@stefanp44, do you have a particularly large database? Generally it shouldn’t go anywhere near 1 gb of memory usage.

Hi,

No, for this particular website, the database is about 3,5 Mb, so a rather samll one. I set the server memory up to 1G but it is never used up. What troubles me is that one day backups were working fine and the next day I got about 30 emails daily (error notificatons), each for every one of the websites I run.

I searched several posts on the Internet. It seems that one of the recurring reasons is the MariaDB version. This website uses MariaDB 10.2.12. It is highly unlikely that the host would be ok to downgrade, so I guess I’d better wait for an update?

@stefanp44, yes that is more than likely the issue. Unfortunately there’s not too much we can do at our end. You might let your host know about the issue, and they can try to find a solution, or else switch database versions. But it seems to be a well-known issue with this version of MariaDB.

I have the exact same problem. I have spoken to my host who cannot downgrade to the older version which is running on another server where I have sites and the backups work OK. Hopefully this can be resolved soon.

WordPress version: 4.9.4
BackWPup version: 3.4.4
PHP version: 7.0.28 (64bit)
MySQL version: 10.2.13-MariaDB-log-cll-lve
cURL version: 7.54.0
cURL SSL version: OpenSSL/1.0.2k
WP-Cron url: https://xxxxxxxxxxxx/wp-cron.php
Server self connect: Response Test O.K.
Document root: /home/MYsitexxxx/public_html
Temp folder: /home/MYsitexxxx/public_html/wp-content/uploads/backwpup-90a3f0-temp/
Log folder: /home/MYsitexxxx/public_html/wp-content/uploads/backwpup-90a3f0-logs/
Server: LiteSpeed
Operating System: Linux
PHP SAPI: litespeed
Current PHP user: xxxxxxxxxx
Maximum execution time: 60 seconds
Alternative WP Cron: Off
Disabled WP Cron: Off
CHMOD Dir: 493
Server Time: 14:54
Blog Time: 14:54
Blog Timezone: Europe/London
Blog Time offset: 0 hours
Blog language: en-GB
MySQL Client encoding: utf8mb4
PHP Memory limit: 368M
WP memory limit: 368M
WP maximum memory limit: 368M
Memory in use: 16.00 MB
Loaded PHP Extensions:: Core, PDO, Phar, Reflection, SPL, SimpleXML, Zend OPcache, bcmath, bz2, calendar, ctype, curl, date, dom, exif, fileinfo, filter, ftp, gd, gettext, gmp, hash, iconv, imap, ionCube Loader, json, libxml, litespeed, mbstring, mcrypt, mysqli, mysqlnd, openssl, pcntl, pcre, pdo_dblib, pdo_mysql, pdo_sqlite, posix, readline, session, shmop, soap, sockets, sqlite3, standard, tokenizer, wddx, xml, xmlreader, xmlwriter, xsl, zip, zlib

And here is the error message just for a small db back up!

[INFO] BackWPup 3.4.4; A project of Inpsyde GmbH
[INFO] WordPress 4.9.4 on https://Mysitexxxx/
[INFO] Log Level: Normal
[INFO] BackWPup job: Db
[INFO] Logfile is: backwpup_log_90a3f0_2018-03-21_14-47-05.html
[INFO] Backup file is: Db__2018-03-21_14-47-05_KSIKH4FD01.tar.gz
[21-Mar-2018 14:47:05] 1. Try to backup database …
[21-Mar-2018 14:47:05] Connected to database xxxxxxxxxxxx on localhost
[21-Mar-2018 14:47:05] ERROR: Allowed memory size of 385875968 bytes exhausted (tried to allocate 1701601920 bytes)
[21-Mar-2018 14:47:06] 2. Try to backup database …
[21-Mar-2018 14:47:06] Connected to database xxxxxxxxx on localhost
[21-Mar-2018 14:47:06] ERROR: Allowed memory size of 385875968 bytes exhausted (tried to allocate 1183587608 bytes)
[21-Mar-2018 14:47:06] 3. Try to backup database …
[21-Mar-2018 14:47:06] Connected to database XXXXXXXXX on localhost
[21-Mar-2018 14:47:06] ERROR: Allowed memory size of 385875968 bytes exhausted (tried to allocate 1279410544 bytes)
[21-Mar-2018 14:47:07] ERROR: Step aborted: too many attempts!
[21-Mar-2018 14:47:07] 1. Trying to generate a manifest file …
[21-Mar-2018 14:47:07] Added manifest.json file with 5.77 KB to backup file list.
[21-Mar-2018 14:47:07] 1. Trying to create backup archive …
[21-Mar-2018 14:47:07] Compressing files as TarGz. Please be patient, this may take a moment.
[21-Mar-2018 14:47:07] Backup archive created.
[21-Mar-2018 14:47:07] Archive size is 2.16 KB.
[21-Mar-2018 14:47:07] 2 Files with 5.99 KB in Archive.
[21-Mar-2018 14:47:07] 1. Try to send backup file to Dropbox …
[21-Mar-2018 14:47:08] Authenticated with Dropbox of user: xxxxxxx
[21-Mar-2018 14:47:08] Uploading to Dropbox …
[21-Mar-2018 14:47:09] Backup transferred to /xxxxx/Db__2018-03-21_14-47-05_KSIKH4FD01.tar.gz
[21-Mar-2018 14:47:11] One file deleted from Dropbox
[21-Mar-2018 14:47:17] 1. Trying to check database …
[21-Mar-2018 14:47:17] Database check done!
[21-Mar-2018 14:47:17] 2 old logs deleted
[21-Mar-2018 14:47:17] ERROR: Job has ended with errors in 12 seconds. You must resolve the errors for correct execution.

• This reply was modified 6 years, 11 months ago by alan555.

@alan555 My host support came up with a solution this afternoon: if you can set up your server PHP version and activate some PHP extensions, instead of using pdo and mysql, they had me use nd_pdo and nd_mysql.

I don’t know what it means (yet) but it works, the backup is effective again.

@stefanp44
Thank you for the solution for this ??
@alan555 could you please try to enable nd_pdo and nd_mysql instead of pdo and mysql?
Normally, these extensions could be changed from your cPanel PHP setting ??

Thanks Stefan and doungcuong96, it works ??

@alan555
Great to hear that, I will inform this solution to all other users :D.
And this problem should be added to our document too!
Thank you!
I will close this case now, if you still have any problem, please let me know!

Btw, If you find BackWPUp is useful for you, we would really appreciate if you leave a positive review and rating.
This would encourage us to develop new free features and provide free support ??
https://www.ads-software.com/support/plugin/backwpup/reviews/

Reviewed ??

@alan555
Oh, Thank you ??