【测试类型：功能】【测试版本：3.0.0】release版本编译安装数据库，且dblink模块编译安装后，create extension dblink导致数据库core

【标题描述】:
【测试类型：SQL功能】【测试版本：3.0.0】release版本编译安装数据库，且dblink模块编译安装后，create extension dblink导致数据库core

【操作系统和硬件信息】(查询命令: cat /etc/system-release, uname -a):
CentOS Linux release 7.6.1810 (Core)
Linux kwemhisprc01300 3.10.0-957.el7.x86_64 #1 SMP Thu Nov 8 23:39:32 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux
【测试环境】(单机/1主x备x级联备):单机

【被测功能】:编译安装方式，追加dblink扩展

【测试类型】:功能测试

【数据库版本】(查询命令: gaussdb –V):
 gaussdb (GaussDB Kernel V500R002C00 build ) compiled at 2022-01-26 14:29:35 commit 0 last mr

【预置条件】:
 新建用户、下载源码包、三方包
 openGauss-server-master.zip
 openGauss-third_party_binarylibs.tar.gz

【操作步骤】(请填写详细的操作步骤):
--step1:编译安装数据库
- unzip openGauss-server-master.zip
- tar -zxvf openGauss-third_party_binarylibs.tar.gz
- 配置环境变量，并source
- cd /.../openGauss-server-master
- ./configure --gcc-version=7.3.0 CC=g++ CFLAGS="-O2 -g3" --prefix=$GAUSSHOME --3rd=$BINARYLIBS --enable-thread-safety --without-readline --without-zlib
- make
- make install
- gs_initdb -D /.../dest/dn1 -U user -E UTF-8 --nodename='dn1'
- gs_guc set -D /.../dest/dn1  -c "port = 35001"

--step2:编译安装dblink
- cd /..../contrib/dblink/
- make 
- make install

--step3：启动、连接数据库，进行加载dblink扩展
- gs_ctl start -D /.../dest/dn1 -Z single_node
- gsql -r postgres -p 35001
- create extension dblink;

【预期输出】:
--step1:成功
--step2:成功
--step3:成功

【实际输出】:
--step1:成功
--step2:成功
--step3:报错：The connection to the server was lost. Attempting reset: Failed.

【原因分析】:
1. 这个问题的根因
2. 问题推断过程
3. 还有哪些原因可能造成类似现象
4. 该问题是否有临时规避措施
5. 问题解决方案
6. 预计修复问题时间

【日志信息】(请附上日志文件、截图、coredump信息):
![输入图片说明](https://images.gitee.com/uploads/images/2022/0127/174710_5309c421_10357626.png "屏报错截图.png")
![输入图片说明](https://images.gitee.com/uploads/images/2022/0127/174853_31d6e39c_10357626.png "屏幕截图.png")
#0  BBOX_CreateCoredump (file_name=file_name@entry=0x0) at bbox_create.cpp:404
#1  0x0000562c628f8fdf in bbox_handler (sig=<optimized out>, si=0x7fa9efccb0b0, uc=0x7fa9efccaf80) at gs_bbox.cpp:123
#2  <signal handler called>
#3  repallocDebug (pointer=0x0, size=size@entry=16, file=file@entry=0x562c674c05c7 "extension.cpp", line=line@entry=2911) at mcxt.cpp:1282
#4  0x0000562c62a812bb in RepallocSessionVarsArrayIfNecessary () at extension.cpp:2910
#5  0x00007fa9ea3f829e in init_session_vars () at dblink.cpp:229
#6  0x0000562c626bfd9a in internal_load_library (libname=libname@entry=0x7fa9edc0a730 "/data/lixin/20220125/pkg/openGauss-server-master/src/dest/lib/postgresql/dblink.so")
    at dfmgr.cpp:326
#7  0x0000562c626c0cf2 in load_external_function (filename=<optimized out>, funcname=funcname@entry=0x7fa9edc096c0 "dblink_connect", signalNotFound=signalNotFound@entry=true,
    isValidate=isValidate@entry=true) at dfmgr.cpp:109
#8  0x0000562c622e3d7a in fmgr_c_validator (fcinfo=<optimized out>) at pg_proc.cpp:1764
#9  0x0000562c626c6290 in OidFunctionCall3Coll (functionId=functionId@entry=2247, collation=collation@entry=0, arg1=arg1@entry=49157, arg2=arg2@entry=0, arg3=arg3@entry=0)
    at fmgr.cpp:1857
#10 0x0000562c622e78d2 in ProcedureCreate (procedureName=0x7fa9ee971a50 "dblink_connect", procNamespace=procNamespace@entry=2200, propackageid=propackageid@entry=0,
    isOraStyle=<optimized out>, replace=false, returnsSet=returnsSet@entry=false, returnType=25, proowner=10, languageObjectId=13, languageValidator=2247,
    prosrc=0x7fa9edbee910 "dblink_connect", probin=<optimized out>, isAgg=false, isWindowFunc=false, security_definer=false, isLeakProof=false, isStrict=true, volatility=118 'v',
    parameterTypes=0x7fa9edc09200, allParameterTypes=0, parameterModes=0, parameterNames=0, parameterDefaults=0x0, proconfig=0, procost=procost@entry=1, prorows=prorows@entry=0,
    prodefaultargpos=0x0, fenced=false, shippable=false, package=<optimized out>, proIsProcedure=false, proargsrc=0x0, isPrivate=false) at pg_proc.cpp:1665
#11 0x0000562c62a8a9ff in CreateFunction (stmt=stmt@entry=0x7fa9ee971bd8, queryString=queryString@entry=0x562c64e5182b " ", pkg_oid=pkg_oid@entry=0) at functioncmds.cpp:1125
#12 0x0000562c62c3f8fe in standard_ProcessUtility (parse_tree=parse_tree@entry=0x7fa9ee971bd8, query_string=query_string@entry=0x562c64e5182b " ", params=params@entry=0x0,
    is_top_level=<optimized out>, dest=dest@entry=0x7fa9ee10a1f0, sent_to_remote=<optimized out>, completion_tag=0x0, isCTAS=false) at utility.cpp:4653
#13 0x00007faa54358f11 in gsaudit_ProcessUtility_hook (parsetree=0x7fa9ee971bd8, queryString=0x562c64e5182b " ", params=0x0, isTopLevel=<optimized out>, dest=0x7fa9ee10a1f0,
    sentToRemote=<optimized out>, completionTag=0x0, isCTAS=false) at gs_policy_plugin.cpp:1062
#14 0x0000562c62c4d9ec in pgaudit_ProcessUtility (parsetree=0x7fa9ee971bd8, queryString=0x562c64e5182b " ", params=<optimized out>, isTopLevel=<optimized out>, dest=<optimized out>,
    sentToRemote=<optimized out>, completionTag=0x0, isCTAS=false) at auditfuncs.cpp:1198
#15 0x0000562c62a7ad58 in execute_sql_string (filename=<optimized out>, sql=<optimized out>) at extension.cpp:758
#16 execute_extension_script (extensionOid=extensionOid@entry=49156, control=control@entry=0x7fa9ee971b88, from_version=from_version@entry=0x0,
    version=version@entry=0x7fa9ee971cb8 "1.0", requiredSchemas=requiredSchemas@entry=0x0, schemaName=schemaName@entry=0x7fa9ee971b70 "public", schemaOid=2200) at extension.cpp:903
#17 0x0000562c62a7c931 in CreateExtension (stmt=stmt@entry=0x7fa9edb28ab0) at extension.cpp:1438
#18 0x0000562c62c4297e in standard_ProcessUtility (parse_tree=parse_tree@entry=0x7fa9edb28ab0, query_string=query_string@entry=0x7fa9edb28040 "create extension dblink;",
    params=params@entry=0x0, is_top_level=<optimized out>, dest=dest@entry=0x7fa9edb28b30, sent_to_remote=<optimized out>, completion_tag=0x7fa9efcd1ac0 "", isCTAS=false)
    at utility.cpp:2976
#19 0x00007faa54358f11 in gsaudit_ProcessUtility_hook (parsetree=0x7fa9edb28ab0, queryString=0x7fa9edb28040 "create extension dblink;", params=0x0, isTopLevel=<optimized out>,
    dest=0x7fa9edb28b30, sentToRemote=<optimized out>, completionTag=0x7fa9efcd1ac0 "", isCTAS=false) at gs_policy_plugin.cpp:1062
#20 0x0000562c62c4d9ec in pgaudit_ProcessUtility (parsetree=0x7fa9edb28ab0, queryString=0x7fa9edb28040 "create extension dblink;", params=<optimized out>, isTopLevel=<optimized out>,
    dest=<optimized out>, sentToRemote=<optimized out>, completionTag=0x7fa9efcd1ac0 "", isCTAS=false) at auditfuncs.cpp:1198
#21 0x0000562c62c31d35 in PortalRunUtility (portal=portal@entry=0x7fa9edbf8040, utilityStmt=utilityStmt@entry=0x7fa9edb28ab0, isTopLevel=isTopLevel@entry=true,
    dest=dest@entry=0x7fa9edb28b30, completionTag=completionTag@entry=0x7fa9efcd1ac0 "") at pquery.cpp:1758
#22 0x0000562c62c32c0c in PortalRunMulti (portal=portal@entry=0x7fa9edbf8040, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x7fa9edb28b30, altdest=altdest@entry=0x7fa9edb28b30,
    completionTag=completionTag@entry=0x7fa9efcd1ac0 "") at pquery.cpp:1937
#23 0x0000562c62c356c8 in PortalRun (portal=portal@entry=0x7fa9edbf8040, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x7fa9edb28b30,
    altdest=altdest@entry=0x7fa9edb28b30, completionTag=completionTag@entry=0x7fa9efcd1ac0 "") at pquery.cpp:1183
#24 0x0000562c62c2a034 in exec_simple_query (query_string=<optimized out>, query_string@entry=0x7fa9edb28040 "create extension dblink;", msg=msg@entry=0x7fa9efcd1c50,
    messageType=QUERY_MESSAGE) at postgres.cpp:2702
#25 0x0000562c62c2dd33 in PostgresMain (argc=<optimized out>, argv=argv@entry=0x7fa9ee281918, dbname=<optimized out>, username=<optimized out>) at postgres.cpp:8325
#26 0x0000562c62ba3175 in BackendRun (port=port@entry=0x7fa9efcd21f0) at postmaster.cpp:7732
#27 0x0000562c62bc0498 in GaussDbThreadMain<(knl_thread_role)1> (arg=0x7faa35172d28) at postmaster.cpp:11599
#28 0x0000562c62ba31d5 in InternalThreadFunc (args=<optimized out>) at postmaster.cpp:12156
#29 0x00007faa5e8ceea5 in start_thread () from /lib64/libpthread.so.0
#30 0x00007faa5e5f7b0d in clone () from /lib64/libc.so.6

【测试代码】:

openGauss/openGauss-server

内容风险标识

评论 (6)

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

内容风险标识