- Posts
hello,
I use Total Upkeep to backup my WordPress site on Sunday and Wednesday early mornings (2:00/3:00am). On those mornings, normally around 10:00am, I check to see if my site is up and running, it is not. I cannot log in to my website to see what is wrong. I log into my host and see that my I/O Usage, Physical Memory Usage, IOPS, and sometimes my disk usage are all at/near 100%. My emails – yes emails from BoldGrid – show that the data was backup successfully around 7:00 am. Then I get 4 or 5 more emails from BoldGrid saying backup failure. And those 4 or 5 come around the same time my website cannot be accessed.
This is happening every time and my website is inaccessible! what is going on? I am disabling Total Upkeep now before I get a 5th email this morning. This is ridiculous. I have pictures and have kept the last several backup emails.
Hi Danielle-
Sorry to hear about the issues backing up your site, especially that it’s exceeding your hosting account limits.
From what you’ve described, it sounds like your site might be too large for your hosting account to handle a full site backup.
The most common cause of this is that you might be backing up backups from another plugin. Check your wp-content directory for a directory called ai1wm-backups or updraft (All in One WP Migration or Updraft), or any other backup plugin you might have used in the past.
Another common cause of this is simply having a lot of media uploads. You may consider excluding your wp-content/uploads directory from your regular backups, and back up your uploads folder manually less frequently.
We also might be able to identify some ways to keep your backup size down from the information in your logs. If you’re running the most recent version of Total Upkeep, large files are logged for troubleshooting.
Navigate to Total Upkeep > Tools > Logs and look for the file starting with archive- that corresponds to your most recent backup. Copy and paste that here, and we’ll be able to see if the plugin has detected any large files you might be able to exclude from your backups or even delete if you don’t need them.
Hi Jesse!
Thanks for responding so quickly!
You were correct; there is an ai1wmp-backups directory. I renamed it to add “.donotuse” but I can certainly delete the directory if necessary.
You were correct again, my website is based on travel and I’m a photographer so it is media file heavy.
Below is the archive log from this morning.
Version 5.5.1
archive-1603260016.log[2020-10-21 06:00:16 UTC] Last error: Array (
[type] => 2
[message] => unpack(): Type L: not enough input, need 4, have 0
[file] => /home/selfis5/public_html/wp-content/plugins/w3-total-cache/Cache_File.php
[line] => 169
)[2020-10-21 06:00:16 UTC] PHP Version: 7.4.9
[2020-10-21 06:00:16 UTC] WordPress Version: 5.5.1
[2020-10-21 06:00:16 UTC] Total Upkeep version: 1.14.6
[2020-10-21 06:00:16 UTC] Backup process initialized.
[2020-10-21 06:00:17 UTC] ——————————————————————————–
[2020-10-21 06:00:17 UTC] Starting dump of database…
[2020-10-21 06:00:17 UTC] Memory usage – limit / current / peak memory usage: 2048M / 81694832 (77.91 MB) / 82506920 (79 MB)
[2020-10-21 06:00:18 UTC] Database info: Array (
[wp_actionscheduler_actions] => 703
[wp_actionscheduler_claims] => 0
[wp_actionscheduler_groups] => 2
[wp_actionscheduler_logs] => 2107
[wp_ahm_assets] => 0
[wp_ahm_download_stats] => 0
[wp_ahm_emails] => 0
[wp_cmplz_cookiebanners] => 1
[wp_cmplz_cookies] => 85
[wp_cmplz_dnsmpd] => 0
[wp_cmplz_services] => 23
[wp_commentmeta] => 60
[wp_comments] => 106
[wp_eopa_global_rule_table] => 0
[wp_eopa_poptions_table] => 0
[wp_eopa_rowoption_table] => 0
[wp_eopa_temp_table] => 0
[wp_gamipress_logs] => 85
[wp_gamipress_logs_meta] => 318
[wp_gamipress_user_earnings] => 0
[wp_gamipress_user_earnings_meta] => 0
[wp_ihc_download_monitor_limit] => 0
[wp_ihc_reason_for_cancel_delete_levels] => 0
[wp_ihc_security_login] => 0
[wp_ihc_user_logs] => 0
[wp_ihc_user_sites] => 0
[wp_ihc_woo_product_level_relations] => 0
[wp_ihc_woo_products] => 0
[wp_lifterlms_api_keys] => 0
[wp_lifterlms_events] => 0
[wp_lifterlms_notifications] => 0
[wp_lifterlms_product_to_voucher] => 0
[wp_lifterlms_quiz_attempts] => 0
[wp_lifterlms_sessions] => 2
[wp_lifterlms_user_postmeta] => 0
[wp_lifterlms_voucher_code_redemptions] => 0
[wp_lifterlms_vouchers_codes] => 0
[wp_lifterlms_webhooks] => 0
[wp_links] => 0
[wp_litespeed_img_optm] => 0
[wp_litespeed_optimizer] => 0
[wp_loginizer_logs] => 49
[wp_nf3_action_meta] => 5129
[wp_nf3_actions] => 213
[wp_nf3_chunks] => 6
[wp_nf3_field_meta] => 7535
[wp_nf3_fields] => 343
[wp_nf3_form_meta] => 4933
[wp_nf3_forms] => 54
[wp_nf3_object_meta] => 0
[wp_nf3_objects] => 0
[wp_nf3_relationships] => 0
[wp_nf3_upgrades] => 54
[wp_options] => 4309
[wp_postmeta] => 17725
[wp_posts] => 4206
[wp_sbi_instagram_feeds_posts] => 81
[wp_sbi_instagram_posts] => 81
[wp_smush_dir_images] => 0
[wp_tcb_api_error_log] => 0
[wp_td_fields] => 16
[wp_td_groups] => 3
[wp_term_relationships] => 5853
[wp_term_taxonomy] => 3263
[wp_termmeta] => 16
[wp_terms] => 3263
[wp_tge_answers] => 381
[wp_tge_questions] => 39
[wp_tqb_event_log] => 0
[wp_tqb_results] => 4
[wp_tqb_results_links] => 4
[wp_tqb_tests] => 0
[wp_tqb_tests_items] => 0
[wp_tqb_user_answers] => 52
[wp_tqb_users] => 3
[wp_tqb_variations] => 5
[wp_usermeta] => 236
[wp_users] => 4
[wp_w3tc_cdn_pathmap] => 0
[wp_w3tc_cdn_queue] => 1
[wp_wc_download_log] => 0
[wp_wc_product_meta_lookup] => 0
[wp_wc_tax_rate_classes] => 2
[wp_wc_webhooks] => 0
[wp_weforms_entries] => 0
[wp_weforms_entrymeta] => 0
[wp_woocommerce_api_keys] => 0
[wp_woocommerce_attribute_taxonomies] => 0
[wp_woocommerce_downloadable_product_permissions] => 0
[wp_woocommerce_log] => 0
[wp_woocommerce_order_itemmeta] => 0
[wp_woocommerce_order_items] => 0
[wp_woocommerce_payment_tokenmeta] => 0
[wp_woocommerce_payment_tokens] => 0
[wp_woocommerce_sessions] => 11
[wp_woocommerce_shipping_zone_locations] => 0
[wp_woocommerce_shipping_zone_methods] => 0
[wp_woocommerce_shipping_zones] => 0
[wp_woocommerce_tax_rate_locations] => 0
[wp_woocommerce_tax_rates] => 0
[wp_wp_quiz_emails] => 0
[wp_wp_quiz_play_data] => 0
[wp_wp_quiz_players] => 0
[wp_wp_quiz_user_actions] => 0
[wp_yoast_indexable] => 0
[wp_yoast_migrations] => 3
[wp_yoast_primary_term] => 0
[wp_yoast_seo_links] => 1898
[wp_yoast_seo_meta] => 7030
)[2020-10-21 06:00:37 UTC] Dump of database complete! $status = 1
[2020-10-21 06:00:37 UTC] Memory usage – limit / current / peak memory usage: 2048M / 81711416 (77.93 MB) / 265334176 (253 MB)
[2020-10-21 06:00:37 UTC] ——————————————————————————–
[2020-10-21 06:01:00 UTC] Database dump file added to file list: /home/selfis5/boldgrid_backup/selfis5_wo770.20201021-060018.sql / 73223212 (69.83 MB)
[2020-10-21 06:01:00 UTC] Starting archiving of files. Chosen compressor: php_zip
[2020-10-21 06:01:00 UTC] Memory usage – limit / current / peak memory usage: 2048M / 126982464 (121.10 MB) / 265334176 (253 MB)
[2020-10-21 06:05:29 UTC] Last error: Array (
[type] => 8
[message] => unserialize(): Error at offset 132706 of 336769 bytes
[file] => /home/selfis5/public_html/wp-content/plugins/w3-total-cache/Cache_File.php
[line] => 138
)[2020-10-21 06:05:29 UTC] Total files / size archived: 67071 / 7046314377 (6.56 GB)
[2020-10-21 06:05:30 UTC] Starting to close the zip file.
[2020-10-21 06:05:30 UTC] Memory usage – limit / current / peak memory usage: 2048M / 128524336 (122.57 MB) / 265334176 (253 MB)
[2020-10-21 07:17:50 UTC] Finished closing the zip file.
[2020-10-21 07:17:50 UTC] Memory usage – limit / current / peak memory usage: 2048M / 128524240 (122.57 MB) / 265334176 (253 MB)
[2020-10-21 07:17:50 UTC] Last error: Array (
[type] => 8
[message] => mysqli_query(): send of 435 bytes failed with errno=32 Broken pipe
[file] => /home/selfis5/public_html/wp-includes/wp-db.php
[line] => 2033
)[2020-10-21 07:17:50 UTC] Archiving of files complete!
[2020-10-21 07:17:50 UTC] Archive filepath / size: /home/selfis5/boldgrid_backup/boldgrid-backup-selfishmetravel.com-f7fa4d64-20201021-060100.zip / 6716230548 (6.25 GB)
[2020-10-21 07:17:50 UTC] Memory usage – limit / current / peak memory usage: 2048M / 129631272 (123.63 MB) / 265334176 (253 MB)
[2020-10-21 07:17:55 UTC] Backup complete!
[2020-10-21 07:17:55 UTC] Memory usage – limit / current / peak memory usage: 2048M / 128551904 (122.60 MB) / 265334176 (253 MB)I appreciate any help I can get.
Thank you!
Danielle
Hi Danielle-
Thanks for the additional information! This log didn’t notice any individual large files, but it does say the full backup is about 6.25GB. Since you mentioned you’ve got a lot of photography, I’d speculate this is kind of a “death by a thousand cuts” type of failure.
Going off this log file, your backup took about 1 hour and 16 minutes, for a total size of 6.25GB. A little back-of-the-napkin math shows that to be around 1.47MB/Second of disk I/O, and it hit a maximum memory usage of 253MB, which might well come close to or exceed your hosting account’s limitations. Most shared hosting providers will allow you a spike in disk I/O or memory, but this was sustained for over an hour so it might trigger action from your server.
Here are a couple of things I’d do for this. First, it looks like you’re using W3 Total Cache, so you can save a bit by excluding your disk cache directory. But the main thing is going to be excluding your media uploads.
Navigate to Total Upkeep > Settings > Backup Storage and select the option for a Custom Backup for Files and Folders.
Add the following to your Exclude line (I’m guessing exactly what your All in One WP Migration directory is after you renamed it):
,/wp-content/cache,/wp-content/uploads,/wp-content/ai1wm-backups.donotuse
Don’t forget that first comma to separate it from the default excludes.
Using these settings will ensure you can recover your website from a fatal error or even a hack. Keeping a good backup of your media files will take a little extra work though.
What I do for this website is create a backup of each month’s media and store it in a safe location. Since WordPress already saves your media in time-based directories, you don’t need to make new backups of past folders over and over again.
So, once per month, create a backup of that month’s media files and store it some place safe like Google Drive. So I’ll have backups of wp-content/uploads/2020/01, 02, 03, and so on. That way you’ll always be safe, and your regular backups won’t crash the site.
Okay Jesse, I’ve excluded the wp-content string as you suggested and set a monthly reminder to manually backup the images from the previous month.
Thank you for all your help. Hopefully, this eliminates some stress.
I won’t post again unless I run into a problem. Have a great rest of the year!
Danielle
- The topic ‘[Resolved] Backups depleting system resources’ is closed to new replies.
