• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

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