1213 - Deadlock found when trying to get lock; try restarting transaction 出现这个原因要记住一点就是：innodb的行锁 和解锁都是针对主键索引的。如果查询时根据索引锁表，但更新时却不是通过主键更新， 那么等待的解锁查询的进程将会报1213错误，程序里有可能返回一个null值
相关文章
- 1213 - Deadlock found when trying to get lock; try restarting transaction
- 数据库死锁的问题，Deadlock found when trying to get lock; try restarting transaction at Query.formatError
- MySql 更新死锁问题 Deadlock found when trying to get lock; try restarting transaction
- MySQL error : Deadlock found when trying to get lock; try restarting transaction
- MySQL遇到Deadlock found when trying to get lock，解决方案
- myqltransactionRollbackexception deadlock found when trying to get lock
- mysql报错：Deadlock found when trying to get lock; try restarting transaction的解决方法
- mysql - InnoDB存储引擎 死锁问题（ Deadlock found when trying to get lock; try restarting transaction ）
- mysql 报ERROR：Deadlock found when trying to get lock; try restarting transaction
- 关于MYSQL 死锁的问题 Deadlock found when trying to get lock; try restarting ..........