[Bug]: [date 8.27]1.2-dev tke regression: sysbench10w read_write 1000threads reported Duplicate entry error

[heni02]

Is there an existing issue for the same bug?

• [X] I have checked the existing issues.

Branch Name

1.2

Commit ID

968c8f7d6

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

job: https://github.com/matrixorigin/mo-nightly-regression/actions/runs/10579993708/job/29334436462

mo log: https://grafana.ci.matrixorigin.cn/explore?panes=%7B%22xGy%22:%7B%22datasource%22:%22loki%22,%22queries%22:%5B%7B%22refId%22:%22A%22,%22expr%22:%22%7Bnamespace%3D%5C%22mo-branch-nightly-968c8f7d6-20240827%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:%221724794063211%22,%22to%22:%221724807756796%22%7D%7D%7D&schemaVersion=1&orgId=1

Expected Behavior

No response

Steps to Reproduce

tke sysbench regression

Additional information

No response

[triump2020]

Add log ： https://github.com/triump2020/matrixone/tree/test-dup-base-1.2-dev

[XuPeng-SH]

@aptend

[aptend]

Despite attempts to reduce the flush interval and utilize Gaussian and Pareto distributions in Sysbench, reproducing the issue remains unsuccessful.

[heni02]

罗飞分支加log测试后write_only复现了： cc @triump2020 job:https://github.com/matrixorigin/mo-auto-test/actions/runs/10785439767/job/29914598341

mo log： https://grafana.ci.matrixorigin.cn/explore?panes=%7B%22qFM%22:%7B%22datasource%22:%22loki%22,%22queries%22:%5B%7B%22refId%22:%22A%22,%22expr%22:%22%7Bnamespace%3D%5C%22mo-search-nightly-68a447b55-20240910%5C%22%7D%20%7C%3D%20%60Duplicate%20entry%20%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:%221725934285333%22,%22to%22:%221725955885333%22%7D%7D%7D&schemaVersion=1&orgId=1

[triump2020]

It's related to https://github.com/matrixorigin/matrixone/pull/17388

[triump2020]

Wait for #17388 merging.

[triump2020]

Wait for https://github.com/matrixorigin/matrixone/pull/17388 merging.

[triump2020]

Wait for https://github.com/matrixorigin/matrixone/pull/17388 merging.

[triump2020]

Wait for https://github.com/matrixorigin/matrixone/pull/17388 merging.

[triump2020]

Wait for https://github.com/matrixorigin/matrixone/pull/17388 merging.

[triump2020]

Wait for https://github.com/matrixorigin/matrixone/pull/17388 merging.

[triump2020]

Wait for https://github.com/matrixorigin/matrixone/pull/17388 merging.

[triump2020]

Wait for https://github.com/matrixorigin/matrixone/pull/17388 merging. @ouyuanning

[triump2020]

Wait for @ouyuanning ’s PR

[triump2020]

Wait for @ouyuanning ’s PR

[aressu1985]

update on 11.09 job link: https://github.com/matrixorigin/mo-nightly-regression/actions/runs/11743962543/job/32732065024

mo-log: https://shanghai.idc.matrixorigin.cn:30001/explore?panes=%7B%22GYP%22:%7B%22datasource%22:%22loki%22,%22queries%22:%5B%7B%22refId%22:%22A%22,%22expr%22:%22%7Bhost%3D%5C%2210-222-1-128%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:%221731094493127%22,%22to%22:%221731105305113%22%7D%7D%7D&schemaVersion=1&orgId=1