MySQL "max_allowed_packet" error

Symptons

There are several JDBC errors in log:

Cause

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

Diagnosis

This error appears several times in application log.

Solution

In order to increase the packet size you have to modify the max_allowed_packet parameter. Edit /etc/my.cnf for MySQL instance, or /etc/my.cnf.d/server.cnf for MariaDB (in some distros
you my 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 by this query:

Properties

Keywords