Backups partially completed due to errors in client databses

cPanel, Industry leading hosting platform with world-class support.
Post Reply
MrIver
Posts: 6
Joined: March 28th, 2020, 8:37 pm

Backups partially completed due to errors in client databses

Post by MrIver »

Hi Guys,

We are a happy user of JetBackup on several of our shared hosting servers.

However, we have an issue.

On every server we constantly have 5-8 clients who do not get a complete backup, because they have a faulty database.

Right now we are manually contacting these customers to get them to fix their database, so their backup can run fully, but this is not a scaleable solution. Many of the customers do not know how to fix their db, so they dont have a database-backup at all.

Therefore i have these questions:

1 - Is there anyway to automatically notifying clients if their backup do not complete fully?
2 - OR can we setup Jetbackup so it backup the database eventhough the database has corrupt tables?

Thanks!
JetAppsAnton
Staff Member
Staff Member
Posts: 54
Joined: March 2nd, 2019, 2:40 am

Re: Backups partially completed due to errors in client databses

Post by JetAppsAnton »

Hi MrIver,

Glad to hear of your positive experience using JetBackup and sorry to hear about your issue.

For Item #1, JetBackup currently does not have a built-in feature to send notifications to
for each corresponding accounts regarding their backups.
With that said, I will be reaching out to our devs to further discuss this feature and consider for a future release of JetBackup. May I also suggest opening up a request for this feature at our request
site: request.jetapps.com

For Item #2, You can achieve this by enabling the "force" flag on Settings > Performance and this should let jetbackup proceed with the mysqldump regardless of the corrupted tables/database.
https://docs.jetbackup.com/manual/whm/S ... force-flag

For more information about the mysqldump force flag, please visit the official documentation here:
https://dev.mysql.com/doc/refman/8.0/en ... dump_force

Best Regards,
Anton, JetApps Team.
Anton, JetApps Team
MrIver
Posts: 6
Joined: March 28th, 2020, 8:37 pm

Re: Backups partially completed due to errors in client databses

Post by MrIver »

Hi Anton,

Thank you very much for your reply.

We already got "Force" set to yes:

https://imgur.com/a/FQnaYFw

However we still got errors like the one below, making the database backup fail:

Code: Select all

[31 March 2020 12:02:09 AM +0200] 	Databases
[31 March 2020 12:02:09 AM +0200] 		Grabbing...
[31 March 2020 12:02:09 AM +0200] 			Dumping Database 'cust_wp2' (Engine: MySQL)...FAILED
[31 March 2020 12:02:09 AM +0200] [ERROR] mysqldump: Error 1194: Table 'wp_woocommerce_sessions' is marked as crashed and should 

Code: Select all

[28 March 2020 12:03:39 AM +0100] 	Databases
[28 March 2020 12:03:39 AM +0100] 		Grabbing...
[28 March 2020 12:03:39 AM +0100] 			Dumping Database 'cust2_wp2' (Engine: MySQL)...FAILED
[28 March 2020 12:03:39 AM +0100] [ERROR] mysqldump: Error 1194: Table 'wp_wfhits' is marked as crashed and should be repaired when dumping table `wp_wfhits` at row: 865
mysqldump: Error 1194: Table 'wp_wflogins' is marked as crashed and should be repaired when dumping table `wp_wflogins` at row: 800
Something we are missing in the setup?
MrIver
Posts: 6
Joined: March 28th, 2020, 8:37 pm

Re: Backups partially completed due to errors in client databses

Post by MrIver »

Hi Anton,

Any idea of what we are missing in our setup in order to make it work?

Thanks!
JetAppsAnton
Staff Member
Staff Member
Posts: 54
Joined: March 2nd, 2019, 2:40 am

Re: Backups partially completed due to errors in client databses

Post by JetAppsAnton »

Hi MrIver,

Apologies for the delay getting back to you. Could you please verify if the following databases are missing or incomplete from your backups after setting the force flag?

Just to clarify,
With --force, mysqldump prints the error message, but it also writes an SQL comment containing the view definition to the dump output and continues executing.
You will still receive an error message for the broken tables as mysqldump will still return an error over to JetBackup. The main benefit with the --force flag is that mysqldump will continue to create a dumpfile of your database after encountering an error.

For example, when creating a dump without the force flag, MySQL will stop generating the dump file at the point of receiving an error:

Code: Select all

mysqldump broken_test_database > test.sql
-rw-r--r--.  1 root root 1277 Apr  2 19:30 test.sql
while with the --force flag, it will still print out an error but continues to execute and dump the rest of the database.

Code: Select all

mysqldump --force broken_test_database > test2.sql
-rw-r--r--.  1 root root 1748 Apr  2 19:31 test2.sql
Ultimately, you would want to have theses tables/databases repaired for a reliable backup.

If you still encounter issue, please don't hesitate to reach out and open a ticket to our helpdesk at support@jetapps.com.

Best Regards,
Anton, JetApps Team.
Anton, JetApps Team
MrIver
Posts: 6
Joined: March 28th, 2020, 8:37 pm

Re: Backups partially completed due to errors in client databses

Post by MrIver »

Hi Anton,

Thanks for getting back.

Yes I can confirm that the databases are not beeing backed up for customers with errors.

Example: CustomerA

Code: Select all

[03 April 2020 12:02:54 AM +0200] 	Databases
[03 April 2020 12:02:54 AM +0200] 		Grabbing...
[03 April 2020 12:02:54 AM +0200] 			Dumping Database 'CustomerA' (Engine: MySQL)...FAILED
[03 April 2020 12:02:54 AM +0200] [ERROR] mysqldump: Error 1194: Table 'wp_woocommerce_sessions' is marked as crashed and should be repaired when dumping table `wp_woocommerce_sessions` at row: 0
When i log into cPanel as this customer and look under JetBackup -> Database Backup i get "No Backups Found"

https://imgur.com/a/hrtKUMk

When running backups for that table commandline i get the same error:

Code: Select all

[root@XX ~]# mysqldump --force CustomerA_DB > test2.sql
mysqldump: Error 1194: Table 'wp_woocommerce_sessions' is marked as crashed and should be repaired when dumping table `wp_woocommerce_sessions` at row: 0
We are using JetBackup version Version 4.0.18
JetAppsAnton
Staff Member
Staff Member
Posts: 54
Joined: March 2nd, 2019, 2:40 am

Re: Backups partially completed due to errors in client databses

Post by JetAppsAnton »

Hi MrIver,

Thank you for the additional information, may I suggest opening a ticket with us at support@jetapps.com so that our support technicians could have a further look into your issue and provide better assistance.

Thank You,
Anton, JetApps Team.
Anton, JetApps Team
MrIver
Posts: 6
Joined: March 28th, 2020, 8:37 pm

Re: Backups partially completed due to errors in client databses

Post by MrIver »

Thanks - we have opened a ticket with you.
Post Reply