topic Re: Issue with Custom job executor Activiti 5.17 in Alfresco Archive

Issue with Custom job executor Activiti 5.17

ganeshr — Thu, 03 Sep 2015 15:17:55 GMT

We are using Activiti 5.17.0 version and to improve the performance of jobs tried to implement custom job executor in process engine.After configuring custom job executor with custom pool configuration we are getting UniversalConnectionPoolException while executing the jobs. We are running activiti

Re: Issue with Custom job executor Activiti 5.17

vasile_dirla — Mon, 07 Sep 2015 09:00:07 GMT

HI,
have a look here http://docs.oracle.com/cd/E18283_01/java.112/e12265/optimize.htm
maybe it will help you configuring the connection pool.

just for testing purpose try increasing the "ncs.datasource.pool.max-pool-size" value to 100. (this is the max connections as I know)
and then use it intenssive for a longer time to see if it will reach the limit again.
if the limit is reach again then there is a problem with reusing connections,
Anyway you should monitor the number of opened connections in the DB server to see if it is increasing in time

Re: Issue with Custom job executor Activiti 5.17

ganeshr — Wed, 09 Sep 2015 18:57:20 GMT

After setting queueSize and corePoolSize to same then we are not getting the exception. But however we are still monitoring the connections to see if we again receive this exception.

Re: Issue with Custom job executor Activiti 5.17

ganeshr — Thu, 10 Sep 2015 13:47:33 GMT

We are again seeing the exception. We tried increasing the connections to 100 as well but it is not working. Not sure why it is giving problem when we use custom job executor otherwise we are not getting that exception but the performance of job executor is very slow.
Is there any other way to improve the performance of job executor?

Re: Issue with Custom job executor Activiti 5.17

trademak — Sat, 12 Sep 2015 16:56:55 GMT

What do you mean with "the performance of the job executor is very slow"? Which job executor are you using exactly?

Best regards,

Re: Issue with Custom job executor Activiti 5.17

ganeshr — Mon, 14 Sep 2015 14:06:48 GMT

We initially used DefaultJobExecutor, as this is very slow. We have created a custom Job executor and configured the same in process engine configuration with the above configuration. But we are getting the exception I mentioned in my previous comments.
If we get back back to default job executor then we are not getting the connection exceptions.

Re: Issue with Custom job executor Activiti 5.17

jbarrez — Tue, 15 Sep 2015 10:24:14 GMT

The exception does point to a badly configured connection pool (or a database setting that limits the number of connections).

Re: Issue with Custom job executor Activiti 5.17

jbarrez — Tue, 15 Sep 2015 10:24:14 GMT

The exception does point to a badly configured connection pool (or a database setting that limits the number of connections).

Re: Issue with Custom job executor Activiti 5.17

ganeshr — Tue, 15 Sep 2015 16:07:01 GMT

We have set with enough database connection, please see my first comments that has database configurations. Even I increased database connection from 50 to 100 but still facing the same error.