【测试类型：SQL功能】【测试版本：5.1.1】【资源池化】开启spq，查询目标列包含函数group_concat，数据库coredump

【标题描述】:开启spq,查询目标列包含函数group_concat，数据库coredump
【测试类型：SQL功能】【测试版本：5.1.1】【资源池化】开启spq,查询目标列包含函数group_concat，数据库coredump
【操作系统和硬件信息】(查询命令: cat /etc/system-release, uname -a):
openEuler release 20.03 (LTS-SP3)
Linux openGauss117 4.19.90-2303.4.0.0193.oe1.aarch64 #1 SMP Wed Mar 22 03:04:16 UTC 2023 aarch64 aarch64 aarch64 GNU/Linux
【测试环境】(单机/1主x备x级联备):一主两备
【被测功能】:spq多机并行
【测试类型】:功能测试
【数据库版本】(查询命令: gaussdb -V):
gaussdb (openGauss 5.1.1 build 812682c6) compiled at 2023-11-01 00:08:56 commit 0 last mr
【预置条件】:
gs_guc set -N all -I all -c"shared_preload_libraries='security_plugin,spqplugin'"
spqplugin.cluster_map = 'xxx|xxx|xxx|xxx|xxx|xxx,...'
【操作步骤】(请填写详细的操作步骤):

--1.建表
drop table if exists students cascade;
create table students(
 id        serial primary key,
 name      varchar(20) not null,
 age       tinyint default 0,
 height    decimal(4,2),
 gender    char(10) default null,
 cls_id    int default 0,
 is_delete bit default '0'
);
copy students from '/home/sjdms/spqstudents.tbl' delimiter as ',';
--2.不开启spq，查询
explain select gender,group_concat(name) from students group by gender;
select gender,group_concat(name) from students group by gender;
--3.开启spq，查询
set spqplugin.enable_spq to on;
explain select gender,group_concat(name) from students group by gender;
select gender,group_concat(name) from students group by gender;

drop table if exists students cascade;
【预期输出】:开启spq与不开启spq查询表结果一致，执行成功
![输入图片说明](https://foruda.gitee.com/images/1699327662362891011/f04cf7a6_10840237.png "que.png")
【实际输出】:数据库core
![输入图片说明](https://foruda.gitee.com/images/1699327559966489663/5e585b79_10840237.png "corenew.png")
![输入图片说明](https://foruda.gitee.com/images/1699327606889601569/27302a76_10840237.png "asdf.png")
【原因分析】:
1. 这个问题的根因
2. 问题推断过程
3. 还有哪些原因可能造成类似现象
4. 该问题是否有临时规避措施
5. 问题解决方案
6. 预计修复问题时间

【日志信息】(请附上日志文件、截图、coredump信息):
```
#0  0x0000aaab9e71188c in sys_wait4 (ru=0x0, options=options@entry=1073741824, stat_addr=stat_addr@entry=0xffa195bc66ac, upid=upid@entry=1905853) at bbox_syscall_support.cpp:36
36      bbox_syscall_support.cpp: No such file or directory.
[Current thread is 1 (LWP 1901078)]
(gdb) bt
#0  0x0000aaab9e71188c in sys_wait4 (ru=0x0, options=options@entry=1073741824, stat_addr=stat_addr@entry=0xffa195bc66ac, upid=upid@entry=1905853) at bbox_syscall_support.cpp:36
#1  sys_waitpid (pid=pid@entry=1905853, status=status@entry=0xffa195bc66ac, options=options@entry=1073741824) at bbox_syscall_support.cpp:516
#2  0x0000aaab9e712c88 in BBOX_GetClonePidResult (iClonePid=iClonePid@entry=1905853, pstArgs=pstArgs@entry=0xffa195bc6730, iCloneErrno=iCloneErrno@entry=9) at bbox_threads.cpp:572
#3  0x0000aaab9e712fc8 in BBOX_GetAllThreads (enType=<optimized out>, pDone=pDone@entry=0xaaab9e709b70 <BBOX_FinishDumpFile(void*)>, pDoneArgs=pDoneArgs@entry=0xffa195bc6878,
    pCallback=<optimized out>) at bbox_threads.cpp:700
#4  0x0000aaab9e709e2c in BBOX_CreateCoredump (file_name=0xffa195bc69a8 "/home/core//core-gaussdb-2060587-2023_11_06_14_36_41-bbox.lz4", file_name@entry=0x0) at bbox_create.cpp:440
#5  0x0000aaab9e714934 in bbox_handler (sig=11, si=0xffa195bc6ee0, uc=<optimized out>) at gs_bbox.cpp:112
#6  bbox_handler (sig=11, si=0xffa195bc6ee0, uc=<optimized out>) at gs_bbox.cpp:102
#7  <signal handler called>
#8  0x0000fffe7f367a3c in ?? () from /usr/lib64/libc.so.6
#9  0x0000aaab9f2aff0c in memcpy_s ()
#10 0x0000aaab9e2f5cc4 in datumCopyInternal (value=281069427361016, typLen=<optimized out>, copySize=copySize@entry=0xffa195bc81a8, typByVal=false) at datum.cpp:122
#11 0x0000aaab9e2f5ec8 in datumCopyInternal (copySize=0xffa195bc81a8, typLen=<optimized out>, typByVal=<optimized out>, value=<optimized out>) at datum.cpp:117
#12 datumCopy (value=<optimized out>, typByVal=<optimized out>, typLen=<optimized out>) at datum.cpp:134
#13 0x0000aaab9eb46d7c in finalize_aggregate (aggstate=aggstate@entry=0xffa193cca050, peraggstate=peraggstate@entry=0xffa1943801c0,
    pergroupstate=pergroupstate@entry=0xffa193603648, resultVal=resultVal@entry=0xffa194380170, resultIsNull=resultIsNull@entry=0xffa194380198) at nodeAgg.cpp:1020
#14 0x0000aaab9eb471dc in finalize_aggregates (aggstate=aggstate@entry=0xffa193cca050, peragg=peragg@entry=0xffa1943801c0, pergroup=pergroup@entry=0xffa193603648,
    currentSet=currentSet@entry=0) at nodeAgg.cpp:1113
#15 0x0000aaab9eb47e10 in agg_retrieve_hash_table (aggstate=0xffa193cca050) at nodeAgg.cpp:2173
#16 agg_retrieve (node=0xffa193cca050) at nodeAgg.cpp:1489
#17 ExecAgg (state=0xffa193cca050) at nodeAgg.cpp:1552
#18 0x0000aaab9eafcf34 in ExecProcNode (node=0xffa193cca050) at ../../../../src/include/executor/executor.h:279
#19 ExecutePlan (motJitContext=0x0, dest=0xffa193cc2410, direction=<optimized out>, numberTuples=0, sendTuples=true, operation=CMD_SELECT, planstate=0xffa193cca050,
    estate=0xffa193cc8050) at execMain.cpp:2251
#20 standard_ExecutorRun (queryDesc=0xffa193ec4050, direction=<optimized out>, count=0) at execMain.cpp:653
#21 0x0000aaab9eafd15c in ExecutorRun (queryDesc=queryDesc@entry=0xffa193ec4050, direction=direction@entry=ForwardScanDirection, count=count@entry=0) at execMain.cpp:505
#22 0x0000aaab9ea7f260 in PortalRunSelect (portal=portal@entry=0xffa193cc4050, forward=forward@entry=true, count=0, count@entry=9223372036854775807, dest=dest@entry=0xffa193cc2410)
    at pquery.cpp:1425
#23 0x0000aaab9ea80eb0 in PortalRun (portal=portal@entry=0xffa193cc4050, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0xffa193cc2410,
    altdest=altdest@entry=0xffa193cc2410, completionTag=completionTag@entry=0xffa195bc8c68 "") at pquery.cpp:1159
#24 0x0000aaab9eac120c in execute_stream_plan (producer=0xffa196a57850) at streamMain.cpp:520
#25 StreamMain () at streamMain.cpp:146
#26 0x0000aaab9e9fd6c0 in GaussDbThreadMain<(knl_thread_role)6> (arg=<optimized out>) at postmaster.cpp:11761
#27 0x0000aaab9e9cfa14 in InternalThreadFunc (args=<optimized out>) at postmaster.cpp:14560
#28 0x0000fffe7f46878c in ?? () from /usr/lib64/libpthread.so.0
#29 0x0000fffe7f3b510c in ?? () from /usr/lib64/libc.so.6
```
【测试代码】:无

openGauss/openGauss-server

内容风险标识

评论 (3)

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

内容风险标识