we had an incident with our Camunda engine yesterday. Tomcat ran out of heap while deleting a huge amount of historic process instances.
Does anybody have experience what the expected behavior is? In our case the list contained about 37k entries. We saw Tomcat running OOM after executing about 30% of the deletions. There was nothing else going on on the engine at this point of time.
we will have batch deletion of historic process instances in the next alpha release of 7.6.0. Corresponding method signature will be deleteHistoricProcessInstancesAsync. Would that help you?
this is great news. We just have been caught by surprise by running into this issue. We can surely chunk this kind of work while waiting for the 7.6 release. Is there any number you can suggest knowing what is happening in the background? We have been thinking about no more than 5k deletions at a time.