All,
We have implemented Camunda for our application since June 2019, but we never though of cleaning up the history data. Right now we have several processes with multiple old deployments for those processes.
Currently I am trying to clean up the old completed process instance. I read the camunda docs and forums on cleanup strategies. Currently I am trying to test how it works.
So I updated historyTimeToLive for one of the old deployments of a particular process to 0. And I can see it is updated in ACT_RE_PROCDEF table for that particular Definition Id.
Now there are 3 completed process instance for this process. When I try to trigger manual cleanup using Rest : http://localhost:9993/rest/history/cleanup
I get the response as stated in the docs. But nothing gets cleaned up.
On further investigation, I can see entries in ACT_HI_JOB_LOG for that corresponding several clean up job with JOB_STATE = 2, and in ACT_RU_JOB I could see 1 entry but the locks are null and SUSPENSION_STATE_ = 2.
I also tried updating the suspension state to 1, but then again it recreates an entry in job log and update the suspension state to 2.
Would like to know if it is possible to manually cleanup with only updating the historyTimeToLive and not doing any configuration for the batch in process engine.