Multiple DB backups when doing file backup
-
I have UD set to do daily DB backups, and a weekly file backup on a Wednesday. Every Wednesday, I get multiple DB backups while UD goes through the file backup process (which can take a while with a few GB of files). All of a sudden I lose all of my previous days’ DB backups because so many are taken on the one day. Any way to stop this?
-
Hi,
Please could you send us a copy of the latest backup log? This can be found in the UpdraftPlus Existing Backups tab.
The contents will be too long to post here directly, but you can use an online service such as Dropbox or Pastebin, and post the link here.
Best Wishes,
BryleHere’s the 3 log files from yesterday:
https://www.dropbox.com/s/vqlgcmlau4dafvl/log.a3183b3598c6.txt?dl=0
https://www.dropbox.com/s/wtvf481k4ljouox/log.3bc48743d45e.txt?dl=0
https://www.dropbox.com/s/uubasfwluqopmpq/log.2ad0291d87a0.txt?dl=0Rgds,
Doug.Hi Doug,
It appears that, due to the length of time that the file backups are taking and the fact that this is done in a single run, the database backup event is not being unscheduled correctly.
Please could you try adding the following line to your wp-config.php file, and check the backups next Wednesday:
define('UPDRAFTPLUS_SEMAPHORE_LOCK_WAIT', 7810);The line should be placed above the line reading ‘stop editing’.
Looks like I’m still getting the same problem – 3 database backups so far today, and the files backup has yet to complete. Here’s the 3 log files created so far:
https://www.dropbox.com/s/u4g736yl723zt09/log.db529b3aeb84.txt?dl=0
https://www.dropbox.com/s/us586xb3kk4r4ro/log.6a99c348f314.txt?dl=0
https://www.dropbox.com/s/wjo1gcln1nq2llp/log.eb996ec13bb0.txt?dl=0Rgds,
Doug.Hi Doug,
Please could you install the free WP Crontrol plugin, then go to Tools->Cron Events?
How many times do the following events appear in the list?
updraft_backup
updraft_backup_databaseThey only appear once each in the list as expected.
Doug.
It’s Wednesday again and again I’m getting multiple DB backups. Really need some help with this ASAP. Thanks.
Hi Doug,
Please could you send us the newest set of backup logs?
https://www.dropbox.com/s/qti1lsvhex8jbyz/log.d96999d42652.txt?dl=0
https://www.dropbox.com/s/xcha17k2utvv123/log.3b1caa86452f.txt?dl=0
https://www.dropbox.com/s/65lm9wuyjo7i3fe/log.cd3f71ca1331.txt?dl=0I’ve had a total of 9 emails about backups this morning – 8 are about DB backups and only 1 is for files & database. Really need this resolved ASAP.
Hi Doug,
Three separate backups indicates that the WordPress core task scheduler is kicking off the backup three times. The backups are significantly far apart in terms of time. This indicates that there’s something in your WP scheduled task list which keeps re-saving the job back to the list, causing it to recur. This is likely to be either a long-running task, or something that runs very frequently. Unfortunately the WP scheduling engine has a lot of bugs which are easy to trigger if you’re not careful, particularly in very frequent or long-running tasks (because of WP saving all tasks in a single row in the databases, which is a really bad mis-design). If you install a plugin like WP Crontrol, and then look at the list of registered tasks, that will indicate possibilities. Or alternatively there is https://github.com/humanmade/Cavalcade which replaces the WP scheduled task engine with one that removes some of the design flaws.
David
The topic ‘Multiple DB backups when doing file backup’ is closed to new replies.