# Flowable Table Locking issue

**URL:** <https://forum.flowable.org/t/flowable-table-locking-issue/8155>\
**Category:** Flowable Engine\
**Created:** [July 19, 2021, 11:00am UTC](https://forum.flowable.org/t/flowable-table-locking-issue/8155 "2021-07-19T11:00:48Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![sameer.uppal](https://avatars.discourse-cdn.com/v4/letter/s/9e8a1a/32.png) [@sameer.uppal](https://forum.flowable.org/u/sameer.uppal)\
**Post date:** [July 19, 2021, 11:00am UTC](https://forum.flowable.org/t/flowable-table-locking-issue/8155/1 "2021-07-19T11:00:48Z")

</div>

Hi Team  
Getting below error.  
org.flowable.engine.impl.persistence.entity.HistoricActivityInstanceEntityImpl.insertHistoricActivityInstance-Inline

org.apache.ibatis.exceptions.PersistenceException:

### Error updating database. Cause: java.sql.SQLTransientConnectionException: (conn=1860579) Lock wait timeout exceeded; try restarting transaction

### The error may exist in org/flowable/db/mapping/entity/HistoricActivityInstance.xml

### The error may involve org.flowable.engine.impl.persistence.entity.HistoricActivityInstanceEntityImpl.insertHistoricActivityInstance-Inline

### The error occurred while setting parameters

### SQL: insert into ACT\_HI\_ACTINST ( ID\_, REV\_, PROC\_DEF\_ID\_, PROC\_INST\_ID\_, EXECUTION\_ID\_, ACT\_ID\_, TASK\_ID\_, CALL\_PROC\_INST\_ID\_, ACT\_NAME\_, ACT\_TYPE\_, ASSIGNEE\_, START\_TIME\_, END\_TIME\_, DURATION\_, DELETE\_REASON\_, TENANT\_ID\_ ) values ( ?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )

### Cause: java.sql.SQLTransientConnectionException: (conn=1860579) Lock wait timeout exceeded; try restarting transaction

```
    at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:199)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:184)
    at org.flowable.common.engine.impl.db.DbSqlSession.flushRegularInsert(DbSqlSession.java:509)
    at org.flowable.common.engine.impl.db.DbSqlSession.flushInsertEntities(DbSqlSession.java:493)
    at org.flowable.common.engine.impl.db.DbSqlSession.flushInserts(DbSqlSession.java:473)
    at org.flowable.common.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:358)
    at org.flowable.common.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:192)
    at org.flowable.common.engine.impl.interceptor.CommandContext.close(CommandContext.java:61)
    at org.flowable.common.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:81)
    at org.flowable.common.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:51)
    at org.flowable.common.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:30)
    at org.flowable.common.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:56)
    at org.flowable.common.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:51)
    at org.flowable.engine.impl.RuntimeServiceImpl.startProcessInstance(RuntimeServiceImpl.java:732)
    at org.flowable.engine.impl.runtime.ProcessInstanceBuilderImpl.start(ProcessInstanceBuilderImpl.java:205)
    at com.techm.bm.om.orderdecompositionservice.services.WorkflowService.startProcess(WorkflowService.java:134)
    at com.techm.bm.om.orderdecompositionservice.consumer.ServiceOrderCreatedEventHandler.on(ServiceOrderCreatedEventHandler.java:86)
    at sun.reflect.GeneratedMethodAccessor830.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.axonframework.messaging.annotation.AnnotatedMessageHandlingMember.handle(AnnotatedMessageHandlingMember.java:132)
    at org.axonframework.eventhandling.AnnotationEventHandlerAdapter.handle(AnnotationEventHandlerAdapter.java:91)
    at org.axonframework.eventhandling.SimpleEventHandlerInvoker.handle(SimpleEventHandlerInvoker.java:108)
    at org.axonframework.eventhandling.MultiEventHandlerInvoker.handle(MultiEventHandlerInvoker.java:89)
    at org.axonframework.eventhandling.AbstractEventProcessor.lambda$null$1(AbstractEventProcessor.java:165)
    at org.axonframework.messaging.DefaultInterceptorChain.proceed(DefaultInterceptorChain.java:57)
    at org.axonframework.messaging.interceptors.CorrelationDataInterceptor.handle(CorrelationDataInterceptor.java:65)
    at org.axonframework.messaging.DefaultInterceptorChain.proceed(DefaultInterceptorChain.java:55)
    at org.axonframework.eventhandling.TrackingEventProcessor.lambda$new$1(TrackingEventProcessor.java:181)
    at org.axonframework.messaging.DefaultInterceptorChain.proceed(DefaultInterceptorChain.java:55)
    at org.axonframework.eventhandling.AbstractEventProcessor.lambda$processInUnitOfWork$2(AbstractEventProcessor.java:173)
    at org.axonframework.messaging.unitofwork.BatchingUnitOfWork.executeWithResult(BatchingUnitOfWork.java:86)
    at org.axonframework.eventhandling.AbstractEventProcessor.processInUnitOfWork(AbstractEventProcessor.java:159)
    at org.axonframework.eventhandling.TrackingEventProcessor.processBatch(TrackingEventProcessor.java:438)
    at org.axonframework.eventhandling.TrackingEventProcessor.processingLoop(TrackingEventProcessor.java:301)
    at org.axonframework.eventhandling.TrackingEventProcessor$TrackingSegmentWorker.run(TrackingEventProcessor.java:1161)
    at org.axonframework.eventhandling.TrackingEventProcessor$WorkerLauncher.run(TrackingEventProcessor.java:1276)
    at java.lang.Thread.run(Thread.java:748)

```

Caused by: java.sql.SQLTransientConnectionException: (conn=1860579) Lock wait timeout exceeded; try restarting transaction  
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:79)  
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:153)  
at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:273)  
at org.mariadb.jdbc.ClientSidePreparedStatement.executeInternal(ClientSidePreparedStatement.java:229)  
at org.mariadb.jdbc.ClientSidePreparedStatement.execute(ClientSidePreparedStatement.java:149)  
at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)  
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)  
at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47)  
at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)  
at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)  
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)  
at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)  
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:197)  
… 37 common frames omitted  
Caused by: org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: Lock wait timeout exceeded; try restarting transaction  
at org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException.of(MariaDbSqlException.java:34)  
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:194)  
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:177)  
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:321)  
at org.mariadb.jdbc.ClientSidePreparedStatement.executeInternal(ClientSidePreparedStatement.java:220)  
… 46 common frames omitted  
Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction  
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1674)  
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1536)  
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1499)  
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:318)  
… 47 common frames omitted

2021-07-19 10:23:11.769 ERROR 7 — [tion-process]-0] .b.o.o.c.ServiceOrderCreatedEventHandler :

### Error updating database. Cause: java.sql.SQLTransientConnectionException: (conn=1860579) Lock wait timeout exceeded; try restarting transaction

### The error may exist in org/flowable/db/mapping/entity/HistoricActivityInstance.xml

### The error may involve org.flowable.engine.impl.persistence.entity.HistoricActivityInstanceEntityImpl.insertHistoricActivityInstance-Inline

### The error occurred while setting parameters

### SQL: insert into ACT\_HI\_ACTINST ( ID\_, REV\_, PROC\_DEF\_ID\_, PROC\_INST\_ID\_, EXECUTION\_ID\_, ACT\_ID\_, TASK\_ID\_, CALL\_PROC\_INST\_ID\_, ACT\_NAME\_, ACT\_TYPE\_, ASSIGNEE\_, START\_TIME\_, END\_TIME\_, DURATION\_, DELETE\_REASON\_, TENANT\_ID\_ ) values ( ?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )

### Cause: java.sql.SQLTransientConnectionException: (conn=1860579) Lock wait timeout exceeded; try restarting transaction

org.apache.ibatis.exceptions.PersistenceException:

### Error updating database. Cause: java.sql.SQLTransientConnectionException: (conn=1860579) Lock wait timeout exceeded; try restarting transaction

### The error may exist in org/flowable/db/mapping/entity/HistoricActivityInstance.xml

### The error may involve org.flowable.engine.impl.persistence.entity.HistoricActivityInstanceEntityImpl.insertHistoricActivityInstance-Inline

### The error occurred while setting parameters

### SQL: insert into ACT\_HI\_ACTINST ( ID\_, REV\_, PROC\_DEF\_ID\_, PROC\_INST\_ID\_, EXECUTION\_ID\_, ACT\_ID\_, TASK\_ID\_, CALL\_PROC\_INST\_ID\_, ACT\_NAME\_, ACT\_TYPE\_, ASSIGNEE\_, START\_TIME\_, END\_TIME\_, DURATION\_, DELETE\_REASON\_, TENANT\_ID\_ ) values ( ?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )

### Cause: java.sql.SQLTransientConnectionException: (conn=1860579) Lock wait timeout exceeded; try restarting transaction

```
    at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:199)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:184)
    at org.flowable.common.engine.impl.db.DbSqlSession.flushRegularInsert(DbSqlSession.java:509)
    at org.flowable.common.engine.impl.db.DbSqlSession.flushInsertEntities(DbSqlSession.java:493)
    at org.flowable.common.engine.impl.db.DbSqlSession.flushInserts(DbSqlSession.java:473)
    at org.flowable.common.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:358)
    at org.flowable.common.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:192)
    at org.flowable.common.engine.impl.interceptor.CommandContext.close(CommandContext.java:61)
    at org.flowable.common.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:81)
    at org.flowable.common.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:51)
    at org.flowable.common.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:30)
    at org.flowable.common.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:56)
    at org.flowable.common.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:51)
    at org.flowable.engine.impl.RuntimeServiceImpl.startProcessInstance(RuntimeServiceImpl.java:732)
    at org.flowable.engine.impl.runtime.ProcessInstanceBuilderImpl.start(ProcessInstanceBuilderImpl.java:205)
    at com.techm.bm.om.orderdecompositionservice.services.WorkflowService.startProcess(WorkflowService.java:134)
    at com.techm.bm.om.orderdecompositionservice.consumer.ServiceOrderCreatedEventHandler.on(ServiceOrderCreatedEventHandler.java:86)
    at sun.reflect.GeneratedMethodAccessor830.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.axonframework.messaging.annotation.AnnotatedMessageHandlingMember.handle(AnnotatedMessageHandlingMember.java:132)
    at org.axonframework.eventhandling.AnnotationEventHandlerAdapter.handle(AnnotationEventHandlerAdapter.java:91)
    at org.axonframework.eventhandling.SimpleEventHandlerInvoker.handle(SimpleEventHandlerInvoker.java:108)
    at org.axonframework.eventhandling.MultiEventHandlerInvoker.handle(MultiEventHandlerInvoker.java:89)
    at org.axonframework.eventhandling.AbstractEventProcessor.lambda$null$1(AbstractEventProcessor.java:165)
    at org.axonframework.messaging.DefaultInterceptorChain.proceed(DefaultInterceptorChain.java:57)
    at org.axonframework.messaging.interceptors.CorrelationDataInterceptor.handle(CorrelationDataInterceptor.java:65)
    at org.axonframework.messaging.DefaultInterceptorChain.proceed(DefaultInterceptorChain.java:55)
    at org.axonframework.eventhandling.TrackingEventProcessor.lambda$new$1(TrackingEventProcessor.java:181)
    at org.axonframework.messaging.DefaultInterceptorChain.proceed(DefaultInterceptorChain.java:55)
    at org.axonframework.eventhandling.AbstractEventProcessor.lambda$processInUnitOfWork$2(AbstractEventProcessor.java:173)
    at org.axonframework.messaging.unitofwork.BatchingUnitOfWork.executeWithResult(BatchingUnitOfWork.java:86)
    at org.axonframework.eventhandling.AbstractEventProcessor.processInUnitOfWork(AbstractEventProcessor.java:159)
    at org.axonframework.eventhandling.TrackingEventProcessor.processBatch(TrackingEventProcessor.java:438)
    at org.axonframework.eventhandling.TrackingEventProcessor.processingLoop(TrackingEventProcessor.java:301)
    at org.axonframework.eventhandling.TrackingEventProcessor$TrackingSegmentWorker.run(TrackingEventProcessor.java:1161)
    at org.axonframework.eventhandling.TrackingEventProcessor$WorkerLauncher.run(TrackingEventProcessor.java:1276)
    at java.lang.Thread.run(Thread.java:748)

```

Caused by: java.sql.SQLTransientConnectionException: (conn=1860579) Lock wait timeout exceeded; try restarting transaction  
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:79)  
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:153)  
at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:273)  
at org.mariadb.jdbc.ClientSidePreparedStatement.executeInternal(ClientSidePreparedStatement.java:229)  
at org.mariadb.jdbc.ClientSidePreparedStatement.execute(ClientSidePreparedStatement.java:149)  
at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)  
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)  
at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47)  
at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)  
at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)  
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)  
at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)  
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:197)  
… 37 common frames omitted  
Caused by: org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: Lock wait timeout exceeded; try restarting transaction  
at org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException.of(MariaDbSqlException.java:34)  
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:194)  
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:177)  
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:321)  
at org.mariadb.jdbc.ClientSidePreparedStatement.executeInternal(ClientSidePreparedStatement.java:220)  
… 46 common frames omitted  
Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction  
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1674)  
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1536)  
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1499)  
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:318)  
… 47 common frames omitted

2021-07-19 10:23:12.315 WARN 7 — [tion-process]-0] o.a.e.TrackingEventProcessor : Error occurred. Starting retry mode.

javax.management.RuntimeErrorException:

### Error updating database. Cause: java.sql.SQLTransientConnectionException: (conn=1860579) Lock wait timeout exceeded; try restarting transaction

### The error may exist in org/flowable/db/mapping/entity/HistoricActivityInstance.xml

### The error may involve org.flowable.engine.impl.persistence.entity.HistoricActivityInstanceEntityImpl.insertHistoricActivityInstance-Inline

### The error occurred while setting parameters

### SQL: insert into ACT\_HI\_ACTINST ( ID\_, REV\_, PROC\_DEF\_ID\_, PROC\_INST\_ID\_, EXECUTION\_ID\_, ACT\_ID\_, TASK\_ID\_, CALL\_PROC\_INST\_ID\_, ACT\_NAME\_, ACT\_TYPE\_, ASSIGNEE\_, START\_TIME\_, END\_TIME\_, DURATION\_, DELETE\_REASON\_, TENANT\_ID\_ ) values ( ?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )

### Cause: java.sql.SQLTransientConnectionException: (conn=1860579) Lock wait timeout exceeded; try restarting transaction

```
    at com.techm.bm.om.orderdecompositionservice.consumer.ServiceOrderCreatedEventHandler.on(ServiceOrderCreatedEventHandler.java:90)

```

---

<div class="post-metadata">

**Author:** ![joram](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/joram/32/26_2.png) [@joram](https://forum.flowable.org/u/joram)\
**Post date:** [August 2, 2021, 7:53am UTC](https://forum.flowable.org/t/flowable-table-locking-issue/8155/2 "2021-08-02T07:53:28Z")

</div>

> [@sameer.uppal](#):
>
> Lock wait timeout exceeded;

This typically means the database can’t handle the load it needs to handle: a lock was taken but the work wasn’t completed in the timeout period.

Can you share more about which database / it’s setup? And how much concurrency / type of load you have?

---

<div class="post-metadata">

**Author:** ![sameer.uppal](https://avatars.discourse-cdn.com/v4/letter/s/9e8a1a/32.png) [@sameer.uppal](https://forum.flowable.org/u/sameer.uppal)\
**Post date:** [August 2, 2021, 11:17am UTC](https://forum.flowable.org/t/flowable-table-locking-issue/8155/3 "2021-08-02T11:17:51Z")

</div>

> [@joram](#):
>
> Can you share more about which database / it’s setup? And how much concurrency / type of load you have?

@joram thanks for reply. we are using MariaDb and currently having 10 concurrent user but facing this lock issue sometime.  
please suggest someone to resolve this issue,

---

<div class="post-metadata">

**Author:** ![joram](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/joram/32/26_2.png) [@joram](https://forum.flowable.org/u/joram)\
**Post date:** [August 2, 2021, 1:17pm UTC](https://forum.flowable.org/t/flowable-table-locking-issue/8155/4 "2021-08-02T13:17:16Z")

</div>

With 10 users, you should hardly be giving the database a sweat. How is your database setup (hardware-wise), did you configure your connection pool settings, any config that might help us?

---

<div class="post-metadata">

**Author:** ![ROY](https://avatars.discourse-cdn.com/v4/letter/r/4da419/32.png) [@ROY](https://forum.flowable.org/u/ROY)\
**Post date:** [November 15, 2022, 10:51am UTC](https://forum.flowable.org/t/flowable-table-locking-issue/8155/5 "2022-11-15T10:51:01Z")

</div>

HI @sameer.uppal I am also having the same issue. can you please let me know how you solved the issue.

@joram I am using Mysql which is running on Linux and flowable also runs on the same server  
RAM 128 and CPU 32  
with innodb\_lock\_wait\_timetout = 50

---

<div class="post-metadata">

**Author:** ![joram](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/joram/32/26_2.png) [@joram](https://forum.flowable.org/u/joram)\
**Post date:** [November 23, 2022, 9:32am UTC](https://forum.flowable.org/t/flowable-table-locking-issue/8155/6 "2022-11-23T09:32:16Z")

</div>

What kind of load / logic are you executing on it? Did you give the db enough resources (the server can have 128 gb ram, but mysql also needs to be configured to use it).

---

<div class="post-metadata">

**Author:** ![ROY](https://avatars.discourse-cdn.com/v4/letter/r/4da419/32.png) [@ROY](https://forum.flowable.org/u/ROY)\
**Post date:** [November 23, 2022, 4:22pm UTC](https://forum.flowable.org/t/flowable-table-locking-issue/8155/7 "2022-11-23T16:22:40Z")

</div>

HI Joram,

The load of the execution : 1000+ models connected in a flow and which involves a couple of multi-instance

i have configured mysql with below parameters  
innodb-buffer-pool-size=21474836480  
innodb\_buffer\_pool\_instances=20  
innodb\_log\_file\_size=4294967296  
sort\_buffer\_size = 50M  
read\_rnd\_buffer\_size = 50M  
join\_buffer\_size = 256M  
innodb\_log\_buffer\_size = 167772160  
innodb\_sort\_buffer\_size = 10485760  
innodb\_read\_io\_threads = 16  
innodb\_write\_io\_threads = 16  
innodb\_status\_output = ON  
innodb\_status\_output\_locks = ON  
innodb\_rollback\_on\_timeout = ON

with my further analysis what I understood is  
Once the lock issue starts then on one of thread is acquiring the jobs but is not processing it. so the execution is also stuck

Regards,  
Febin Roy

---

<div class="post-metadata">

**Author:** ![ROY](https://avatars.discourse-cdn.com/v4/letter/r/4da419/32.png) [@ROY](https://forum.flowable.org/u/ROY)\
**Post date:** [November 27, 2022, 6:40pm UTC](https://forum.flowable.org/t/flowable-table-locking-issue/8155/8 "2022-11-27T18:40:52Z")

</div>

in database logs i can see the deadlock is created by the below query

delete BYTES\_  
from ACT\_GE\_BYTEARRAY BYTES\_  
where BYTES\_.ID\_ in (  
select RES.BATCH\_DOC\_ID\_  
from FLW\_RU\_BATCH RES  
WHERE RES.TYPE\_ = ‘historicProcessDelete’  
and RES.COMPLETE\_TIME\_ \< ‘2021-11-25 07:00:44.744’

```
            and RES.BATCH_DOC_ID_ is not null
             and RES.BATCH_DOC_ID_ != ''
        union all
        select PARTS_.RESULT_DOC_ID_
        from FLW_RU_BATCH_PART PARTS_
        where PARTS_.RESULT_DOC_ID_ is not null
             and PARTS_.RESULT_DOC_ID_ != ''
            and PARTS_.BATCH_ID_ in (
                select RES.ID_
    from FLW_RU_BATCH RES
     WHERE RES.TYPE_ = 'historicProcessDelete'

```

---

<div class="post-metadata">

**Author:** ![joram](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/joram/32/26_2.png) [@joram](https://forum.flowable.org/u/joram)\
**Post date:** [November 29, 2022, 8:06am UTC](https://forum.flowable.org/t/flowable-table-locking-issue/8155/9 "2022-11-29T08:06:38Z")

</div>

That looks like the housekeeping deletion query. I’m assuming you have a lot of historical data? What settings do you have for the housekeeping?

Note: in the upcoming 6.8.0 version we have improved the performance of the housekeeping. On huge tables with aggressive parameters, it could be before that the database can’t cope with the load being put on it (hence the deadlock exception).