Task completion slowness due to ACT_RU_VARIABLE quries

Devakumar_Jayaraman · September 28, 2016, 5:13am

Dear All,

We are using CAMUNDA latest version in our project and going production this week. We face slowness issue due to query on ACT_RU_VARIABLE table which has around 200K records. Each query to update/delele takes more than 300 ms which in turn causes a task completion around 3 to 6 seconds.

Big worry is this slowness will increase further if load becomes more. Please suggest if there is any other alternative solution to optimize variable table or any other alternative way to store variables to overcome this issue.

Thanks & Regards,
Devakumar J

aakhmerov · September 28, 2016, 7:38am

Hi @Devakumar_Jayaraman,

thank you for the info, we will take a closer look at the database structure. Meanwhile, could you tell me which query exactly is slowing you down?

Cheers,
Askar

Devakumar_Jayaraman · September 28, 2016, 7:58am

Hi,

Please find the query logs here

77629: 27-09-16 06:22:46.742 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.cmd [BaseLogger.java:114] ENGINE-13005 Starting command -------------------- SignalCmd ----------------------
77631: 27-09-16 06:22:46.742 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.cmd [BaseLogger.java:114] ENGINE-13009 opening new command context
77632: 27-09-16 06:22:46.743 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.E.selectExecution [BaseJdbcLogger.java:139] ==> Preparing: select * from ACT_RU_EXECUTION where ID_ = ?
77633: 27-09-16 06:22:46.743 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.E.selectExecution [BaseJdbcLogger.java:139] ==> Parameters: 7e6fd9f5-846d-11e6-b0b4-000f530e1f6c(String)
77646: 27-09-16 06:22:46.822 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.E.selectExecution [BaseJdbcLogger.java:139] <== Total: 1
77649: 27-09-16 06:22:46.824 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.P.selectProcessDefinition [BaseJdbcLogger.java:139] ==> Preparing: select * from ACT_RE_PROCDEF where ID_ = ?
77652: 27-09-16 06:22:46.825 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.P.selectProcessDefinition [BaseJdbcLogger.java:139] ==> Parameters: ORACLE_ADD_LOCAL_ACCOUNT:3:33913225-4753-11e6-ad9c-005056991119(String)
77655: 27-09-16 06:22:46.827 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.P.selectProcessDefinition [BaseJdbcLogger.java:139] <== Total: 1
77656: 27-09-16 06:22:46.828 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.selectVariablesByExecutionId [BaseJdbcLogger.java:139] ==> Preparing: SELECT RES., ( case when RES.TASK_ID_ is not null and RES.EXECUTION_ID_ is not null then EXECUTION.ACT_INST_ID_ when RES.CASE_EXECUTION_ID_ is not null then RES.CASE_EXECUTION_ID_ when EXECUTION.PARENT_ID_ is null and RES.IS_CONCURRENT_LOCAL_ = 0 then EXECUTION.ID_ when EXECUTION.IS_SCOPE_ = 1 and EXECUTION.PARENT_ID_ is not null and RES.IS_CONCURRENT_LOCAL_ = 0 then PARENT_EXECUTION.ACT_INST_ID_ else EXECUTION.ACT_INST_ID_ end ) ACT_INST_ID_ FROM ACT_RU_VARIABLE RES LEFT JOIN ACT_RU_EXECUTION EXECUTION ON RES.EXECUTION_ID_ = EXECUTION.ID_ LEFT JOIN ACT_RU_EXECUTION PARENT_EXECUTION ON EXECUTION.PARENT_ID_ = PARENT_EXECUTION.ID_ WHERE EXECUTION_ID_ = ? AND TASK_ID_ is null
77657: 27-09-16 06:22:46.829 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.selectVariablesByExecutionId [BaseJdbcLogger.java:139] ==> Parameters: 7e6fd9f5-846d-11e6-b0b4-000f530e1f6c(String)
77705: 27-09-16 06:22:47.208 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.selectVariablesByExecutionId [BaseJdbcLogger.java:139] <== Total: 6
77706: 27-09-16 06:22:47.209 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.E.selectExecutionsByProcessInstanceId [BaseJdbcLogger.java:139] ==> Preparing: select * from ACT_RU_EXECUTION where PROC_INST_ID_ = ?
77707: 27-09-16 06:22:47.209 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.E.selectExecutionsByProcessInstanceId [BaseJdbcLogger.java:139] ==> Parameters: 70a79059-846d-11e6-b0b4-000f530e1f6c(String)
77708: 27-09-16 06:22:47.356 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.E.selectExecutionsByProcessInstanceId [BaseJdbcLogger.java:139] <== Total: 736
77709: 27-09-16 06:22:47.360 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.selectVariablesByExecutionId [BaseJdbcLogger.java:139] ==> Preparing: SELECT RES., ( case when RES.TASK_ID_ is not null and RES.EXECUTION_ID_ is not null then EXECUTION.ACT_INST_ID_ when RES.CASE_EXECUTION_ID_ is not null then RES.CASE_EXECUTION_ID_ when EXECUTION.PARENT_ID_ is null and RES.IS_CONCURRENT_LOCAL_ = 0 then EXECUTION.ID_ when EXECUTION.IS_SCOPE_ = 1 and EXECUTION.PARENT_ID_ is not null and RES.IS_CONCURRENT_LOCAL_ = 0 then PARENT_EXECUTION.ACT_INST_ID_ else EXECUTION.ACT_INST_ID_ end ) ACT_INST_ID_ FROM ACT_RU_VARIABLE RES LEFT JOIN ACT_RU_EXECUTION EXECUTION ON RES.EXECUTION_ID_ = EXECUTION.ID_ LEFT JOIN ACT_RU_EXECUTION PARENT_EXECUTION ON EXECUTION.PARENT_ID_ = PARENT_EXECUTION.ID_ WHERE EXECUTION_ID_ = ? AND TASK_ID_ is null
77710: 27-09-16 06:22:47.361 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.selectVariablesByExecutionId [BaseJdbcLogger.java:139] ==> Parameters: 7e6fd9f0-846d-11e6-b0b4-000f530e1f6c(String)
77729: 27-09-16 06:22:47.711 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.selectVariablesByExecutionId [BaseJdbcLogger.java:139] <== Total: 3
77730: 27-09-16 06:22:47.711 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.selectVariablesByExecutionId [BaseJdbcLogger.java:139] ==> Preparing: SELECT RES., ( case when RES.TASK_ID_ is not null and RES.EXECUTION_ID_ is not null then EXECUTION.ACT_INST_ID_ when RES.CASE_EXECUTION_ID_ is not null then RES.CASE_EXECUTION_ID_ when EXECUTION.PARENT_ID_ is null and RES.IS_CONCURRENT_LOCAL_ = 0 then EXECUTION.ID_ when EXECUTION.IS_SCOPE_ = 1 and EXECUTION.PARENT_ID_ is not null and RES.IS_CONCURRENT_LOCAL_ = 0 then PARENT_EXECUTION.ACT_INST_ID_ else EXECUTION.ACT_INST_ID_ end ) ACT_INST_ID_ FROM ACT_RU_VARIABLE RES LEFT JOIN ACT_RU_EXECUTION EXECUTION ON RES.EXECUTION_ID_ = EXECUTION.ID_ LEFT JOIN ACT_RU_EXECUTION PARENT_EXECUTION ON EXECUTION.PARENT_ID_ = PARENT_EXECUTION.ID_ WHERE EXECUTION_ID_ = ? AND TASK_ID_ is null
77731: 27-09-16 06:22:47.712 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.selectVariablesByExecutionId [BaseJdbcLogger.java:139] ==> Parameters: 7e6e05d9-846d-11e6-b0b4-000f530e1f6c(String)
77741: 27-09-16 06:22:48.055 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.selectVariablesByExecutionId [BaseJdbcLogger.java:139] <== Total: 1
77742: 27-09-16 06:22:48.055 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.selectVariablesByExecutionId [BaseJdbcLogger.java:139] ==> Preparing: SELECT RES., ( case when RES.TASK_ID_ is not null and RES.EXECUTION_ID_ is not null then EXECUTION.ACT_INST_ID_ when RES.CASE_EXECUTION_ID_ is not null then RES.CASE_EXECUTION_ID_ when EXECUTION.PARENT_ID_ is null and RES.IS_CONCURRENT_LOCAL_ = 0 then EXECUTION.ID_ when EXECUTION.IS_SCOPE_ = 1 and EXECUTION.PARENT_ID_ is not null and RES.IS_CONCURRENT_LOCAL_ = 0 then PARENT_EXECUTION.ACT_INST_ID_ else EXECUTION.ACT_INST_ID_ end ) ACT_INST_ID_ FROM ACT_RU_VARIABLE RES LEFT JOIN ACT_RU_EXECUTION EXECUTION ON RES.EXECUTION_ID_ = EXECUTION.ID_ LEFT JOIN ACT_RU_EXECUTION PARENT_EXECUTION ON EXECUTION.PARENT_ID_ = PARENT_EXECUTION.ID_ WHERE EXECUTION_ID_ = ? AND TASK_ID_ is null
77743: 27-09-16 06:22:48.056 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.selectVariablesByExecutionId [BaseJdbcLogger.java:139] ==> Parameters: 7c2ddb4a-846d-11e6-b0b4-000f530e1f6c(String)
77753: 27-09-16 06:22:48.416 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.selectVariablesByExecutionId [BaseJdbcLogger.java:139] <== Total: 2
77754: 27-09-16 06:22:48.416 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.selectVariablesByExecutionId [BaseJdbcLogger.java:139] ==> Preparing: SELECT RES., ( case when RES.TASK_ID_ is not null and RES.EXECUTION_ID_ is not null then EXECUTION.ACT_INST_ID_ when RES.CASE_EXECUTION_ID_ is not null then RES.CASE_EXECUTION_ID_ when EXECUTION.PARENT_ID_ is null and RES.IS_CONCURRENT_LOCAL_ = 0 then EXECUTION.ID_ when EXECUTION.IS_SCOPE_ = 1 and EXECUTION.PARENT_ID_ is not null and RES.IS_CONCURRENT_LOCAL_ = 0 then PARENT_EXECUTION.ACT_INST_ID_ else EXECUTION.ACT_INST_ID_ end ) ACT_INST_ID_ FROM ACT_RU_VARIABLE RES LEFT JOIN ACT_RU_EXECUTION EXECUTION ON RES.EXECUTION_ID_ = EXECUTION.ID_ LEFT JOIN ACT_RU_EXECUTION PARENT_EXECUTION ON EXECUTION.PARENT_ID_ = PARENT_EXECUTION.ID_ WHERE EXECUTION_ID_ = ? AND TASK_ID_ is null
77755: 27-09-16 06:22:48.417 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.selectVariablesByExecutionId [BaseJdbcLogger.java:139] ==> Parameters: 7c2db2fd-846d-11e6-b0b4-000f530e1f6c(String)
77765: 27-09-16 06:22:48.763 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.selectVariablesByExecutionId [BaseJdbcLogger.java:139] <== Total: 3
77766: 27-09-16 06:22:48.763 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.selectVariablesByExecutionId [BaseJdbcLogger.java:139] ==> Preparing: SELECT RES., ( case when RES.TASK_ID_ is not null and RES.EXECUTION_ID_ is not null then EXECUTION.ACT_INST_ID_ when RES.CASE_EXECUTION_ID_ is not null then RES.CASE_EXECUTION_ID_ when EXECUTION.PARENT_ID_ is null and RES.IS_CONCURRENT_LOCAL_ = 0 then EXECUTION.ID_ when EXECUTION.IS_SCOPE_ = 1 and EXECUTION.PARENT_ID_ is not null and RES.IS_CONCURRENT_LOCAL_ = 0 then PARENT_EXECUTION.ACT_INST_ID_ else EXECUTION.ACT_INST_ID_ end ) ACT_INST_ID_ FROM ACT_RU_VARIABLE RES LEFT JOIN ACT_RU_EXECUTION EXECUTION ON RES.EXECUTION_ID_ = EXECUTION.ID_ LEFT JOIN ACT_RU_EXECUTION PARENT_EXECUTION ON EXECUTION.PARENT_ID_ = PARENT_EXECUTION.ID_ WHERE EXECUTION_ID_ = ? AND TASK_ID_ is null
77767: 27-09-16 06:22:48.764 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.selectVariablesByExecutionId [BaseJdbcLogger.java:139] ==> Parameters: 70a79059-846d-11e6-b0b4-000f530e1f6c(String)
77777: 27-09-16 06:22:49.115 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.selectVariablesByExecutionId [BaseJdbcLogger.java:139] <== Total: 9
77778: 27-09-16 06:22:49.116 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.selectByteArray [BaseJdbcLogger.java:139] ==> Preparing: select * from ACT_GE_BYTEARRAY where ID_ = ?
77779: 27-09-16 06:22:49.117 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.selectByteArray [BaseJdbcLogger.java:139] ==> Parameters: 6adf0ebe-8472-11e6-955a-000f530e1f6c(String)
77780: 27-09-16 06:22:49.124 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.selectByteArray [BaseJdbcLogger.java:139] <== Total: 1
77781: 27-09-16 06:22:49.125 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c INFO [adapterExecutorService-6] c.p.w.b.ApmTaskBehaviour [ApmTaskBehaviour.java:59] Execution status => null
77876: 27-09-16 06:22:49.395 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.persistence [BaseLogger.java:114] ENGINE-03006 Cache state after flush: [
78632: 27-09-16 06:22:49.397 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.persistence [BaseLogger.java:114] ENGINE-03008 Flush Summary: [
78654: 27-09-16 06:22:49.397 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.persistence [BaseLogger.java:114] ENGINE-03009 SQL operation: ‘INSERT’; Entity: ‘ByteArrayEntity[id=6e316e1a-8472-11e6-955a-000f530e1f6c]’
78655: 27-09-16 06:22:49.398 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.insertByteArray [BaseJdbcLogger.java:139] ==> Preparing: insert into ACT_GE_BYTEARRAY(ID_, NAME_, BYTES_, DEPLOYMENT_ID_, TENANT_ID_, REV_) values ( ?, ?, ?, ?, ?, 1 )
78656: 27-09-16 06:22:49.398 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.insertByteArray [BaseJdbcLogger.java:139] ==> Parameters: 6e316e1a-8472-11e6-955a-000f530e1f6c(String), adapterPayload(String), java.io.ByteArrayInputStream@5cb21990(ByteArrayInputStream), null, null
78657: 27-09-16 06:22:49.400 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.insertByteArray [BaseJdbcLogger.java:139] <== Updates: 1
78658: 27-09-16 06:22:49.400 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.persistence [BaseLogger.java:114] ENGINE-03009 SQL operation: ‘UPDATE’; Entity: ‘VariableInstanceEntity[id=734e46b0-846d-11e6-b0b4-000f530e1f6c]’
78659: 27-09-16 06:22:49.401 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.updateVariableInstance [BaseJdbcLogger.java:139] ==> Preparing: update ACT_RU_VARIABLE set REV_ = ?, EXECUTION_ID_ = ?, VAR_SCOPE_ = ?, TYPE_ = ?, BYTEARRAY_ID_ = ?, DOUBLE_ = ?, LONG_ = ?, TEXT_ = ?, TEXT2_ = ?, SEQUENCE_COUNTER_ = ? where ID_ = ? and REV_ = ?
78660: 27-09-16 06:22:49.401 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.updateVariableInstance [BaseJdbcLogger.java:139] ==> Parameters: 174(Integer), 70a79059-846d-11e6-b0b4-000f530e1f6c(String), 70a79059-846d-11e6-b0b4-000f530e1f6c(String), serializable(String), 6e316e1a-8472-11e6-955a-000f530e1f6c(String), null, null, null, com.phoenix.adapter.domain.AdapterMessage(String), 174(Long), 734e46b0-846d-11e6-b0b4-000f530e1f6c(String), 173(Integer)
79749: 27-09-16 06:22:49.599 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.updateVariableInstance [BaseJdbcLogger.java:139] <== Updates: 1
79751: 27-09-16 06:22:49.600 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.persistence [BaseLogger.java:114] ENGINE-03009 SQL operation: ‘UPDATE’; Entity: ‘VariableInstanceEntity[id=7c2db300-846d-11e6-b0b4-000f530e1f6c]’
79753: 27-09-16 06:22:49.601 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.updateVariableInstance [BaseJdbcLogger.java:139] ==> Preparing: update ACT_RU_VARIABLE set REV_ = ?, EXECUTION_ID_ = ?, VAR_SCOPE_ = ?, TYPE_ = ?, BYTEARRAY_ID_ = ?, DOUBLE_ = ?, LONG_ = ?, TEXT_ = ?, TEXT2_ = ?, SEQUENCE_COUNTER_ = ? where ID_ = ? and REV_ = ?
79755: 27-09-16 06:22:49.602 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.updateVariableInstance [BaseJdbcLogger.java:139] ==> Parameters: 172(Integer), 7c2db2fd-846d-11e6-b0b4-000f530e1f6c(String), 7c2db2fd-846d-11e6-b0b4-000f530e1f6c(String), integer(String), null, null, 171(Long), 171(String), null, 172(Long), 7c2db300-846d-11e6-b0b4-000f530e1f6c(String), 171(Integer)
81606: 27-09-16 06:22:49.792 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.updateVariableInstance [BaseJdbcLogger.java:139] <== Updates: 1
81607: 27-09-16 06:22:49.792 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.persistence [BaseLogger.java:114] ENGINE-03009 SQL operation: ‘UPDATE’; Entity: ‘VariableInstanceEntity[id=7c2db301-846d-11e6-b0b4-000f530e1f6c]’
81608: 27-09-16 06:22:49.793 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.updateVariableInstance [BaseJdbcLogger.java:139] ==> Preparing: update ACT_RU_VARIABLE set REV_ = ?, EXECUTION_ID_ = ?, VAR_SCOPE_ = ?, TYPE_ = ?, BYTEARRAY_ID_ = ?, DOUBLE_ = ?, LONG_ = ?, TEXT_ = ?, TEXT2_ = ?, SEQUENCE_COUNTER_ = ? where ID_ = ? and REV_ = ?
81609: 27-09-16 06:22:49.793 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.updateVariableInstance [BaseJdbcLogger.java:139] ==> Parameters: 172(Integer), 7c2db2fd-846d-11e6-b0b4-000f530e1f6c(String), 7c2db2fd-846d-11e6-b0b4-000f530e1f6c(String), integer(String), null, null, 140(Long), 140(String), null, 172(Long), 7c2db301-846d-11e6-b0b4-000f530e1f6c(String), 171(Integer)
81622: 27-09-16 06:22:49.981 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.updateVariableInstance [BaseJdbcLogger.java:139] <== Updates: 1
81623: 27-09-16 06:22:49.982 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.persistence [BaseLogger.java:114] ENGINE-03009 SQL operation: ‘DELETE’; Entity: ‘VariableInstanceEntity[id=7e6e05db-846d-11e6-b0b4-000f530e1f6c]’
81624: 27-09-16 06:22:49.982 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.deleteVariableInstance [BaseJdbcLogger.java:139] ==> Preparing: delete from ACT_RU_VARIABLE where ID_ = ? and REV_ = ?
81625: 27-09-16 06:22:49.983 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.deleteVariableInstance [BaseJdbcLogger.java:139] ==> Parameters: 7e6e05db-846d-11e6-b0b4-000f530e1f6c(String), 1(Integer)
81638: 27-09-16 06:22:50.170 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.deleteVariableInstance [BaseJdbcLogger.java:139] <== Updates: 1
81639: 27-09-16 06:22:50.171 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.persistence [BaseLogger.java:114] ENGINE-03009 SQL operation: ‘DELETE’; Entity: ‘VariableInstanceEntity[id=7e6fd9f2-846d-11e6-b0b4-000f530e1f6c]’
81640: 27-09-16 06:22:50.171 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.deleteVariableInstance [BaseJdbcLogger.java:139] ==> Preparing: delete from ACT_RU_VARIABLE where ID_ = ? and REV_ = ?
81641: 27-09-16 06:22:50.171 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.deleteVariableInstance [BaseJdbcLogger.java:139] ==> Parameters: 7e6fd9f2-846d-11e6-b0b4-000f530e1f6c(String), 1(Integer)
81651: 27-09-16 06:22:50.348 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.deleteVariableInstance [BaseJdbcLogger.java:139] <== Updates: 1
81653: 27-09-16 06:22:50.349 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.persistence [BaseLogger.java:114] ENGINE-03009 SQL operation: ‘DELETE’; Entity: ‘VariableInstanceEntity[id=7e6fd9f3-846d-11e6-b0b4-000f530e1f6c]’
81655: 27-09-16 06:22:50.350 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.deleteVariableInstance [BaseJdbcLogger.java:139] ==> Preparing: delete from ACT_RU_VARIABLE where ID_ = ? and REV_ = ?
81657: 27-09-16 06:22:50.351 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.deleteVariableInstance [BaseJdbcLogger.java:139] ==> Parameters: 7e6fd9f3-846d-11e6-b0b4-000f530e1f6c(String), 1(Integer)
81667: 27-09-16 06:22:50.540 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.deleteVariableInstance [BaseJdbcLogger.java:139] <== Updates: 1
81669: 27-09-16 06:22:50.541 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.persistence [BaseLogger.java:114] ENGINE-03009 SQL operation: ‘DELETE’; Entity: ‘VariableInstanceEntity[id=7e6fd9f4-846d-11e6-b0b4-000f530e1f6c]’
81671: 27-09-16 06:22:50.542 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.deleteVariableInstance [BaseJdbcLogger.java:139] ==> Preparing: delete from ACT_RU_VARIABLE where ID_ = ? and REV_ = ?
81673: 27-09-16 06:22:50.543 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.deleteVariableInstance [BaseJdbcLogger.java:139] ==> Parameters: 7e6fd9f4-846d-11e6-b0b4-000f530e1f6c(String), 1(Integer)
81682: 27-09-16 06:22:50.732 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.deleteVariableInstance [BaseJdbcLogger.java:139] <== Updates: 1
81684: 27-09-16 06:22:50.733 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.persistence [BaseLogger.java:114] ENGINE-03009 SQL operation: ‘DELETE’; Entity: ‘VariableInstanceEntity[id=7e6fd9f6-846d-11e6-b0b4-000f530e1f6c]’
81686: 27-09-16 06:22:50.734 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.deleteVariableInstance [BaseJdbcLogger.java:139] ==> Preparing: delete from ACT_RU_VARIABLE where ID_ = ? and REV_ = ?
81688: 27-09-16 06:22:50.735 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.deleteVariableInstance [BaseJdbcLogger.java:139] ==> Parameters: 7e6fd9f6-846d-11e6-b0b4-000f530e1f6c(String), 1(Integer)
81699: 27-09-16 06:22:50.924 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.deleteVariableInstance [BaseJdbcLogger.java:139] <== Updates: 1
81701: 27-09-16 06:22:50.925 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.persistence [BaseLogger.java:114] ENGINE-03009 SQL operation: ‘DELETE’; Entity: ‘VariableInstanceEntity[id=7e6fd9f7-846d-11e6-b0b4-000f530e1f6c]’
81703: 27-09-16 06:22:50.925 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.deleteVariableInstance [BaseJdbcLogger.java:139] ==> Preparing: delete from ACT_RU_VARIABLE where ID_ = ? and REV_ = ?
81705: 27-09-16 06:22:50.926 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.deleteVariableInstance [BaseJdbcLogger.java:139] ==> Parameters: 7e6fd9f7-846d-11e6-b0b4-000f530e1f6c(String), 1(Integer)
81715: 27-09-16 06:22:51.114 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.deleteVariableInstance [BaseJdbcLogger.java:139] <== Updates: 1
81717: 27-09-16 06:22:51.115 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.persistence [BaseLogger.java:114] ENGINE-03009 SQL operation: ‘DELETE’; Entity: ‘VariableInstanceEntity[id=7e6fd9f9-846d-11e6-b0b4-000f530e1f6c]’
81719: 27-09-16 06:22:51.116 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.deleteVariableInstance [BaseJdbcLogger.java:139] ==> Preparing: delete from ACT_RU_VARIABLE where ID_ = ? and REV_ = ?
81721: 27-09-16 06:22:51.117 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.deleteVariableInstance [BaseJdbcLogger.java:139] ==> Parameters: 7e6fd9f9-846d-11e6-b0b4-000f530e1f6c(String), 1(Integer)
81731: 27-09-16 06:22:51.306 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.deleteVariableInstance [BaseJdbcLogger.java:139] <== Updates: 1
81733: 27-09-16 06:22:51.307 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.persistence [BaseLogger.java:114] ENGINE-03009 SQL operation: ‘DELETE’; Entity: ‘VariableInstanceEntity[id=7e6fd9fa-846d-11e6-b0b4-000f530e1f6c]’
81735: 27-09-16 06:22:51.307 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.deleteVariableInstance [BaseJdbcLogger.java:139] ==> Preparing: delete from ACT_RU_VARIABLE where ID_ = ? and REV_ = ?
81737: 27-09-16 06:22:51.308 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.deleteVariableInstance [BaseJdbcLogger.java:139] ==> Parameters: 7e6fd9fa-846d-11e6-b0b4-000f530e1f6c(String), 1(Integer)
81747: 27-09-16 06:22:51.497 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.deleteVariableInstance [BaseJdbcLogger.java:139] <== Updates: 1
81749: 27-09-16 06:22:51.498 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.persistence [BaseLogger.java:114] ENGINE-03009 SQL operation: ‘DELETE’; Entity: ‘VariableInstanceEntity[id=7e6fd9fb-846d-11e6-b0b4-000f530e1f6c]’
81751: 27-09-16 06:22:51.499 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.deleteVariableInstance [BaseJdbcLogger.java:139] ==> Preparing: delete from ACT_RU_VARIABLE where ID_ = ? and REV_ = ?
81753: 27-09-16 06:22:51.500 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.deleteVariableInstance [BaseJdbcLogger.java:139] ==> Parameters: 7e6fd9fb-846d-11e6-b0b4-000f530e1f6c(String), 1(Integer)
81762: 27-09-16 06:22:51.688 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.deleteVariableInstance [BaseJdbcLogger.java:139] <== Updates: 1
81764: 27-09-16 06:22:51.689 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.persistence [BaseLogger.java:114] ENGINE-03009 SQL operation: ‘DELETE’; Entity: ‘VariableInstanceEntity[id=7e6fd9fc-846d-11e6-b0b4-000f530e1f6c]’
81766: 27-09-16 06:22:51.690 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.deleteVariableInstance [BaseJdbcLogger.java:139] ==> Preparing: delete from ACT_RU_VARIABLE where ID_ = ? and REV_ = ?
81768: 27-09-16 06:22:51.691 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.deleteVariableInstance [BaseJdbcLogger.java:139] ==> Parameters: 7e6fd9fc-846d-11e6-b0b4-000f530e1f6c(String), 1(Integer)
81779: 27-09-16 06:22:51.880 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.deleteVariableInstance [BaseJdbcLogger.java:139] <== Updates: 1
81781: 27-09-16 06:22:51.882 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.persistence [BaseLogger.java:114] ENGINE-03010 SQL bulk operation: ‘DELETE’; Statement: ‘deleteByteArrayNoRevisionCheck’; Parameter: ‘6adf0ebe-8472-11e6-955a-000f530e1f6c’
81783: 27-09-16 06:22:51.883 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.deleteByteArrayNoRevisionCheck [BaseJdbcLogger.java:139] ==> Preparing: delete from ACT_GE_BYTEARRAY where ID_ = ?
81785: 27-09-16 06:22:51.884 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.deleteByteArrayNoRevisionCheck [BaseJdbcLogger.java:139] ==> Parameters: 6adf0ebe-8472-11e6-955a-000f530e1f6c(String)
81786: 27-09-16 06:22:51.890 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.V.deleteByteArrayNoRevisionCheck [BaseJdbcLogger.java:139] <== Updates: 1
81787: 27-09-16 06:22:51.891 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.persistence [BaseLogger.java:114] ENGINE-03009 SQL operation: ‘UPDATE’; Entity: ‘ExecutionEntity[id=7c2ddb4a-846d-11e6-b0b4-000f530e1f6c]’
81788: 27-09-16 06:22:51.891 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.E.updateExecution [BaseJdbcLogger.java:139] ==> Preparing: update ACT_RU_EXECUTION set REV_ = ?, PROC_DEF_ID_ = ?, ACT_ID_ = ?, ACT_INST_ID_ = ?, IS_ACTIVE_ = ?, IS_CONCURRENT_ = ?, IS_SCOPE_ = ?, IS_EVENT_SCOPE_ = ?, PARENT_ID_ = ?, SUPER_EXEC_ = ?, SUSPENSION_STATE_ = ?, CACHED_ENT_STATE_ = ?, SEQUENCE_COUNTER_ = ?, TENANT_ID_ = ? where ID_ = ? and REV_ = ?
81789: 27-09-16 06:22:51.892 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.E.updateExecution [BaseJdbcLogger.java:139] ==> Parameters: 2(Integer), ORACLE_ADD_LOCAL_ACCOUNT:3:33913225-4753-11e6-ad9c-005056991119(String), SubProcess_1(String), null, false(Boolean), true(Boolean), false(Boolean), false(Boolean), 7c2db2fd-846d-11e6-b0b4-000f530e1f6c(String), null, 1(Integer), 16(Integer), 31(Long), null, 7c2ddb4a-846d-11e6-b0b4-000f530e1f6c(String), 1(Integer)
81790: 27-09-16 06:22:51.950 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.E.updateExecution [BaseJdbcLogger.java:139] <== Updates: 1
81791: 27-09-16 06:22:51.950 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.persistence [BaseLogger.java:114] ENGINE-03009 SQL operation: ‘UPDATE’; Entity: ‘ExecutionEntity[id=7c2db2fd-846d-11e6-b0b4-000f530e1f6c]’
81792: 27-09-16 06:22:51.950 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.E.updateExecution [BaseJdbcLogger.java:139] ==> Preparing: update ACT_RU_EXECUTION set REV_ = ?, PROC_DEF_ID_ = ?, ACT_ID_ = ?, ACT_INST_ID_ = ?, IS_ACTIVE_ = ?, IS_CONCURRENT_ = ?, IS_SCOPE_ = ?, IS_EVENT_SCOPE_ = ?, PARENT_ID_ = ?, SUPER_EXEC_ = ?, SUSPENSION_STATE_ = ?, CACHED_ENT_STATE_ = ?, SEQUENCE_COUNTER_ = ?, TENANT_ID_ = ? where ID_ = ? and REV_ = ?
81793: 27-09-16 06:22:51.951 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.E.updateExecution [BaseJdbcLogger.java:139] ==> Parameters: 172(Integer), ORACLE_ADD_LOCAL_ACCOUNT:3:33913225-4753-11e6-ad9c-005056991119(String), null, 7c2db2fe-846d-11e6-b0b4-000f530e1f6c(String), false(Boolean), false(Boolean), true(Boolean), false(Boolean), 70a79059-846d-11e6-b0b4-000f530e1f6c(String), null, 1(Integer), 16(Integer), 17(Long), null, 7c2db2fd-846d-11e6-b0b4-000f530e1f6c(String), 171(Integer)
81794: 27-09-16 06:22:51.971 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.E.updateExecution [BaseJdbcLogger.java:139] <== Updates: 1
81795: 27-09-16 06:22:51.972 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.persistence [BaseLogger.java:114] ENGINE-03009 SQL operation: ‘DELETE’; Entity: ‘ExecutionEntity[id=7e6fd9f5-846d-11e6-b0b4-000f530e1f6c]’
81796: 27-09-16 06:22:51.972 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.E.deleteExecution [BaseJdbcLogger.java:139] ==> Preparing: delete from ACT_RU_EXECUTION where ID_ = ? and REV_ = ?
81797: 27-09-16 06:22:51.973 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.E.deleteExecution [BaseJdbcLogger.java:139] ==> Parameters: 7e6fd9f5-846d-11e6-b0b4-000f530e1f6c(String), 1(Integer)
81806: 27-09-16 06:22:52.029 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.E.deleteExecution [BaseJdbcLogger.java:139] <== Updates: 1
81807: 27-09-16 06:22:52.030 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.persistence [BaseLogger.java:114] ENGINE-03009 SQL operation: ‘DELETE’; Entity: ‘ExecutionEntity[id=7e6fd9f0-846d-11e6-b0b4-000f530e1f6c]’
81808: 27-09-16 06:22:52.030 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.E.deleteExecution [BaseJdbcLogger.java:139] ==> Preparing: delete from ACT_RU_EXECUTION where ID_ = ? and REV_ = ?
81809: 27-09-16 06:22:52.030 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.E.deleteExecution [BaseJdbcLogger.java:139] ==> Parameters: 7e6fd9f0-846d-11e6-b0b4-000f530e1f6c(String), 1(Integer)
81818: 27-09-16 06:22:52.088 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.E.deleteExecution [BaseJdbcLogger.java:139] <== Updates: 1
81819: 27-09-16 06:22:52.088 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.persistence [BaseLogger.java:114] ENGINE-03009 SQL operation: ‘DELETE’; Entity: ‘ExecutionEntity[id=7e6e05d9-846d-11e6-b0b4-000f530e1f6c]’
81820: 27-09-16 06:22:52.089 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.E.deleteExecution [BaseJdbcLogger.java:139] ==> Preparing: delete from ACT_RU_EXECUTION where ID_ = ? and REV_ = ?
81821: 27-09-16 06:22:52.089 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.E.deleteExecution [BaseJdbcLogger.java:139] ==> Parameters: 7e6e05d9-846d-11e6-b0b4-000f530e1f6c(String), 1(Integer)
81823: 27-09-16 06:22:52.141 TID=2052326b-0a0c-4f29-be7e-9611bf24a02c DEBUG [adapterExecutorService-6] o.c.b.e.i.p.e.E.deleteExecution [BaseJdbcLogger.java:139] <== Updates: 1

Devakumar_Jayaraman · September 28, 2016, 7:59am

Please provide if any alternate way to store and retrieve variables.

aakhmerov · September 28, 2016, 8:29am

Hi @Devakumar_Jayaraman,

did you try to run EXPLAIN against this query already? Can you see which indexes are used?

Cheers,
Askar

Devakumar_Jayaraman · September 29, 2016, 3:39pm

Hi @aakhmerov,

Its plain update/delete queries on ACT_RU_VARIABLE table.
delete from ACT_RU_EXECUTION where ID_ = ? and REV_ = ?
Looks like query time increases drastically based on load.

For eg)

When 50K records it takes around 20 ms.
When 200K records it takes around 200 ms.

Our process has the complexity of having multi-instance sub process which is spanning around 1000 parallel tasks.

So it requires better way to store and retrieve execution variables.

Thanks & Regards,
Devakumar J

aakhmerov · September 29, 2016, 3:43pm

Hi @Devakumar_Jayaraman,

I meant explain sql query https://www.postgresql.org/docs/9.1/static/sql-explain.html. Which database are you using?

Cheers,
Askar.

Devakumar_Jayaraman · September 29, 2016, 3:53pm

Hi Askar,

We are using ORACLE database.

Thanks & Regards,
Devakumar J

aakhmerov · September 29, 2016, 4:17pm

Hi @Devakumar_Jayaraman,

then here is the right command reference

https://docs.oracle.com/cd/B19306_01/server.102/b14211/ex_plan.htm#i3305

Pythari · October 27, 2021, 11:29am

Am also facing the same issue, ACT_RU_VARIABLE having 1cr records and getting performance issues. Checked query plan and table is going FULL table scan eventhough we have all the indexes available. Please suggest a solution

Phaneendra · December 28, 2021, 5:39am

@Devakumar_Jayaraman @Pythari , We are facing similar issue with exact same query which is taking too long to complete. Can you please suggest how you are able to resolve the same?

system · January 30, 2024, 10:41am