This issue requires an assignee. Since you haven't specified one, we've assigned TestManager as the default assignee for this issue.

Welcome To openGauss Community

Hey @totaj , thanks for your contribution to the community.

Bot Usage Manual

I'm the Bot here serving you. You can find the instructions on how to interact with me at Here . That means you can comment below every pull request or issue to trigger Bot Commands.

Contact Guide

If you have any questions, please contact the SIG: StorageEngine, AI, CM, CloudNative, SecurityTechnology, SQLEngine ,
and any of the maintainers: @CarrotGo, @chendong76, @chenxiaobin19, @congzhou2603, @dodders, @hwworkholic, @jemappellehc, @muyulinzhong, @quemingjian, @shenzheng4, @shirley_zhengx, @superlchf, @totaj, @wlff234, @wofanzheng, @ywzq1161327784 ,
and any of the committers: @Igali, @bihua111, @cailei19, @h_ray, @levy53071, @libiao2024, @lihaixiao, @mrzack, @wangfeihuo, @wuyuechuan, @xiong_xjun, @zhangfengzhi123, @zhangxubo, @zhangzq131, @zjh_hw .

/assign

原始用例复现：

子分区用例扩展复现：

【自验环境】
openEuler 20.03 aarch64，single_node

【转测包】
openGauss7.0.0.B022
git_num: bc72a519

【关联 PR】
PR 9640
Issue 8420

【验证内容】

1. gpi_merge_upsert_concurrent.sql 执行通过，最终结果为 20|2|2；
2. 指定分区 UPSERT、普通 UPSERT、COPY、跨分区 UPDATE 执行正常；
3. gpi_merge_upsert_subpartition.sql 执行通过，最终结果为 1|0|1；
4. 子分区 UPSERT、COPY、UPDATE、DELETE及父子分区关系查找执行正常；
5. 并发用例连续执行 20 次，无非预期 ERROR、PANIC、FATAL；
6. 服务端日志无分区映射错误和 cache 引用泄漏错误。

【自验结果】
通过。

【回归人员】sungang14
【回归日期】2026.9.11
【回归版本】openGauss 7.0.0B022
【回归结论】通过
【回归步骤】
drop table if exists tmp_t;
CREATE TABLE tmp_t
(
a date primary key,
b int ,
c VARCHAR2 ( 30 )
)
PARTITION BY RANGE (a) INTERVAL ('1 month')
(
PARTITION p1 VALUES LESS THAN ('2021-01-31 23:59:59'),
PARTITION p2 VALUES LESS THAN ('2021-02-28 23:59:59'),
PARTITION p3 VALUES LESS THAN ('2021-03-31 23:59:59'),
PARTITION p4 VALUES LESS THAN ('2021-04-30 23:59:59')
)
ENABLE ROW MOVEMENT;

drop table if exists interval_part_t;
CREATE TABLE interval_part_t (like tmp_t including all);

create index i_interval_part_t on interval_part_t(a,c) ;
insert into interval_part_t VALUES('2021-03-07 17:00:00',1,'rr'),('2021-02-08 17:00:00',2,'dd');
insert into interval_part_t VALUES('2021-04-07 17:00:00',1,'rr'),('2021-04-08 17:00:00',2,'dd');
insert into interval_part_t VALUES('2021-08-07 17:00:00',1,'dd'),('2021-09-08 17:00:00',2,'dd');
insert into interval_part_t VALUES('2021-05-06 17:00:00',1,'dd'),('2021-10-18 17:00:00',2,'dd');
insert into interval_part_t VALUES('2021-05-17 17:00:00',1,1),('2021-10-08 17:00:00',2,1);
insert into interval_part_t VALUES('2021-10-17 17:00:00',1,1),('2021-11-08 17:00:00',2,1);
insert into interval_part_t VALUES('2021-08-17 17:00:00',1,1),('2021-08-08 17:00:00',2,1);
insert into interval_part_t VALUES('2021-09-17 17:00:00',1,1),('2021-10-02 17:00:00',2,1);
insert into interval_part_t VALUES('2021-11-17 17:00:00',1,1),('2023-01-08 17:00:00',2,1);
insert into interval_part_t VALUES('2021-12-28 17:00:00',2,1),('2021-11-18 17:00:00',1,1);

\parallel on
alter table interval_part_t merge partitions sys_p2,sys_p4,sys_p5 into partition sys_p5 update global index;
insert into interval_part_t VALUES('2021-11-17 17:00:00',1,1),('2023-01-08 17:00:00',2,1) ON DUPLICATE KEY UPDATE c='zz';
insert into interval_part_t VALUES('2021-12-28 17:00:00',2,1),('2021-11-18 17:00:00',1,1) ON DUPLICATE KEY UPDATE c='zz';
\parallel off

【转测日期】2026-10-10
【转测包】8.0.0-RC1.B001 目录，实际内核版本：7.0.0 build 6a41b1ba
【验证内容】issue #8420 原始并发用例
【结论】通过。数据保留 20 行，4 行 UPSERT 更新正确，分区合并成功，全局索引有效，无引用计数泄漏告警。

验收日期：2026-10-16
验收版本：8.0.0-RC1.B002
验收结论：验收通过