Backup Hangs

Hi,

Please could you ask your hosts to check the MySQL server error log for any issues that are occurring around the time of the backup?
Could they also check the PHP error logs for any errors or timeouts occurring around the time of the backup?

I cleared my error log, ran UpdraftPlus, and then check the log to see the following. It doesn’t mean anything to me, but perhaps to you?
20180410T181049: https://www.mchesleyjohnson.com/wp-admin/admin-ajax.php
mmap() failed: [12] Cannot allocate memory
mmap() failed: [12] Cannot allocate memory
PHP Fatal error: Out of memory (allocated 192937984) (tried to allocate 1499136 bytes) in /hermes/walnaweb10a/b1769/moo.mcjohnsonfineartcom/mchesleyjohnson/wp-includes/wp-db.php on line 1889
20180410T181417: https://www.mchesleyjohnson.com/wp-cron.php
mmap() failed: [12] Cannot allocate memory
mmap() failed: [12] Cannot allocate memory
PHP Fatal error: Out of memory (allocated 192937984) (tried to allocate 1499136 bytes) in /hermes/walnaweb10a/b1769/moo.mcjohnsonfineartcom/mchesleyjohnson/wp-includes/wp-db.php on line 1889
20180410T183045: https://www.mchesleyjohnson.com/wp-cron.php
mysqldump: Error 2020: Got packet bigger than ‘max_allowed_packet’ bytes when dumping table wp_pttl_itsec_logs at row: 1009
mmap() failed: [12] Cannot allocate memory
mmap() failed: [12] Cannot allocate memory
PHP Fatal error: Out of memory (allocated 192937984) (tried to allocate 1499136 bytes) in /hermes/walnaweb10a/b1769/moo.mcjohnsonfineartcom/mchesleyjohnson/wp-includes/wp-db.php on line 1889
20180410T183831: https://www.mchesleyjohnson.com/wp-cron.php
mmap() failed: [12] Cannot allocate memory
mmap() failed: [12] Cannot allocate memory
PHP Fatal error: Out of memory (allocated 192937984) (tried to allocate 1523712 bytes) in /hermes/walnaweb10a/b1769/moo.mcjohnsonfineartcom/mchesleyjohnson/wp-includes/wp-db.php on line 1889
20180410T184343: https://www.mchesleyjohnson.com/wp-cron.php
mmap() failed: [12] Cannot allocate memory
mmap() failed: [12] Cannot allocate memory
PHP Fatal error: Out of memory (allocated 192937984) (tried to allocate 1523712 bytes) in /hermes/walnaweb10a/b1769/moo.mcjohnsonfineartcom/mchesleyjohnson/wp-includes/wp-db.php on line 1889
20180410T185141: https://www.mchesleyjohnson.com/wp-cron.php
mmap() failed: [12] Cannot allocate memory
mmap() failed: [12] Cannot allocate memory
PHP Fatal error: Out of memory (allocated 192937984) (tried to allocate 1523712 bytes) in /hermes/walnaweb10a/b1769/moo.mcjohnsonfineartcom/mchesleyjohnson/wp-includes/wp-db.php on line 1889

This seems to be the key line:

mysqldump: Error 2020: Got packet bigger than ‘max_allowed_packet’ bytes when dumping table wp_pttl_itsec_logs at row: 1009

Hi,

It appears that there is a large piece of data that is larger than the current maximum allowed packet size.

Please could you ask your hosts/server admin to check the ‘max_allowed_packet’ configuration (this should be found in the my.cnf file), and increase this if possible.

I would also recommend increasing the PHP memory limit if possible.

Hi – It seems it is a problem with the security log file. I’ve modified the option for iThemes Security Pro to put the log in a text file rather than in the database, and then I cleared the database. This has fixed the problem. So, it’s not a problem with Updraft Plus, I believe. THanks for your help.