topic PersistenceException - Packet for query is too large in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/persistenceexception-packet-for-query-is-too-large/m-p/140630#M98489 <HTML><HEAD></HEAD><BODY><SPAN>Hi all,</SPAN><BR /><BR /><SPAN>Last night a process ran and I found this exception on the log files:</SPAN><BR /><BLOCKQUOTE class="jive-quote">Caused by: org.apache.ibatis.exceptions.PersistenceException:<BR />### Error updating database.&nbsp; Cause: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (2017529 &gt; 1048576). You can change this value on the server by setting the max_allowed_packet' variable.<BR />### The error may involve org.activiti.engine.impl.persistence.entity.VariableInstanceEntity.insertByteArray-Inline<BR />### The error occurred while setting parameters<BR />### SQL: insert into ACT_GE_BYTEARRAY(ID_, REV_, NAME_, BYTES_, DEPLOYMENT_ID_)&nbsp;&nbsp;&nbsp;&nbsp; values (&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?&nbsp;&nbsp;&nbsp;&nbsp; )<BR />### Cause: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (2017529 &gt; 1048576). You can change this value on the server by setting the max_allowed_packet' variable.<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:147)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:134)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.db.DbSqlSession.flushInserts(DbSqlSession.java:632)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:459)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:167)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:114)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:69)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:32)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.engine.impl.RuntimeServiceImpl.startProcessInstanceById(RuntimeServiceImpl.java:67)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.activiti.explorer.ui.process.listener.StartProcessInstanceClickListener.buttonClick(StartProcessInstanceClickListener.java:71)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.GeneratedMethodAccessor179.invoke(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.reflect.Method.invoke(Method.java:616)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:490)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; … 26 more<BR />Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (2017529 &gt; 1048576). You can change this value on the server by setting the max_allowed_packet' variable.</BLOCKQUOTE><BR /><SPAN>My question here is, what should I do now? How does this affect my activiti installation? What's the worst that can happen?</SPAN><BR /><BR /><SPAN>I have changed the value of that variable to avoid future problems, but I wanted to know what I should be expecting from the engine after an insert into this table has failed.</SPAN><BR /><BR /><SPAN>Many thanks!</SPAN><BR /><BR /><SPAN>PD: I'm using activiti 5.11.</SPAN></BODY></HTML> Fri, 14 Dec 2012 13:11:36 GMT fwachs 2012-12-14T13:11:36Z PersistenceException - Packet for query is too large https://connect.hyland.com/t5/alfresco-archive/persistenceexception-packet-for-query-is-too-large/m-p/140630#M98489 Hi all,Last night a process ran and I found this exception on the log files:Caused by: org.apache.ibatis.exceptions.PersistenceException:### Error updating database.&nbsp; Cause: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (2017529 &gt; 1048576). You can change this value on the s Fri, 14 Dec 2012 13:11:36 GMT https://connect.hyland.com/t5/alfresco-archive/persistenceexception-packet-for-query-is-too-large/m-p/140630#M98489 fwachs 2012-12-14T13:11:36Z Re: PersistenceException - Packet for query is too large https://connect.hyland.com/t5/alfresco-archive/persistenceexception-packet-for-query-is-too-large/m-p/140631#M98490 <HTML><HEAD></HEAD><BODY><SPAN>I would assume the whole transaction failed and the engine or rather the process instances is in the 'previous´ state, meaning the state it was in when this transaction was started.</SPAN></BODY></HTML> Fri, 14 Dec 2012 19:43:52 GMT https://connect.hyland.com/t5/alfresco-archive/persistenceexception-packet-for-query-is-too-large/m-p/140631#M98490 ronald_van_kuij 2012-12-14T19:43:52Z Re: PersistenceException - Packet for query is too large https://connect.hyland.com/t5/alfresco-archive/persistenceexception-packet-for-query-is-too-large/m-p/140632#M98491 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>I've got the same problem, did you found a solution without increasing the value of max_allowed_packet ?</SPAN><BR /><BR /><SPAN>Regards,</SPAN><BR /></BODY></HTML> Wed, 12 Oct 2016 09:40:27 GMT https://connect.hyland.com/t5/alfresco-archive/persistenceexception-packet-for-query-is-too-large/m-p/140632#M98491 pbreak75 2016-10-12T09:40:27Z