序列化失败:尝试获取锁时发现死锁 [英] Serialization failure: Deadlock found when trying to get lock

问题描述

当特定表正在运行多个更新时，我遇到以下错误 数据库-MySQL-InnoDB引擎 语言PHP- PDO

I am getting below error when there is multiple update is running particular table Data base - Mysql - innodb engine Language PHP- PDO

错误-序列化失败:尝试获取锁时发现死锁

Error - Serialization failure: Deadlock found when trying to get lock

我检查了以下链接 SQLSTATE [40001]:序列化失败:1213死锁在尝试获取锁时被发现；尝试按Magento职位重新开始交易

推荐答案

您可以检查此链接

You can check this link Deadlock exception code for PHP, MySQL PDOException? to handle the error, or you may want to simply try again.

MySQL告诉您正在对要更新的数据运行另一个更新.所以不要让你这样做.

MySQL tells you another update is running on the data that you want to update. So doesn't let you to do it.

有关死锁的更多信息，请 https://en.wikipedia.org/wiki/Deadlock

And for more information about deadlocks https://en.wikipedia.org/wiki/Deadlock

这篇关于序列化失败:尝试获取锁时发现死锁的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！