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.

commons-user | 心如止水 | 3 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    com.mysql.jdbc.PacketTooBigException: Packet for query is too large (77 > -1)

    commons-user | 3 years ago | 心如止水
    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.
  2. 0

    Re: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (77 > -1)

    commons-user | 3 years ago | sebb
    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.
  3. 0

    RE: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (77 > -1)

    commons-user | 3 years ago | Martin Gainty
    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.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. MyBatis
      MapperProxy.invoke
      1. org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)
      2. org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:61)
      3. org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:53)
      4. org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:38)
      5. org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:66)
      6. org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:35)
      6 frames
    3. Unknown
      $Proxy408.queryById
      1. $Proxy408.queryById(Unknown Source)
      1 frame