【TiDB 版本】
Release Version: v4.0.0
Edition: Community
Git Commit Hash: 689a6b6439ae7835947fcaccf329a3fc303986cb
Git Branch: heads/refs/tags/v4.0.0
UTC Build Time: 2020-05-28 01:37:40
GoVersion: go1.13
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false
【问题描述】
第一个会话:
START TRANSACTION;
select * from tb_customer_score where
c_no=‘0036148’ for UPDATE ;
第二个会话:
select * from tb_customer_score where
c_no=‘0036148’ for UPDATE ;
为什么不会阻塞呢?
update tb_customer_score set c_score=1 where
c_no=‘0036148’ ;
执行update会阻塞
若提问为性能优化、故障排查类问题,请下载脚本运行。终端输出的打印结果,请务必全选并复制粘贴上传。