Search code examples
activitibpmnbusiness-process-management

Activiti DB cleanup

I've noticed that the activiti server DB is getting quite big and is using a lot of disk-space. I are working with the rest API. I don't really use the history so I don't mind deleting it but I'm having trouble figuring out how to identify all the finished jobs/tasks/processes and calling relevant delete API. If this can be done via SQL commands directly on the DB that would be fine as well.

Solution

  • Likely the tables that are growing are the history tables (ACT_HI_*) which will grow depending on the history level you have set in your Activiti engine.

    That said, archiving of the history tables is very easy as there are no foreign keys.

    First, retrieve all closed or terminated process instances using something like:

    select proc_inst_id_ from act_hi_procinst where end_act_id_ IS NOT NULL or 
delete_reason_ IS NOT NULL

    Then use this list to delete associated rows from:

    ACT_HI_ACTINST
ACT_HI_ATTACHMENT
ACT_HI_COMMENT
ACT_HI_DETAIL
ACT_HI_IDENTITYLINK
ACT_HI_TASKINST
ACT_HI_VARINST

    Finally, you can delete the rows from ACT_HI_PROCINST

    Hope this helps, Greg