PacketTooBigException - Packet for Query is too Large

Problem

If you use MySQL you may get the following error, when installing or upgrading Scroll:

com.mysql.jdbc.PacketTooBigException: Packet for query is too large (5224044 > 4193280). You can change this value on the server by setting the max_allowed_packet' variable.
CODE

If you install through the Plugin Repository, the error looks like this:

To resolve this problem, you need to increase the value for max_allowed_packet. Make sure to set the packed size when starting the server, not the client.
CODE

Environment

  • MySQL Database
  • All Scroll add-ons
  • All versions

Resolution

To resolve this problem, you need to increase the value for max_allowed_packet.

To increase the value:

  • Execute the following statement:

    shell> mysqld --max_allowed_packet=32M
    CODE

Cause

The packet for query is too large.

Related Information

Please have a look at the following pages:

Cookie Notice

We use cookies to create a secure and effective browsing experience for our website visitors and to understand how you use our site (i.e. Google Analytics). For more information:
Click Here

OK Don't track me.