Transaction (Process ID 122) was deadlocked on lock resources with another process and has
been chosen as the deadlock victim. Rerun the transaction. [SQLSTATE 40001] (Error 1205).
The step failed.
有一个作业每天固定时间执行,就是计算一些数据并更新(批量update语句)到一张表(表A)中。 但是昨天作业执行时出现以下错误,主要是说死锁的问题。 Transaction (Process ID 122) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. [SQLSTATE 40001] (Error 1