message correlation problems

Camunda 7 Topics
1

Please help me analyze the possible causes:

  1. When the platform calls runtimeService.createMessageCorrelation(messageName)
    .processInstanceBusinessKey(BpmnModelParser.getProcessActId(workflowId))
    .setVariableLocal(WorkflowConst.TASK_STATUS_TYPE, taskStatusType)
    .correlate() in a scheduled task, it gets stuck for 1.5 hours and then automatically recovers;

  2. This code is called within a for loop;

  3. Investigation revealed that the ACT_RU_EVENT_SUBSCR table has accumulated a large amount of historical data;

  4. The current Camunda version is 7.19.0;

  5. Database investigation showed long-running transactions at the time, but no long-term database locks;

  6. Other platform functions are normal; only this scheduled task is affected, and other scheduled tasks also operate normally;

  7. This phenomenon has occurred multiple times with varying recovery times observed: 1.5h, 1h, 3h, 5h.