We are encountering a very serious issue now when we are using Camunda…
Our database get CPU 100% usage some times ( RDS Postgresql 9.4.15)… and the query that we found is from Camunda system as below in attached file (It is big query but we could not get it all …select format…).
That is reaching to number 2 issue, when our database is 100% CPU usage… Camunda can not handle it and it got hung… we have to restart service all the time when this happen.
What is selectActivityStatisticsByQueryCriteriaSql do?
Here is connection that we set in our Camunda Jboss:
This query is responsible for the activity data and it is used in the GET /history/process-definition/{id}/statistics.
If you use Cockpit or this Rest request, and you have big amount of data in the db, you could experience delays. Please confirm if it is the case.
I had this case open to Camunda Support… they had come back with a very good temp solution. i am working with them for permanent solution… thanks for your support as well
