关于FLOWABLE中MYBATIS 事务的问题

大板牙花生 2021-03-29 03:55:06



Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction

	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)

	at com.mysql.jdbc.Util.getInstance(Util.java:408)

	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:952)

	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976)

	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3912)

	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)

	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)

	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486)

	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)

	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1197)

	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3409)

	at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440)

	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3407)

	at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:167)

	at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:498)

	at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:46)

	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:198)

	... 107 common frames omitted

org.apache.ibatis.exceptions.PersistenceException: 

### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction

### The error may involve org.flowable.engine.impl.persistence.entity.ActivityInstanceEntityImpl.insertActivityInstance-Inline

### The error occurred while setting parameters

### SQL: insert into ACT_RU_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: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction

	at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)

	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:200)

	at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:185)

	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.TaskServiceImpl.complete(TaskServiceImpl.java:213)

	at com.zyd.shiro.controller.RestFlowActiondoController.apply(RestFlowActiondoController.java:239)

	at com.zyd.shiro.controller.RestFlowActiondoController$$FastClassBySpringCGLIB$$ab2bac1e.invoke(<generated>)

	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)