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

Share this page:

Suggested articles

1 Comment(s)

Add comment

Comments

From: 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?