![]() LOCK WAIT 6 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 7 TRANSACTION 167187, ACTIVE 0 sec inserting So there is always one transaction deleting from ACT_RU_* and another transaction manipulating (insert or update) ACT_RU_*, e.g. the data from the runtime tables is going to be deleted). Root Cause: Caused by: : Deadlock found when trying to get lock try restarting transactionĪt .(AbstractQueryProtocol.java:1594) ~Īt .(AbstractQueryProtocol.java:1453) ~Īt .(AbstractQueryProtocol.java:1415) ~Īt .(AbstractQueryProtocol.java:289) ~Īt .executeInternal(ClientSidePreparedStatement.java:221) ~Īt .execute(ClientSidePreparedStatement.java:157) ~Īt 2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:198) ~Īt .(PreparedStatementHandler.java:47) ~Īt .(RoutingStatementHandler.java:74) ~Īt .SimpleExecutor.doUpdate(SimpleExecutor.java:50) ~Īt .BaseExecutor.update(BaseExecutor.java:117) ~Īt .CachingExecutor.update(CachingExecutor.java:76) ~Īt .(DefaultSqlSession.java:197) ~Īny Looking at the deadlocks happening in our production system, it turns out, that deadlocks appear always when process-instances are completing (i.e. ![]() # Cause: : (conn=45) Deadlock found when trying to get lock try restarting transactionĪt .ExceptionFactory.wrapException(ExceptionFactory.java:30) ~Īt .(DefaultSqlSession.java:199) ~Īt .impl.db.DbSqlSession.flushUpdates(DbSqlSession.java:570) ~Īt .impl.db.DbSqlSession.flush(DbSqlSession.java:359) ~Īt .(CommandContext.java:192) ~Īt .(CommandContext.java:61) ~Īt .(CommandContextInterceptor.java:81) ~Īt .(LogInterceptor.java:30) ~ # SQL: update ACT_RU_ACTINST SET REV_ = ?, PROC_DEF_ID_ = ?, END_TIME_ = ?, ![]() # The error occurred while setting parameters # The error may exist in org/flowable/db/mapping/entity/ActivityInstance.xml Cause: : (conn=45) Deadlock found when trying to get lock try restarting transaction We use flowable 6.5.0 and MariaDB 10.3 und see following deadlock while running different process-instances in parallel: # Error updating database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |