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

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via commons-user by Martin Gainty, 1 year ago
Packet for query is too large (77 > -1). You can change this value on the server by setting the max_allowed_packet' variable.
via commons-user by sebb, 1 year ago
Packet for query is too large (77 > -1). You can change this value on the server by setting the max_allowed_packet' variable.
via commons-user by 心如止水, 1 year ago
Packet for query is too large (77 > -1). You can change this value on the server by setting the max_allowed_packet' variable.
via Stack Overflow by Prachi
, 1 year ago
Packet for query is too large (7989143 > 4194304). You can change this value on the server by setting the max_allowed_packet' variable.
com.mysql.jdbc.PacketTooBigException: Packet for query is too large (77 > -1). You can change this value on the server by setting the max_allowed_packet' variable.
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:61)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:53)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:38)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:66)
at undefined.$Proxy408.queryById(Unknown Source)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

Know the solutions? Share your knowledge to help other developers to debug faster.