topic TaskQuery stucks when quering for Task in Alfresco Archive

TaskQuery stucks when quering for Task

swamy2156 — Mon, 08 Jul 2013 10:43:41 GMT

Hi.,I am using activiti 5.12.1v and using Oracle database. In DB, ACT_RU_TASK table contains around 27,000 rows. While querying for task based on process instance id, While debugging came to know that its hangs at taskQuery.singleResult(). code is as follows. TaskQuery taskQuery = task

Re: TaskQuery stucks when quering for Task

frederikherema1 — Tue, 09 Jul 2013 08:47:13 GMT

What is the configuration of your datasource? Are you sure there are enough database connections available? Also check if access to DB is still working and what the fail-timeout of the connections are.

There is no magic going on in that query, just a plain SQL-select. So must be the database…

Re: TaskQuery stucks when quering for Task

swamy2156 — Tue, 09 Jul 2013 11:26:32 GMT

Yes… After increase the maxActive size its working fine. I came to know this when Isolated this issue in a standalone program and increased the size… Thank you for your reply.
<code>
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
    <property name="driverClassName" value="${jdbc.driver}" />
    <property name="url" value="${jdbc.url}" />
    <property name="username" value="${jdbc.username}" />
    <property name="password" value="${jdbc.pwd}" />
    <property name="defaultAutoCommit" value="true" />
    <property name="maxActive" value="20" />
    <property name="maxIdle" value="10" />
</bean>
</code>

-Swamy.

Re: TaskQuery stucks when quering for Task

frederikherema1 — Wed, 10 Jul 2013 07:06:40 GMT

No problem, glad it's solved.