topic Workflow engine hangs-up with large number of process instance in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/workflow-engine-hangs-up-with-large-number-of-process-instance/m-p/184840#M137970 <HTML><HEAD></HEAD><BODY><SPAN>Hi All,</SPAN><BR /><BR /><SPAN>I am facing an issue while execution of large number of process instance in parallel. Everything seems to work like charm when executing fewer process instance (say 7-10) but it comes to a pause when the concurrency is increased to say 30. Even the processes already acquired come to a still. Also the other Application components, sharing the same datasource take time to perform the database operations.</SPAN><BR /><BR /><SPAN>Could this be an issue with the datasource or connection pooling not working? I am using a c3p0 datasource implementation.</SPAN><BR /><BR /><SPAN>My datasource configuration looks like -</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />&nbsp;&nbsp;&nbsp;&lt;bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;destroy-method="close"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="driverClass"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;value&gt;${dataSource.driverClassName}&lt;/value&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/property&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="jdbcUrl"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;value&gt;${dataSource.url}&lt;/value&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/property&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="idleConnectionTestPeriod"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;value&gt;${idle_connection_test_period}&lt;/value&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/property&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="preferredTestQuery"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;value&gt;Select 1;&lt;/value&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/property&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name="properties"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;props&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;prop key="c3p0.acquire_increment"&gt;5&lt;/prop&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;prop key="c3p0.max_size"&gt;100&lt;/prop&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;prop key="c3p0.max_statements"&gt;0&lt;/prop&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;prop key="c3p0.min_size"&gt;10&lt;/prop&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;prop key="user"&gt;${dataSource.username}&lt;/prop&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;prop key="password"&gt;*********&lt;/prop&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/props&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/property&gt;<BR />&nbsp;&nbsp;&nbsp;&lt;/bean&gt;<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Thu, 15 Jan 2015 06:42:41 GMT sushantmahajan 2015-01-15T06:42:41Z Workflow engine hangs-up with large number of process instance https://connect.hyland.com/t5/alfresco-archive/workflow-engine-hangs-up-with-large-number-of-process-instance/m-p/184840#M137970 Hi All,I am facing an issue while execution of large number of process instance in parallel. Everything seems to work like charm when executing fewer process instance (say 7-10) but it comes to a pause when the concurrency is increased to say 30. Even the processes already acquired come to a still. Thu, 15 Jan 2015 06:42:41 GMT https://connect.hyland.com/t5/alfresco-archive/workflow-engine-hangs-up-with-large-number-of-process-instance/m-p/184840#M137970 sushantmahajan 2015-01-15T06:42:41Z Re: Workflow engine hangs-up with large number of process instance https://connect.hyland.com/t5/alfresco-archive/workflow-engine-hangs-up-with-large-number-of-process-instance/m-p/184841#M137971 <HTML><HEAD></HEAD><BODY><SPAN>It all depends on what you're doing in that process. You seem to have 100 connections, which should be ok for 30 proc insances. However, if your process instances take 10 seconds to finish … you might see stalling obviously.</SPAN></BODY></HTML> Fri, 16 Jan 2015 15:33:50 GMT https://connect.hyland.com/t5/alfresco-archive/workflow-engine-hangs-up-with-large-number-of-process-instance/m-p/184841#M137971 jbarrez 2015-01-16T15:33:50Z