Camunda version used : 7.13.0-alpha4
RDS DB type : db.t2.medium
When I login to cockpit, In DB i see a query mentioned below is executing and it shoots the CPU usage to 97%.
If I delete the running query from process list in DB . CPU usage comes down to 3%.
I see this issue is already in discussion in other threads.Any help to resolve this issue is Appreciated. We cannot afford to remove authorization check on login.
select count(distinct RES.ID_ ) from ACT_RU_TASK RES left join ACT_RE_PROCDEF PROCDEF on RES.PROC_DEF_ID_ = PROCDEF.ID_ left JOIN (SELECT A.* FROM ACT_RU_AUTHORIZATION A WHERE A.TYPE_ < 2 AND ( A.USER_ID_ in ( ‘admin’, ‘’) OR A.GROUP_ID_ IN (‘camunda-admin’)) AND ((A.RESOURCE_TYPE_ = 7 AND A.PERMS_ & 2 = 2 OR A.RESOURCE_TYPE_ = 6 AND A.PERMS_ & 64 = 64))) AUTH ON (AUTH.RESOURCE_ID_ in (RES.ID_, PROCDEF.KEY_, '’)) WHERE(1 = 1) and ((RES.CASE_EXECUTION_ID_ IS NOT NULL) OR (AUTH.RESOURCE_ID_ IS NOT NULL));