Receiving Warning errors while taking Plesk backups

[Madhu1]

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

 

[IgorG]

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.