MySQL "max_allowed_packet" error

Symptoms

There are several JDBC errors in the log:

Cause

As the message says, the max_allowed_packet setting is not big enough.

Diagnosis

This error appears several times in the application log.

Solution

In order to increase the packet size you have to modify the max_allowed_packet parameter. Edit /etc/my.cnf for a MySQL instance, or /etc/my.cnf.d/server.cnf for MariaDB (in some distros
you may find it at /etc/mysql/mariadb.conf.d/50-server.cnf)

Once changed, you need to restart MySQL. On Debian/Ubuntu, the command is:

And on Fedora/RedHat/CentOS, it is:

After that you can check this new value with this query:

Properties

Keywords