[Bug]: big-data-regression(1.2-dev): update table report 'r-w conflict'.

[Ariznawlll]

Is there an existing issue for the same bug?

• [X] I have checked the existing issues.

Branch Name

1.2-dev

Commit ID

3f5bca9889c977887ded185df0a533ab0d03082f

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

job url: https://github.com/matrixorigin/mo-nightly-regression/actions/runs/10939094868/job/30368659631

https://grafana.ci.matrixorigin.cn/explore?panes=%7B%22a4w%22:%7B%22datasource%22:%22loki%22,%22queries%22:%5B%7B%22refId%22:%22A%22,%22expr%22:%22%7Bnamespace%3D%5C%22mo-big-data-20240919%5C%22%7D%20%7C%3D%20%60r-w%20conflict%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:%221726747748000%22,%22to%22:%221726748339000%22%7D%7D%7D&schemaVersion=1&orgId=1

Expected Behavior

No response

Steps to Reproduce

数据量：1亿 （约33G）

出错表的schema：
create table if not exists big_data_test.table_with_pk_index_for_write_100M( id bigint primary key, col1 tinyint, col2 smallint, col3 int, col4 bigint, col5 tinyint unsigned, col6 smallint unsigned, col7 int unsigned, col8 bigint unsigned, col9 float, col10 double, col11 varchar(255), col12 Date, col13 DateTime, col14 timestamp, col15 bool, col16 decimal(16,6), col17 text, col18 json, col19 blob, col20 binary(255), col21 varbinary(255), col22 vecf32(3), col23 vecf32(3), col24 vecf64(3), col25 vecf64(3), key(col3), unique key(col4)）;

报错的sql：
update big_data_test.table_with_pk_index_for_write_100M set col3 = col3 + 1 where id <= 10000000

Additional information

No response

[jiangxinmeng1]

依赖 https://github.com/matrixorigin/matrixone/issues/18520

[jiangxinmeng1]

修好了

[Ariznawlll]

testing

[Ariznawlll]

1.2-dev commit：0d56ba8b83807211268434f336f2c54094575617 最新一轮测试还有该问题

log：https://grafana.ci.matrixorigin.cn/explore?panes=%7B%22oKe%22:%7B%22datasource%22:%22loki%22,%22queries%22:%5B%7B%22refId%22:%22A%22,%22expr%22:%22%7Bnamespace%3D%5C%22mo-big-data-20241010%5C%22%7D%20%7C%3D%20%60r-w%20conflict%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:%221728579285000%22,%22to%22:%221728580494000%22%7D%7D%7D&schemaVersion=1&orgId=1

数据量：1亿 （约33G）

出错表的schema：
create table if not exists big_data_test.table_with_pk_index_for_write_100M( id bigint primary key, col1 tinyint, col2 smallint, col3 int, col4 bigint, col5 tinyint unsigned, col6 smallint unsigned, col7 int unsigned, col8 bigint unsigned, col9 float, col10 double, col11 varchar(255), col12 Date, col13 DateTime, col14 timestamp, col15 bool, col16 decimal(16,6), col17 text, col18 json, col19 blob, col20 binary(255), col21 varbinary(255), col22 vecf32(3), col23 vecf32(3), col24 vecf64(3), col25 vecf64(3), key(col3), unique key(col4)）;

报错的sql：
update big_data_test.table_with_pk_index_for_write_100M set col3 = col3 + 1 where id <= 10000000