Unexpected ERROR 8141 (HY000): assertion failed

[maxshuang]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

1. set up cluster using tiup

tiup  playground  nightly --tag newest3   --db 1 --kv 3 --pd 1  --ticdc 1

2. run following sql

create table t11 (n numeric(10));
create table t12 (n numeric(10));
insert into t12 values (1),(2),(4),(8),(16),(32);
select * from t12 left outer join t11  using (n);
delete  t11,t12 from t12 left outer join t11  using (n);

2. What did you expect to see? (Required)

everything normal

3. What did you see instead (Required)

mysql> delete t11,t12 from t12 left outer join t11 using (n);
ERROR 8141 (HY000): assertion failed: key: 7480000000000003815f728000000000000000, assertion: Exist, start_ts: 431500354669510657, existing start ts: 0, existing commit ts: 0

4. What is your TiDB version? (Required)

mysql> select tidb_version();
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| tidb_version() |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Release Version: v5.5.0-alpha
Edition: Community
Git Commit Hash: 171a354
Git Branch: heads/refs/tags/v5.5.0-alpha
UTC Build Time: 2022-02-20 14:54:53
GoVersion: go1.16.4
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

[ekexium]

duplicated with #31321 .