跨事务游标FETCH数据导致宕机

【标题描述】:开启线程池和GlobalSysCache的情况下，跨事务游标FETCH数据宕机
【测试类型：SQL功能/存储功能/接口功能/工具功能/性能/并发/压力长稳/故障注入/安全/资料/编码规范】SQL功能
【测试版本：x.x.x】 6.0.0

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

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

【被测功能】:跨事务游标（WITH HOLD）

【测试类型】:SQL功能

【数据库版本】(查询命令: gaussdb -V):6.0.0

【预置条件】:开启线程池和GlobalSysCache

【操作步骤】(请填写详细的操作步骤):
```sql
create table t(c1 int, c2 text, c3 text);
insert into t values (generate_series(1,10000), md5(random()::text), md5(random()::text));
set work_mem = '64kB';
declare cur_sdx_32360_10 no scroll binary cursor with hold for select * from t;
fetch forward 2 from cur_sdx_32360_10;
move forward 1 in cur_sdx_32360_10;
close cur_sdx_32360_10;
```

【预期输出】:

【实际输出】:

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

【日志信息】(请附上日志文件、截图、coredump信息):
```bash
(gdb) bt
#0  BBOX_CreateCoredump (file_name=file_name@entry=0x0) at bbox_create.cpp:404
#1  0x0000560d1fddab11 in bbox_handler (sig=<optimized out>, si=<optimized out>, uc=<optimized out>) at gs_bbox.cpp:116
#2  <signal handler called>
#3  0x0000560d2088987b in Delete (file=file@entry=2) at fd.cpp:954
#4  0x0000560d2088d465 in FileAccess (file=2) at fd.cpp:1197
#5  0x0000560d20893896 in FilePWrite (file=2, buffer=0x7f2672d078b0 "0f2986093b8561c4P", amount=5376, offset=794624, wait_event_info=wait_event_info@entry=167772161, fastExtendSize=fastExtendSize@entry=0) at fd.cpp:2222
#6  0x0000560d20894052 in BufFileDumpBuffer (file=file@entry=0x7f2672d07850) at buffile.cpp:517
#7  0x0000560d20894231 in BufFileFlush (file=file@entry=0x7f2672d07850) at buffile.cpp:666
#8  0x0000560d2089505f in BufFileFlush (file=0x7f2672d07850) at buffile.cpp:714
#9  BufFileSeek (file=0x7f2672d07850, fileno=<optimized out>, offset=<optimized out>, whence=whence@entry=0) at buffile.cpp:734
#10 0x0000560d1fbf171d in tuplestore_gettuple (state=0x7f2661af0050, forward=<optimized out>, should_free=0x7f2685d166df) at tuplestore.cpp:1047
#11 0x0000560d1fbf21e2 in tuplestore_gettupleslot (state=<optimized out>, forward=forward@entry=true, copy=copy@entry=false, slot=slot@entry=0x7f266bd81418) at tuplestore.cpp:1145
#12 0x0000560d2019f4dd in RunFromStore (portal=portal@entry=0x7f266473e270, direction=direction@entry=ForwardScanDirection, count=count@entry=2, dest=dest@entry=0x7f267aba2498) at pquery.cpp:1586
#13 0x0000560d201a17e1 in PortalRunSelect (portal=portal@entry=0x7f266473e270, forward=<optimized out>, count=2, dest=0x7f267aba2498) at pquery.cpp:1392
#14 0x0000560d201a1adc in DoPortalRunFetch (portal=portal@entry=0x7f266473e270, fdirection=<optimized out>, fdirection@entry=FETCH_FORWARD, count=<optimized out>, count@entry=2, dest=dest@entry=0x7f267aba2498)
    at pquery.cpp:2289
#15 0x0000560d201a32da in PortalRunFetch (portal=portal@entry=0x7f266473e270, fdirection=FETCH_FORWARD, count=2, dest=dest@entry=0x7f267aba2498) at pquery.cpp:2051
#16 0x0000560d1ffa6904 in PerformPortalFetch (stmt=stmt@entry=0x7f267ac60b18, dest=dest@entry=0x7f267aba2498, completionTag=completionTag@entry=0x7f2685d18a90 "") at portalcmds.cpp:199
#17 0x0000560d201ac61d in standard_ProcessUtility (processutility_cxt=processutility_cxt@entry=0x7f2685d18a20, dest=dest@entry=0x7f267aba2498, sent_to_remote=<optimized out>,
    completion_tag=completion_tag@entry=0x7f2685d18a90 "", context=context@entry=PROCESS_UTILITY_TOPLEVEL, isCTAS=<optimized out>) at utility.cpp:3031
#18 0x00007f27be460f81 in gsaudit_ProcessUtility_hook (processutility_cxt=0x7f2685d18a20, dest=0x7f267aba2498, sentToRemote=<optimized out>, completionTag=0x7f2685d18a90 "", context=PROCESS_UTILITY_TOPLEVEL,
    isCTAS=<optimized out>) at gs_policy_plugin.cpp:819
#19 0x0000560d201b1f2f in pgaudit_ProcessUtility (processutility_cxt=0x7f2685d18a20, dest=<optimized out>, sentToRemote=<optimized out>, completionTag=<optimized out>, context=<optimized out>, isCTAS=<optimized out>)
    at auditfuncs.cpp:1419
#20 0x0000560d201b04c5 in ProcessUtility (processutility_cxt=processutility_cxt@entry=0x7f2685d18a20, dest=dest@entry=0x7f267aba2498, sent_to_remote=sent_to_remote@entry=false,
    completion_tag=completion_tag@entry=0x7f2685d18a90 "", context=context@entry=PROCESS_UTILITY_TOPLEVEL, isCTAS=isCTAS@entry=false) at utility.cpp:1586
#21 0x0000560d2019f395 in PortalRunUtility (portal=portal@entry=0x7f266473e050, utilityStmt=0x7f267ac60b18, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x7f267aba2498,
    completionTag=completionTag@entry=0x7f2685d18a90 "") at pquery.cpp:1734
#22 0x0000560d201a3007 in FillPortalStore (portal=portal@entry=0x7f266473e050, isTopLevel=isTopLevel@entry=true) at pquery.cpp:1528
#23 0x0000560d201a4197 in PortalRun (portal=portal@entry=0x7f266473e050, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x7f267ac60c38, altdest=altdest@entry=0x7f267ac60c38,
    completionTag=completionTag@entry=0x7f2685d18e20 "") at pquery.cpp:1144
#24 0x0000560d201910ec in exec_simple_query (query_string=<optimized out>, query_string@entry=0x7f267ac60050 "fetch forward 2 from cur_sdx_32360_10;", messageType=messageType@entry=QUERY_MESSAGE,
    msg=msg@entry=0x7f2685d192e0) at postgres.cpp:3043
#25 0x0000560d20196b98 in PostgresMain (argc=<optimized out>, argv=argv@entry=0x7f2683b2daf0, dbname=<optimized out>, username=<optimized out>) at postgres.cpp:9265
#26 0x0000560d200eb8c2 in BackendRun (port=port@entry=0x7f2685d1a920) at postmaster.cpp:9598
#27 0x0000560d20113c20 in GaussDbThreadMain<(knl_thread_role)2> (arg=0x7f26c090bc60) at postmaster.cpp:14197
#28 0x0000560d200eb955 in InternalThreadFunc (args=<optimized out>) at postmaster.cpp:14827
#29 0x00007f27a859dea5 in start_thread (arg=0x7f2685d4f700) at pthread_create.c:307
#30 0x00007f27a82c696d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
```
【测试代码】:

openGauss/openGauss-server

内容风险标识

评论 (5)

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

内容风险标识