Deadlock found when trying to get lock; try restarting transaction模拟解锁和上锁过程java
-------上锁set autocommit=0; #关闭自动提交SELECT * from t_b_ru_task t where t.id='7373dc02597e4d15bfc9e823e238bf0d' FOR UPDATE;# 给id为1的数据行添加行锁SELECT * from t_b_ru_task t where t.id='10c23242cc804ccbadbde0ca8bc2e5d7' FOR UPDATE;# 给id为1的数据行添加行锁set autocommit
原创
2021-10-25 09:34:55 ·
438 阅读 ·
0 评论