MySQL - Got a packet bigger than 'max_allowed_packet' bytes

Error: MySQL - ERROR 1153 (08S01) at line 138: Got a packet bigger than 'max_allowed_packet' bytes

You see the following error while executing a MySQL query:

ERROR 1153 (08S01) at line 138: Got a packet bigger than 'max_allowed_packet' bytes

 

Solution

Open your my.cnf file - on Debian/Ubuntu, it's /etc/mysql/my.cnf, on Fedora/RedHat/CentOS, it's /etc/my.cnf - and search for the max_allowed_packet line.

I suggest you play around with its value a bit - double or quadruple its value, restart MySQL - on Debian/Ubuntu, the command is

/etc/init.d/mysql restart

... and on Fedora/RedHat/CentOS, the command is

/etc/init.d/mysqld restart

- and see if the error goes away. If not, increase the max_allowed_packet value again.

Share this page:

0 Comment(s)

Add comment