Unable to restore backup: Got a packet bigger than ‘max_allowed_packet’ bytes

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:

How to set max_allowed_packet size for MySQL?.