Support » Plugin: BackWPup - WordPress Backup Plugin » Allowed memory size of XXX exhausted (tried to allocate)

  • Resolved Stéphane PISKORZ

    (@stefanp44)


    Hi,

    I have more and more trouble with backups: they were really working fine up until two weeks ago and then somehows, all my websites aren’t backing up anymore. I didn’t change any of my setings, I just keep getting daily error logs

    I get two kinds of error. This is the first one


    [INFO] BackWPup 3.4.4; Un projet de Inpsyde GmbH
    [INFO] WordPress 4.9.4 sur xxxxxxxxxxxxxxxxx
    [INFO] niveau de suivi : Normal (traduit)
    [INFO] Opération BackWPup : database-plugin.list
    [INFO] Le fichier journal est : backwpup_log_f01358_2018-03-15_02-51-57.html
    [INFO] Fichier sauvegarde : 2018-03-15_02-51-57_J7YBGWD601.zip
    [15-Mar-2018 02:51:57] 1. Tentative de dump de la base de données…
    [15-Mar-2018 02:51:57] Connexion à la base de données ohvp_bdd sur localhost
    [15-Mar-2018 02:51:57] ERREUR: Allowed memory size of 1073741824 bytes exhausted (tried to allocate 1701601920 bytes)
    [15-Mar-2018 02:51:58] 2. Tentative de dump de la base de données…
    [15-Mar-2018 02:51:59] Connexion à la base de données ohvp_bdd sur localhost
    [15-Mar-2018 02:51:59] ERREUR: Allowed memory size of 1073741824 bytes exhausted (tried to allocate 1701601920 bytes)
    [15-Mar-2018 02:52:00] 3. Tentative de dump de la base de données…
    [15-Mar-2018 02:52:00] Connexion à la base de données ohvp_bdd sur localhost
    [15-Mar-2018 02:52:00] ERREUR: Allowed memory size of 1073741824 bytes exhausted (tried to allocate 1701601920 bytes)
    [15-Mar-2018 02:52:01] ERREUR: Étape abandonnée : trop de tentatives !
    [15-Mar-2018 02:52:01] 1. Tentative de création d’une liste des dossiers à sauvegarder…
    [15-Mar-2018 02:52:01] Ajout "wp-config.php" à la liste des fichiers à sauvegarder
    [15-Mar-2018 02:52:01] Ajout ".htaccess" à la liste des fichiers à sauvegarder
    [15-Mar-2018 02:52:01] Ajout "robots.txt" à la liste des fichiers à sauvegarder
    [15-Mar-2018 02:52:01] 1. Tentative de création d’un fichier avec les noms des extensions installées…
    [15-Mar-2018 02:52:02] Ajout de la liste des fichiers des extensions "ohvp.pluginlist.txt" avec 2,35 KB à la liste des fichiers à sauvegarder.
    [15-Mar-2018 02:52:02] 1. Tentative de création d’un manifeste…
    [15-Mar-2018 02:52:02] Ajout du fichier manifeste .json avec 5,80 KB à la liste des fichiers de la sauvegarde.
    [15-Mar-2018 02:52:02] 1. Tentative de création de l’archive…
    [15-Mar-2018 02:52:02] Compression des fichiers en ZipArchive. Veuillez patienter, cela peut prendre un certain temps.
    [15-Mar-2018 02:52:04] Archive de sauvegarde créée.
    [15-Mar-2018 02:52:04] La taille de l'archive est de 9,86 KB.
    [15-Mar-2018 02:52:04] 6 fichiers avec 24,88 KB à sauvegarder
    [15-Mar-2018 02:52:06] Un fichier de sauvegarde supprimé
    [15-Mar-2018 02:52:06] 1. Tentative d’envoi de la sauvegarde vers un serveur FTP…
    [15-Mar-2018 02:52:06] Connecté au serveur FTP: xxxxxxxxxxxxxxxxxxx:21
    [15-Mar-2018 02:52:06] Commande client FTP: USER perspective
    [15-Mar-2018 02:52:07] Réponse du serveur FTP: User perspective logged in.
    [15-Mar-2018 02:52:07] Commande client FTP: SYST
    [15-Mar-2018 02:52:07] Réponse du serveur FTP: UNIX
    [15-Mar-2018 02:52:07] Le répertoire FTP actuel est : xxxxxxxxxxxxxxx/xxxxxxxxxxxxxx
    [15-Mar-2018 02:52:07] Commande client FTP: PASV
    [15-Mar-2018 02:52:07] Réponse du serveur FTP: Passage en mode passif
    [15-Mar-2018 02:52:07] Début du chargement par FTP …
    [15-Mar-2018 02:52:07] Sauvegarde envoyée vers le serveur FTP: /xxxxxxx/2018-03-15_02-51-57_J7YBGWD601.zip
    [15-Mar-2018 02:52:07] Un fichier supprimé sur le serveur FTP
    [15-Mar-2018 02:52:07] Un ancien journal supprimé
    [15-Mar-2018 02:52:07] ERREUR: L’opération s’est terminée avec des erreurs en 10 secondes. Vous devez corriger les erreurs pour une exécution correcte.

    Second one is

    [15-Mar-2018 01:38:22] AVERTISSEMENT : ftp_nb_fput(): Entering Passive Mode (109,234,162,45,206,43)
    [15-Mar-2018 01:38:22] ERREUR: Impossible de transférer la sauvegarde vers le serveur FTP ! (impossible to transfer backup to FTP server)

    Is there something I did wrong?

Viewing 15 replies - 1 through 15 (of 20 total)
  • Plugin Support duongcuong96

    (@duongcuong96)

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

    Plugin Support duongcuong96

    (@duongcuong96)

    @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 1 year, 7 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.

    Plugin Support duongcuong96

    (@duongcuong96)

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

    Plugin Support duongcuong96

    (@duongcuong96)

    @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://wordpress.org/support/plugin/backwpup/reviews/

    Reviewed 😉

    Plugin Support duongcuong96

    (@duongcuong96)

    @alan555
    Oh, Thank you 😉

Viewing 15 replies - 1 through 15 (of 20 total)
  • The topic ‘Allowed memory size of XXX exhausted (tried to allocate)’ is closed to new replies.