[solved] MySQL - Got a packet bigger than 'max_allowed_packet' bytes

On this page

  1. Solution

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

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.

Falko Timme

About Falko Timme

Falko Timme is an experienced Linux administrator and founder of Timme Hosting, a leading nginx business hosting company in Germany. He is one of the most active authors on HowtoForge since 2005 and one of the core developers of ISPConfig since 2000. He has also contributed to the O'Reilly book "Linux System Administration".

Share this page:

Suggested articles

1 Comment(s)

Add comment

Comments

By: Niubbo75

Hello, I have try to do that but when I set a value different from 16M (I need at least 20M to let my customer install ERPAL) mysql want restart. Is there a way to increase that value only for that website in ISPConfig 3.1?