Dump fails: MySQL server has gone away

Created:

2016-11-16 13:04:38 UTC

Modified:

2017-08-08 13:42:18 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Dump fails: MySQL server has gone away

Applicable to:

  • Plesk 12.5 for Linux

Symptoms

Backup shows the error:

DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/psa/PMM/agents/shared/Db/MysqlDbiBackend.pm line 69.

Also the following string can be find in ./sessions/*/psadump.log :

[18223]: 2016-09-15 14:22:38.667 DEBUG Timeout occured during mysql query. Reconnecting.

No errors in MySQL log

Cause

wait_timeout param in /etc/my.cnf is too low.

Resolution

Increase wait_timeout and restart mysqld service

Have more questions? Submit a request
Please sign in to leave a comment.