已关闭
[Bug]: B库和D库发布订阅check用例失败--ddl_replication #8409
ywzq1161327784创建于 8月18日关闭于 8月29日
8月18日 添加了label：bug
opengauss_bot
8月18日 评论：
8月18日 评论：
This issue requires an assignee. Since you haven't specified one, we've assigned TestManager as the default assignee for this issue.
8月18日 将 TestManager 设为负责人
opengauss_bot8月18日 添加了label：sig/StorageEngine,sig/AI,sig/CM,sig/CloudNative,sig/SecurityTechnology,sig/SQLEngine
8月18日 添加了label：sig/StorageEngine,sig/AI,sig/CM,sig/CloudNative,sig/SecurityTechnology,sig/SQLEngine
opengauss_bot
8月18日 评论：
8月18日 评论：
Welcome To openGauss Community
Hey @ywzq1161327784 , 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 .
8月18日 修改了issue 的描述
8月18日 移除了负责人 TestManager
opengauss_bot
8月18日 评论：
8月18日 评论：
This issue requires an assignee. Since you haven't specified one, we've assigned TestManager as the default assignee for this issue.
8月18日 将 TestManager 设为负责人
8月18日 将 ywzq1161327784 设为负责人，移除负责人 TestManager
8月18日 关联了看板：openGauss 7.0.0-LTS
8月19日 issue状态由 待办的 改变为 已完成
ywzq1161327784
8月19日 评论：
8月19日 评论：
cmake编译，A/B/D库发布订阅check均ok（其中B库未包含dolphin插件）
[douxin@openGauss62 openGauss-server]$ cd /usr1/douxin/openGauss-server/tmp_build/src/test/subscription
[douxin@openGauss62 subscription]$
[douxin@openGauss62 subscription]$ make check p=42000 dbcompatibility=A
cd /usr1/douxin/openGauss-server/tmp_build && make -f CMakeFiles/Makefile2 src/test/subscription/CMakeFiles/check.dir/rule
make[1]: Entering directory '/usr1/douxin/openGauss-server/tmp_build'
make[2]: Entering directory '/usr1/douxin/openGauss-server/tmp_build'
make[3]: Entering directory '/usr1/douxin/openGauss-server/tmp_build'
Scanning dependencies of target check
make[3]: Leaving directory '/usr1/douxin/openGauss-server/tmp_build'
make[3]: Entering directory '/usr1/douxin/openGauss-server/tmp_build'
removing /usr1/douxin/openGauss-server/src/test/subscription/tmp_check
removing /usr1/douxin/openGauss-server/src/test/subscription/results
init and start the database
testcase result time(s)
rep_changes .... ok 51
ddl_replication .... ok 482
pub_switchover .... ok 25
types .... ok 35
constraints .... ok 17
binary .... ok 27
diff_schema .... ok 21
generated .... ok 17
rewrite .... ok 16
sync .... ok 38
encoding .... ok 10
ddl .... ok 11
matviews .... ok 16
change_wal_level .... ok 22
skiplsn .... ok 27
disable .... ok 12
pub_subconflict .... ok 43
bugs .... ok 91
dump .... ok 31
stop the database
total testcase 19: 19 passed, 0 failed
total time: 1134s
[douxin@openGauss62 subscription]$ make check p=45000 dbcompatibility=B && make
check p=45000 dbcompatibility=D
cd /usr1/douxin/openGauss-server/tmp_build && make -f CMakeFiles/Makefile2 src/test/subscription/CMakeFiles/check.dir/rule
make[1]: Entering directory '/usr1/douxin/openGauss-server/tmp_build'
make[2]: Entering directory '/usr1/douxin/openGauss-server/tmp_build'
make[3]: Entering directory '/usr1/douxin/openGauss-server/tmp_build'
make[3]: Leaving directory '/usr1/douxin/openGauss-server/tmp_build'
make[3]: Entering directory '/usr1/douxin/openGauss-server/tmp_build'
removing /usr1/douxin/openGauss-server/src/test/subscription/tmp_check
removing /usr1/douxin/openGauss-server/src/test/subscription/results
init and start the database
testcase result time(s)
rep_changes .... ok 53
ddl_replication .... ok 505
pub_switchover .... ok 24
types .... ok 34
constraints .... ok 17
binary .... ok 26
diff_schema .... ok 21
generated .... ok 16
rewrite .... ok 16
sync .... ok 37
encoding .... ok 10
ddl .... ok 11
matviews .... ok 15
change_wal_level .... ok 22
skiplsn .... ok 27
disable .... ok 12
pub_subconflict .... ok 42
bugs .... ok 87
dump .... ok 31
stop the database
total testcase 19: 19 passed, 0 failed
total time: 1146s
make[3]: Leaving directory '/usr1/douxin/openGauss-server/tmp_build'
Built target check
make[2]: Leaving directory '/usr1/douxin/openGauss-server/tmp_build'
make[1]: Leaving directory '/usr1/douxin/openGauss-server/tmp_build'
cd /usr1/douxin/openGauss-server/tmp_build && make -f CMakeFiles/Makefile2 src/test/subscription/CMakeFiles/check.dir/rule
make[1]: Entering directory '/usr1/douxin/openGauss-server/tmp_build'
make[2]: Entering directory '/usr1/douxin/openGauss-server/tmp_build'
make[3]: Entering directory '/usr1/douxin/openGauss-server/tmp_build'
make[3]: Leaving directory '/usr1/douxin/openGauss-server/tmp_build'
make[3]: Entering directory '/usr1/douxin/openGauss-server/tmp_build'
removing /usr1/douxin/openGauss-server/src/test/subscription/tmp_check
removing /usr1/douxin/openGauss-server/src/test/subscription/results
init and start the database
testcase result time(s)
rep_changes .... ok 54
ddl_replication .... ok 661
pub_switchover .... ok 33
types .... ok 34
constraints .... ok 17
binary .... ok 26
diff_schema .... ok 22
generated .... ok 16
rewrite .... ok 17
sync .... ok 37
encoding .... ok 10
ddl .... ok 11
matviews .... ok 16
change_wal_level .... ok 22
skiplsn .... ok 27
disable .... ok 12
pub_subconflict .... ok 43
bugs .... ok 92
dump .... ok 29
stop the database
total testcase 19: 19 passed, 0 failed
total time: 1315s
make[3]: Leaving directory '/usr1/douxin/openGauss-server/tmp_build'
Built target check
make[2]: Leaving directory '/usr1/douxin/openGauss-server/tmp_build'
make[1]: Leaving directory '/usr1/douxin/openGauss-server/tmp_build'
[douxin@openGauss62 subscription]$ python -V
Python 3.7.9
[douxin@openGauss62 subscription]$ gaussdb -V
gaussdb (openGauss 7.0.0-RC3 build 85f0c1f0) compiled at 2026-08-19 12:18:06 commit 1000 last mr 9389 debug on aarch64-unknown-linux-gnu, compiled by g++ (GCC) 10.3.1, 64-bit
8月19日 issue状态由 已完成 改变为 待回归
8月19日 issue状态由 待回归 改变为 已完成
ywzq11613277848月19日 修改标题为 “[Bug]: B库和D库发布订阅check用例失败--ddl_replication”，原标题为“[Bug]: D库发布订阅check用例失败--ddl_replication”
8月19日 修改标题为 “[Bug]: B库和D库发布订阅check用例失败--ddl_replication”，原标题为“[Bug]: D库发布订阅check用例失败--ddl_replication”
8月19日 修改了issue 的描述
ywzq1161327784
8月20日 评论：
8月20日 评论：
B库带dolphin插件，cmake编译，A/B/D库发布订阅check均执行成功
[douxin@openGauss62 openGauss-server]$ cd tmp_build/src/test/subscription/
[douxin@openGauss62 subscription]$
[douxin@openGauss62 subscription]$
[douxin@openGauss62 subscription]$
[douxin@openGauss62 subscription]$ make check p=42000 dbcompatibility=B && make check p=42000 dbcompatibility=A && make check p=42000 dbcomp
atibility=D
cd /usr1/douxin/openGauss-server/tmp_build && make -f CMakeFiles/Makefile2 src/test/subscription/CMakeFiles/check.dir/rule
make[1]: Entering directory '/usr1/douxin/openGauss-server/tmp_build'
make[2]: Entering directory '/usr1/douxin/openGauss-server/tmp_build'
make[3]: Entering directory '/usr1/douxin/openGauss-server/tmp_build'
Scanning dependencies of target check
make[3]: Leaving directory '/usr1/douxin/openGauss-server/tmp_build'
make[3]: Entering directory '/usr1/douxin/openGauss-server/tmp_build'
removing /usr1/douxin/openGauss-server/src/test/subscription/tmp_check
removing /usr1/douxin/openGauss-server/src/test/subscription/results
init and start the database
testcase result time(s)
rep_changes .... ok 87
ddl_replication .... ok 998
pub_switchover .... ok 55
types .... ok 71
constraints .... ok 37
binary .... ok 57
diff_schema .... ok 40
generated .... ok 36
rewrite .... ok 50
sync .... ok 82
encoding .... ok 28
ddl .... ok 32
matviews .... ok 37
change_wal_level .... ok 58
skiplsn .... ok 57
disable .... ok 33
pub_subconflict .... ok 61
bugs .... ok 117
dump .... ok 89
stop the database
total testcase 19: 19 passed, 0 failed
total time: 2195s
make[3]: Leaving directory '/usr1/douxin/openGauss-server/tmp_build'
Built target check
make[2]: Leaving directory '/usr1/douxin/openGauss-server/tmp_build'
make[1]: Leaving directory '/usr1/douxin/openGauss-server/tmp_build'
cd /usr1/douxin/openGauss-server/tmp_build && make -f CMakeFiles/Makefile2 src/test/subscription/CMakeFiles/check.dir/rule
make[1]: Entering directory '/usr1/douxin/openGauss-server/tmp_build'
make[2]: Entering directory '/usr1/douxin/openGauss-server/tmp_build'
make[3]: Entering directory '/usr1/douxin/openGauss-server/tmp_build'
make[3]: Leaving directory '/usr1/douxin/openGauss-server/tmp_build'
make[3]: Entering directory '/usr1/douxin/openGauss-server/tmp_build'
removing /usr1/douxin/openGauss-server/src/test/subscription/tmp_check
removing /usr1/douxin/openGauss-server/src/test/subscription/results
init and start the database
testcase result time(s)
rep_changes .... ok 54
ddl_replication .... ok 658
pub_switchover .... ok 33
types .... ok 34
constraints .... ok 17
binary .... ok 26
diff_schema .... ok 22
generated .... ok 16
rewrite .... ok 16
sync .... ok 38
encoding .... ok 10
ddl .... ok 11
matviews .... ok 16
change_wal_level .... ok 22
skiplsn .... ok 27
disable .... ok 12
pub_subconflict .... ok 43
bugs .... ok 89
dump .... ok 31
stop the database
total testcase 19: 19 passed, 0 failed
total time: 1315s
make[3]: Leaving directory '/usr1/douxin/openGauss-server/tmp_build'
Built target check
make[2]: Leaving directory '/usr1/douxin/openGauss-server/tmp_build'
make[1]: Leaving directory '/usr1/douxin/openGauss-server/tmp_build'
cd /usr1/douxin/openGauss-server/tmp_build && make -f CMakeFiles/Makefile2 src/test/subscription/CMakeFiles/check.dir/rule
make[1]: Entering directory '/usr1/douxin/openGauss-server/tmp_build'
make[2]: Entering directory '/usr1/douxin/openGauss-server/tmp_build'
make[3]: Entering directory '/usr1/douxin/openGauss-server/tmp_build'
make[3]: Leaving directory '/usr1/douxin/openGauss-server/tmp_build'
make[3]: Entering directory '/usr1/douxin/openGauss-server/tmp_build'
removing /usr1/douxin/openGauss-server/src/test/subscription/tmp_check
removing /usr1/douxin/openGauss-server/src/test/subscription/results
init and start the database
testcase result time(s)
rep_changes .... ok 50
ddl_replication .... ok 465
pub_switchover .... ok 32
types .... ok 33
constraints .... ok 17
binary .... ok 26
diff_schema .... ok 21
generated .... ok 16
rewrite .... ok 16
sync .... ok 37
encoding .... ok 10
ddl .... ok 10
matviews .... ok 16
change_wal_level .... ok 22
skiplsn .... ok 27
disable .... ok 12
pub_subconflict .... ok 42
bugs .... ok 88
dump .... ok 30
stop the database
total testcase 19: 19 passed, 0 failed
total time: 1104s
make[3]: Leaving directory '/usr1/douxin/openGauss-server/tmp_build'
Built target check
make[2]: Leaving directory '/usr1/douxin/openGauss-server/tmp_build'
make[1]: Leaving directory '/usr1/douxin/openGauss-server/tmp_build'
[douxin@openGauss62 subscription]$ python -V
Python 3.7.9
[douxin@openGauss62 subscription]$ gaussdb -V
gaussdb (openGauss 7.0.0-RC3 build 57622f53) compiled at 2026-08-20 11:27:19 commit 1000 last mr 9389 debug on aarch64-unknown-linux-gnu, compiled by g++ (GCC) 10.3.1, 64-bit
[douxin@openGauss62 subscription]$
ywzq1161327784
8月26日 评论：
8月26日 评论：
2026.8.26自验，A/B/D库均自验ok，B库包含dolphin插件
[douxin@openGauss62 tmp_build]$ gsql -V
gsql (openGauss 7.0.0-RC3 build 4d60ae84) compiled at 2026-08-25 21:17:30 commit 1000 last mr 9389 debug on aarch64-unknown-linux-gnu, compiled by g++ (GCC) 10.3.1, 64-bit
[douxin@openGauss62 tmp_build]$
[douxin@openGauss62 tmp_build]$
[douxin@openGauss62 tmp_build]$ make check p=40500 dbcompatibility=D && make check p=40500 dbcompatibility=A
removing /usr1/douxin/openGauss-server/src/test/subscription/tmp_check
removing /usr1/douxin/openGauss-server/src/test/subscription/results
init and start the database
testcase result time(s)
rep_changes .... ok 52
ddl_replication .... ok 460
pub_switchover .... ok 24
types .... ok 33
constraints .... ok 17
binary .... ok 26
diff_schema .... ok 21
generated .... ok 16
rewrite .... ok 15
sync .... ok 37
encoding .... ok 9
ddl .... ok 11
matviews .... ok 15
change_wal_level .... ok 22
skiplsn .... ok 27
disable .... ok 12
pub_subconflict .... ok 41
bugs .... ok 94
dump .... ok 31
stop the database
total testcase 19: 19 passed, 0 failed
total time: 1098s
Built target check
removing /usr1/douxin/openGauss-server/src/test/subscription/tmp_check
removing /usr1/douxin/openGauss-server/src/test/subscription/results
init and start the database
testcase result time(s)
rep_changes .... ok 52
ddl_replication .... ok 502
pub_switchover .... ok 31
types .... ok 33
constraints .... ok 18
binary .... ok 26
diff_schema .... ok 22
generated .... ok 16
rewrite .... ok 16
sync .... ok 38
encoding .... ok 10
ddl .... ok 11
matviews .... ok 16
change_wal_level .... ok 22
skiplsn .... ok 27
disable .... ok 12
pub_subconflict .... ok 43
bugs .... ok 89
dump .... ok 31
stop the database
total testcase 19: 19 passed, 0 failed
total time: 1150s
Built target check
[douxin@openGauss62 tmp_build]$ python -V
Python 3.7.9
[douxin@openGauss62 tmp_build]$ gaussdb -V
[session-layout] sizeof(knl_session_context)=52816, sizeof(knl_session_attr)=44048, sizeof(knl_u_utils_context)=520, sizeof(knl_u_utils_guc_cold_context)=464, sizeof(knl_u_misc_context)=88, sizeof(knl_u_misc_path_cold_context)=2048, sizeof(knl_u_pgxc_context)=216, sizeof(knl_u_pgxc_addr_cold_context)=1280
[session-layout] offsetof(attr)=472, offsetof(proc_cxt)=47896, offsetof(utils_cxt)=50688, offsetof(opt_cxt)=46400, offsetof(pgxc_cxt)=46712, offsetof(SPI_cxt)=48232, offsetof(xact_cxt)=48120, offsetof(storage_cxt)=48960, offsetof(misc_cxt)=46312
gaussdb (openGauss 7.0.0-RC3 build 4d60ae84) compiled at 2026-08-25 21:17:30 commit 1000 last mr 9389 debug on aarch64-unknown-linux-gnu, compiled by g++ (GCC) 10.3.1, 64-bit
[douxin@openGauss62 tmp_build]$ make check p=40500 dbcompatibility=B
removing /usr1/douxin/openGauss-server/src/test/subscription/tmp_check
removing /usr1/douxin/openGauss-server/src/test/subscription/results
init and start the database
testcase result time(s)
rep_changes .... ok 83
ddl_replication .... ok 796
pub_switchover .... ok 54
types .... ok 67
constraints .... ok 36
binary .... ok 55
diff_schema .... ok 39
generated .... ok 36
rewrite .... ok 49
sync .... ok 55
encoding .... ok 28
ddl .... ok 31
matviews .... ok 37
change_wal_level .... ok 55
skiplsn .... ok 56
disable .... ok 33
pub_subconflict .... ok 60
bugs .... ok 116
dump .... ok 76
stop the database
total testcase 19: 19 passed, 0 failed
total time: 1929s
Built target check
其中B库注释了openGauss-server/src/test/subscription/testcase/ddl_replication_sql/B/ddl_alter_table.sql +2154行代码，该sql会产生core，已提单
https://gitcode.com/opengauss/openGauss-server/issues/8430
alter table t1 modify f1 text after f3, add f10 int default 10 after f2;
8月26日 issue状态由 已完成 改变为 待回归
sungang14
8月29日 评论：
8月29日 评论：
【回归人员】sungang14
【回归日期】2026.8.29
【回归版本】openGauss 7.0.0B019
【回归结论】通过
【回归步骤】
A/B/D库均自验ok，B库包含dolphin插件
8月29日 issue状态由 待回归 改变为 已验收
8月29日 关闭了 issue
测试类型
SQL功能
测试版本
7.0.0LTS
问题描述
D库发布订阅check用例失败
操作系统和硬件信息
不限
测试环境
企业版单机
被测功能
D库发布订阅check
预置条件
无
操作步骤
编译跑发布订阅check，指定兼容性D
预期输出
D库发布订阅check成功
实际输出
D库发布订阅check失败--ddl_replication用例
虽然下面显示失败，但对比日志和执行时间，看到明显失败
B库带dolphin插件--ddl_replication用例失败
日志信息
见实际输出
提单组织
内部开发
测试代码