[Bug]: lock consumes too much memory and OOM during daily run

### Is there an existing issue for the same bug?

- [x] I have checked the existing issues.

### Branch Name

main

### Commit ID

latest

### Other Environment Information

```Markdown
- Hardware parameters:
- OS type:
- Others:
```

### Actual Behavior

### Expected Behavior

_No response_

### Steps to Reproduce

```Markdown
https://github.com/matrixorigin/mo-nightly-regression/actions/runs/14081187486/job/39478806526

https://grafana.ci.matrixorigin.cn/explore?panes=%7B%223Ff%22:%7B%22datasource%22:%22pyroscope%22,%22queries%22:%5B%7B%22groupBy%22:%5B%5D,%22labelSelector%22:%22%7Bpod%3D%5C%22nightly-regression-dis-tp-cn-7qckm%5C%22%7D%22,%22queryType%22:%22both%22,%22refId%22:%22A%22,%22profileTypeId%22:%22memory:inuse_space:bytes:space:bytes%22,%22datasource%22:%7B%22type%22:%22grafana-pyroscope-datasource%22,%22uid%22:%22pyroscope%22%7D%7D%5D,%22range%22:%7B%22from%22:%22now-3h%22,%22to%22:%22now%22%7D%7D%7D&schemaVersion=1&orgId=1
```

### Additional information

_No response_