[Bug]: Duplicate entry '47652' for key 'id during sysbench read_write and write_only cases on distributed

[aressu1985]

Is there an existing issue for the same bug?

• [X] I have checked the existing issues.

Branch Name

main

Commit ID

967435ecc961c952fcd6faf5dd2c2fcac952d530

Other Environment Information

- Hardware parameters:
3*CN: 16C 64G
1*DN: 16C 64G
3*LOG: 4C 16G
3*PRXOY: 3C 7G
- OS type:
- Others:

Actual Behavior

job link: https://github.com/matrixorigin/mo-nightly-regression/actions/runs/11541331975/job/32129077656

mo-log: https://grafana.ci.matrixorigin.cn/explore?panes=%7B%22PHL%22:%7B%22datasource%22:%22loki%22,%22queries%22:%5B%7B%22refId%22:%22A%22,%22expr%22:%22%7Bnamespace%3D%5C%22mo-main-nightly-967435ecc-20241027%5C%22%7D%20%7C%3D%20%60Duplicate%20entry%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:%221730067480857%22,%22to%22:%221730068232716%22%7D%7D%7D&schemaVersion=1&orgId=1

Expected Behavior

No response

Steps to Reproduce

occassionally in sysbench read_write and write_only cases

Additional information

No response

[triump2020]

Duplicate with #18400 ?

[aressu1985]

update on 10.31 commit: job link:https://github.com/matrixorigin/mo-nightly-regression/actions/runs/11596736880/job/32308601638

0bbda669365e51df6d65fd33219f34f1515e8717

mo-log: https://grafana.ci.matrixorigin.cn/explore?panes=%7B%22f0j%22:%7B%22datasource%22:%22loki%22,%22queries%22:%5B%7B%22refId%22:%22A%22,%22expr%22:%22%7Bnamespace%3D%5C%22mo-branch-nightly-0bbda6693-20241030%5C%22%7D%20%7C%3D%20%60Duplicate%20entry%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:%221730331231787%22,%22to%22:%221730332327716%22%7D%7D%7D&schemaVersion=1&orgId=1