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


Solutions on the web36

Solution icon of web
via mysql.com by Unknown author, 1 year ago
Packet for query is too large (1122 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.

Solution icon of stackoverflow
Packet for query is too large (7501 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.

Solution icon of atlassian
via Atlassian JIRA by Gliffy ChrisK, 1 year ago
Packet for query is too large (1048592 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.

Solution icon of kuali
via Kuali JIRA by Steven Black, 1 year ago
Packet for query is too large (1486406 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.

Solution icon of web
via JIRA by Alice Carey, 1 year ago
Packet for query is too large (2622380 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.

Solution icon of atlassian
via Atlassian JIRA by Gliffy ChrisK, 1 year ago
Packet for query is too large (1048592 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.

Solution icon of sonarsource
via SonarSource JIRA by Julien Lancelot, 1 year ago
Packet for query is too large (2828417 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.

Solution icon of web
via JIRA by Damian Jansen, 1 year ago
Packet for query is too large (1304637 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.

Solution icon of oraclecommunity
via Oracle Community by 843859, 10 months ago
Packet for query is too large (2585458 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.

Solution icon of web
via nabble.com by Unknown author, 1 year ago
Packet for query is too >> large (1054948 > 1048576). You can change this value on the server by >> setting the max_allowed_packet' variable.

Stack trace

com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1122 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
	at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3592)[mysql-connector-java-5.1.34.jar:5.1.34]
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2417)[mysql-connector-java-5.1.34.jar:5.1.34]

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago