act_ge_bytearray size

[luisalves00]

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

[ronald_van_kuij]

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

[luisalves00]

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.

[pkuehn]

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

[martin_grofcik]

Hi Paul,

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

Regards
Martin

[jbarrez]

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?