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

Question

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?

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

Khuong Vu · Answer

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

Khuong Vu · Answer

@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

Ryan Goodwin · Answer

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.