Cheap VPS & Xen Server

Residential Proxy Network - Hourly & Monthly Packages

MySQL – Got a packet bigger than ‘max_allowed_packet’ bytes


‘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.

Comments

comments