Tagged: Backup Schedule, Total Upkeep
-
AuthorPosts
-
Danielle LewisGuest
My backups have been failing for a week now. My host has increased the memory_limit and post_max_size values but I ran the backup manually and it failed (see log below) and I’m at a loss to know what’s ging on.
[2023-11-10 18:08:00 UTC] PHP Version: 7.4.33
[2023-11-10 18:08:00 UTC] WordPress Version: 6.3.2
[2023-11-10 18:08:00 UTC] Total Upkeep version: 1.15.7
[2023-11-10 18:08:00 UTC] getpgid support: Available
[2023-11-10 18:08:00 UTC] Backup process initialized.
[2023-11-10 18:08:00 UTC] Backup process initialized.
[2023-11-10 18:08:01 UTC] Process id: 2659938
[2023-11-10 18:08:01 UTC] ——————————————————————————–
[2023-11-10 18:08:01 UTC] Starting dump of database…
[2023-11-10 18:08:01 UTC] Memory usage – limit / current / peak memory usage: 2048M / 27427072 (26.16 MB) / 29768384 (28 MB)
[2023-11-10 18:08:01 UTC] Database info: Array
(
[qtzpO_actionscheduler_actions] => 703
[qtzpO_actionscheduler_claims] => 0
[qtzpO_actionscheduler_groups] => 2
[qtzpO_actionscheduler_logs] => 2107
[qtzpO_ahm_asset_links] => 0
[qtzpO_ahm_assets] => 0
[qtzpO_ahm_download_stats] => 0
[qtzpO_ahm_emails] => 0
[qtzpO_ahm_sessions] => 0
[qtzpO_ahm_social_conns] => 0
[qtzpO_burst_goals] => 0
[qtzpO_burst_sessions] => 470
[qtzpO_burst_statistics] => 595
[qtzpO_cmplz_cookiebanners] => 1
[qtzpO_cmplz_cookies] => 178
[qtzpO_cmplz_dnsmpd] => 0
[qtzpO_cmplz_services] => 39
[qtzpO_commentmeta] => 78
[qtzpO_comments] => 106
[qtzpO_eopa_global_rule_table] => 0
[qtzpO_eopa_poptions_table] => 0
[qtzpO_eopa_rowoption_table] => 0
[qtzpO_eopa_temp_table] => 0
[qtzpO_gamipress_logs] => 85
[qtzpO_gamipress_logs_meta] => 318
[qtzpO_gamipress_user_earnings] => 0
[qtzpO_gamipress_user_earnings_meta] => 0
[qtzpO_ihc_download_monitor_limit] => 0
[qtzpO_ihc_reason_for_cancel_delete_levels] => 0
[qtzpO_ihc_security_login] => 0
[qtzpO_ihc_user_logs] => 0
[qtzpO_ihc_user_sites] => 0
[qtzpO_ihc_woo_product_level_relations] => 0
[qtzpO_ihc_woo_products] => 0
[qtzpO_jetpack_sync_queue] => 0
[qtzpO_lifterlms_api_keys] => 0
[qtzpO_lifterlms_events] => 0
[qtzpO_lifterlms_notifications] => 0
[qtzpO_lifterlms_product_to_voucher] => 0
[qtzpO_lifterlms_quiz_attempts] => 0
[qtzpO_lifterlms_sessions] => 2
[qtzpO_lifterlms_user_postmeta] => 0
[qtzpO_lifterlms_voucher_code_redemptions] => 0
[qtzpO_lifterlms_vouchers_codes] => 0
[qtzpO_lifterlms_webhooks] => 0
[qtzpO_links] => 0
[qtzpO_litespeed_img_optm] => 0
[qtzpO_litespeed_optimizer] => 0
[qtzpO_loginizer_logs] => 49
[qtzpO_nf3_action_meta] => 5130
[qtzpO_nf3_actions] => 213
[qtzpO_nf3_chunks] => 6
[qtzpO_nf3_field_meta] => 7535
[qtzpO_nf3_fields] => 343
[qtzpO_nf3_form_meta] => 4933
[qtzpO_nf3_forms] => 54
[qtzpO_nf3_object_meta] => 0
[qtzpO_nf3_objects] => 0
[qtzpO_nf3_relationships] => 0
[qtzpO_nf3_upgrades] => 54
[qtzpO_options] => 2085
[qtzpO_postmeta] => 32889
[qtzpO_posts] => 8498
[qtzpO_rsssl_csp_log] => 0
[qtzpO_rsssl_xmlrpc] => 0
[qtzpO_sbi_feeds] => 1
[qtzpO_smush_dir_images] => 0
[qtzpO_tcb_api_error_log] => 2
[qtzpO_td_fields] => 18
[qtzpO_td_groups] => 3
[qtzpO_term_relationships] => 7155
[qtzpO_term_taxonomy] => 1983
[qtzpO_termmeta] => 18
[qtzpO_terms] => 1983
[qtzpO_tge_answers] => 1899
[qtzpO_tge_questions] => 211
[qtzpO_thrive_reporting_logs] => 13
[qtzpO_tqb_event_log] => 1757
[qtzpO_tqb_results] => 75
[qtzpO_tqb_results_links] => 75
[qtzpO_tqb_tests] => 35
[qtzpO_tqb_tests_items] => 70
[qtzpO_tqb_user_answers] => 4073
[qtzpO_tqb_users] => 252
[qtzpO_tqb_variations] => 522
[qtzpO_usermeta] => 430
[qtzpO_users] => 9
[qtzpO_w3tc_cdn_pathmap] => 0
[qtzpO_w3tc_cdn_queue] => 1
[qtzpO_wc_download_log] => 0
[qtzpO_wc_product_meta_lookup] => 0
[qtzpO_wc_tax_rate_classes] => 2
[qtzpO_wc_webhooks] => 0
[qtzpO_weforms_entries] => 0
[qtzpO_weforms_entrymeta] => 0
[qtzpO_woocommerce_api_keys] => 0
[qtzpO_woocommerce_attribute_taxonomies] => 0
[qtzpO_woocommerce_downloadable_product_permissions] => 0
[qtzpO_woocommerce_log] => 0
[qtzpO_woocommerce_order_itemmeta] => 0
[qtzpO_woocommerce_order_items] => 0
[qtzpO_woocommerce_payment_tokenmeta] => 0
[qtzpO_woocommerce_payment_tokens] => 0
[qtzpO_woocommerce_sessions] => 11
[qtzpO_woocommerce_shipping_zone_locations] => 0
[qtzpO_woocommerce_shipping_zone_methods] => 0
[qtzpO_woocommerce_shipping_zones] => 0
[qtzpO_woocommerce_tax_rate_locations] => 0
[qtzpO_woocommerce_tax_rates] => 0
[qtzpO_wp_quiz_emails] => 0
[qtzpO_wp_quiz_play_data] => 0
[qtzpO_wp_quiz_players] => 0
[qtzpO_wp_quiz_user_actions] => 0
[qtzpO_wppopups_hits] => 942
[qtzpO_yoast_indexable] => 2299
[qtzpO_yoast_indexable_hierarchy] => 2298
[qtzpO_yoast_migrations] => 26
[qtzpO_yoast_primary_term] => 157
[qtzpO_yoast_prominent_words] => 8096
[qtzpO_yoast_seo_links] => 4952
[qtzpO_yoast_seo_meta] => 8126
[qtzpO_zcwc_forms] => 0
)[2023-11-10 18:08:16 UTC] Dump of database complete! $status = 1
[2023-11-10 18:08:16 UTC] Memory usage – limit / current / peak memory usage: 2048M / 29665288 (28.29 MB) / 430696880 (411 MB)
[2023-11-10 18:08:16 UTC] ——————————————————————————–
[2023-11-10 18:08:16 UTC] Retrieving file list.
[2023-11-10 18:08:25 UTC] Backup process running: Yes (pgid = 3148207)
[2023-11-10 18:08:29 UTC] Backup process running: Yes (pgid = 3148207)
[2023-11-10 18:08:33 UTC] Backup process running: Yes (pgid = 3148207)
[2023-11-10 18:08:37 UTC] Retrieving backup directory.
[2023-11-10 18:08:37 UTC] Adding Database to file list.
[2023-11-10 18:08:37 UTC] Database dump file added to file list: /home/selfis5/boldgrid_backup/selfis5_wo770.20231110-180801.sql / 160149784 (152.73 MB)
[2023-11-10 18:08:37 UTC] Starting archiving of files. Chosen compressor: php_zip
[2023-11-10 18:08:37 UTC] Memory usage – limit / current / peak memory usage: 2048M / 103539768 (98.74 MB) / 430696880 (411 MB)
[2023-11-10 18:08:37 UTC] ——————————————————————————–
[2023-11-10 18:08:37 UTC] Starting to analyze filelist…
[2023-11-10 18:08:37 UTC] Memory usage – limit / current / peak memory usage: 2048M / 101357512 (96.66 MB) / 430696880 (411 MB)
[2023-11-10 18:08:38 UTC] Backup process running: Yes (pgid = 3148207)
[2023-11-10 18:08:41 UTC] Finished analyzing filelist!
[2023-11-10 18:08:41 UTC] Memory usage – limit / current / peak memory usage: 2048M / 105556136 (100.67 MB) / 430696880 (411 MB)
[2023-11-10 18:08:56 UTC] Backup process running: Yes (pgid = 3148207)
[2023-11-10 18:09:01 UTC] Backup process running: Yes (pgid = 3148207)
[2023-11-10 18:09:02 UTC] Backup process running: Yes (pgid = 3148207)
[2023-11-10 18:09:07 UTC] Backup process running: Yes (pgid = 3148207)
[2023-11-10 18:09:12 UTC] Backup process running: Yes (pgid = 3148207)
[2023-11-10 18:09:17 UTC] Backup process running: Yes (pgid = 3148207)
[2023-11-10 18:09:22 UTC] Backup process running: Yes (pgid = 3148207)
[2023-11-10 18:09:27 UTC] Backup process running: Yes (pgid = 3148207)
[2023-11-10 18:09:32 UTC] Backup process running: Yes (pgid = 3148207)
[2023-11-10 18:09:43 UTC] Backup process running: Yes (pgid = 3148207)
[2023-11-10 18:09:48 UTC] Backup process running: Yes (pgid = 3148207)
[2023-11-10 18:09:48 UTC] Backup process running: Yes (pgid = 3148207)
[2023-11-10 18:09:53 UTC] Backup process running: Yes (pgid = 3148207)
[2023-11-10 18:09:58 UTC] Backup process running: Yes (pgid = 3148207)
[2023-11-10 18:10:04 UTC] Backup process running: Yes (pgid = 3148207)
[2023-11-10 18:10:08 UTC] Backup process running: Yes (pgid = 3148207)
[2023-11-10 18:10:13 UTC] Backup process running: Yes (pgid = 3148207)
[2023-11-10 18:10:15 UTC] Total files / size archived: 112192 / 13627114555 (12.69 GB)
[2023-11-10 18:10:15 UTC] Starting to close the zip file.
[2023-11-10 18:10:16 UTC] Memory usage – limit / current / peak memory usage: 2048M / 107585704 (102.60 MB) / 430696880 (411 MB)
[2023-11-10 18:10:32 UTC] Backup process running: NoBrandon CKeymasterHi Danielle,
Sorry to hear you’re having trouble with Total Upkeep backups but let’s see if we can help!
Being that your backups have been failing for a week do you remember making any changes to your website that could have effected the backup process? It could be something like adding or updating a theme or plugin, updating WordPress core, PHP version etc.
One thing I noticed is you are running your backups using PHP zip as your chosen compressor type.
[2023-11-10 18:08:37 UTC] Starting archiving of files. Chosen compressor: php_zip
You might benefit from switching your backup compressor type, navigate to Total Upkeep > Settings > Backup Process. If System Zip is available, choose that option. System Zip is significantly faster than the PclZip or ZipArchive libraries, and may use fewer resources. Attempt to create another backup using the Default compression level.
If the backup still fails, try reducing the Compression Level. A setting of 0 will not compress the backup at all, using the lowest amount of CPU and memory. This does mean that the Disk Input/Output is increased due to the larger file size, however.
You can also run a sanity check to see if the server is indeed killing the backup process. This usually this happens when the backup takes too long complete. The sanity check will run a smaller sized backup that only includes .txt files with the purpose of determining if a smaller sized backup will process.
In order to run the Sanity Check you’ll need to create a “custom backup” and in the includes section For “Files & Folders” enter *.txt. Also exclude all database tables from your backup.
After your backup completes, visit your logs section to verify that it did. This sanity check will let us know if this issue is with your backup itself or if there’s something going on outside of that like with your server or hosting resource limits.I hope this helps Danielle! We look forward to answering any further questions you might have.
Danielle LewisGuestI changed the backup compressor to System Zip and the backup completed successfully! Thank you, Brandon!!
For backstory, I was traveling so no changes were made on the website. I just started receiving backup failures. I also did a sanity check and that failed too.
Anyway, thanks again!
Brandon CKeymasterHi Danielle,
I’m happy to hear you were able to get you backups back up and running! It’s always fantastic when a solution works out.
Remember, if you’re ever on the road again and run into any issues or have any questions about your backups or restorations, don’t hesitate to reach out. We’re here to help make sure things run smoothly no matter where you are.
Safe travels!
-
AuthorPosts