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
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards 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