CODEWITHSUNDEEP
phpmysqlpdo
nitin jain
nitin jain

Reputation: 298

Serialization failure: Deadlock found when trying to get lock

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

I checked below link SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction by Magento position

Upvotes: 2

Views: 8892

Answers (1)

mertak
mertak

Reputation: 66

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 tells you another update is running on the data that you want to update. So doesn't let you to do it.

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

Upvotes: 2

Related Questions