Error 2020: Got packet bigger than 'max_allowed_packet' bytes when dumping table...

[tupson]

Greetings,

I am trying to perform the following backup option:

/opt/otrs/scripts/backup.pl -d /opt/backups/ -c gzip -r 8 -f fullbackup

and every time it begins, it throws an error:

Backup /opt/backups//2019-11-25_14-06/Config.tar.gz ... done
Backup /opt/backups//2019-11-25_14-06/Application.tar.gz ... done
Dump MySQL data to /opt/backups//2019-11-25_14-06/DatabaseBackup.sql.gz ... mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' bytes when dumping table `article_data_mime_plain` at row: 869
Deleting incomplete backup /opt/backups//2019-11-25_14-06 ... done
[Mon Nov 25 14:06:26 2019] backup.pl: Backup failed
failed

I modified the /etc/my.cnf 'max_allowed_packet' size from 256M to 512M to 1024M and all give the same error. How do I resolve this so I can backup my OTRS database?

[wurzel]

hi,

this is no OTRS matter but you should put the max allowed packet in the mysqldump section not in the mysqld section.


Flo

[tupson]

hi,

this is no OTRS matter but you should put the max allowed packet in the mysqldump section not in the mysqld section.


Flo

Yes, this is where I was putting this information. *See below"

[mysqld]
max_allowed_packet = 512M
query_cache_size = 64M
innodb_log_file_size = 256M
character-set-server = utf8
collation-server = utf8_unicode_ci
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd

[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid

[wurzel]

Hi,

there should be a [mysqldump] section somwhere... put it there

Flo