单个存储过程不会导致死锁，这是另一个同时运行的进程，例如以相同的顺序更新同一个表。你必须找出它是哪一个。

A single stored procedure won't cause a deadlock, it's an other process running at the same time and e.g. update the same table but in a different order. You have to find out which one it is.

你永远不能防止100％的死锁，它们可以发生。

And you can never prevent deadlocks for 100%, they can occur.