topic Activiti hanging waiting for next Id. in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/activiti-hanging-waiting-for-next-id/m-p/37107#M15599 <HTML><HEAD></HEAD><BODY><P>We are seeing a problem with the Activiti engine hanging in an apparent deadlock.</P><P>We have deployed Activiti 5.22.0 in Tomcat, and using C3P0 connection pool. If we set Tomcat thread pool size to be equal to or greater than the connection pool size, the entire system hangs, apparently waiting to get the next id from the DB. Below is the relevant section of the thread dump. Each thread seems to be stuck in the same place.</P><P>Any ideas? Should the thread pool always be smaller than the connection pool?</P><P></P><P>Thanks.</P><P><SPAN style="font-family: 'courier new', courier, monospace; font-size: 13px;"><BR />"http-nio-8080-exec-20" #45 daemon prio=5 os_prio=0 tid=0x00007f2b7c020800 nid=0x2694 waiting for monitor entry [0x00007f2bee15c000]<BR /> java.lang.Thread.State: BLOCKED (on object monitor)<BR /> at org.activiti.engine.impl.db.DbIdGenerator.getNextId(DbIdGenerator.java:35)<BR /> - waiting to lock &lt;0x00000006c1f952d8&gt; (a org.activiti.engine.impl.db.DbIdGenerator)<BR /> at org.activiti.engine.impl.db.DbSqlSession.insert(DbSqlSession.java:151)<BR /> at org.activiti.engine.impl.persistence.entity.ExecutionEntity.insert(ExecutionEntity.java:1270)<BR /> at org.activiti.engine.impl.persistence.entity.ProcessDefinitionEntity.newProcessInstance(ProcessDefinitionEntity.java:146)<BR /> at org.activiti.engine.impl.pvm.process.ProcessDefinitionImpl.createProcessInstanceForInitial(ProcessDefinitionImpl.java:63)<BR /> at org.activiti.engine.impl.pvm.process.ProcessDefinitionImpl.createProcessInstance(ProcessDefinitionImpl.java:53)<BR /> at org.activiti.engine.impl.persistence.entity.ProcessDefinitionEntity.createProcessInstance(ProcessDefinitionEntity.java:87)<BR /> at org.activiti.engine.impl.persistence.entity.ProcessDefinitionEntity.createProcessInstance(ProcessDefinitionEntity.java:135)<BR /> at org.activiti.engine.impl.cmd.StartProcessInstanceCmd.execute(StartProcessInstanceCmd.java:99)<BR /> at org.activiti.engine.impl.cmd.StartProcessInstanceCmd.execute(StartProcessInstanceCmd.java:37)<BR /> at org.activiti.engine.impl.interceptor.CommandInvoker.execute(CommandInvoker.java:24)<BR /> at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:57)<BR /> at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:47)<BR /> at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)<BR /> at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:45)<BR /> at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)<BR /> at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40)<BR /> at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:35)<BR /> at org.activiti.engine.impl.RuntimeServiceImpl.startProcessInstanceByKey(RuntimeServiceImpl.java:86)<BR /> at org.activiti.rest.service.api.runtime.process.ProcessInstanceCollectionResource.createProcessInstance(ProcessInstanceCollectionResource.java:166)<BR /><BR /><BR /></SPAN></P></BODY></HTML> Thu, 18 May 2017 19:01:31 GMT mprakash 2017-05-18T19:01:31Z Activiti hanging waiting for next Id. https://connect.hyland.com/t5/alfresco-forum/activiti-hanging-waiting-for-next-id/m-p/37107#M15599 We are seeing a problem with the Activiti engine hanging in an apparent deadlock.We have deployed Activiti 5.22.0 in Tomcat, and using C3P0 connection pool. If we set Tomcat thread pool size to be equal to or greater than the connection pool size, the entire system hangs, apparently waiting to get t Thu, 18 May 2017 19:01:31 GMT https://connect.hyland.com/t5/alfresco-forum/activiti-hanging-waiting-for-next-id/m-p/37107#M15599 mprakash 2017-05-18T19:01:31Z Re: Activiti hanging waiting for next Id. https://connect.hyland.com/t5/alfresco-forum/activiti-hanging-waiting-for-next-id/m-p/37108#M15600 <HTML><HEAD></HEAD><BODY><P>Use the strongUUid generator. It does not utilize the database, is more performant and is a much better option for production environments.</P><P></P><P>Greg</P><P><A href="https://migration33.stage.lithium.com/t5/tag/bp3/tg-p"></A>‌</P></BODY></HTML> Fri, 19 May 2017 15:11:44 GMT https://connect.hyland.com/t5/alfresco-forum/activiti-hanging-waiting-for-next-id/m-p/37108#M15600 gdharley 2017-05-19T15:11:44Z Re: Activiti hanging waiting for next Id. https://connect.hyland.com/t5/alfresco-forum/activiti-hanging-waiting-for-next-id/m-p/37109#M15601 <HTML><HEAD></HEAD><BODY><P>Thanks for the pointer. Will give it a try.</P><P></P><P><A href="mailto:Mayank.@mayank" rel="nofollow noopener noreferrer">Mayank</A>.</P></BODY></HTML> Fri, 19 May 2017 18:52:22 GMT https://connect.hyland.com/t5/alfresco-forum/activiti-hanging-waiting-for-next-id/m-p/37109#M15601 mprakash 2017-05-19T18:52:22Z