Backup failed after changing row amount

Resolved bamstaff
(@bamstaff)

5 years, 3 months ago

This is a follow up to a previous post. My backup kept failing and support asked me to change the “Number of rows to backup at once” to 1000. I have made the change and tried to perform a new backup. It got to about 45% and then failed. Below is the log file content:

Date: 2020-12-17 16:51:00 UTC
Reloads: ON
User mode: Free
BackupGuard version: 1.5.3
Supported archive version: 5
Database prefix: wp_fhtl_
Site URL: http://www.bamjamboise.com
Home URL: http://www.bamjamboise.com
Uploads path: /var/www/vhosts/bamjamboise.com/httpdocs/wp-content/uploads
Site installation: standard
OS: Linux
Server: Apache
User agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36
PHP version: 5.6.40
MySQL version: 5.5.5
Int size: 8
Int lib: gmp
Memory limit: 128M
Max execution time: 30
Disk free space: 391.8GB
CURL available: Yes
Openssl version: OpenSSL 1.0.1e-fips 11 Feb 2013
CURL version: 7.29.0 / SSL: NSS/3.44 / libz: 1.2.7
Email notifications: OFF
FTP passive mode: OFF
Exclude paths:
Tables to exclude:
Number of rows to backup: 1000
AJAX request frequency: 2000
Environment: WordPress 5.2.9
Backup mode: Manual
Backup type: files,database

2020-12-17 16:51:00: Start backup
2020-12-17 16:51:00: Reload method set to ajax
2020-12-17 16:51:00: Start backup database
2020-12-17 16:51:00: Total tables to backup: 66
2020-12-17 16:51:00: Total rows to backup: 35620
2020-12-17 16:51:00: Start backup table: wp_fhtl_options
2020-12-17 16:51:00: End backup table: wp_fhtl_options
2020-12-17 16:51:00: Start backup table: wp_fhtl_commentmeta
2020-12-17 16:51:00: End backup table: wp_fhtl_commentmeta
2020-12-17 16:51:00: Start backup table: wp_fhtl_comments
2020-12-17 16:51:00: End backup table: wp_fhtl_comments
2020-12-17 16:51:00: Start backup table: wp_fhtl_eg_grids
2020-12-17 16:51:00: End backup table: wp_fhtl_eg_grids
2020-12-17 16:51:00: Start backup table: wp_fhtl_eg_item_elements
2020-12-17 16:51:00: End backup table: wp_fhtl_eg_item_elements
2020-12-17 16:51:00: Start backup table: wp_fhtl_eg_item_skins
2020-12-17 16:51:00: End backup table: wp_fhtl_eg_item_skins
2020-12-17 16:51:00: Start backup table: wp_fhtl_eg_navigation_skins
2020-12-17 16:51:00: End backup table: wp_fhtl_eg_navigation_skins
2020-12-17 16:51:00: Start backup table: wp_fhtl_ewwwio_images
2020-12-17 16:51:00: End backup table: wp_fhtl_ewwwio_images
2020-12-17 16:51:00: Start backup table: wp_fhtl_links
2020-12-17 16:51:00: End backup table: wp_fhtl_links
2020-12-17 16:51:00: Start backup table: wp_fhtl_postmeta
2020-12-17 16:51:00: End backup table: wp_fhtl_postmeta
2020-12-17 16:51:00: Start backup table: wp_fhtl_posts
2020-12-17 16:51:00: End backup table: wp_fhtl_posts
2020-12-17 16:51:00: Start backup table: wp_fhtl_redirection_404
2020-12-17 16:51:00: End backup table: wp_fhtl_redirection_404
2020-12-17 16:51:00: Start backup table: wp_fhtl_redirection_groups
2020-12-17 16:51:00: End backup table: wp_fhtl_redirection_groups
2020-12-17 16:51:00: Start backup table: wp_fhtl_redirection_items
2020-12-17 16:51:00: End backup table: wp_fhtl_redirection_items
2020-12-17 16:51:00: Start backup table: wp_fhtl_redirection_logs
2020-12-17 16:51:00: End backup table: wp_fhtl_redirection_logs
2020-12-17 16:51:00: Start backup table: wp_fhtl_revslider_css
2020-12-17 16:51:00: End backup table: wp_fhtl_revslider_css
2020-12-17 16:51:00: Start backup table: wp_fhtl_revslider_layer_animations
2020-12-17 16:51:00: End backup table: wp_fhtl_revslider_layer_animations
2020-12-17 16:51:00: Start backup table: wp_fhtl_revslider_navigations
2020-12-17 16:51:00: End backup table: wp_fhtl_revslider_navigations
2020-12-17 16:51:00: Start backup table: wp_fhtl_revslider_sliders
2020-12-17 16:51:00: End backup table: wp_fhtl_revslider_sliders
2020-12-17 16:51:00: Start backup table: wp_fhtl_revslider_slides
2020-12-17 16:51:00: End backup table: wp_fhtl_revslider_slides
2020-12-17 16:51:00: Start backup table: wp_fhtl_revslider_static_slides
2020-12-17 16:51:00: End backup table: wp_fhtl_revslider_static_slides
2020-12-17 16:51:00: Start backup table: wp_fhtl_term_relationships
2020-12-17 16:51:00: End backup table: wp_fhtl_term_relationships
2020-12-17 16:51:00: Start backup table: wp_fhtl_term_taxonomy
2020-12-17 16:51:00: End backup table: wp_fhtl_term_taxonomy
2020-12-17 16:51:00: Start backup table: wp_fhtl_termmeta
2020-12-17 16:51:00: End backup table: wp_fhtl_termmeta
2020-12-17 16:51:00: Start backup table: wp_fhtl_terms
2020-12-17 16:52:00: End backup table: wp_fhtl_terms
2020-12-17 16:52:00: Start backup table: wp_fhtl_usermeta
2020-12-17 16:52:00: End backup table: wp_fhtl_usermeta
2020-12-17 16:52:00: Start backup table: wp_fhtl_users
2020-12-17 16:52:00: End backup table: wp_fhtl_users
2020-12-17 16:52:00: Start backup table: wp_fhtl_wfBadLeechers
2020-12-17 16:52:00: End backup table: wp_fhtl_wfBadLeechers
2020-12-17 16:52:00: Start backup table: wp_fhtl_wfBlockedIPLog
2020-12-17 16:53:00: End backup table: wp_fhtl_wfBlockedIPLog
2020-12-17 16:53:00: Start backup table: wp_fhtl_wfBlocks
2020-12-17 16:56:00: SGExceptionExecutionTimeError: Execution timeout error [File: /var/www/vhosts/bamjamboise.com/httpdocs/wp-content/plugins/backup/com/core/backup/SGBackup.php, Line: 128, URL: /wp-admin/admin-ajax.php]

Viewing 7 replies - 1 through 7 (of 7 total)

Thread Starter bamstaff
(@bamstaff)

5 years, 3 months ago

During a backup, I would also occasionally get this error message;

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator at root@localhost to inform them of the time this error occurred, and the actions you performed just before this error.

More information about this error may be available in the server error log.

Support Backup Guard
(@backup-guard)

5 years, 3 months ago

Dear @bamstaff ,

Thanks for giving us more info on the case.

The following table seems to be quite large: wp_fhtl_wfBlocks

Could you make the Number of Rows to Backup at once 100 this time and let us know about the result?

Thread Starter bamstaff
(@bamstaff)

5 years, 3 months ago

I’m getting the same result. In the middle I get this error:
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator at root@localhost to inform them of the time this error occurred, and the actions you performed just before this error.

More information about this error may be available in the server error log.

Here is the log file:
Date: 2020-12-18 18:47:00 UTC
Reloads: ON
User mode: Free
BackupGuard version: 1.5.3
Supported archive version: 5
Database prefix: wp_fhtl_
Site URL: http://www.bamjamboise.com
Home URL: http://www.bamjamboise.com
Uploads path: /var/www/vhosts/bamjamboise.com/httpdocs/wp-content/uploads
Site installation: standard
OS: Linux
Server: Apache
User agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36
PHP version: 5.6.40
MySQL version: 5.5.5
Int size: 8
Int lib: gmp
Memory limit: 128M
Max execution time: 30
Disk free space: 391.9GB
CURL available: Yes
Openssl version: OpenSSL 1.0.1e-fips 11 Feb 2013
CURL version: 7.29.0 / SSL: NSS/3.44 / libz: 1.2.7
Email notifications: OFF
FTP passive mode: OFF
Exclude paths:
Tables to exclude:
Number of rows to backup: 100
AJAX request frequency: 2000
Environment: WordPress 5.2.9
Backup mode: Manual
Backup type: files,database

2020-12-18 18:47:00: Start backup
2020-12-18 18:47:00: Reload method set to ajax
2020-12-18 18:47:00: Start backup database
2020-12-18 18:47:00: Total tables to backup: 68
2020-12-18 18:47:00: Total rows to backup: 35630
2020-12-18 18:47:00: Start backup table: wp_fhtl_options
2020-12-18 18:47:00: End backup table: wp_fhtl_options
2020-12-18 18:47:00: Start backup table: wp_fhtl_commentmeta
2020-12-18 18:47:00: End backup table: wp_fhtl_commentmeta
2020-12-18 18:47:00: Start backup table: wp_fhtl_comments
2020-12-18 18:47:00: End backup table: wp_fhtl_comments
2020-12-18 18:47:00: Start backup table: wp_fhtl_eg_grids
2020-12-18 18:47:00: End backup table: wp_fhtl_eg_grids
2020-12-18 18:47:00: Start backup table: wp_fhtl_eg_item_elements
2020-12-18 18:47:00: End backup table: wp_fhtl_eg_item_elements
2020-12-18 18:47:00: Start backup table: wp_fhtl_eg_item_skins
2020-12-18 18:48:00: End backup table: wp_fhtl_eg_item_skins
2020-12-18 18:48:00: Start backup table: wp_fhtl_eg_navigation_skins
2020-12-18 18:48:00: End backup table: wp_fhtl_eg_navigation_skins
2020-12-18 18:48:00: Start backup table: wp_fhtl_ewwwio_images
2020-12-18 18:48:00: End backup table: wp_fhtl_ewwwio_images
2020-12-18 18:48:00: Start backup table: wp_fhtl_links
2020-12-18 18:48:00: End backup table: wp_fhtl_links
2020-12-18 18:48:00: Start backup table: wp_fhtl_postmeta
2020-12-18 18:51:00: SGExceptionExecutionTimeError: Execution timeout error [File: /var/www/vhosts/bamjamboise.com/httpdocs/wp-content/plugins/backup/com/core/backup/SGBackup.php, Line: 128, URL: /wp-admin/admin-ajax.php]

Support Backup Guard
(@backup-guard)

5 years, 3 months ago

Dear @bamstaff ,

Could you make the Request Frequency (from the plugin settings) 10 seconds and complete multiple backups?
Once done, please, also send the backup logs of those backups to us via wetransfer.com so we can check and compare them.
Please send the logs via wetransfer.com using the link retrieving option.
Like this: https://prnt.sc/qr3ntv

Support Backup Guard
(@backup-guard)

5 years, 3 months ago

Dear @bamstaff ,

We are wondering whether you did as recommended in our previous message and what result you had.

Thread Starter bamstaff
(@bamstaff)

5 years, 3 months ago

Hi and thank you for all your responses. I ended up finding another solution to get this taken care of. I appreciate you checking in.

Support Backup Guard
(@backup-guard)

5 years, 3 months ago

Dear @bamstaff ,

Understood. In any case, if you decide to get back to us and continue using our service we will make sure to have the problem you were facing fixed.
So, hopefully we will have the chance to collaborate.

Take care.

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘Backup failed after changing row amount’ is closed to new replies.

Tags