单据提交后 报update sa_task错误

xuxu

报update sa_task错误
麻烦看看为什么会报这样的错误 本来流程应该是正常往下走的

在日志里找到了trace
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: update SA_Task i set  i.sParent='EE1ACAF172E7404F93D11CC30EBFD1DB', i.sStatusID=:sStatusID, i.sActualFinishTime=:sActualFinishTime, i.sStatusName=:sStatusName, i.sLock=:sLock, i.sLastModifyTime=:sLastModifyTime
where i='00644B0695764AB5ABED256FF5609EAE' and  i.sLock='7893263CDD8A46A0B3E8394D75DE2028'
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlUpdate(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlExecuteUpdate(Unknown Source)
        at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
        at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
        at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
        at com.justep.system.process.Task.doUpdate(Unknown Source)
        at com.justep.system.process.Individual.doSave(Unknown Source)
        at com.justep.system.process.Individual.save(Unknown Source)
        at com.justep.system.process.Task.save(Unknown Source)
        at com.justep.system.process.Task.save(Unknown Source)
        at com.justep.system.process.Task.save(Unknown Source)
        at com.justep.system.process.TaskEngine.commit(Unknown Source)
        at com.justep.system.process.ProcessEngine.commit(Unknown Source)
        at ProcessProcedure.advanceProcess(ProcessProcedure.java:355)
        ... 44 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: UPDATE SA_Task SET SA_Task.sParentID = ?, SA_Task.SSTATUSID =  ? , SA_Task.SACTUALFINISHTIME =  ? , SA_Task.SSTATUSNAME =  ? , SA_Task.SLOCK =  ? , SA_Task.SLASTMODIFYTIME =  ?   
WHERE  (SA_Task.sID = ?) AND (SA_Task.SLOCK = ?) , binds: [EE1ACAF172E7404F93D11CC30EBFD1DB, tesCanceled, 2018-05-17 15:24:51.111, 已取消, 7DBE13AD68844D1CBCD9E6F2AF2D4193, 2018-05-17 15:24:51.111, 00644B0695764AB5ABED256FF5609EAE, 7893263CDD8A46A0B3E8394D75DE2028]出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
        ... 58 more
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:422)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:400)
        at com.mysql.jdbc.Util.getInstance(Util.java:383)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2113)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2049)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2034)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
        ... 59 more

jishuang

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:422)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:400)
        at com.mysql.jdbc.Util.getInstance(Util.java:383)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)


这个是数据库的标准错误，可以到网上查找原因

xuxu

jishuang 发表于 2018-5-17 15:40
com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to ge ...

我知道是死锁
但是表定义和update的语句  都是X5自带的
而且这UPDATE语句不是X5自动生成并执行的吗？
我即便找到原因 我能改吗？

xuxu

jishuang 发表于 2018-5-17 15:40
com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to ge ...

请看看日志里的这个截图
是否是同一个update语句(参数也一样)  一起执行了两次
第一次是执行成功了  但是第二次就报错

jishuang

http://bbs.wex5.com/forum.php?mod=viewthread&tid=190102