【测试类型：SQL功能】【测试版本：5.1.1】初始用户/sysadmin用户连接数据库使用pg_prepared_statement查询产生core文件，数据库宕

【标题描述】:
【测试类型：SQL功能】【测试版本：5.1.1】 初始用户/sysadmin用户连接数据库使用pg_prepared_statement查询产生core文件，数据库宕

【操作系统和硬件信息】(查询命令: cat /etc/system-release, uname -a):
CentOS Linux release 7.6.1908 (Core)
Linux kwemhisprc01300 3.10.0-1062.el7.x86_64 #1 SMP Wed Aug 7 18:08:02 UTC 2019 x86_64 x86_64 x86_64 GNU/Linux

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

【被测功能】:PG_PREPARED_STATEMENT函数查询

【测试类型】:功能测试

【数据库版本】(查询命令: gaussdb -V):gsql ((openGauss 5.1.1 build 45f6613a) compiled at 2023-11-29 09:41:17 commit 0 last mr  )

【预置条件】:数据库正常运行

【操作步骤】(请填写详细的操作步骤):
1.建表
drop table if exists t_prepare_20;
create table t_prepare_20(c1 int, c2 text);
2.新建session1，创建预备语句
prepare stmt1 as insert into t_prepare_20 values(1, 'openGauss');
3.新建session2，创建预备语句
prepare stmt2 as insert into t_prepare_20 values(1, 'openGauss');
4.使用初始用户连接数据库，查询视图
select * from pg_prepared_statement(0) order by 1, 2;

【预期输出】:
1.执行成功
2.执行成功
3.执行成功
4.查询成功，可查询到stmt1、stmt2

【实际输出】:
1.执行成功
2.执行成功
3.执行成功
4.产生core文件，数据库宕
![输入图片说明](https://foruda.gitee.com/images/1701742122539418897/c3fabfb8_8772917.png "屏幕截图")
![输入图片说明](https://foruda.gitee.com/images/1701742057349836337/6953cc0a_8772917.png "屏幕截图")

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

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

```
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib64/libthread_db.so.1".
Core was generated by `/data3/nyl/nyl_1179/cluster/app/bin/gaussdb -D /data3/nyl/nyl_1179/cluster/dn1'.
#0  BBOX_CreateCoredump (file_name=file_name@entry=0x0) at bbox_create.cpp:404
404     bbox_create.cpp: No such file or directory.
Missing separate debuginfos, use: debuginfo-install glibc-2.17-326.el7_9.x86_64 keyutils-libs-1.5.8-3.el7.x86_64 krb5-libs-1.15.1-37.el              7_6.x86_64 libaio-0.3.109-13.el7.x86_64 libcom_err-1.42.9-16.el7.x86_64 libselinux-2.5-14.1.el7.x86_64 ncurses-libs-5.9-14.20130511.el7              _4.x86_64 nss-softokn-freebl-3.44.0-5.el7.x86_64 openssl-libs-1.0.2k-19.el7.x86_64
(gdb) bt
#0  BBOX_CreateCoredump (file_name=file_name@entry=0x0) at bbox_create.cpp:404
#1  0x0000564b8c2da5a2 in bbox_handler (sig=<optimized out>, si=0x7efb3c094ef0, uc=0x7efb3c094dc0) at gs_bbox.cpp:112
#2  bbox_handler (sig=<optimized out>, si=0x7efb3c094ef0, uc=0x7efb3c094dc0) at gs_bbox.cpp:102
#3  <signal handler called>
#4  hash_seq_search (status=status@entry=0x7efb3c095b00) at dynahash.cpp:1130
#5  0x0000564b8c4ad3f4 in GetPreparedStatements (htbl=htbl@entry=0x7efb554d8050, tupStore=tupStore@entry=0x7efb56abd6f0,
    tupDesc=tupDesc@entry=0x7efb56abd2d0, sessionId=139617509369600, userName=userName@entry=0x7efb55552050 "nyl_1179")
    at prepare.cpp:1632
#6  0x0000564b8c4ad79b in GetThreadPreparedStatements (tupStore=tupStore@entry=0x7efb56abd6f0, tupDesc=tupDesc@entry=0x7efb56abd2d0,
    sessionId=sessionId@entry=0) at prepare.cpp:1672
#7  0x0000564b8c4adb2f in pg_prepared_statement_global (fcinfo=<optimized out>) at prepare.cpp:1614
#8  0x0000564b8c7394ed in ExecMakeTableFunctionResult (funcexpr=0x7efb56abc978, econtext=<optimized out>,
    expectedDesc=<optimized out>, randomAccess=<optimized out>, node=node@entry=0x7efb55550050) at execQual.cpp:3275
#9  0x0000564b8c798bde in FunctionNext (node=0x7efb55550050) at nodeFunctionscan.cpp:63
#10 0x0000564b8c71bdbe in ExecProcNode (node=0x7efb55550050) at ../../../../src/include/executor/executor.h:279
#11 ExecutePlan (motJitContext=<optimized out>, dest=<optimized out>, direction=<optimized out>, numberTuples=<optimized out>,
    sendTuples=<optimized out>, operation=<optimized out>, planstate=0x7efb55550050, estate=0x7efb554de050) at execMain.cpp:2251
#12 standard_ExecutorRun (queryDesc=0x7efb569e5c50, direction=<optimized out>, count=<optimized out>) at execMain.cpp:653
#13 0x0000564b8c580065 in explain_ExecutorRun (queryDesc=<optimized out>, direction=<optimized out>, count=<optimized out>)
    at auto_explain.cpp:122
#14 0x0000564b8c71bf2d in ExecutorRun(QueryDesc*, ScanDirection, long) () at execMain.cpp:503
#15 0x0000564b8c6921d6 in PortalRunSelect (portal=portal@entry=0x7efb41866050, forward=forward@entry=true, count=0,
    count@entry=9223372036854775807, dest=dest@entry=0x7efb56acd1c0) at pquery.cpp:1425
#16 0x0000564b8c6942b5 in PortalRun(PortalData*, long, bool, _DestReceiver*, _DestReceiver*, char*) () at pquery.cpp:1159
#17 0x0000564b8c68342c in exec_simple_query(char const*, MessageType, StringInfoData*) () at postgres.cpp:3000
#18 0x0000564b8c68801e in PostgresMain(int, char**, char const*, char const*) () at postgres.cpp:9101
#19 0x0000564b8c5d85f1 in BackendRun (port=port@entry=0x7efb3c0980e0) at postmaster.cpp:9443
#20 0x0000564b8c607ad8 in GaussDbThreadMain<(knl_thread_role)1> (arg=0x7efb99098a60) at postmaster.cpp:11786
#21 0x0000564b8c5d8675 in InternalThreadFunc (args=<optimized out>) at postmaster.cpp:14585
#22 0x00007efc66e0fea5 in start_thread () from /lib64/libpthread.so.0
#23 0x00007efc66b38b0d in clone () from /lib64/libc.so.6
```

【测试代码】:

openGauss/openGauss-server

内容风险标识

评论 (5)

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

内容风险标识