On 09/12/2014 14:04, Rob van de Meulengraaf wrote:
Hi,
I have a question about the size of the ACT_GE_BYTEARRAY. This is
getting quite large. For about 290k records in table SyncopeUsers
there are about 2300k records in ACT_GE_BYTEARRAY with a filesize of
about 10 GB. It seems that is contains serialized data such as:
| ?? sr %org.apache.syncope.common.mod.UserMod*??@??j\ L
membershipsToBeAddedt Ljava/util/Set;L membershipsToBeRemovedq
~ Lpasswordt Ljava/lang/String;L pwdPropRequestt
3Lorg/apache/syncope/common/to/PropagationRequestTO;Lusernameq ~
xr 5org.apache.syncope.common.mod.AbstractAttributableMod,??+?)?^ J
idL attributesToBeRemovedq ~ L attributesToBeUpdatedq ~
L derivedAttributesToBeAddedq ~ L derivedAttributesToBeRemovedq ~ L
resourcesToBeAddedq ~ L resourcesToBeRemovedq ~
L virtualAttributesToBeRemovedq ~ L virtualAttributesToBeUpdatedq ~ xr
*org.apache.syncope.common.AbstractBaseBean+J????"? xp ?'sr
java.util.HashSet?D?????4 xpw
etc.
How can I prevent serialized data to be stored here or minimize it?
Can I clean up data from this table?
Hi Rob,
the entries in the ACT_GE_BYTEARAY table are serialized objects passed
as arguments to user workflow tasks.
As such, there is no way to prevent this serialization, but you *should*
be able to purge such table periodically - see [1] for a discussion on
Activiti forum about a similar topic.
HTH
Regards.
[1]
http://forums.activiti.org/content/cleanup-activiti-history-tables-and-actgebytearray
--
Francesco Chicchiriccò
Tirasa - Open Source Excellence
http://www.tirasa.net/
Involved at The Apache Software Foundation:
member, Syncope PMC chair, Cocoon PMC, Olingo PMC
http://people.apache.org/~ilgrosso/
