PacketTooBigException - Packet for Query is too Large

Problem

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

CODE

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.

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

CODE

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.

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:
CODE
```
shell> mysqld --max_allowed_packet=32M
```

Cause

The packet for query is too large.

Related Information

Please have a look at the following pages: