Packet for Query Is Too Large

Issue

The following dashboard alert appears in the source database:

java.lang.RuntimeException: com.mysql.cj.jdbc.exceptions.PacketTooBigException:  
Packet for query is too large ( current size \[size in kbytes\] \> allowed size \[size in kbytes\]).  
You can change this value on the server by setting the 'max\_allowed\_packet' variable.
content_copy

Environment

Connector: MySQL

Resolution

You need to set the max_allowed_packet variable to accept the higher value.

Do the following:

1. Check the current value of max_allowed_packet in your source database by running the following query:

   SHOW VARIABLES LIKE max_allowed_packet;

2. Increase the value to 16 M or 32 M (higher if required) by running the following query:

   $> mysql --max_allowed_packet=32M

For more information, see .

Cause

A communication packet can be a single SQL statement sent to the MySQL server, a single row that is sent to the client, or a binary log event sent from a master replication server to a slave. The size of the data packet sent from your database exceeds than the size limit set at the source. The default max_allowed_packet variable value is 1 MB.