topic Problem when increasing maxJobsPerAcquisition in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/problem-when-increasing-maxjobsperacquisition/m-p/174445#M127575 <HTML><HEAD></HEAD><BODY><SPAN>I am evaluating usage of Activiti in our project.&nbsp; I made a simple test Java app that embeds Activiti and creates process instances. The process definition includes a timer event, and I am testing how the JobExecutor deals with many jobs that have a same due date. I created 1000 instances, and they all have a user task with a timer boundary event with the exact same due date and time.</SPAN><BR /><SPAN>When maxJobsPerAcquisition is 1, everything goes very well: JobExecutor executes the jobs as fast as it can using its threads pool.</SPAN><BR /><SPAN>When I set maxJobsPerAcquisition to 3, some jobs fails into error, randomly.&nbsp; The higher the maxJobsPerAcquisition, the more frequent I see jobs in error.</SPAN><BR /><SPAN>Note that I do have only one Activiti instance runnning (my test main app). I know that when multiple Activiti access the same DB, maxJobsPerAcuqisition should stay 1 because of locking problems. I was wondering if the problem here is due to locking or not.</SPAN><BR /><BR /><SPAN>The stack trace of one such job error is (I removed some lines to keep it shorter):</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />Exception in thread "pool-1-thread-8" org.activiti.engine.ActivitiException: Job 2575 failed<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.cmd.ExecuteJobsCmd.execute(ExecuteJobsCmd.java:83)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandInvoker.execute(CommandInvoker.java:24)<BR />&nbsp;&nbsp;&nbsp;(…)<BR />&nbsp;&nbsp;&nbsp;at java.lang.Thread.run(Thread.java:722)<BR />Caused by: org.apache.ibatis.exceptions.PersistenceException: <BR />### Error querying database.&nbsp; Cause: java.sql.SQLException: Error accessing PooledConnection. Connection is invalid.<BR />### The error may exist in org/activiti/db/mapping/entity/HistoricActivityInstance.xml<BR />### The error may involve org.activiti.engine.impl.persistence.entity.HistoricActivityInstanceEntity.selectHistoricActivityInstancesByQueryCriteria<BR />### The error occurred while executing a query<BR />### SQL: select * from ( select a.*, ROWNUM rnum from (&nbsp;&nbsp;&nbsp;&nbsp; select RES.*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; from ACT_HI_ACTINST RES&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp; RES.EXECUTION_ID_ = ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and RES.ACT_ID_ = ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; and RES.END_TIME_ is null&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; order by RES.ID_ asc&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ) a where ROWNUM &lt; ?) where rnum&nbsp; &gt;= ?<BR />### Cause: java.sql.SQLException: Error accessing PooledConnection. Connection is invalid.<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:107)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:98)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.selectListWithRawParameter(DbSqlSession.java:286)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:277)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:267)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.persistence.entity.HistoricActivityInstanceEntityManager.findHistoricActivityInstancesByQueryCriteria(HistoricActivityInstanceEntityManager.java:56)<BR />&nbsp;&nbsp;&nbsp;(…)<BR />Caused by: java.sql.SQLException: Error accessing PooledConnection. Connection is invalid.<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.datasource.pooled.PooledConnection.checkConnection(PooledConnection.java:254)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.datasource.pooled.PooledConnection.invoke(PooledConnection.java:243)<BR />&nbsp;&nbsp;&nbsp;(…)<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></CODE></PRE><BR /><SPAN>I use an Oracle DB for persistence. I have default connection pool set-up.</SPAN><BR /><BR /><SPAN>Is this problem linked to db locking and maxJobsPerAcquisition value, or is it "simply" a connection pool issue ? Would the connection pool be too small when we increase the maxJobsPerAcquisition, and therefore the number of parallel job executions ?</SPAN><BR /><SPAN>Any hint will be welcome to help me searching the right direction.</SPAN><BR /><BR /><SPAN>Thanks a lot!</SPAN><BR /></BODY></HTML> Tue, 20 May 2014 15:49:50 GMT hugues 2014-05-20T15:49:50Z Problem when increasing maxJobsPerAcquisition https://connect.hyland.com/t5/alfresco-archive/problem-when-increasing-maxjobsperacquisition/m-p/174445#M127575 I am evaluating usage of Activiti in our project.&nbsp; I made a simple test Java app that embeds Activiti and creates process instances. The process definition includes a timer event, and I am testing how the JobExecutor deals with many jobs that have a same due date. I created 1000 instances, and they Tue, 20 May 2014 15:49:50 GMT https://connect.hyland.com/t5/alfresco-archive/problem-when-increasing-maxjobsperacquisition/m-p/174445#M127575 hugues 2014-05-20T15:49:50Z Re: Problem when increasing maxJobsPerAcquisition https://connect.hyland.com/t5/alfresco-archive/problem-when-increasing-maxjobsperacquisition/m-p/174446#M127576 <HTML><HEAD></HEAD><BODY><SPAN>The exception seems to point to a connection pool problem.</SPAN><BR /><BR /><SPAN>Note that the default connection pool is like 10 connections.</SPAN><BR /><SPAN>Try changing it to a real connection pool (c3p0, boneCP, etc.).</SPAN></BODY></HTML> Wed, 21 May 2014 09:28:52 GMT https://connect.hyland.com/t5/alfresco-archive/problem-when-increasing-maxjobsperacquisition/m-p/174446#M127576 jbarrez 2014-05-21T09:28:52Z