【测试类型：SQL功能】【测试版本：6.0.0】【自动化】备机连接兼容B库，备机core

【标题描述】: 备机连接兼容B库，备机core
【测试类型：SQL功能】【测试版本：6.0.0】【自动化】 备机连接兼容B库，备机core

【操作系统和硬件信息】(查询命令: cat /etc/system-release, uname -a):
CentOS Linux release 7.6.1810 (Core)

【测试环境】(单机/1主x备x级联备):
一主两备

【被测功能】:
备机连接兼容B库

【测试类型】:
功能测试

【数据库版本】(查询命令: gaussdb -V):
gaussdb (openGauss 6.0.0 build b061d510) compiled at 2024-06-12 10:07:05 commit 0 last mr

【预置条件】:
一主两备数据库正常

【操作步骤】(请填写详细的操作步骤):
1. 主机创建兼容B库
create database test_b dbcompatibility 'B';
2. 备机进行连接
 \c test_b

【预期输出】:
1. 主机创建兼容B库，成功
2. 备机进行连接成功

【实际输出】:
1. 主机创建兼容B库，成功
2. 备机进行连接异常core
![输入图片说明](https://foruda.gitee.com/images/1718853051740507863/8a575d2a_8568116.png "屏幕截图")

【原因分析】:
1. 备机写转发功能优化引起

【日志信息】(请附上日志文件、截图、coredump信息):

```
(gdb) bt
#0  0x0000aaae5b9fb35c in sys_wait4 (ru=0x0, options=options@entry=1073741824, stat_addr=stat_addr@entry=0xfffb363c159c, upid=upid@entry=3405183) at bbox_syscall_support.cpp:36
#1  sys_waitpid (pid=pid@entry=3405183, status=status@entry=0xfffb363c159c, options=options@entry=1073741824) at bbox_syscall_support.cpp:516
#2  0x0000aaae5b9fc758 in BBOX_GetClonePidResult (iClonePid=iClonePid@entry=3405183, pstArgs=pstArgs@entry=0xfffb363c1620, iCloneErrno=iCloneErrno@entry=9) at bbox_threads.cpp:572
#3  0x0000aaae5b9fca98 in BBOX_GetAllThreads (enType=<optimized out>, pDone=pDone@entry=0xaaae5b9f3640 <BBOX_FinishDumpFile(void*)>, pDoneArgs=pDoneArgs@entry=0xfffb363c1768, pCallback=<optimized out>) at bbox_threads.cpp:700
#4  0x0000aaae5b9f38fc in BBOX_CreateCoredump (file_name=0xfffb363c1898 "/core/corefile//core-gaussdb-3388767-2024_06_19_11_29_33-bbox.lz4", file_name@entry=0x0) at bbox_create.cpp:440
#5  0x0000aaae5b9fe0c8 in bbox_handler (sig=<optimized out>, si=<optimized out>, uc=<optimized out>) at gs_bbox.cpp:116
#6  bbox_handler (sig=<optimized out>, si=<optimized out>, uc=<optimized out>) at gs_bbox.cpp:103
#7  <signal handler called>
#8  RedirectManager::get_remote_excute (this=0x0) at ../../../../src/include/replication/libpqsw.h:286
#9  libpqsw_skip_check_readonly () at libpqsw.cpp:574
#10 0x0000fffb31f955ec in check_xact_readonly (parse_tree=0xfffb32ed8d30) at plugin_utility.cpp:446
#11 standard_ProcessUtility (processutility_cxt=processutility_cxt@entry=0xfffb363c5fb8, dest=dest@entry=0xfffb32ed8e00, sent_to_remote=sent_to_remote@entry=false, completion_tag=completion_tag@entry=0xfffb363c5fb8 "",
    context=context@entry=PROCESS_UTILITY_TOPLEVEL, isCTAS=isCTAS@entry=false) at plugin_utility.cpp:2660
#12 0x0000aaae5bd7f284 in standard_ProcessUtility (processutility_cxt=processutility_cxt@entry=0xfffb363c5fb8, dest=0xfffb32ed8e00, dest@entry=0x1, sent_to_remote=false, sent_to_remote@entry=251, completion_tag=0xfffb363c5fb8 "",
    completion_tag@entry=0x0, context=context@entry=PROCESS_UTILITY_TOPLEVEL, isCTAS=false) at utility.cpp:2567
#13 0x0000fffcda0a85a8 in gsaudit_ProcessUtility_hook (processutility_cxt=0xfffb363c5fb8, dest=0x1, sentToRemote=251, completionTag=0x0, context=PROCESS_UTILITY_TOPLEVEL, isCTAS=<optimized out>) at gs_policy_plugin.cpp:819
#14 0x0000aaae5bd873ec in pgaudit_ProcessUtility (processutility_cxt=0xfffb363c5ac8, dest=<optimized out>, sentToRemote=<optimized out>, completionTag=<optimized out>, context=<optimized out>, isCTAS=<optimized out>)
    at auditfuncs.cpp:1419
#15 0x0000aaae5bd82950 in ProcessUtility (processutility_cxt=processutility_cxt@entry=0xfffb363c5ac8, dest=dest@entry=0xfffb32ed8e00, sent_to_remote=sent_to_remote@entry=false, completion_tag=completion_tag@entry=0xfffb363c5fb8 "",
    context=context@entry=PROCESS_UTILITY_TOPLEVEL, isCTAS=isCTAS@entry=false) at utility.cpp:1565
#16 0x0000aaae5bd74c98 in PortalRunUtility (portal=portal@entry=0xfffb33220050, utilityStmt=utilityStmt@entry=0xfffb32ed8d30, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0xfffb32ed8e00,
    completionTag=completionTag@entry=0xfffb363c5fb8 "") at pquery.cpp:1740
#17 0x0000aaae5bd77ae4 in PortalRunMulti (portal=portal@entry=0xfffb33220050, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0xfffb32ed8e00, altdest=altdest@entry=0xfffb32ed8e00,
    completionTag=completionTag@entry=0xfffb363c5fb8 "") at pquery.cpp:1919
#18 0x0000aaae5bd78fd8 in PortalRun (portal=portal@entry=0xfffb33220050, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0xfffb32ed8e00, altdest=altdest@entry=0xfffb32ed8e00,
    completionTag=completionTag@entry=0xfffb363c5fb8 "") at pquery.cpp:1188
#19 0x0000aaae5bd67bb4 in exec_simple_query (
    query_string=query_string@entry=0xfffb32ed8050 "SET connection_info = '{\"driver_name\":\"libpq\",\"driver_version\":\"(openGauss 6.0.0 build b061d510) compiled at 2024-06-12 11:36:06 commit 0 last mr  \"}'",
    messageType=messageType@entry=QUERY_MESSAGE, msg=msg@entry=0xfffb363c7ec8) at postgres.cpp:3095
#20 0x0000aaae5bd6c714 in PostgresMain (argc=<optimized out>, argv=argv@entry=0xfffb344a1f68, dbname=<optimized out>, username=<optimized out>) at postgres.cpp:9229
#21 0x0000aaae5bcc4cdc in BackendRun (port=port@entry=0xfffb363c7c18) at postmaster.cpp:9650
#22 0x0000aaae5bcf25a0 in GaussDbThreadMain<(knl_thread_role)1> (arg=<optimized out>) at postmaster.cpp:12024
#23 0x0000aaae5bcc4d70 in InternalThreadFunc (args=<optimized out>) at postmaster.cpp:14881
#24 0x0000fffcda3788cc in ?? () from /lib64/libpthread.so.0
#25 0x0000fffcda2b954c in ?? () from /lib64/libc.so.6
(gdb) quit
```

【测试代码】:

openGauss/Plugin

内容风险标识

评论 (5)

openGauss/Plugin .gitee-modal { width: 500px !important; }

内容风险标识