• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

Receiving Warning errors while taking Plesk backups

Madhu1

New Pleskian
Hi we are getting the following error message during our scheduled backup

Could anyone please assist...

Warning: mysql "wordpress_9"

Not all the data was backed up into /mnt/backup/web03/domains/domain.com.au/databases/wordpress_9_1 successfully. Use of chdir('') or chdir(undef) as chdir() is deprecated at /opt/psa/PMM/agents/shared/Storage/Bundle.pm line 39.

mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `backupdb_wp_commentmeta` at row: 717
 
Lost connection to MySQL server during query when dumping table

This is a reported bug in mysql and you need to tune the "time_out" parameters to get rid of this issue.

mysql> show variables like "%timeout%";
+----------------------------+-------+

| Variable_name | Value |
+----------------------------+-------+

| connect_timeout | 10 |
| delayed_insert_timeout | 300 |
| innodb_lock_wait_timeout | 50 |
| innodb_rollback_on_timeout | OFF |
| interactive_timeout | 28800 |
| net_read_timeout | 30 |
| net_write_timeout | 60 |
| slave_net_timeout | 3600 |
| table_lock_wait_timeout | 50 |
| wait_timeout | 28800 |
+----------------------------+-------+
10 rows in set (0.00 sec)

This are the current values being set in the server. Please consider tuning the above parameters in the server.
Reference Link: http://bugs.mysql.com/bug.php?id=1370

Also, you need to increase the parameter "wait_timeout" necessarily in /etc/my.cnf:

wait_timeout = 31536000

Do not forget to restart mysql service after changes.
 
Back
Top