topic Exceptions with concurrent Access in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/exceptions-with-concurrent-access/m-p/208765#M161895 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>We are doing a performance test on activiti engine with 450 users concurrently accessing four applications deployed on four JVMs.</SPAN><BR /><BR /><SPAN>Below are the exceptions we have identified during our run</SPAN><BR /><BR /><SPAN>Any information on the cause or analysis on the below exceptions is highly appreciated.</SPAN><BR /><BR /><SPAN>Also, please advice if there is some thing which we might need to fix at our end(application level)</SPAN><BR /><BR /><SPAN>INFO&nbsp;&nbsp; | jvm 1&nbsp;&nbsp;&nbsp; | 2014/12/09 03:52:08 | 09 Dec 2014 03:52:08,187 [catalina-exec-33] ERROR DbSqlSession&nbsp; - ########################### PERF TEST EXCEPTION BEGIN #################################</SPAN><BR /><SPAN>INFO&nbsp;&nbsp; | jvm 1&nbsp;&nbsp;&nbsp; | 2014/12/09 03:52:08 | 09 Dec 2014 03:52:08,189 [catalina-exec-33] ERROR DbSqlSession&nbsp; - updateHistoricVariableInstance</SPAN><BR /><SPAN>INFO&nbsp;&nbsp; | jvm 1&nbsp;&nbsp;&nbsp; | 2014/12/09 03:52:08 | 09 Dec 2014 03:52:08,189 [catalina-exec-33] ERROR DbSqlSession&nbsp; - HistoricVariableInstanceEntity[id=3109119, name=request, revision=1, type=serializable, byteArrayValueId=3109120] was updated by another transaction concurrently</SPAN><BR /><SPAN>INFO&nbsp;&nbsp; | jvm 1&nbsp;&nbsp;&nbsp; | 2014/12/09 03:52:08 | 09 Dec 2014 03:52:08,189 [catalina-exec-33] ERROR DbSqlSession&nbsp; - ########################### PERF TEST EXCEPTION END #################################</SPAN><BR /><SPAN>INFO&nbsp;&nbsp; | jvm 1&nbsp;&nbsp;&nbsp; | 2014/12/09 04:24:41 | 09 Dec 2014 04:24:41,037 [catalina-exec-53] ERROR DbSqlSession&nbsp; - ########################### PERF TEST EXCEPTION BEGIN #################################</SPAN><BR /><SPAN>INFO&nbsp;&nbsp; | jvm 1&nbsp;&nbsp;&nbsp; | 2014/12/09 04:24:41 | 09 Dec 2014 04:24:41,038 [catalina-exec-53] ERROR DbSqlSession&nbsp; - updateHistoricVariableInstance</SPAN><BR /><SPAN>INFO&nbsp;&nbsp; | jvm 1&nbsp;&nbsp;&nbsp; | 2014/12/09 04:24:41 | 09 Dec 2014 04:24:41,038 [catalina-exec-53] ERROR DbSqlSession&nbsp; - HistoricVariableInstanceEntity[id=3168413, name=request, revision=1, type=serializable, byteArrayValueId=3168414] was updated by another transaction concurrently</SPAN><BR /><SPAN>INFO&nbsp;&nbsp; | jvm 1&nbsp;&nbsp;&nbsp; | 2014/12/09 04:24:41 | 09 Dec 2014 04:24:41,038 [catalina-exec-53] ERROR DbSqlSession&nbsp; - ########################### PERF TEST EXCEPTION END #################################</SPAN><BR /><SPAN>INFO&nbsp;&nbsp; | jvm 1&nbsp;&nbsp;&nbsp; | 2014/12/09 06:01:34 | 09 Dec 2014 06:01:34,102 [catalina-exec-48] ERROR DbSqlSession&nbsp; - ########################### PERF TEST EXCEPTION BEGIN #################################</SPAN><BR /><SPAN>INFO&nbsp;&nbsp; | jvm 1&nbsp;&nbsp;&nbsp; | 2014/12/09 06:01:34 | 09 Dec 2014 06:01:34,102 [catalina-exec-48] ERROR DbSqlSession&nbsp; - updateProperty</SPAN><BR /><SPAN>INFO&nbsp;&nbsp; | jvm 1&nbsp;&nbsp;&nbsp; | 2014/12/09 06:01:34 | 09 Dec 2014 06:01:34,103 [catalina-exec-48] ERROR DbSqlSession&nbsp; - PropertyEntity[name=next.dbid, value=3292701] was updated by another transaction concurrently</SPAN><BR /><SPAN>INFO&nbsp;&nbsp; | jvm 1&nbsp;&nbsp;&nbsp; | 2014/12/09 06:01:34 | 09 Dec 2014 06:01:34,103 [catalina-exec-48] ERROR DbSqlSession&nbsp; - ########################### PERF TEST EXCEPTION END #################################</SPAN><BR /><BR /><SPAN>INFO&nbsp;&nbsp; | jvm 2&nbsp;&nbsp;&nbsp; | 2014/12/09 05:45:55 | 09 Dec 2014 05:45:55,639 [catalina-exec-34] ERROR DbSqlSession&nbsp; - ########################### PERF TEST EXCEPTION BEGIN #################################</SPAN><BR /><SPAN>INFO&nbsp;&nbsp; | jvm 2&nbsp;&nbsp;&nbsp; | 2014/12/09 05:45:55 | 09 Dec 2014 05:45:55,660 [catalina-exec-34] ERROR DbSqlSession&nbsp; - updateHistoricVariableInstance</SPAN><BR /><SPAN>INFO&nbsp;&nbsp; | jvm 2&nbsp;&nbsp;&nbsp; | 2014/12/09 05:45:55 | 09 Dec 2014 05:45:55,660 [catalina-exec-34] ERROR DbSqlSession&nbsp; - HistoricVariableInstanceEntity[id=3243161, name=request, revision=1, type=serializable, byteArrayValueId=3243162] was updated by another transaction concurrently</SPAN><BR /><SPAN>INFO&nbsp;&nbsp; | jvm 2&nbsp;&nbsp;&nbsp; | 2014/12/09 05:45:55 | 09 Dec 2014 05:45:55,660 [catalina-exec-34] ERROR DbSqlSession&nbsp; - ########################### PERF TEST EXCEPTION END #################################</SPAN><BR /><SPAN>INFO&nbsp;&nbsp; | jvm 2&nbsp;&nbsp;&nbsp; | 2014/12/09 07:58:54 | 09 Dec 2014 07:58:54,525 [catalina-exec-64] ERROR DbSqlSession&nbsp; - ########################### PERF TEST EXCEPTION BEGIN #################################</SPAN><BR /><SPAN>INFO&nbsp;&nbsp; | jvm 2&nbsp;&nbsp;&nbsp; | 2014/12/09 07:58:54 | 09 Dec 2014 07:58:54,526 [catalina-exec-64] ERROR DbSqlSession&nbsp; - updateHistoricVariableInstance</SPAN><BR /><SPAN>INFO&nbsp;&nbsp; | jvm 2&nbsp;&nbsp;&nbsp; | 2014/12/09 07:58:54 | 09 Dec 2014 07:58:54,526 [catalina-exec-64] ERROR DbSqlSession&nbsp; - HistoricVariableInstanceEntity[id=3376290, name=request, revision=0, type=serializable, byteArrayValueId=3376291] was updated by another transaction concurrently</SPAN><BR /><SPAN>INFO&nbsp;&nbsp; | jvm 2&nbsp;&nbsp;&nbsp; | 2014/12/09 07:58:54 | 09 Dec 2014 07:58:54,526 [catalina-exec-64] ERROR DbSqlSession&nbsp; - ########################### PERF TEST EXCEPTION END #################################</SPAN><BR /><SPAN>INFO&nbsp;&nbsp; | jvm 2&nbsp;&nbsp;&nbsp; | 2014/12/09 09:43:42 | Dec 09, 2014 9:43:42 AM com.sun.jersey.spi.container.ContainerResponse mapMappableContainerException</SPAN><BR /><BR /><BR /><SPAN>INFO&nbsp;&nbsp; | jvm 1&nbsp;&nbsp;&nbsp; | 2014/12/09 03:52:08 | 09 Dec 2014 03:52:08,187 [catalina-exec-33] ERROR DbSqlSession&nbsp; - ########################### PERF TEST EXCEPTION BEGIN #################################</SPAN><BR /><SPAN>INFO&nbsp;&nbsp; | jvm 1&nbsp;&nbsp;&nbsp; | 2014/12/09 03:52:08 | 09 Dec 2014 03:52:08,189 [catalina-exec-33] ERROR DbSqlSession&nbsp; - updateHistoricVariableInstance</SPAN><BR /><SPAN>INFO&nbsp;&nbsp; | jvm 1&nbsp;&nbsp;&nbsp; | 2014/12/09 03:52:08 | 09 Dec 2014 03:52:08,189 [catalina-exec-33] ERROR DbSqlSession&nbsp; - HistoricVariableInstanceEntity[id=3109119, name=request, revision=1, type=serializable, byteArrayValueId=3109120] was updated by another transaction concurrently</SPAN><BR /><SPAN>INFO&nbsp;&nbsp; | jvm 1&nbsp;&nbsp;&nbsp; | 2014/12/09 03:52:08 | 09 Dec 2014 03:52:08,189 [catalina-exec-33] ERROR DbSqlSession&nbsp; - ########################### PERF TEST EXCEPTION END #################################</SPAN><BR /><SPAN>INFO&nbsp;&nbsp; | jvm 1&nbsp;&nbsp;&nbsp; | 2014/12/09 04:24:41 | 09 Dec 2014 04:24:41,037 [catalina-exec-53] ERROR DbSqlSession&nbsp; - ########################### PERF TEST EXCEPTION BEGIN #################################</SPAN><BR /><SPAN>INFO&nbsp;&nbsp; | jvm 1&nbsp;&nbsp;&nbsp; | 2014/12/09 04:24:41 | 09 Dec 2014 04:24:41,038 [catalina-exec-53] ERROR DbSqlSession&nbsp; - updateHistoricVariableInstance</SPAN><BR /><SPAN>INFO&nbsp;&nbsp; | jvm 1&nbsp;&nbsp;&nbsp; | 2014/12/09 04:24:41 | 09 Dec 2014 04:24:41,038 [catalina-exec-53] ERROR DbSqlSession&nbsp; - HistoricVariableInstanceEntity[id=3168413, name=request, revision=1, type=serializable, byteArrayValueId=3168414] was updated by another transaction concurrently</SPAN><BR /><SPAN>INFO&nbsp;&nbsp; | jvm 1&nbsp;&nbsp;&nbsp; | 2014/12/09 04:24:41 | 09 Dec 2014 04:24:41,038 [catalina-exec-53] ERROR DbSqlSession&nbsp; - ########################### PERF TEST EXCEPTION END #################################</SPAN><BR /><SPAN>INFO&nbsp;&nbsp; | jvm 1&nbsp;&nbsp;&nbsp; | 2014/12/09 06:01:34 | 09 Dec 2014 06:01:34,102 [catalina-exec-48] ERROR DbSqlSession&nbsp; - ########################### PERF TEST EXCEPTION BEGIN #################################</SPAN><BR /><SPAN>INFO&nbsp;&nbsp; | jvm 1&nbsp;&nbsp;&nbsp; | 2014/12/09 06:01:34 | 09 Dec 2014 06:01:34,102 [catalina-exec-48] ERROR DbSqlSession&nbsp; - updateProperty</SPAN><BR /><SPAN>INFO&nbsp;&nbsp; | jvm 1&nbsp;&nbsp;&nbsp; | 2014/12/09 06:01:34 | 09 Dec 2014 06:01:34,103 [catalina-exec-48] ERROR DbSqlSession&nbsp; - PropertyEntity[name=next.dbid, value=3292701] was updated by another transaction concurrently</SPAN><BR /><SPAN>INFO&nbsp;&nbsp; | jvm 1&nbsp;&nbsp;&nbsp; | 2014/12/09 06:01:34 | 09 Dec 2014 06:01:34,103 [catalina-exec-48] ERROR DbSqlSession&nbsp; - ########################### PERF TEST EXCEPTION END #################################</SPAN><BR /><BR /><SPAN>INFO&nbsp;&nbsp; | jvm 1&nbsp;&nbsp;&nbsp; | 2014/12/09 03:22:08 | 09 Dec 2014 03:22:08,384 [Thread-4] ERROR DbSqlSession&nbsp; - ########################### PERF TEST EXCEPTION BEGIN #################################</SPAN><BR /><SPAN>INFO&nbsp;&nbsp; | jvm 1&nbsp;&nbsp;&nbsp; | 2014/12/09 03:22:08 | 09 Dec 2014 03:22:08,386 [Thread-4] ERROR DbSqlSession&nbsp; - updateTimer</SPAN><BR /><SPAN>INFO&nbsp;&nbsp; | jvm 1&nbsp;&nbsp;&nbsp; | 2014/12/09 03:22:08 | 09 Dec 2014 03:22:08,386 [Thread-4] ERROR DbSqlSession&nbsp; - JobEntity [id=3089759] was updated by another transaction concurrently</SPAN><BR /><SPAN>INFO&nbsp;&nbsp; | jvm 1&nbsp;&nbsp;&nbsp; | 2014/12/09 03:22:08 | 09 Dec 2014 03:22:08,386 [Thread-4] ERROR DbSqlSession&nbsp; - ########################### PERF TEST EXCEPTION END #################################</SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><SPAN>Sathish</SPAN><BR /><SPAN> </SPAN><BR /><BR /><BR /><BR /></BODY></HTML> Tue, 09 Dec 2014 21:43:04 GMT satramalin 2014-12-09T21:43:04Z Exceptions with concurrent Access https://connect.hyland.com/t5/alfresco-archive/exceptions-with-concurrent-access/m-p/208765#M161895 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 runAny information on the cause or analysis on the below exceptions is highly appreciated.Also, please advice if Tue, 09 Dec 2014 21:43:04 GMT https://connect.hyland.com/t5/alfresco-archive/exceptions-with-concurrent-access/m-p/208765#M161895 satramalin 2014-12-09T21:43:04Z Re: Exceptions with concurrent Access https://connect.hyland.com/t5/alfresco-archive/exceptions-with-concurrent-access/m-p/208766#M161896 <HTML><HEAD></HEAD><BODY><SPAN>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.</SPAN><BR /><BR /><SPAN>Best regards,</SPAN></BODY></HTML> Thu, 11 Dec 2014 08:39:06 GMT https://connect.hyland.com/t5/alfresco-archive/exceptions-with-concurrent-access/m-p/208766#M161896 trademak 2014-12-11T08:39:06Z