Packet for Query Is Too Largelink
Issuelink
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.
Environmentlink
Connector: MySQL
Resolutionlink
You need to set the max_allowed_packet
variable to accept the higher value.
Do the following:
Check the current value of
max\_allowed\_packet
in your source database by running the following query:SHOW VARIABLES LIKE max_allowed_packet;
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 MySQL's documentation.
Causelink
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.