topic Re: act_ge_bytearray size in Alfresco Archive

act_ge_bytearray size

luisalves00 — Mon, 25 Jul 2011 08:38:53 GMT

Hello,the table act_ge_bytearray is getting to large.which is the problem?* <property name="history" value="audit" />..or * I'm passing large objects (that are serialized to the DB) into the workflows (I'm using jpa).best regards

Re: act_ge_bytearray size

ronald_van_kuij — Mon, 25 Jul 2011 15:44:08 GMT

what about the combination? Since either can be 'fixed' to solve the problem

Re: act_ge_bytearray size

luisalves00 — Tue, 26 Jul 2011 08:31:54 GMT

uhm….after inspecting the table I found out that it stores all the deployed versions of my workflows (xml and png).
So the problem isn't related with object serialization or history level.

tks anyway.

Re: act_ge_bytearray size

pkuehn — Mon, 25 Aug 2014 15:24:50 GMT

Hi,

In our application we use activiti 5.11 and postgres as db and we have the same problem that the table act_ge_bytearray gets really large (about 500 - 600 MB).
This happens when we start our test, which starts sequentially about 100 processes. Each process has about 5 - 7 MB of data.

Increasing the number of running processes results the size of database larger than 1 TB, which cause that the partition is running full.

Any advice would be helpful.

best regards,
Paul

Re: act_ge_bytearray size

martin_grofcik — Tue, 26 Aug 2014 05:44:17 GMT

Hi Paul,

I read really good article from Tiese.
http://bitly.nl/redirect/&url=GpLFcd

Regards
Martin

Re: act_ge_bytearray size

jbarrez — Sat, 30 Aug 2014 16:45:19 GMT

What do you store? Only the process xml and png?

Or as Martin indicates, do you serialize a lot of process variables which are not primitives?