I should have mentioned, there are many similar errors, one after the other of which the one above is just one.
Some more errors…
[03-Jun-2013 22:32:11 UTC] PHP Warning: gzopen(/home/emptymir/public_html/wp-content/updraft/backup_2013-06-03-1037_Empty_Mirror__Arts_Magazine_amp_Beat_Generation_Resource_93881d045db2-db-table-wp_3wp_activity_monitor_user_statistics.table.gz) [<a href='function.gzopen'>function.gzopen</a>]: failed to open stream: No such file or directory in /home/emptymir/public_html/wp-content/plugins/updraftplus/updraftplus.php on line 1400
[03-Jun-2013 22:32:11 UTC] PHP Warning: gzopen(/home/emptymir/public_html/wp-content/updraft/backup_2013-06-03-1037_Empty_Mirror__Arts_Magazine_amp_Beat_Generation_Resource_93881d045db2-db-table-wp_PO_groups.table.gz) [<a href='function.gzopen'>function.gzopen</a>]: failed to open stream: No such file or directory in /home/emptymir/public_html/wp-content/plugins/updraftplus/updraftplus.php on line 1400
[03-Jun-2013 22:32:11 UTC] PHP Warning: gzopen(/home/emptymir/public_html/wp-content/updraft/backup_2013-06-03-1037_Empty_Mirror__Arts_Magazine_amp_Beat_Generation_Resource_93881d045db2-db-table-wp_PO_post_plugins.table.gz) [<a href='function.gzopen'>function.gzopen</a>]: failed to open stream: No such file or directory in /home/emptymir/public_html/wp-content/plugins/updraftplus/updraftplus.php on line 1400
[03-Jun-2013 22:32:11 UTC] PHP Warning: gzopen(/home/emptymir/public_html/wp-content/updraft/backup_2013-06-03-1037_Empty_Mirror__Arts_Magazine_amp_Beat_Generation_Resource_93881d045db2-db-table-wp_PO_url_plugins.table.gz) [<a href='function.gzopen'>function.gzopen</a>]: failed to open stream: No such file or directory in /home/emptymir/public_html/wp-content/plugins/updraftplus/updraftplus.php on line 1400
The whole thing is over 1000 lines long but if you need more please let me know.
Hi Denise,
With those messages logged, it doesn’t sound possible that the backup is running properly. Are you sure it is?
The most likely cause of those warnings is that the permissions on your wp-content/updraft directory (where files are written to whilst the backup is created) are too restrictive and don’t allow writing. Alternatively, your disk space / account quota may be full.
Please could you send a complete log so that I can have more information? Please use pastebin.com (they are too long to post in the forum here).
Many thanks,
David
Hi David,
Thanks so much for your reply. Well, I don’t know if the backup is running properly. Backups are made, and a copy is stored on the server; another copy is sent to S3. So, it looks to me like it’s working but I don’t really have any way of knowing.
Pastebin said the log was too big so I did a bit of hunting for an alternative and found friendpaste. So here it is: https://friendpaste.com/697eKEcWib01o6zT1foFIn
There is plenty of disk space; we’re only using a small fraction of what’s available to us. So maybe it’s a permissions issue?
Thanks so much!
Denise
Hi Denise,
From the log, I can now see the problem.
You have a statistics plugin which logs a line in the database for every single visitor. The result is a database table (wp_tts_trafficstats) which has a massive 396,465 rows and takes just over 91 minutes to create the backup of. During that 91 minutes, UpdraftPlus does not realise that the whole thing has not stalled, which leads to various bits of logging that wouldn’t otherwise happen.
Such a table is likely to be having a large effect on your site performance, and the most efficient solution all-around would be to use a MySQL tool to purge it of non-recent data. That should not just solve the UpdraftPlus issue, but make your site faster too.
David
Hi David,
Well that’s very strange. Many months ago I installed the Track That Stat plugin – and uninstalled it a month or so later. It’s been a long time and I would have thought it had completely uninstalled.
I will look into that!
Thanks so much.
best,
Denise
From past reports, it doesn’t seem to delete its data upon deinstallation – that has to be done manually.
If you like UpdraftPlus, please give us a 5-star review – http://wordpress.org/support/view/plugin-reviews/updraftplus?rate=5#postform – thank you!
David
Another quick question – do you know of a good tool that would get rid of the table? I’m not very knowledgeable about SQL so not quite sure what I’m looking for.
Never mind, I figured it out! Thanks again for all your help, David!
David, I’m glad to give you 5-star review, and just have done so.
I notice that Track That Stat is no longer available here – hmmm.
I got my database cleaned out and all is well.
Thanks again!
Denise
