camunda-bpm-platform External Task fetch and lock query performs bad with MS SQL Server

External Task fetch and lock query performs bad with MS SQL Server

Open mboskamp opened this issue 6 months ago • 0 comments

Environment (Required on creation)

Camunda 7.20.0 and higher (probably lower versions are also affected but not confirmed)
MS SQL Server (confirmed with 2019)

Description (Required on creation; please attach any relevant screenshots, stacktraces, log files, etc. to the ticket)

The fetch and lock query for external tasks performs poorly on MS SQL Server when there are many External Task entities in the database. The problem becomes more severe when there is a high number of authorization entities in the database as well.

Query execution times can be in the tens of seconds for 50.000 External Tasks and 500 authorizations.

Steps to reproduce (Required on creation)

Connect a Camunda distro to MS SQL Server
Deploy a process that produces at least one External Task (see example process that has seven parallel External Tasks below)
Start many process instances of that process (try to aim for 10.000-20.000 External Tasks)
Bonus step: Create many (500 or so) authorizations (e.g. using Postman, see example below)
Manually execute the two SQL queries below. The current (non-optimized) query will take significantly longer.

Example Process

<?xml version="1.0" encoding="UTF-8"?>
<bpmn:definitions xmlns:bpmn="http://www.omg.org/spec/BPMN/20100524/MODEL" xmlns:bpmndi="http://www.omg.org/spec/BPMN/20100524/DI" xmlns:di="http://www.omg.org/spec/DD/20100524/DI" xmlns:dc="http://www.omg.org/spec/DD/20100524/DC" xmlns:camunda="http://camunda.org/schema/1.0/bpmn" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" id="Definitions_1" targetNamespace="http://bpmn.io/schema/bpmn" exporter="Camunda Modeler" exporterVersion="5.21.0">
  <bpmn:process id="loadtestprocess" name="loadtestprocess" isExecutable="true" camunda:historyTimeToLive="P180D">
    <bpmn:sequenceFlow id="SequenceFlow_0nww3wx" sourceRef="StartEvent_1" targetRef="Gateway_127vtiv" />
    <bpmn:serviceTask id="Task_1lvjtd4" name="Retrieve customer credit score" camunda:type="external" camunda:topic="load">
      <bpmn:incoming>Flow_0bmhdel</bpmn:incoming>
      <bpmn:outgoing>Flow_12lr5yn</bpmn:outgoing>
    </bpmn:serviceTask>
    <bpmn:startEvent id="StartEvent_1">
      <bpmn:outgoing>SequenceFlow_0nww3wx</bpmn:outgoing>
    </bpmn:startEvent>
    <bpmn:endEvent id="Event_0l8q1ga">
      <bpmn:incoming>Flow_03qokqd</bpmn:incoming>
    </bpmn:endEvent>
    <bpmn:sequenceFlow id="Flow_12lr5yn" sourceRef="Task_1lvjtd4" targetRef="Gateway_04wc636" />
    <bpmn:userTask id="Activity_0vhkaf3">
      <bpmn:incoming>Flow_16e4ay3</bpmn:incoming>
      <bpmn:outgoing>Flow_03qokqd</bpmn:outgoing>
    </bpmn:userTask>
    <bpmn:sequenceFlow id="Flow_03qokqd" sourceRef="Activity_0vhkaf3" targetRef="Event_0l8q1ga" />
    <bpmn:sequenceFlow id="Flow_0bmhdel" sourceRef="Gateway_127vtiv" targetRef="Task_1lvjtd4" />
    <bpmn:parallelGateway id="Gateway_127vtiv">
      <bpmn:incoming>SequenceFlow_0nww3wx</bpmn:incoming>
      <bpmn:outgoing>Flow_0bmhdel</bpmn:outgoing>
      <bpmn:outgoing>Flow_017c84m</bpmn:outgoing>
      <bpmn:outgoing>Flow_1jtj99k</bpmn:outgoing>
      <bpmn:outgoing>Flow_1s047n3</bpmn:outgoing>
      <bpmn:outgoing>Flow_1lh5uam</bpmn:outgoing>
      <bpmn:outgoing>Flow_08hx4zl</bpmn:outgoing>
      <bpmn:outgoing>Flow_1xr7mhb</bpmn:outgoing>
    </bpmn:parallelGateway>
    <bpmn:serviceTask id="Activity_0ft1424" name="Retrieve customer credit score" camunda:type="external" camunda:topic="load">
      <bpmn:incoming>Flow_1jtj99k</bpmn:incoming>
      <bpmn:outgoing>Flow_0ose4it</bpmn:outgoing>
    </bpmn:serviceTask>
    <bpmn:serviceTask id="Activity_0kgs128" name="Retrieve customer credit score" camunda:type="external" camunda:topic="load">
      <bpmn:incoming>Flow_1s047n3</bpmn:incoming>
      <bpmn:outgoing>Flow_1eilyy1</bpmn:outgoing>
    </bpmn:serviceTask>
    <bpmn:serviceTask id="Activity_0smz301" name="Retrieve customer credit score" camunda:type="external" camunda:topic="load">
      <bpmn:incoming>Flow_1lh5uam</bpmn:incoming>
      <bpmn:outgoing>Flow_1pxhbtb</bpmn:outgoing>
    </bpmn:serviceTask>
    <bpmn:serviceTask id="Activity_0wuhd36" name="Retrieve customer credit score" camunda:type="external" camunda:topic="load">
      <bpmn:incoming>Flow_017c84m</bpmn:incoming>
      <bpmn:outgoing>Flow_19hbn2c</bpmn:outgoing>
    </bpmn:serviceTask>
    <bpmn:sequenceFlow id="Flow_017c84m" sourceRef="Gateway_127vtiv" targetRef="Activity_0wuhd36" />
    <bpmn:sequenceFlow id="Flow_1jtj99k" sourceRef="Gateway_127vtiv" targetRef="Activity_0ft1424" />
    <bpmn:sequenceFlow id="Flow_1s047n3" sourceRef="Gateway_127vtiv" targetRef="Activity_0kgs128" />
    <bpmn:sequenceFlow id="Flow_1lh5uam" sourceRef="Gateway_127vtiv" targetRef="Activity_0smz301" />
    <bpmn:sequenceFlow id="Flow_16e4ay3" sourceRef="Gateway_04wc636" targetRef="Activity_0vhkaf3" />
    <bpmn:parallelGateway id="Gateway_04wc636">
      <bpmn:incoming>Flow_12lr5yn</bpmn:incoming>
      <bpmn:incoming>Flow_19hbn2c</bpmn:incoming>
      <bpmn:incoming>Flow_0ose4it</bpmn:incoming>
      <bpmn:incoming>Flow_1eilyy1</bpmn:incoming>
      <bpmn:incoming>Flow_1pxhbtb</bpmn:incoming>
      <bpmn:incoming>Flow_0d7vitp</bpmn:incoming>
      <bpmn:incoming>Flow_168u0f1</bpmn:incoming>
      <bpmn:outgoing>Flow_16e4ay3</bpmn:outgoing>
    </bpmn:parallelGateway>
    <bpmn:sequenceFlow id="Flow_19hbn2c" sourceRef="Activity_0wuhd36" targetRef="Gateway_04wc636" />
    <bpmn:sequenceFlow id="Flow_0ose4it" sourceRef="Activity_0ft1424" targetRef="Gateway_04wc636" />
    <bpmn:sequenceFlow id="Flow_1eilyy1" sourceRef="Activity_0kgs128" targetRef="Gateway_04wc636" />
    <bpmn:sequenceFlow id="Flow_1pxhbtb" sourceRef="Activity_0smz301" targetRef="Gateway_04wc636" />
    <bpmn:serviceTask id="Activity_1ch22bb" name="Retrieve customer credit score" camunda:type="external" camunda:topic="load">
      <bpmn:incoming>Flow_1xr7mhb</bpmn:incoming>
      <bpmn:outgoing>Flow_168u0f1</bpmn:outgoing>
    </bpmn:serviceTask>
    <bpmn:serviceTask id="Activity_16ydba2" name="Retrieve customer credit score" camunda:type="external" camunda:topic="load">
      <bpmn:incoming>Flow_08hx4zl</bpmn:incoming>
      <bpmn:outgoing>Flow_0d7vitp</bpmn:outgoing>
    </bpmn:serviceTask>
    <bpmn:sequenceFlow id="Flow_08hx4zl" sourceRef="Gateway_127vtiv" targetRef="Activity_16ydba2" />
    <bpmn:sequenceFlow id="Flow_0d7vitp" sourceRef="Activity_16ydba2" targetRef="Gateway_04wc636" />
    <bpmn:sequenceFlow id="Flow_1xr7mhb" sourceRef="Gateway_127vtiv" targetRef="Activity_1ch22bb" />
    <bpmn:sequenceFlow id="Flow_168u0f1" sourceRef="Activity_1ch22bb" targetRef="Gateway_04wc636" />
  </bpmn:process>
  <bpmndi:BPMNDiagram id="BPMNDiagram_1">
    <bpmndi:BPMNPlane id="BPMNPlane_1" bpmnElement="loadtestprocess">
      <bpmndi:BPMNShape id="ServiceTask_0xcwm5l_di" bpmnElement="Task_1lvjtd4">
        <dc:Bounds x="410" y="409" width="100" height="80" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Event_1osg9rj_di" bpmnElement="StartEvent_1">
        <dc:Bounds x="152" y="430" width="36" height="36" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Event_0l8q1ga_di" bpmnElement="Event_0l8q1ga">
        <dc:Bounds x="952" y="431" width="36" height="36" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Activity_0ssuntd_di" bpmnElement="Activity_0vhkaf3">
        <dc:Bounds x="750" y="409" width="100" height="80" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Gateway_16hojk7_di" bpmnElement="Gateway_127vtiv">
        <dc:Bounds x="255" y="423" width="50" height="50" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="BPMNShape_1ld24hp" bpmnElement="Activity_0ft1424">
        <dc:Bounds x="410" y="300" width="100" height="80" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="BPMNShape_1d674g4" bpmnElement="Activity_0kgs128">
        <dc:Bounds x="410" y="510" width="100" height="80" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="BPMNShape_1g8ktw2" bpmnElement="Activity_0smz301">
        <dc:Bounds x="410" y="610" width="100" height="80" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="BPMNShape_0av0fd0" bpmnElement="Activity_0wuhd36">
        <dc:Bounds x="410" y="200" width="100" height="80" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="Gateway_1ggx179_di" bpmnElement="Gateway_04wc636">
        <dc:Bounds x="595" y="424" width="50" height="50" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="BPMNShape_0hwgrjw" bpmnElement="Activity_1ch22bb">
        <dc:Bounds x="410" y="720" width="100" height="80" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNShape id="BPMNShape_0gcozp1" bpmnElement="Activity_16ydba2">
        <dc:Bounds x="410" y="80" width="100" height="80" />
      </bpmndi:BPMNShape>
      <bpmndi:BPMNEdge id="SequenceFlow_0nww3wx_di" bpmnElement="SequenceFlow_0nww3wx">
        <di:waypoint x="188" y="448" />
        <di:waypoint x="255" y="448" />
        <bpmndi:BPMNLabel>
          <dc:Bounds x="346" y="258" width="90" height="13" />
        </bpmndi:BPMNLabel>
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_12lr5yn_di" bpmnElement="Flow_12lr5yn">
        <di:waypoint x="510" y="449" />
        <di:waypoint x="595" y="449" />
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_03qokqd_di" bpmnElement="Flow_03qokqd">
        <di:waypoint x="850" y="449" />
        <di:waypoint x="952" y="449" />
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_0bmhdel_di" bpmnElement="Flow_0bmhdel">
        <di:waypoint x="305" y="448" />
        <di:waypoint x="410" y="448" />
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_017c84m_di" bpmnElement="Flow_017c84m">
        <di:waypoint x="280" y="423" />
        <di:waypoint x="280" y="240" />
        <di:waypoint x="410" y="240" />
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_1jtj99k_di" bpmnElement="Flow_1jtj99k">
        <di:waypoint x="280" y="423" />
        <di:waypoint x="280" y="340" />
        <di:waypoint x="410" y="340" />
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_1s047n3_di" bpmnElement="Flow_1s047n3">
        <di:waypoint x="280" y="473" />
        <di:waypoint x="280" y="550" />
        <di:waypoint x="410" y="550" />
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_1lh5uam_di" bpmnElement="Flow_1lh5uam">
        <di:waypoint x="280" y="473" />
        <di:waypoint x="280" y="650" />
        <di:waypoint x="410" y="650" />
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_16e4ay3_di" bpmnElement="Flow_16e4ay3">
        <di:waypoint x="645" y="449" />
        <di:waypoint x="750" y="449" />
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_19hbn2c_di" bpmnElement="Flow_19hbn2c">
        <di:waypoint x="510" y="240" />
        <di:waypoint x="620" y="240" />
        <di:waypoint x="620" y="424" />
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_0ose4it_di" bpmnElement="Flow_0ose4it">
        <di:waypoint x="510" y="340" />
        <di:waypoint x="620" y="340" />
        <di:waypoint x="620" y="424" />
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_1eilyy1_di" bpmnElement="Flow_1eilyy1">
        <di:waypoint x="510" y="550" />
        <di:waypoint x="620" y="550" />
        <di:waypoint x="620" y="474" />
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_1pxhbtb_di" bpmnElement="Flow_1pxhbtb">
        <di:waypoint x="510" y="650" />
        <di:waypoint x="620" y="650" />
        <di:waypoint x="620" y="474" />
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_08hx4zl_di" bpmnElement="Flow_08hx4zl">
        <di:waypoint x="280" y="423" />
        <di:waypoint x="280" y="120" />
        <di:waypoint x="410" y="120" />
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_0d7vitp_di" bpmnElement="Flow_0d7vitp">
        <di:waypoint x="510" y="120" />
        <di:waypoint x="620" y="120" />
        <di:waypoint x="620" y="424" />
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_1xr7mhb_di" bpmnElement="Flow_1xr7mhb">
        <di:waypoint x="280" y="473" />
        <di:waypoint x="280" y="760" />
        <di:waypoint x="410" y="760" />
      </bpmndi:BPMNEdge>
      <bpmndi:BPMNEdge id="Flow_168u0f1_di" bpmnElement="Flow_168u0f1">
        <di:waypoint x="510" y="760" />
        <di:waypoint x="620" y="760" />
        <di:waypoint x="620" y="474" />
      </bpmndi:BPMNEdge>
    </bpmndi:BPMNPlane>
  </bpmndi:BPMNDiagram>
</bpmn:definitions>

Start many process instances

Using shell script:

#!/bin/bash
for i in $(seq 1 1500);
do
    data="{ \"businessKey\": \"MYTEST-$i\" }"
    echo $data
    curl -d "$data" -H "Content-Type: application/json" -X POST http://localhost:8080/engine-rest/process-definition/key/myloadtestprocess/start
   
    echo
done

Using Postman:

Create a new Runner
Run the following URL x times: POST http://localhost:8080/engine-rest/process-definition/key/loadtestprocess/start

Create many authorizations

Using Postman:

Create a new Runner
Create a new Request
Add a prerequest script (see below) that creates a variable (var) that we can increment for each execution of the request.
Add a Test script (see below) that increments the variable (var). The variable is used in the payload of the request to make each authorization unique.
Run the following URL x times: POST http://localhost:8080/engine-rest/authorization/create with the JSON payload below.

Pre-request script:

var value = pm.environment.get("var");
if( !value) {
    pm.environment.set("var", 1);
}

Test script:

var value = pm.environment.get("var");
pm.environment.set("var", value+1);

JSON payload:

{
  "type": 0,
  "permissions": [
    "CREATE",
    "READ"
  ],
  "userId": "*",
  "groupId": null,
  "resourceType": 1,
  "resourceId": "{{var}}"
}

Old query (unoptimized)

---- unoptimized
SELECT SUB.* 
FROM ( select RES.* , row_number() over (ORDER BY RES.PRIORITY_ desc) rnk 
FROM ( select distinct RES.* 
	from ( select RES.*, PI.BUSINESS_KEY_, PD.VERSION_TAG_ from ACT_RU_EXT_TASK RES left join ACT_RU_EXECUTION PI on RES.PROC_INST_ID_ = PI.ID_ inner join ACT_RE_PROCDEF PD on RES.PROC_DEF_ID_ = PD.ID_ 
left join ( SELECT A.* FROM ACT_RU_AUTHORIZATION A 
	WHERE A.TYPE_ < 2 AND ( A.USER_ID_ in ( 'demo', '*') OR A.GROUP_ID_ IN ( 'camunda-admin' ) ) ) AUTH 
		ON ( (AUTH.RESOURCE_TYPE_ = 8 AND (AUTH.RESOURCE_ID_ IN ( RES.PROC_INST_ID_ , '*' )) 
			AND AUTH.PERMS_ &2 = 2) OR (AUTH.RESOURCE_TYPE_ = 6 
			AND (AUTH.RESOURCE_ID_ IN ( RES.PROC_DEF_KEY_ , '*' )) 
			AND AUTH.PERMS_ &512 = 512) ) 
left join ( SELECT A.* FROM ACT_RU_AUTHORIZATION A 
	WHERE A.TYPE_ < 2 
	AND ( A.USER_ID_ in ( 'demo', '*') OR A.GROUP_ID_ IN ( 'camunda-admin' ) ) ) AUTH1 
		ON ( (AUTH1.RESOURCE_TYPE_ = 8 
		AND (AUTH1.RESOURCE_ID_ IN ( RES.PROC_INST_ID_ , '*' )) 
		AND AUTH1.PERMS_ &4 = 4) OR (AUTH1.RESOURCE_TYPE_ = 6 
		AND (AUTH1.RESOURCE_ID_ IN ( RES.PROC_DEF_KEY_ , '*' )) 
		AND AUTH1.PERMS_ &1024 = 1024) ) 
		WHERE (RES.LOCK_EXP_TIME_ is null or RES.LOCK_EXP_TIME_ <= GETDATE()) 
		and (RES.SUSPENSION_STATE_ is null or RES.SUSPENSION_STATE_ = 1) 
		and (RES.RETRIES_ is null or RES.RETRIES_ > 0) 
		and ( RES.TOPIC_NAME_ = 'load' ) 
		AND AUTH.RESOURCE_ID_ IS NOT NULL 
		AND AUTH1.RESOURCE_ID_ IS NOT NULL 
		) RES )RES ) SUB 
		WHERE SUB.rnk >= 1 AND SUB.rnk < 2 ORDER BY SUB.rnk

New query (optimized)

--- optimized
With AUTH as ( SELECT A.* FROM ACT_RU_AUTHORIZATION A 
	WHERE A.TYPE_ < 2 AND A.USER_ID_ in ( 'demo', '*') 
	union
	(SELECT A.* FROM ACT_RU_AUTHORIZATION A 
	WHERE A.TYPE_ < 2 AND A.GROUP_ID_ IN ( 'camunda-admin' )) )
, AUTH1 as ( SELECT A.* FROM ACT_RU_AUTHORIZATION A 
	WHERE A.TYPE_ < 2 AND A.USER_ID_ in ( 'demo', '*') 
	union
	(SELECT A.* FROM ACT_RU_AUTHORIZATION A 
	WHERE A.TYPE_ < 2 AND A.GROUP_ID_ IN ( 'camunda-admin' )) )
SELECT SUB.* 
FROM ( select RES.* , row_number() over (ORDER BY RES.PRIORITY_ desc) rnk 
FROM ( select distinct RES.* 
	from ( select RES.*, PI.BUSINESS_KEY_, PD.VERSION_TAG_ from ACT_RU_EXT_TASK RES left join ACT_RU_EXECUTION PI on RES.PROC_INST_ID_ = PI.ID_ inner join ACT_RE_PROCDEF PD on RES.PROC_DEF_ID_ = PD.ID_ 
left join AUTH 
		ON ( (AUTH.RESOURCE_TYPE_ = 8 AND (AUTH.RESOURCE_ID_ IN ( RES.PROC_INST_ID_ , '*' )) 
			AND AUTH.PERMS_ &2 = 2) OR (AUTH.RESOURCE_TYPE_ = 6 
			AND (AUTH.RESOURCE_ID_ IN ( RES.PROC_DEF_KEY_ , '*' )) 
			AND AUTH.PERMS_ &512 = 512) ) 
left join AUTH1
		ON ( (AUTH1.RESOURCE_TYPE_ = 8 
		AND (AUTH1.RESOURCE_ID_ IN ( RES.PROC_INST_ID_ , '*' )) 
		AND AUTH1.PERMS_ &4 = 4) OR (AUTH1.RESOURCE_TYPE_ = 6 
		AND (AUTH1.RESOURCE_ID_ IN ( RES.PROC_DEF_KEY_ , '*' )) 
		AND AUTH1.PERMS_ &1024 = 1024) ) 
		WHERE (RES.LOCK_EXP_TIME_ is null or RES.LOCK_EXP_TIME_ <= GETDATE()) 
		and (RES.SUSPENSION_STATE_ is null or RES.SUSPENSION_STATE_ = 1) 
		and (RES.RETRIES_ is null or RES.RETRIES_ > 0) 
		and ( RES.TOPIC_NAME_ = 'load' ) 
		AND AUTH.RESOURCE_ID_ IS NOT NULL 
		AND AUTH1.RESOURCE_ID_ IS NOT NULL 
		) RES )RES ) SUB 
		WHERE SUB.rnk >= 1 AND SUB.rnk < 2 ORDER BY SUB.rnk

Observed Behavior (Required on creation)

With ~20.000 External Task and ~500 authorization entities in the database the current query takes ~7 seconds (may differ on your system). The new query takes ~1.5 seconds (may differ on your system, but should be significantly lower than the first query).

Expected behavior (Required on creation)

The new query is implemented for fetch and lock queries, reducing the time that the DB needs to perform the query with high numbers of External Tasks and authorizations.

Root Cause (Required on prioritization)

The authorization check performs some joins with a lot of conditions combined by OR.
Using UNION (ref) instead of OR is much more performant on SQL Server.

Solution Ideas

Use DB specific statements to create a new query for SQL server that uses UNION instead of OR for the authorization check.

Hints

In the support case, there are visual representations of query plans for both queries: https://jira.camunda.com/browse/SUPPORT-20214?focusedCommentId=367076&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-367076

Breakdown

### Pull Requests

Dev2QA handover

[ ] Does this ticket need a QA test and the testing goals are not clear from the description? Add a Dev2QA handover comment

Aug 28 '24 09:08 mboskamp

camunda-bpm-platform
camunda-bpm-platform copied to clipboard

External Task fetch and lock query performs bad with MS SQL Server

Environment (Required on creation)

Description (Required on creation; please attach any relevant screenshots, stacktraces, log files, etc. to the ticket)

Steps to reproduce (Required on creation)

Observed Behavior (Required on creation)

Expected behavior (Required on creation)

Root Cause (Required on prioritization)

Solution Ideas

Hints

Links

Breakdown

Dev2QA handover

camunda-bpm-platform camunda-bpm-platform copied to clipboard

External Task fetch and lock query performs bad with MS SQL Server

Environment (Required on creation)

Description (Required on creation; please attach any relevant screenshots, stacktraces, log files, etc. to the ticket)

Steps to reproduce (Required on creation)

Observed Behavior (Required on creation)

Expected behavior (Required on creation)

Root Cause (Required on prioritization)

Solution Ideas

Hints

Links

Breakdown

Dev2QA handover

camunda-bpm-platform
camunda-bpm-platform copied to clipboard