[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.
(adsbygoogle = window.adsbygoogle || []).push({});