Exceptions with concurrent Access

[satramalin]

Hi,

We are doing a performance test on activiti engine with 450 users concurrently accessing four applications deployed on four JVMs.

Below are the exceptions we have identified during our run

Any information on the cause or analysis on the below exceptions is highly appreciated.

Also, please advice if there is some thing which we might need to fix at our end(application level)

INFO   | jvm 1    | 2014/12/09 03:52:08 | 09 Dec 2014 03:52:08,187 [catalina-exec-33] ERROR DbSqlSession  - ########################### PERF TEST EXCEPTION BEGIN #################################
INFO   | jvm 1    | 2014/12/09 03:52:08 | 09 Dec 2014 03:52:08,189 [catalina-exec-33] ERROR DbSqlSession  - updateHistoricVariableInstance
INFO   | jvm 1    | 2014/12/09 03:52:08 | 09 Dec 2014 03:52:08,189 [catalina-exec-33] ERROR DbSqlSession  - HistoricVariableInstanceEntity[id=3109119, name=request, revision=1, type=serializable, byteArrayValueId=3109120] was updated by another transaction concurrently
INFO   | jvm 1    | 2014/12/09 03:52:08 | 09 Dec 2014 03:52:08,189 [catalina-exec-33] ERROR DbSqlSession  - ########################### PERF TEST EXCEPTION END #################################
INFO   | jvm 1    | 2014/12/09 04:24:41 | 09 Dec 2014 04:24:41,037 [catalina-exec-53] ERROR DbSqlSession  - ########################### PERF TEST EXCEPTION BEGIN #################################
INFO   | jvm 1    | 2014/12/09 04:24:41 | 09 Dec 2014 04:24:41,038 [catalina-exec-53] ERROR DbSqlSession  - updateHistoricVariableInstance
INFO   | jvm 1    | 2014/12/09 04:24:41 | 09 Dec 2014 04:24:41,038 [catalina-exec-53] ERROR DbSqlSession  - HistoricVariableInstanceEntity[id=3168413, name=request, revision=1, type=serializable, byteArrayValueId=3168414] was updated by another transaction concurrently
INFO   | jvm 1    | 2014/12/09 04:24:41 | 09 Dec 2014 04:24:41,038 [catalina-exec-53] ERROR DbSqlSession  - ########################### PERF TEST EXCEPTION END #################################
INFO   | jvm 1    | 2014/12/09 06:01:34 | 09 Dec 2014 06:01:34,102 [catalina-exec-48] ERROR DbSqlSession  - ########################### PERF TEST EXCEPTION BEGIN #################################
INFO   | jvm 1    | 2014/12/09 06:01:34 | 09 Dec 2014 06:01:34,102 [catalina-exec-48] ERROR DbSqlSession  - updateProperty
INFO   | jvm 1    | 2014/12/09 06:01:34 | 09 Dec 2014 06:01:34,103 [catalina-exec-48] ERROR DbSqlSession  - PropertyEntity[name=next.dbid, value=3292701] was updated by another transaction concurrently
INFO   | jvm 1    | 2014/12/09 06:01:34 | 09 Dec 2014 06:01:34,103 [catalina-exec-48] ERROR DbSqlSession  - ########################### PERF TEST EXCEPTION END #################################

INFO   | jvm 2    | 2014/12/09 05:45:55 | 09 Dec 2014 05:45:55,639 [catalina-exec-34] ERROR DbSqlSession  - ########################### PERF TEST EXCEPTION BEGIN #################################
INFO   | jvm 2    | 2014/12/09 05:45:55 | 09 Dec 2014 05:45:55,660 [catalina-exec-34] ERROR DbSqlSession  - updateHistoricVariableInstance
INFO   | jvm 2    | 2014/12/09 05:45:55 | 09 Dec 2014 05:45:55,660 [catalina-exec-34] ERROR DbSqlSession  - HistoricVariableInstanceEntity[id=3243161, name=request, revision=1, type=serializable, byteArrayValueId=3243162] was updated by another transaction concurrently
INFO   | jvm 2    | 2014/12/09 05:45:55 | 09 Dec 2014 05:45:55,660 [catalina-exec-34] ERROR DbSqlSession  - ########################### PERF TEST EXCEPTION END #################################
INFO   | jvm 2    | 2014/12/09 07:58:54 | 09 Dec 2014 07:58:54,525 [catalina-exec-64] ERROR DbSqlSession  - ########################### PERF TEST EXCEPTION BEGIN #################################
INFO   | jvm 2    | 2014/12/09 07:58:54 | 09 Dec 2014 07:58:54,526 [catalina-exec-64] ERROR DbSqlSession  - updateHistoricVariableInstance
INFO   | jvm 2    | 2014/12/09 07:58:54 | 09 Dec 2014 07:58:54,526 [catalina-exec-64] ERROR DbSqlSession  - HistoricVariableInstanceEntity[id=3376290, name=request, revision=0, type=serializable, byteArrayValueId=3376291] was updated by another transaction concurrently
INFO   | jvm 2    | 2014/12/09 07:58:54 | 09 Dec 2014 07:58:54,526 [catalina-exec-64] ERROR DbSqlSession  - ########################### PERF TEST EXCEPTION END #################################
INFO   | jvm 2    | 2014/12/09 09:43:42 | Dec 09, 2014 9:43:42 AM com.sun.jersey.spi.container.ContainerResponse mapMappableContainerException


INFO   | jvm 1    | 2014/12/09 03:52:08 | 09 Dec 2014 03:52:08,187 [catalina-exec-33] ERROR DbSqlSession  - ########################### PERF TEST EXCEPTION BEGIN #################################
INFO   | jvm 1    | 2014/12/09 03:52:08 | 09 Dec 2014 03:52:08,189 [catalina-exec-33] ERROR DbSqlSession  - updateHistoricVariableInstance
INFO   | jvm 1    | 2014/12/09 03:52:08 | 09 Dec 2014 03:52:08,189 [catalina-exec-33] ERROR DbSqlSession  - HistoricVariableInstanceEntity[id=3109119, name=request, revision=1, type=serializable, byteArrayValueId=3109120] was updated by another transaction concurrently
INFO   | jvm 1    | 2014/12/09 03:52:08 | 09 Dec 2014 03:52:08,189 [catalina-exec-33] ERROR DbSqlSession  - ########################### PERF TEST EXCEPTION END #################################
INFO   | jvm 1    | 2014/12/09 04:24:41 | 09 Dec 2014 04:24:41,037 [catalina-exec-53] ERROR DbSqlSession  - ########################### PERF TEST EXCEPTION BEGIN #################################
INFO   | jvm 1    | 2014/12/09 04:24:41 | 09 Dec 2014 04:24:41,038 [catalina-exec-53] ERROR DbSqlSession  - updateHistoricVariableInstance
INFO   | jvm 1    | 2014/12/09 04:24:41 | 09 Dec 2014 04:24:41,038 [catalina-exec-53] ERROR DbSqlSession  - HistoricVariableInstanceEntity[id=3168413, name=request, revision=1, type=serializable, byteArrayValueId=3168414] was updated by another transaction concurrently
INFO   | jvm 1    | 2014/12/09 04:24:41 | 09 Dec 2014 04:24:41,038 [catalina-exec-53] ERROR DbSqlSession  - ########################### PERF TEST EXCEPTION END #################################
INFO   | jvm 1    | 2014/12/09 06:01:34 | 09 Dec 2014 06:01:34,102 [catalina-exec-48] ERROR DbSqlSession  - ########################### PERF TEST EXCEPTION BEGIN #################################
INFO   | jvm 1    | 2014/12/09 06:01:34 | 09 Dec 2014 06:01:34,102 [catalina-exec-48] ERROR DbSqlSession  - updateProperty
INFO   | jvm 1    | 2014/12/09 06:01:34 | 09 Dec 2014 06:01:34,103 [catalina-exec-48] ERROR DbSqlSession  - PropertyEntity[name=next.dbid, value=3292701] was updated by another transaction concurrently
INFO   | jvm 1    | 2014/12/09 06:01:34 | 09 Dec 2014 06:01:34,103 [catalina-exec-48] ERROR DbSqlSession  - ########################### PERF TEST EXCEPTION END #################################

INFO   | jvm 1    | 2014/12/09 03:22:08 | 09 Dec 2014 03:22:08,384 [Thread-4] ERROR DbSqlSession  - ########################### PERF TEST EXCEPTION BEGIN #################################
INFO   | jvm 1    | 2014/12/09 03:22:08 | 09 Dec 2014 03:22:08,386 [Thread-4] ERROR DbSqlSession  - updateTimer
INFO   | jvm 1    | 2014/12/09 03:22:08 | 09 Dec 2014 03:22:08,386 [Thread-4] ERROR DbSqlSession  - JobEntity [id=3089759] was updated by another transaction concurrently
INFO   | jvm 1    | 2014/12/09 03:22:08 | 09 Dec 2014 03:22:08,386 [Thread-4] ERROR DbSqlSession  - ########################### PERF TEST EXCEPTION END #################################

Thanks,
Sathish

[trademak]

When 2 threads are updating variables for a specific process instance at the same time, such an exception can occur. Retry logic is one solution to solve this issue.

Best regards,