【测试类型：接口功能】【测试版本：6.0.0】JDBC方式，不同类型调用greatest函数，产生core

【测试类型：接口功能】【测试版本：6.0.0】 JDBC方式执行测试用例，产生core

【操作系统和硬件信息】(查询命令: cat /etc/system-release, uname -a):Linux localhost.localdomain 4.19.90-24.4.v2101.ky10.aarch64 #1 SMP Mon May 24 14:45:37 CST 2021 aarch64 aarch64 aarch64 GNU/Linux

【测试环境】单机

【被测功能】:嵌套数组

【测试类型】:SQL功能

【数据库版本】：B025 openGauss 6.0.0 build eecf4e10 （B023版本也挂库）

【预置条件】:无

【操作步骤】(请填写详细的操作步骤):
1、构造测试用例，存储为.sql后缀文本文件：
select * FROM greatest (4);
select contain FROM greatest (4);
-- T_Float
select * FROM greatest (123.456);
-- T_BitString
select * FROM greatest(B'101');
select * FROM greatest(X'101');
-- T_String
select * FROM greatest ('sadf');
-- 没有意义，为了防止结果与预期不一致
drop table test;
create table test(a int);
select * from test;
drop table test;

2、使用Yat工具执行该测试用例，实例挂掉，core

3、使用gsql工具执行以上SQL，成功且结果正确，未挂库

4、Yat版本：Version project ':yat:setting'.version Build At 2024-03-06 16:51:36

5、JDBC版本：6.0.0 随B025发布

【预期输出】:

【实际输出】:

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

【日志信息】(请附上日志文件、截图、coredump信息):
coredump信息:
warning: Unable to find libthread_db matching inferior's thread library, thread debugging will not be available.
Core was generated by `/opt/ShenTongGS/app/bin/gaussdb -D /opt/ShenTongGS/data/db1'.
#0  0x0000aaabcfab55dc in sys_waitpid(int, int*, int) ()
[Current thread is 1 (LWP 3511964)]
(gdb) bt
#0  0x0000aaabcfab55dc in sys_waitpid(int, int*, int) ()
#1  0x0000aaabcfab69d8 in BBOX_GetClonePidResult(int, BBOX_ListParams*, int) ()
#2  0x0000aaabcfab6d18 in BBOX_GetAllThreads(GET_THREAD_TYPE, void (*)(void*), void*, int (*)(void (*)(void*), void*, int, int*, std::__va_list), ...)
    ()
#3  0x0000aaabcfaadb7c in BBOX_CreateCoredump ()
#4  0x0000aaabcfab8348 in ?? ()
#5  <signal handler called>
#6  0x0000aaabcf603628 in getCursorStreamFromFuncArg(FuncExpr*) ()
#7  0x0000aaabcfb3c838 in finalize_node_id(Plan*, int*, int*, int*, int*, int*, int*, int*, List*, List*, List**, int*, bool, bool, bool, bool, NodeGroupInfoContext*) ()
#8  0x0000aaabcfb1b3d0 in standard_planner(Query*, int, ParamListInfoData*) ()
#9  0x0000aaabcfb2ed00 in pgxc_planner(Query*, int, ParamListInfoData*) ()
#10 0x0000aaabcfb1bda4 in planner(Query*, int, ParamListInfoData*) ()
#11 0x0000aaabcfe1cd2c in pg_plan_query(Query*, int, ParamListInfoData*, bool) ()
#12 0x0000aaabcfe1ce54 in pg_plan_queries(List*, int, ParamListInfoData*) ()
#13 0x0000aaabcf8128fc in BuildCachedPlan(CachedPlanSource*, List*, ParamListInfoData*, bool) ()
#14 0x0000aaabcfd448fc in GetDefaultGenericPlan(CachedPlanSource*, ParamListInfoData*, List**, bool*) ()
#15 0x0000aaabcf815fd8 in GetWiseCachedPlan(CachedPlanSource*, ParamListInfoData*, bool) ()
#16 0x0000aaabcfe1f6b4 in ?? ()
#17 0x0000aaabcfe27a60 in PostgresMain(int, char**, char const*, char const*) ()
#18 0x0000aaabcfd7dc7c in ?? ()
#19 0x0000aaabcfdabed0 in int GaussDbThreadMain<(knl_thread_role)1>(knl_thread_arg*) ()
#20 0x0000aaabcfd7dd10 in ?? ()
#21 0x0000ffffa6cc87ac in ?? () from /usr/lib64/libpthread.so.0
#22 0x0000ffffa6c060fc in ?? () from /usr/lib64/libc.so.6

【测试代码】:

openGauss/openGauss-server

内容风险标识

评论 (4)

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

内容风险标识