topic Custom Job Executor giving problem in cluster environment in Alfresco Archive

Custom Job Executor giving problem in cluster environment

tkarthik26 — Thu, 03 Sep 2015 15:08:54 GMT

Hi,I am using activiti 5.17.0 and trying to implement my own job executor by extending org.activiti.engine.impl.jobexecutor.JobExecutor, but ended up getting UniversalConnectionPoolException while executing the jobs. Seems like if there are many jobs simultaneously running then this issue is coming.

Re: Custom Job Executor giving problem in cluster environment

trademak — Mon, 07 Sep 2015 14:51:42 GMT

Please check your pool settings and the amount of connections you can create with your database user. The job executor needs a number of database connections to execute the SQL statements.

Best regards,

Re: Custom Job Executor giving problem in cluster environment

tkarthik26 — Thu, 10 Sep 2015 15:29:25 GMT

I decreased the values to be equal to ucp connection pool properties but I get the same exception.
<code>
<bean id="customJobExecutor" class="com.uprr.bpm.activiti.custom.CustomJobExecutor">
   <property name="queueSize" value="5"></property>
   <property name="corePoolSize" value="5"></property>
   <property name="maxPoolSize" value="50"></property>
   <property name="keepAliveTime" value="0"></property>
</bean>
</code>

Below are my ucp pool configuration. The min-pool-size = 5 and max-pool-size = 50
<code>
<ucpool-manager id="ncs.ucp.manager.bpe.enpr">
    <ucpooled-datasource id="ncs.ucp.datasource.bpe.enpr"
      url="<some url>"
      fast-connection-failover-enabled="true"
      initial-pool-size="5"
      max-pool-size="50"
      min-pool-size="5"
      max-statements="5"
      validate-connection-on-borrow="true"
      inactive-connection-timeout="10" />
</ucpool-manager>
</code>