[solved] MySQL – Got a packet bigger than ‘max_allowed_packet’ bytes

[solved] MySQL – Got a packet bigger than ‘max_allowed_packet’ bytes

You see the following error while executing a MySQL query:eval(ez_write_tag([[728,90],’howtoforge_com-box-3′,’ezslot_10′,106,’0′,’0′]));

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

 

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

service mysql restart

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

service mysqld restart

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

About the Author

Leave a Reply