[Bug]: [date 4.27] tke regression: mo hung about matrixone HOT 5 CLOSED

date 4.28 也同样出现卡住问题
job：https://github.com/matrixorigin/mo-nightly-regression/actions/runs/8868322751/job/24352635422

mo log：
https://grafana.ci.matrixorigin.cn/explore?panes=%7B%22BkN%22:%7B%22datasource%22:%22loki%22,%22queries%22:%5B%7B%22refId%22:%22A%22,%22expr%22:%22%7Bnamespace%3D%5C%22mo-nightly-regression-20240428%5C%22%7D%20%7C%3D%20%60%60%22,%22queryType%22:%22range%22,%22datasource%22:%7B%22type%22:%22loki%22,%22uid%22:%22loki%22%7D,%22editorMode%22:%22builder%22%7D%5D,%22range%22:%7B%22from%22:%221714340530920%22,%22to%22:%221714341354048%22%7D%7D%7D&schemaVersion=1&orgId=1

profile：
文件比较大，私发开发定位

from matrixone.

从日志里看，是hang在上锁这一步，几个cn都是。大概率是出现了死锁
麻烦 @iamlinjunhong 定位一下

from matrixone.

pr ： #15784

from matrixone.

目前回归已经没有锁问题导致的mo hung的问题，先降级，再观察两天回归测试结果

from matrixone.

没有再出现问题，closed
commit：3ac2f912b
job：https://github.com/matrixorigin/mo-nightly-regression/actions/runs/9003686974/attempts/1

from matrixone.