Got packet bigger than 'max_allowed_packet' bytes when dumping table `plugindata` at row: 21

[Ryan Goodwin]

Hoping for some help.

Mysql is configured for 64mb max_allowed_packet size.

Getting this error when using mysqldump to export:

mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' bytes when dumping table `plugindata` at row: 21

Row 21 in plugindata table is com.atlassian.upm.plugin-license-storage-plugin

First noted when trying to import the dump into new/clone instance. Max allowed packet bumped up to 2048M and still error persists.

Any ideas?

[Libor Tvrdík]

Configuration of MySql and mysqldump is different (if you mean /etc/my.cfg}}.

You have a two solution:

1. Add the command line parametr {{--max_allowed_packet=64M}} to your mysqldump command
2. Or add max_allowed_packet=512M to [mysqldump] section of your my.cnf

See on http://stackoverflow.com/questions/8815445/mysqldump-error-got-packet-bigger-than-max-allowed-packet .

Cheers,

Libor

[Ryan Goodwin]

Thanks for your suggestions, but as I mentioned in the OP, max_allowed_packet has already been increased. I use 512m while taking the mysqldump and 512/1024/2048 in the import statement on the new server. The my.cnf is configured (on both source and dest server) with 64mb. Error persists.

[Khuong Vu]

@libor.tvrdik@telefonica.com 's instructions work for me.  Please see below

[kvu@myserver mysqldump_files]$ mysqldump -uroot -p confluence > mysqldump-2016-05-24-18-32.sql
Enter password:
mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' bytes when dumping table `PLUGINDATA` at row: 47
[kvu@myserver mysqldump_files]$ vi /etc/my.cnf
[kvu@myserver mysqldump_files]$
[kvu@myserver mysqldump_files]$ mysqldump --max_allowed_packet=256M -uroot -p confluence > mysqldump-2016-05-24-18-32.sql

[Khuong Vu]

image2016-5-24 18:53:31.png