lock time out

brachi — Mon, 21 Mar 2016 16:11:15 GMT

i got this exception when running in multi threads.any ideas?15:00:58,992 ERROR [AcquireJobsRunnable] exception during job acquisition:### Error querying database. Cause: org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "ACT_RU_EXECUTION"; SQL statement:select RES.* from ACT_RU_

Re: lock time out

vasile_dirla — Tue, 22 Mar 2016 08:10:53 GMT

Hi,
could you provide some more details ?
Activiti version, and other configurations…

Also if you have a jUnit which could show this would be nice.

Re: lock time out

brachi — Tue, 22 Mar 2016 08:21:31 GMT

activity:
         <groupId>org.activiti</groupId>
            <artifactId>activiti-engine</artifactId>
            <version>5.13</version>

<dependency>
            <groupId>org.activiti</groupId>
            <artifactId>activiti-spring</artifactId>
            <version>5.13</version>
        </dependency>

        <dependency>
            <groupId>com.h2database</groupId>
            <artifactId>h2</artifactId>
            <version>1.3.171</version>
        </dependency>

I don't have a simple unit test to attach, it works fine, until i have heavy load with many threads.
my activity configuration:

<bean id="activitiDataSource" class="org.springframework.jdbc.datasource.SimpleDriverDataSource">
        <property name="driverClass" value="org.h2.Driver"/>
        <property name="url"
                  value="jdbc:h2:mem:active;DB_CLOSE_DELAY=-1"/>
        <property name="username" value="sa"/>
        <property name="password" value=""/>
    </bean>

<bean id="activitiTransactionManager"
          class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="activitiDataSource"/>
    </bean>

<bean id="processEngineConfiguration" class="org.activiti.spring.SpringProcessEngineConfiguration" depends-on="externalParsersLoader">
        <property name="createDiagramOnDeploy" value="false" />
        <property name="dataSource" ref="activitiDataSource"/>
        <property name="transactionManager" ref="activitiTransactionManager"/>
        <property name="databaseSchemaUpdate" value="true"/>
        <property name="jobExecutorActivate" value="true"/>
        <property name="history" value="none"/>
        <property name="preBpmnParseHandlers">
            <list>
               ….
            </list>
        </properties>

i don't need the parameters after the execution instance finish, any idea how to free it?

Re: lock time out

jbarrez — Fri, 25 Mar 2016 12:48:36 GMT

- 5.13 is a very old version of activiti
- Do you have multiple engines going against the same H2 database? If so, H2 is not strong when it comes to concurrency. Use a 'real' database instead (mysql, postgres, etc.)

topic Re: lock time out in Alfresco Archive

lock time out

Re: lock time out

Re: lock time out

Re: lock time out