Backup stuck while saving database

Hi,

Backups are *always* created in wp-content/updraft – but if you have some storage set (e.g. FTP), then they are then uploaded there and removed from wp-content/updraft after successful upload.

If you post a full log file (use pastebin.com and post the link here), then I may be able to suggest what is going wrong.

Best wishes,
David

Hi David,
Here’s a link : https://dl.dropboxusercontent.com/u/29826503/groupez.net/updraft.txt
I am not quite sure this is the very latest one but I DL it from the link :
“Télécharger le dernier journal” (download latest log)
in the UpdraftPlus Plugin Settings page.
Thanks for your help.
ps. fyi, I have just checked my FTP : it works quite well and haven’t made any changes on it (url, id or pw) since several months.

David,
Another here :
https://dl.dropboxusercontent.com/u/29826503/groupez.net/log.4334198e6528.txt
I think this one is the VERY latest one, as I got it directly from the \wp-content\updraft\ directory.
Rgds.

Hi,

> UpdraftPlus WordPress backup plugin (https://updraftplus.com): 1.7.20

Please update to the latest UpdraftPlus release (1.8.5 – there have been several since 1.7.20), and then see if you get the same problem.

David

Hello David,
I am now on 1.8.5
The issue is still the same.
Here’s the latest log.
Rgds.

Hi,

I think PHP must be crashing for some reason. It seems to be deterministic. Do you have access to the PHP error log? If not, then please ask the web hosting company to forward it to you. There’s likely to be something logged in there about why it’s crashing.

David

David,
Here’s what I have access to : here
Which one(s) would you like to read ?
Paloprisk

None of those look like PHP error logs…

I am going to call them and ask.
—
By the mean time, here’s the UpdraftPlus Plugin Settings screen.
Maybe you’ll find in there some relevant info concerning this issue.
Paloprisk

Hi David,

I haven’t got yet the PHP logs from my web hosting company.

But, knowing that my backups seem to hang during the backup of the “wp-posts” table (see here), I have made a copy of the section of the log where UpdraftPlus tries to backup this table for you to analyze it and see if something might be interesting in there (the log is here).

Another interesting pic is this table that shows you that since 01-01-2014, backups appear to always hang on the DataBase itself.

Let me know if you need some more info.
Paloprisk

Hello David,
I contacted my web hosting company.
They said the PHP logs are definitely available to users provided they write themselves the correct routine to DL the logs or place them in any of the hosted directories.
They suggested that this routine be included into a php script.
I don’t have any idea how to write such a routine as my PHP knowledge is very poor.
—
BTW, could you have a look at the pics and log that I sent you yesterday ?
Thanks for your suggestions and help.
Paloprisk

Hi,

What an unhelpful web hosting company! They could have enabled it for you in the time it took them to write that.

See here: https://perishablepress.com/advanced-php-error-handling-via-htaccess/
Use the one under “Preserve (log) your site’s PHP errors via htaccess” – but alter the path to fit your web hosting setup (you might have to ask your web hosting company to get the right info”, and add the line:

php_value error_reporting 8191

To confirm that PHP error logging is on, upload and run this PHP file in your webspace:

<?php trigger_error(“Test!!”); ?>

That message should then appear in your log file if you’ve got it set up right. If not, then it’s back to the web hosting company for further advice as to why it’s not logging…

Then, with PHP error logging turned on, run a fresh backup, and then check the log file.

The pictures/log you sent yesterday didn’t add any new information to the ones from before. They just confirmed that we need to see the PHP error log.

David

Hello David,
Thanks for your precious info.
Do I have to add the “8191” line at the end of the script ?
As in :

# enable PHP error logging
php_flag  log_errors on
php_value error_log  /(my_web_hosting_path)/PHP_errors.log
php_value error_reporting 8191

Paloprisk

Hi,

Yes, that’s what the addition to the .htaccess file should look like.

David

Hi David,
I am back … it’s been kinda long time, but I’m back.
Actually, my hosting company is so reluctant to support its customers that I decided to do TWO things :
#1 – increase memory allowance to WP plugins in my php.ini
#2 – download the latest version of UpdraftPlus (1.8.8)
And so far … so good (see pic) !
—
One question though : how can I make sure this dB backup is coherent ?
I tried to DL it and open it with 7zip but to no avail, even after I renamed it .tar or .gz.
How can I read this file “easily” to double-check it ?
Thanks.
Yann