topic Got lots of Deadlock exception in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/got-lots-of-deadlock-exception/m-p/15418#M6839 <HTML><HEAD></HEAD><BODY><P>I used Quartz to start timing task, e.g. At 9:00 AM start 1000 instance, bpmn just like this&nbsp;</P><P></P><P>StartEvent-&gt; ServiceTask -&gt; EndTask, very simple.</P><P></P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P>&lt;?xml version="1.0" encoding="UTF-8"?&gt;<BR /><SPAN>&lt;definitions xmlns="</SPAN><A class="jive-link-external-small" href="http://www.omg.org/spec/BPMN/20100524/MODEL" rel="nofollow noopener noreferrer" target="_blank">http://www.omg.org/spec/BPMN/20100524/MODEL</A><SPAN>" xmlns:xsi="</SPAN><A class="jive-link-external-small" href="http://www.w3.org/2001/XMLSchema-instance" rel="nofollow noopener noreferrer" target="_blank">http://www.w3.org/2001/XMLSchema-instance</A><SPAN>" xmlns:xsd="</SPAN><A class="jive-link-external-small" href="http://www.w3.org/2001/XMLSchema" rel="nofollow noopener noreferrer" target="_blank">http://www.w3.org/2001/XMLSchema</A><SPAN>" xmlns:activiti="</SPAN><A class="jive-link-external-small" href="http://activiti.org/bpmn" rel="nofollow noopener noreferrer" target="_blank">http://activiti.org/bpmn</A><SPAN>" xmlns:bpmndi="</SPAN><A class="jive-link-external-small" href="http://www.omg.org/spec/BPMN/20100524/DI" rel="nofollow noopener noreferrer" target="_blank">http://www.omg.org/spec/BPMN/20100524/DI</A><SPAN>" xmlns<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />mgdc="</SPAN><A class="jive-link-external-small" href="http://www.omg.org/spec/DD/20100524/DC" rel="nofollow noopener noreferrer" target="_blank">http://www.omg.org/spec/DD/20100524/DC</A><SPAN>" xmlns<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />mgdi="</SPAN><A class="jive-link-external-small" href="http://www.omg.org/spec/DD/20100524/DI" rel="nofollow noopener noreferrer" target="_blank">http://www.omg.org/spec/DD/20100524/DI</A><SPAN>" typeLanguage="</SPAN><A class="jive-link-external-small" href="http://www.w3.org/2001/XMLSchema" rel="nofollow noopener noreferrer" target="_blank">http://www.w3.org/2001/XMLSchema</A><SPAN>" expressionLanguage="</SPAN><A class="jive-link-external-small" href="http://www.w3.org/1999/XPath" rel="nofollow noopener noreferrer" target="_blank">http://www.w3.org/1999/XPath</A><SPAN>" targetNamespace="</SPAN><A class="jive-link-external-small" href="http://www.activiti.org/processdef" rel="nofollow noopener noreferrer" target="_blank">http://www.activiti.org/processdef</A><SPAN>"&gt;</SPAN><BR /> &lt;process id="P467645aa-4a80-8a0a-6a22-e73271b56873" isExecutable="true"&gt;<BR /> &lt;startEvent id="START"&gt;&lt;/startEvent&gt;<BR /> &lt;sequenceFlow sourceRef="START" targetRef="N-66d5fdc8-6984-4f9a-9156-49fc754aeedc"&gt;&lt;/sequenceFlow&gt;<BR /> &lt;serviceTask id="N-66d5fdc8-6984-4f9a-9156-49fc754aeedc" name="Trigger" <STRONG>activiti:async="true"</STRONG> activiti:delegateExpression="#{triggerWenjuanwangDelegate}"&gt;<BR /> &lt;extensionElements&gt;<BR /> &lt;activiti:field name="parameterMap"&gt;<BR /> &lt;activiti:string&gt;&lt;![CDATA[{"projectId":"590d86baf06eef314f832f3f","shortId":"a2uUb2p","data":{"Q3":"#{contact.mobilePhone}"}}]]&gt;&lt;/activiti:string&gt;<BR /> &lt;/activiti:field&gt;<BR /> &lt;/extensionElements&gt;<BR /> &lt;/serviceTask&gt;<BR /> &lt;endEvent id="N-d39f1d4f-32b7-4870-9f7c-448211edfb54"&gt;&lt;/endEvent&gt;<BR /> &lt;sequenceFlow sourceRef="N-66d5fdc8-6984-4f9a-9156-49fc754aeedc" targetRef="N-d39f1d4f-32b7-4870-9f7c-448211edfb54"&gt;&lt;/sequenceFlow&gt;<BR /> &lt;/process&gt;<BR /> &lt;bpmndi:BPMNDiagram id="BPMNDiagram_P467645aa-4a80-8a0a-6a22-e73271b56873"&gt;<BR /> &lt;bpmndi:BPMNPlane bpmnElement="P467645aa-4a80-8a0a-6a22-e73271b56873" id="BPMNPlane_P467645aa-4a80-8a0a-6a22-e73271b56873"&gt;&lt;/bpmndi:BPMNPlane&gt;<BR /> &lt;/bpmndi:BPMNDiagram&gt;<BR />&lt;/definitions&gt;</P></BLOCKQUOTE><P>Using&nbsp;<SPAN style="background-color: #f6f6f6;"><SPAN>&nbsp;</SPAN></SPAN><SPAN style="background-color: #f6f6f6;"><STRONG>activiti:async="true"</STRONG></SPAN><SPAN style="background-color: #f6f6f6;"><SPAN>&nbsp; in first service task. That's all, but we found lots of Deadlock exception in our test / production env. Mostly occurred in&nbsp;ACT_RU_JOB. We have two app instance as cluster, both contain activiti engine.</SPAN></SPAN></P><P><SPAN style="background-color: #f6f6f6;"><SPAN>I have attached the log file.&nbsp;</SPAN></SPAN></P><P><SPAN style="background-color: #f6f6f6;"></SPAN></P><P><SPAN style="background-color: #f6f6f6;"><SPAN>MySQL LOG</SPAN></SPAN></P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P></P><P>------------------------<BR />LATEST DETECTED DEADLOCK<BR />------------------------<BR />2017-08-31 13:53:32 0x7f2bdb0ea700<BR />*** (1) TRANSACTION:<BR />TRANSACTION 30059034, ACTIVE 0 sec inserting<BR />mysql tables in use 1, locked 1<BR />LOCK WAIT 48 lock struct(s), heap size 8400, 162 row lock(s), undo log entries 9<BR />MySQL thread id 1735054, OS thread handle 139826419922688, query id 97268339 10.0.20.2 root update<BR />insert into ACT_RU_JOB (<BR /> ID_, <BR /> REV_, <BR /> TYPE_,<BR /> LOCK_OWNER_, <BR /> LOCK_EXP_TIME_,<BR /> EXCLUSIVE_,<BR /> EXECUTION_ID_, <BR /> PROCESS_INSTANCE_ID_,<BR /> PROC_DEF_ID_,<BR /> DUEDATE_,<BR /> RETRIES_, <BR /> EXCEPTION_STACK_ID_,<BR /> EXCEPTION_MSG_,<BR /> HANDLER_TYPE_,<BR /> HANDLER_CFG_,<BR /> TENANT_ID_)<BR /> values ('122645',<BR /> 1,<BR /> 'message',<BR /> null,<BR /> null,<BR /> 1,<BR /> '122612',<BR /> '122612',<BR /> 'Pd7abf229-28d2-a864-f780-a8a8de6adf9b:1:120473',<BR /> '2017-08-31 13:58:32.127',<BR /> 3,<BR /> null,<BR /> null,<BR /> 'async-continuation',<BR /> null,<BR /> '1'<BR /> )<BR />*** (1) WAITING FOR THIS LOCK TO BE GRANTED:<BR />RECORD LOCKS space id 2534 page no 5 n bits 144 index PRIMARY of table `nazaio`.`act_ru_job` trx id 30059034 lock_mode X locks gap before rec insert intention waiting<BR />Record lock, heap no 12 PHYSICAL RECORD: n_fields 19; compact format; info bits 0<BR /> 0: len 5; hex 3132353136; asc 12516;;<BR /> 1: len 6; hex 00000079f9ff; asc y ;;<BR /> 2: len 7; hex 730000021607d0; asc s ;;<BR /> 3: len 4; hex 80000006; asc ;;<BR /> 4: len 7; hex 6d657373616765; asc message;;<BR /> 5: SQL NULL;<BR /> 6: SQL NULL;<BR /> 7: len 1; hex 81; asc ;;<BR /> 8: len 5; hex 3132353037; asc 12507;;<BR /> 9: len 5; hex 3132353037; asc 12507;;<BR /> 10: len 30; hex 5035383965656538662d653132622d633661632d356133322d3863656264; asc P589eee8f-e12b-c6ac-5a32-8cebd; (total 45 bytes);<BR /> 11: len 4; hex 80000000; asc ;;<BR /> 12: len 5; hex 3132353231; asc 12521;;<BR /> 13: len 20; hex 466f7220696e70757420737472696e673a202222; asc For input string: "";;<BR /> 14: len 6; hex 591952e617c0; asc Y R ;;<BR /> 15: SQL NULL;<BR /> 16: len 18; hex 6173796e632d636f6e74696e756174696f6e; asc async-continuation;;<BR /> 17: SQL NULL;<BR /> 18: len 1; hex 31; asc 1;;</P><P>*** (2) TRANSACTION:<BR />TRANSACTION 30059176, ACTIVE 0 sec inserting<BR />mysql tables in use 1, locked 1<BR />32 lock struct(s), heap size 3520, 145 row lock(s), undo log entries 9<BR />MySQL thread id 1735056, OS thread handle 139826335491840, query id 97271249 10.0.20.2 root update<BR />insert into ACT_RU_JOB (<BR /> ID_, <BR /> REV_, <BR /> TYPE_,<BR /> LOCK_OWNER_, <BR /> LOCK_EXP_TIME_,<BR /> EXCLUSIVE_,<BR /> EXECUTION_ID_, <BR /> PROCESS_INSTANCE_ID_,<BR /> PROC_DEF_ID_,<BR /> DUEDATE_,<BR /> RETRIES_, <BR /> EXCEPTION_STACK_ID_,<BR /> EXCEPTION_MSG_,<BR /> HANDLER_TYPE_,<BR /> HANDLER_CFG_,<BR /> TENANT_ID_)<BR /> values ('123313',<BR /> 1,<BR /> 'message',<BR /> null,<BR /> null,<BR /> 1,<BR /> '123301',<BR /> '123301',<BR /> 'Pd7abf229-28d2-a864-f780-a8a8de6adf9b:1:120473',<BR /> '2017-08-31 13:58:32.905',<BR /> 3,<BR /> null,<BR /> null,<BR /> 'async-continuation',<BR /> null,<BR /> '1'<BR /> )<BR />*** (2) HOLDS THE LOCK(S):<BR />RECORD LOCKS space id 2534 page no 5 n bits 144 index PRIMARY of table `nazaio`.`act_ru_job` trx id 30059176 lock mode S<BR />Record lock, heap no 12 PHYSICAL RECORD: n_fields 19; compact format; info bits 0<BR /> 0: len 5; hex 3132353136; asc 12516;;<BR /> 1: len 6; hex 00000079f9ff; asc y ;;<BR /> 2: len 7; hex 730000021607d0; asc s ;;<BR /> 3: len 4; hex 80000006; asc ;;<BR /> 4: len 7; hex 6d657373616765; asc message;;<BR /> 5: SQL NULL;<BR /> 6: SQL NULL;<BR /> 7: len 1; hex 81; asc ;;<BR /> 8: len 5; hex 3132353037; asc 12507;;<BR /> 9: len 5; hex 3132353037; asc 12507;;<BR /> 10: len 30; hex 5035383965656538662d653132622d633661632d356133322d3863656264; asc P589eee8f-e12b-c6ac-5a32-8cebd; (total 45 bytes);<BR /> 11: len 4; hex 80000000; asc ;;<BR /> 12: len 5; hex 3132353231; asc 12521;;<BR /> 13: len 20; hex 466f7220696e70757420737472696e673a202222; asc For input string: "";;<BR /> 14: len 6; hex 591952e617c0; asc Y R ;;<BR /> 15: SQL NULL;<BR /> 16: len 18; hex 6173796e632d636f6e74696e756174696f6e; asc async-continuation;;<BR /> 17: SQL NULL;<BR /> 18: len 1; hex 31; asc 1;;</P><P>*** (2) WAITING FOR THIS LOCK TO BE GRANTED:<BR />RECORD LOCKS space id 2534 page no 5 n bits 144 index PRIMARY of table `nazaio`.`act_ru_job` trx id 30059176 lock_mode X locks gap before rec insert intention waiting<BR />Record lock, heap no 12 PHYSICAL RECORD: n_fields 19; compact format; info bits 0<BR /> 0: len 5; hex 3132353136; asc 12516;;<BR /> 1: len 6; hex 00000079f9ff; asc y ;;<BR /> 2: len 7; hex 730000021607d0; asc s ;;<BR /> 3: len 4; hex 80000006; asc ;;<BR /> 4: len 7; hex 6d657373616765; asc message;;<BR /> 5: SQL NULL;<BR /> 6: SQL NULL;<BR /> 7: len 1; hex 81; asc ;;<BR /> 8: len 5; hex 3132353037; asc 12507;;<BR /> 9: len 5; hex 3132353037; asc 12507;;<BR /> 10: len 30; hex 5035383965656538662d653132622d633661632d356133322d3863656264; asc P589eee8f-e12b-c6ac-5a32-8cebd; (total 45 bytes);<BR /> 11: len 4; hex 80000000; asc ;;<BR /> 12: len 5; hex 3132353231; asc 12521;;<BR /> 13: len 20; hex 466f7220696e70757420737472696e673a202222; asc For input string: "";;<BR /> 14: len 6; hex 591952e617c0; asc Y R ;;<BR /> 15: SQL NULL;<BR /> 16: len 18; hex 6173796e632d636f6e74696e756174696f6e; asc async-continuation;;<BR /> 17: SQL NULL;<BR /> 18: len 1; hex 31; asc 1;;</P><P>*** WE ROLL BACK TRANSACTION (2)</P></BLOCKQUOTE><P>Activiti config</P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><PRE style="color: #a9b7c6; background-color: #2b2b2b; font-size: 9.0pt;"><SPAN style="color: #bbb529;">@Bean<BR /></SPAN>ProcessEngineConfiguration <SPAN style="color: #ffc66d;">processEngineConfiguration</SPAN>(DataSource dataSource<SPAN style="color: #cc7832;">, </SPAN><SPAN style="color: #bbb529;">@Qualifier</SPAN>(<SPAN style="color: #6a8759;">"simpleJpaTxManager"</SPAN>) PlatformTransactionManager transactionManager) {<BR />&nbsp;&nbsp;&nbsp; SpringProcessEngineConfiguration processEngineConfiguration = <SPAN style="color: #cc7832;">new </SPAN>SpringProcessEngineConfiguration()<SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp; </SPAN>processEngineConfiguration.setDataSource(dataSource)<SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp; </SPAN>processEngineConfiguration.setTransactionManager(transactionManager)<SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp; </SPAN>processEngineConfiguration.setDatabaseSchemaUpdate(<SPAN style="color: #6a8759;">"true"</SPAN>)<SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp; </SPAN>processEngineConfiguration.setJobExecutorActivate(<SPAN style="color: #cc7832;">false</SPAN>)<SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp; </SPAN>processEngineConfiguration.setAsyncExecutorEnabled(<SPAN style="color: #cc7832;">true</SPAN>)<SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp; </SPAN>processEngineConfiguration.setAsyncExecutorActivate(<SPAN style="color: #cc7832;">true</SPAN>)<SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp; </SPAN>processEngineConfiguration.setDelegateExpressionFieldInjectionMode(DelegateExpressionFieldInjectionMode.<SPAN style="color: #9876aa;">MIXED</SPAN>)<SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp; </SPAN>processEngineConfiguration.setAsyncExecutorCorePoolSize(<SPAN style="color: #9876aa;">asyncExecutorCorePoolSize</SPAN>)<SPAN style="color: #cc7832;">; // 10<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp; </SPAN>processEngineConfiguration.setAsyncExecutorMaxPoolSize(<SPAN style="color: #9876aa;">asyncExecutorMaxPoolSize</SPAN>)<SPAN style="color: #cc7832;">; // 25<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp; </SPAN>processEngineConfiguration.setAsyncExecutorThreadPoolQueueSize(<SPAN style="color: #9876aa;">asyncExecutorThreadPoolQueueSize</SPAN>)<SPAN style="color: #cc7832;">; // 100<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp; </SPAN>processEngineConfiguration.setAsyncExecutorDefaultTimerJobAcquireWaitTime(<SPAN style="color: #6897bb;">1 </SPAN>* <SPAN style="color: #6897bb;">1000</SPAN>)<SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp; return </SPAN>processEngineConfiguration<SPAN style="color: #cc7832;">;<BR /></SPAN>}</PRE></BLOCKQUOTE><P></P><P>DataBase&nbsp;</P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P></P><PRE style="color: #a9b7c6; background-color: #2b2b2b; font-size: 9.0pt;"><SPAN style="color: #cc7832;">private static </SPAN>HikariConfig <SPAN style="color: #ffc66d;">defaultConfig</SPAN>() {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; HikariConfig config = <SPAN style="color: #cc7832;">new </SPAN>HikariConfig()<SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #808080;">//&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; config.setAutoCommit(false);<BR /></SPAN><SPAN style="color: #808080;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>config.setAllowPoolSuspension(<SPAN style="color: #cc7832;">false</SPAN>)<SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>config.setConnectionTestQuery(<SPAN style="color: #6a8759;">"/* ping */ SELECT 1"</SPAN>)<SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>config.setConnectionInitSql(<SPAN style="color: #6a8759;">"SELECT 1"</SPAN>)<SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>config.setConnectionTimeout(<SPAN style="color: #9876aa;">CONNECTION_TIMEOUT</SPAN>)<SPAN style="color: #cc7832;">;&nbsp; // 120s<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>config.setValidationTimeout(<SPAN style="color: #9876aa;">VALIDATION_TIMEOUT</SPAN>)<SPAN style="color: #cc7832;">;&nbsp; // 5s<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>config.setMaxLifetime(<SPAN style="color: #9876aa;">MAX_LIEFTIME</SPAN>)<SPAN style="color: #cc7832;">; // 300m<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>config.setIdleTimeout(<SPAN style="color: #9876aa;">IDLE_TIMEOUT</SPAN>)<SPAN style="color: #cc7832;">; // 120s<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>config.setMinimumIdle(<SPAN style="color: #9876aa;">MINIMUM_IDLE_SIZE</SPAN>)<SPAN style="color: #cc7832;">; // 10<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>config.setDriverClassName(<SPAN style="color: #6a8759;">"com.mysql.jdbc.Driver"</SPAN>)<SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>config.setLeakDetectionThreshold(<SPAN style="color: #9876aa;">LEAK_DETECTION_THRESHOLD</SPAN>)<SPAN style="color: #cc7832;">; // 2s<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>config.setMaximumPoolSize(<SPAN style="color: #9876aa;">MAXIMUM_POOL_SIZE</SPAN>)<SPAN style="color: #cc7832;">; // 60<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>config.setPoolName(<SPAN style="color: #6a8759;">"MySQLDatabasePool"</SPAN>)<SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>config.setReadOnly(<SPAN style="color: #cc7832;">false</SPAN>)<SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>config.setThreadFactory((r) -&gt; <SPAN style="color: #cc7832;">new </SPAN>Thread(r<SPAN style="color: #cc7832;">, </SPAN><SPAN style="color: #6a8759;">"MySQLDatabasePool"</SPAN>))<SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>config.setTransactionIsolation(<SPAN style="color: #6a8759;">"TRANSACTION_READ_COMMITTED"</SPAN>)<SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>config.addDataSourceProperty(<SPAN style="color: #6a8759;">"dataSource.cachePrepStmts"</SPAN><SPAN style="color: #cc7832;">, true</SPAN>)<SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>config.addDataSourceProperty(<SPAN style="color: #6a8759;">"dataSource.prepStmtCacheSize"</SPAN><SPAN style="color: #cc7832;">, </SPAN><SPAN style="color: #6897bb;">250</SPAN>)<SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>config.addDataSourceProperty(<SPAN style="color: #6a8759;">"dataSource.prepStmtCacheSqlLimit"</SPAN><SPAN style="color: #cc7832;">, </SPAN><SPAN style="color: #6897bb;">2048</SPAN>)<SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>config.addDataSourceProperty(<SPAN style="color: #6a8759;">"dataSource.useServerPrepStmts"</SPAN><SPAN style="color: #cc7832;">, true</SPAN>)<SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>config.addDataSourceProperty(<SPAN style="color: #6a8759;">"dataSource.useLocalSessionState"</SPAN><SPAN style="color: #cc7832;">, true</SPAN>)<SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>config.addDataSourceProperty(<SPAN style="color: #6a8759;">"dataSource.useLocalTransactionState"</SPAN><SPAN style="color: #cc7832;">, true</SPAN>)<SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>config.addDataSourceProperty(<SPAN style="color: #6a8759;">"dataSource.rewriteBatchedStatements"</SPAN><SPAN style="color: #cc7832;">, true</SPAN>)<SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>config.addDataSourceProperty(<SPAN style="color: #6a8759;">"dataSource.cacheResultSetMetadata"</SPAN><SPAN style="color: #cc7832;">, true</SPAN>)<SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>config.addDataSourceProperty(<SPAN style="color: #6a8759;">"dataSource.cacheServerConfiguration"</SPAN><SPAN style="color: #cc7832;">, true</SPAN>)<SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>config.addDataSourceProperty(<SPAN style="color: #6a8759;">"dataSource.elideSetAutoCommits"</SPAN><SPAN style="color: #cc7832;">, true</SPAN>)<SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>config.addDataSourceProperty(<SPAN style="color: #6a8759;">"dataSource.maintainTimeStats"</SPAN><SPAN style="color: #cc7832;">, false</SPAN>)<SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return </SPAN>config<SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp; </SPAN>}</PRE></BLOCKQUOTE></BODY></HTML> Wed, 30 Aug 2017 15:16:49 GMT dean 2017-08-30T15:16:49Z Got lots of Deadlock exception https://connect.hyland.com/t5/alfresco-forum/got-lots-of-deadlock-exception/m-p/15418#M6839 I used Quartz to start timing task, e.g. At 9:00 AM start 1000 instance, bpmn just like this&nbsp;StartEvent-&gt; ServiceTask -&gt; EndTask, very simple.&lt;?xml version="1.0" encoding="UTF-8"?&gt;&lt;definitions xmlns="http://www.omg.org/spec/BPMN/20100524/MODEL" xmlns:xsi="http://www.w3.org/2001/XMLSch Wed, 30 Aug 2017 15:16:49 GMT https://connect.hyland.com/t5/alfresco-forum/got-lots-of-deadlock-exception/m-p/15418#M6839 dean 2017-08-30T15:16:49Z Re: Got lots of Deadlock exception https://connect.hyland.com/t5/alfresco-forum/got-lots-of-deadlock-exception/m-p/15419#M6840 <HTML><HEAD></HEAD><BODY><P>That's a huge number of deadlocks! Which version of MySQL &amp; Activiti are you using?</P><P></P><P>Also, can you try&nbsp;<A class="link-titled" href="https://www.activiti.org/userguide/index.html#_disabling_bulk_inserts" title="https://www.activiti.org/userguide/index.html#_disabling_bulk_inserts" rel="nofollow noopener noreferrer"> disabling bulk inserts</A>&nbsp;&nbsp;and see if that makes a difference?&nbsp;</P><P></P><P>Cheers,</P><P>Ciju</P></BODY></HTML> Fri, 01 Sep 2017 15:41:07 GMT https://connect.hyland.com/t5/alfresco-forum/got-lots-of-deadlock-exception/m-p/15419#M6840 cjose 2017-09-01T15:41:07Z Re: Got lots of Deadlock exception https://connect.hyland.com/t5/alfresco-forum/got-lots-of-deadlock-exception/m-p/15420#M6841 <HTML><HEAD></HEAD><BODY><P>Hi Joseph,</P><P></P><P>Thanks for your reply.</P><P></P><P>Activiti: 5.22.0</P><P>MySQL: 5.7.15</P><P></P><P>I will try to disable the bulk inserts but I don' think it should have problems&nbsp;with MySQL DB.</P><P></P><P>Dean</P></BODY></HTML> Sat, 02 Sep 2017 10:37:28 GMT https://connect.hyland.com/t5/alfresco-forum/got-lots-of-deadlock-exception/m-p/15420#M6841 dean 2017-09-02T10:37:28Z