分支节点 sql语句有问题,锁表了



分支节点选的是任意成功,下面是条件判断
这个sql {“sql”: “UPDATE jobs SET result=?,updated_at=? WHERE id = ?”, “name”: “SequelizeDatabaseError”, “parent”: {“sql”: “UPDATE jobs SET result=?,updated_at=? WHERE id = ?”, “code”: “ER_LOCK_WAIT_TIMEOUT”, “errno”: 1205, “sqlState”: “HY000”, “parameters”: [“[-1,-1,-1,null,null,null,null]”, “2024-11-28 22:55:10”, 11372], “sqlMessage”: “Lock wait timeout exceeded; try restarting transaction”}, “message”: “Lock wait timeout exceeded; try restarting transaction”, “original”: {“sql”: “UPDATE jobs SET result=?,updated_at=? WHERE id = ?”, “code”: “ER_LOCK_WAIT_TIMEOUT”, “errno”: 1205, “sqlState”: “HY000”, “parameters”: [“[-1,-1,-1,null,null,null,null]”, “2024-11-28 22:55:10”, 11372], “sqlMessage”: “Lock wait timeout exceeded; try restarting transaction”}, “parameters”: [“[-1,-1,-1,null,null,null,null]”, “2024-11-28 22:55:10”, 11372]}

麻烦问下用的数据库是哪种?

mysql

好的,我这边测一下这种情况。

感谢,我的业务流程就要是算出工单的维修分+工单处理的天数,分支那个流程是任意成功,当处理天数满足2、4、8以此类推(条件判断),然后走后续的流程

我这边本地跑未能复现,可以将你能复现的最小例子配置一个在官方的 demo 上么?方便我们参照排查问题?