commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Martin Gainty <mgai...@hotmail.com>
Subject RE: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (77 > -1)
Date Sun, 16 Feb 2014 13:48:07 GMT

> Date: Sun, 16 Feb 2014 13:04:43 +0000
> Subject: Re: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (77
> -1)
> From: sebbaz@gmail.com
> To: user@commons.apache.org
> 
> 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, 心如止水 <707621918@qq.com> 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: user-unsubscribe@commons.apache.org
> For additional commands, e-mail: user-help@commons.apache.org
> 

 		 	   		  
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message