已关闭
[Bug]: B库和D库发布订阅check用例失败--dump #8407
ywzq1161327784创建于 8月18日关闭于 19 天前
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日 修改标题为 “[Bug]: B库和D库发布订阅check用例失败--dump”，原标题为“[Bug]: D库发布订阅check用例失败--dump”
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
29 天前 issue状态由 待办的 改变为 已完成
ywzq1161327784
29 天前 评论：
29 天前 评论：
cmake编译，A/B/D库发布订阅check均ok
[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
29 天前 issue状态由 已完成 改变为 待回归
29 天前 issue状态由 待回归 改变为 已完成
ywzq1161327784
22 天前 评论：
22 天前 评论：
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;
22 天前 issue状态由 已完成 改变为 待回归
sungang14
20 天前 评论：
20 天前 评论：
【回归人员】sungang14
【回归日期】2026.8.29
【回归版本】openGauss 7.0.0B019
【回归结论】通过
【回归步骤】
A/B/D库均自验ok，B库包含dolphin插件
19 天前 issue状态由 待回归 改变为 已验收
19 天前 关闭了 issue
测试类型
SQL功能
测试版本
7.0.0LTS
问题描述
D库发布订阅check用例失败
操作系统和硬件信息
不限
测试环境
企业版单机
被测功能
D库发布订阅check
预置条件
无
操作步骤
编译跑发布订阅check，指定兼容性D
预期输出
D库发布订阅check成功
实际输出
D库发布订阅check失败
失败原因：d库默认值d_format_behavior_compat_options=''修改为'enable_sbr_identifier,default_collation'默认值，增加默认值default_collation导致encoding和dump用例失败
B库也有类似的问题
日志信息
见实际输出
提单组织
内部开发
测试代码