topic ACT_GE_BYTEARRAY / com.mysql.jdbc.PacketTooBigException in Alfresco Archive

ACT_GE_BYTEARRAY / com.mysql.jdbc.PacketTooBigException

pbreak75 — Wed, 12 Oct 2016 13:48:19 GMT

Hello,Is there a way to avoid this error message bellow without increasing the value of max_allowed_packet ? Error updating database. Cause: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (16005045 > 8388608). You can change this value on the server by setting the max_allow

Re: ACT_GE_BYTEARRAY / com.mysql.jdbc.PacketTooBigException

trademak — Thu, 13 Oct 2016 11:43:00 GMT

Hi,

That's more of a MySQL question. Found this in their documentation:

http://dev.mysql.com/doc/refman/5.7/en/program-variables.html

Best regards,

Re: ACT_GE_BYTEARRAY / com.mysql.jdbc.PacketTooBigException

pbreak75 — Fri, 14 Oct 2016 10:24:13 GMT

Hello,
As i said above, i don't want to change the value of max_allowed_packet , is there a parameter in ACTIVITI to avoid this error?
I had the same problem in another application , I have made sure that queries are always reasonably short.
In activiti , it happens when there is a large amount of data, the request below fails
insert into ACT_GE_BYTEARRAY(ID_, REV_, NAME_, BYTES_, DEPLOYMENT_ID_) values ( ?, 1, ?, ?, ? ).

Best regards,