Backup Failed on Server

  • Resolved dwturner

    (@dwturner)


    2 years, 4 months ago

    I have tried several times to create a backup but each attempt has ended in a failure message. The request frequency started at 2s, then I tried 5s and then 10s. I also changed the number of rows from 10000 to 1000 but none of these various settings resulted in the successful creation of a backup file.

    Here is a copy of the log file from my latest failed attempt:

    `Date: 2022-07-15 11:17:00 America/New_York
    Reloads: ON
    User mode: Free
    BackupGuard version: 1.6.8.7
    Supported archive version: 5
    Database prefix: jvg_
    Site URL: https://staging.nfrccevents.org
    Home URL: https://staging.nfrccevents.org
    Uploads path: /home/customer/www/staging.nfrccevents.org/public_html/wp-content/uploads
    Site installation: standard
    OS: Linux
    Server: Apache
    User agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:102.0) Gecko/20100101 Firefox/102.0
    PHP version: 7.4.30
    MySQL version: 5.7.38
    Int size: 8
    Int lib: gmp
    Memory limit: 768M
    Max execution time: 120
    Disk free space: 867.4GB
    CURL available: Yes
    Openssl version: OpenSSL 1.1.1n FIPS 18 Mar 2022
    CURL version: 7.66.0 / SSL: OpenSSL/1.1.1q-fips / libz: 1.2.11
    Email notifications: OFF
    FTP passive mode: OFF
    Exclude paths: wp-content/uploads/backup-guard
    Tables to exclude:
    Number of rows to backup: 1000
    AJAX request frequency: 10000
    Environment: WordPress 6.0.1
    Backup mode: Manual
    Backup type: files,database

    2022-07-15 11:17:02: Start backup
    2022-07-15 11:17:02: Reload method set to ajax
    2022-07-15 11:17:02: ——- Reload Service ——-
    2022-07-15 11:17:14: Start backup database
    2022-07-15 11:17:14: Total tables to backup: 48
    2022-07-15 11:17:14: Total rows to backup: 1081
    2022-07-15 11:17:14: Start backup table: jvg_options
    2022-07-15 11:17:14: End backup table: jvg_options
    2022-07-15 11:17:14: Start backup table: jvg_actionscheduler_actions
    2022-07-15 11:17:14: End backup table: jvg_actionscheduler_actions
    2022-07-15 11:17:14: Start backup table: jvg_actionscheduler_claims
    2022-07-15 11:17:14: End backup table: jvg_actionscheduler_claims
    2022-07-15 11:17:14: Start backup table: jvg_actionscheduler_groups
    2022-07-15 11:17:14: End backup table: jvg_actionscheduler_groups
    2022-07-15 11:17:14: Start backup table: jvg_actionscheduler_logs
    2022-07-15 11:17:14: End backup table: jvg_actionscheduler_logs
    2022-07-15 11:17:14: Start backup table: jvg_commentmeta
    2022-07-15 11:17:14: End backup table: jvg_commentmeta
    2022-07-15 11:17:14: Start backup table: jvg_comments
    2022-07-15 11:17:14: End backup table: jvg_comments
    2022-07-15 11:17:14: Start backup table: jvg_links
    2022-07-15 11:17:14: End backup table: jvg_links
    2022-07-15 11:17:14: Start backup table: jvg_postmeta
    2022-07-15 11:17:14: End backup table: jvg_postmeta
    2022-07-15 11:17:14: Start backup table: jvg_posts
    2022-07-15 11:17:14: End backup table: jvg_posts
    2022-07-15 11:17:14: Start backup table: jvg_sgs_log_events
    2022-07-15 11:17:14: End backup table: jvg_sgs_log_events
    2022-07-15 11:17:14: Start backup table: jvg_sgs_log_visitors
    2022-07-15 11:17:14: End backup table: jvg_sgs_log_visitors
    2022-07-15 11:17:14: Start backup table: jvg_term_relationships
    2022-07-15 11:17:14: End backup table: jvg_term_relationships
    2022-07-15 11:17:14: Start backup table: jvg_term_taxonomy
    2022-07-15 11:17:14: End backup table: jvg_term_taxonomy
    2022-07-15 11:17:14: Start backup table: jvg_termmeta
    2022-07-15 11:17:14: End backup table: jvg_termmeta
    2022-07-15 11:17:14: Start backup table: jvg_terms
    2022-07-15 11:17:14: End backup table: jvg_terms
    2022-07-15 11:17:14: Start backup table: jvg_usermeta
    2022-07-15 11:17:14: End backup table: jvg_usermeta
    2022-07-15 11:17:14: Start backup table: jvg_users
    2022-07-15 11:17:14: End backup table: jvg_users
    2022-07-15 11:17:14: Start backup table: jvg_wc_admin_note_actions
    2022-07-15 11:17:14: End backup table: jvg_wc_admin_note_actions
    2022-07-15 11:17:14: Start backup table: jvg_wc_admin_notes
    2022-07-15 11:17:14: End backup table: jvg_wc_admin_notes
    2022-07-15 11:17:14: Start backup table: jvg_wc_category_lookup
    2022-07-15 11:17:14: End backup table: jvg_wc_category_lookup
    2022-07-15 11:17:14: Start backup table: jvg_wc_customer_lookup
    2022-07-15 11:17:14: End backup table: jvg_wc_customer_lookup
    2022-07-15 11:17:14: Start backup table: jvg_wc_download_log
    2022-07-15 11:17:14: End backup table: jvg_wc_download_log
    2022-07-15 11:17:14: Start backup table: jvg_wc_order_coupon_lookup
    2022-07-15 11:17:14: End backup table: jvg_wc_order_coupon_lookup
    2022-07-15 11:17:14: Start backup table: jvg_wc_order_product_lookup
    2022-07-15 11:17:14: End backup table: jvg_wc_order_product_lookup
    2022-07-15 11:17:14: Start backup table: jvg_wc_order_stats
    2022-07-15 11:17:14: End backup table: jvg_wc_order_stats
    2022-07-15 11:17:14: Start backup table: jvg_wc_order_tax_lookup
    2022-07-15 11:17:14: End backup table: jvg_wc_order_tax_lookup
    2022-07-15 11:17:14: Start backup table: jvg_wc_product_attributes_lookup
    2022-07-15 11:17:14: End backup table: jvg_wc_product_attributes_lookup
    2022-07-15 11:17:14: Start backup table: jvg_wc_product_download_directories
    2022-07-15 11:17:14: End backup table: jvg_wc_product_download_directories
    2022-07-15 11:17:14: Start backup table: jvg_wc_product_meta_lookup
    2022-07-15 11:17:14: End backup table: jvg_wc_product_meta_lookup
    2022-07-15 11:17:14: Start backup table: jvg_wc_rate_limits
    2022-07-15 11:17:14: End backup table: jvg_wc_rate_limits
    2022-07-15 11:17:14: Start backup table: jvg_wc_reserved_stock
    2022-07-15 11:17:14: End backup table: jvg_wc_reserved_stock
    2022-07-15 11:17:14: Start backup table: jvg_wc_tax_rate_classes
    2022-07-15 11:17:14: End backup table: jvg_wc_tax_rate_classes
    2022-07-15 11:17:14: Start backup table: jvg_wc_webhooks
    2022-07-15 11:17:14: End backup table: jvg_wc_webhooks
    2022-07-15 11:17:14: Start backup table: jvg_woocommerce_api_keys
    2022-07-15 11:17:14: End backup table: jvg_woocommerce_api_keys
    2022-07-15 11:17:14: Start backup table: jvg_woocommerce_attribute_taxonomies
    2022-07-15 11:17:14: End backup table: jvg_woocommerce_attribute_taxonomies
    2022-07-15 11:17:14: Start backup table: jvg_woocommerce_downloadable_product_permissions
    2022-07-15 11:17:14: End backup table: jvg_woocommerce_downloadable_product_permissions
    2022-07-15 11:17:14: Start backup table: jvg_woocommerce_log
    2022-07-15 11:17:14: End backup table: jvg_woocommerce_log
    2022-07-15 11:17:14: Start backup table: jvg_woocommerce_order_itemmeta
    2022-07-15 11:17:15: End backup table: jvg_woocommerce_order_itemmeta
    2022-07-15 11:17:15: Start backup table: jvg_woocommerce_order_items
    2022-07-15 11:17:15: End backup table: jvg_woocommerce_order_items
    2022-07-15 11:17:15: Start backup table: jvg_woocommerce_payment_tokenmeta
    2022-07-15 11:17:15: End backup table: jvg_woocommerce_payment_tokenmeta
    2022-07-15 11:17:15: Start backup table: jvg_woocommerce_payment_tokens
    2022-07-15 11:17:15: End backup table: jvg_woocommerce_payment_tokens
    2022-07-15 11:17:15: Start backup table: jvg_woocommerce_sessions
    2022-07-15 11:17:15: End backup table: jvg_woocommerce_sessions
    2022-07-15 11:17:15: Start backup table: jvg_woocommerce_shipping_zone_locations
    2022-07-15 11:17:15: End backup table: jvg_woocommerce_shipping_zone_locations
    2022-07-15 11:17:15: Start backup table: jvg_woocommerce_shipping_zone_methods
    2022-07-15 11:17:15: End backup table: jvg_woocommerce_shipping_zone_methods
    2022-07-15 11:17:15: Start backup table: jvg_woocommerce_shipping_zones
    2022-07-15 11:17:15: End backup table: jvg_woocommerce_shipping_zones
    2022-07-15 11:17:15: Start backup table: jvg_woocommerce_tax_rate_locations
    2022-07-15 11:17:15: End backup table: jvg_woocommerce_tax_rate_locations
    2022-07-15 11:17:15: Start backup table: jvg_woocommerce_tax_rates
    2022-07-15 11:17:15: End backup table: jvg_woocommerce_tax_rates
    2022-07-15 11:17:15: End backup database
    2022-07-15 11:17:15: Backup database total duration: 1 second
    2022-07-15 11:17:15: ——- Reload Service ——-
    2022-07-15 11:17:28: Start backup files
    2022-07-15 11:17:28: ——- Start prepare file tree ——-
    2022-07-15 11:20:30: SGExceptionExecutionTimeError: Execution timeout error [File: /home/customer/www/staging.nfrccevents.org/public_html/wp-content/plugins/backup/com/core/backup/SGBackup.php, Line: 137, URL: /wp-admin/admin-ajax.php]`

    Any suggestions would be appreciated. Thank you in advance.

    The page I need help with: [log in to see the link]

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support Support Backup Guard

    (@backup-guard)

    Dear @dwturner,

    Thanks a lot for bringing the issue to our attention.

    We are afraid, the reported issue is a specific one and needs a deep investigation.

    Kindly ask you to contact us via [email protected] email address, so we can assist accordingly.

    Please, include the support thread URL in your email, so we can identify you easily.

    Looking ahead to hearing from you soon.

    Best,
    BackupGuard Team

    Thread Starter dwturner

    (@dwturner)

    I have replied via email as instructed.

    Plugin Support Support Backup Guard

    (@backup-guard)

    Dear @dwturner ,

    Thanks for getting back to us.

    We have received your email and will ensure to continue the conversation over there to avoid any misunderstanding.

    Best,
    BackupGuard Team

    Thread Starter dwturner

    (@dwturner)

    Thank you for the in-depth analysis of my site. Your recommendation of either using your cloud backup service or increasing the maximum execution time might be helpful. As you can see from the log file included above, the max exe time is currently set to 120 seconds. Given that the entire site, including the database is approxiately 150mb, could you please suggest a maximumn execution time that might be appropriate.

    Plugin Support Support Backup Guard

    (@backup-guard)

    Dear @dwturner ,

    Thanks for getting back to us.

    Kindly ask you to try to increase the Max execution time minimum to 600.
    But if you can increase it to 1200, it would be great.

    Please, note, that we constantly working on the plugin update and will ensure to improve its performance in the future, so you won’t face issues like that anymore.

    Best,
    BackupGuard Team

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Backup Failed on Server’ is closed to new replies.