> Date: Sun, 16 Feb 2014 13:04:43 +0000 > Subject: Re: com.mysql.jdbc.PacketTooBigException: Packet for query is too > large (77 > -1) > From: [email protected] > To: [email protected] > > This does not appear to be anything to do with any Apache Commons component.
> Try asking on the MySQL user list. MG>hes not getting a kind of response from MySQL Support so he asks here MG>max_allowed_packet = 1M in $MYSQL_HOME/my.ini is the default setting for "Large Object support" in MySQL MG>try updating the my.ini parameter max_allowed_packet = 1M and see if that solves your problem > > On 16 February 2014 02:03, 心如止水 <[email protected]> wrote: > > Hi All , > > > > I have encountered a problem in production environment : > > > > ### Error querying database. Cause: 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. > > ### The error occurred while setting parameters > > ### Cause: 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 org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:35) > > at $Proxy408.queryById(Unknown Source) > > > > I am confused with the number -1 (the max allowed packet size ), how it can > > appear ? > > And the other problem is when the database reover the service , the problem > > is still existing , otherwise I restart the > > tomcat application ,then it's ok > > > > Thanks. > > > > > > Best Regards, > > Guoan Hu > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] >
