MySQL - Got a packet bigger than 'max_allowed_packet' bytes

Want to support HowtoForge? Become a subscriber!
 
Submitted by falko (Contact Author) (Forums) on Fri, 2011-08-12 11:23. :: Errors

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.


Please do not use the comment function to ask for help! If you need help, please use our forum.
Comments will be published after administrator approval.