Symptoms
-
Unable to restore backup due to the next warning in Plesk:
PLESK_WARN: Warning: Errors occurred during deployment of database content. Not all content may be restored. Resolve the errors if required or try to restore the content manually from the archive: databases/dataabse_name[sqldump]: backup_1703110201.tgz
Warning: Execution of /usr/bin/mysql –no-defaults -u dbuser -h localhost -P 3306 –default-character-set utf8mb4 dbname failed with return code 1. Stdin is source /tmp/migration-unpack-VMpKld/backup_1703110201; exit Stderr is ERROR 1153 (08S01) at line 385 in file: ‘/tmp/migration-unpack-VMpKld/backup_1703110201’: Got a packet bigger than ‘max_allowed_packet’ bytes
-
The same rows can appear in the
/var/log/plesk/panel.log
file during the execution of WordPress Smart Updates task.
Cause
The max_allowed_packet value is small in the /etc/my.cnf
or /etc/mysql/my.cnf
file.
Resolution
Increase the max_allowed_packet value according to the following article: