[Bug]: W-W conflict in pessimistic mode

[zhangxu19830126]

Is there an existing issue for the same bug?

• I have checked the existing issues.

Environment

- Version or commit-id (e.g. v0.1.0 or 8b23a93):
- Hardware parameters:
- OS type:
- Others:

Actual Behavior

w-w conflict in pessimistic mode

Expected Behavior

No response

Steps to Reproduce

run tpcc in pessimistic mode

Additional information

No response

[fengttt]

I think this is is dup of #10502

[fengttt]

Not necessarily dup #10502. Even if it is garbage, it is still locked garbage so it should not have w-w. Need more investigation.

[zhangxu19830126]

maybe fixed

[zhangxu19830126]

还没有修复

[zhangxu19830126]

还没有修复

[Ariznawlll]

run bvt under pessimistic mode in ci today, there also occurs w-w conflict.

create table temp(a int);
insert into temp select * from generate_series(1,8192) g;
create table t(a int);
insert into t select * from temp;
insert into t select * from t;
insert into t select * from t;
insert into t select * from t;
insert into t select * from t;
insert into t select * from t;
insert into t select * from t;
insert into t select * from t;
insert into t select * from t;
cn-0.log
cn-1.log
dn.log

[zhangxu19830126]

fix还是有问题，需要继续分析

[zhangxu19830126]

ROWID相关的问题，需要继续修复

[zhangxu19830126]

fixed by #10859

[sukki37]

Hello @zhangxu19830126. The bug issue in the BVT test code has not been removed,issues automatically open.

[Ariznawlll]

local test and ci-test has passed！