nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

lock time out

brachi

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_JOB RES
        LEFT OUTER JOIN ACT_RU_EXECUTION PI ON PI.ID_ = RES.PROCESS_INSTANCE_ID_
    where (RES.RETRIES_ > 0)
      and (RES.DUEDATE_ is null or RES.DUEDATE_ < ?)
      and (RES.LOCK_OWNER_ is null or RES.LOCK_EXP_TIME_ < ?)
          and (
                    (RES.EXECUTION_ID_ is null)
                        or
                        (PI.SUSPENSION_STATE_ = 1)
      )
    LIMIT ? OFFSET ? [50200-171]
### The error may exist in org/activiti/db/mapping/entity/Job.xml
### The error may involve org.activiti.engine.impl.persistence.entity.JobEntity.selectNextJobsToExecute-Inline
### The error occurred while setting parameters
### SQL: select       RES.*            from ACT_RU_JOB RES          LEFT OUTER JOIN ACT_RU_EXECUTION PI ON PI.ID_ = RES.PROCESS_INSTANCE_ID_     where (RES.RETRIES_ > 0)       and (RES.DUEDATE_ is null or RES.DUEDATE_ < ?)       and (RES.LOCK_OWNER_ is null or RES.LOCK_EXP_TIME_ < ?)    and (         (RES.EXECUTION_ID_ is null)      or       (PI.SUSPENSION_STATE_ = 1)       )       LIMIT ? OFFSET ?
### Cause: org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "ACT_RU_EXECUTION"; SQL statement:
select
        RES.*
    from ACT_RU_JOB RES
        LEFT OUTER JOIN ACT_RU_EXECUTION PI ON PI.ID_ = RES.PROCESS_INSTANCE_ID_
    where (RES.RETRIES_ > 0)
      and (RES.DUEDATE_ is null or RES.DUEDATE_ < ?)
      and (RES.LOCK_OWNER_ is null or RES.LOCK_EXP_TIME_ < ?)
          and (
                    (RES.EXECUTION_ID_ is null)
                        or
                        (PI.SUSPENSION_STATE_ = 1)
      )
    LIMIT ? OFFSET ? [50200-171]
org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "ACT_RU_EXECUTION"; SQL statement:

Find more posts tagged with

Comments

vasile_dirla

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.

brachi

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?

jbarrez

- 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.)