cluster下盘场景core

【标题描述】cluster表发生下盘时coredump。

【测试类型】SQL功能

【测试版本】 5.0.0

【问题描述】cluster发生下盘时coredump。

【操作系统和硬件信息】openEuler release 20.03 (LTS) aarch64 GNU/Linux

【测试环境】单机

【被测功能】:cluster

【测试类型】:功能测试

【数据库版本】:
```
openGauss=# select version();
                                                                          version
------------------------------------------------------------------------------------------------------------------------------------------------------------
 (openGauss 5.1.0 build 39835719) compiled at 2023-04-26 11:59:27 commit 0 last mr  debug on aarch64-unknown-linux-gnu, compiled by g++ (GCC) 7.3.0, 64-bit
(1 row)
```

【预置条件】: 创建表对象和索引，导入足以触发下盘的数据。

【操作步骤】(请填写详细的操作步骤):
```
CREATE TABLE bmsql_customer_0083
(
  c_w_id         integer        not null,
  c_d_id         integer        not null,
  c_id           integer        not null,
  c_discount     decimal(4,4),
  c_credit       char(2),
  c_last         varchar(16),
  c_first        varchar(16),
  c_credit_lim   decimal(12,2),
  c_balance      decimal(12,2),
  c_ytd_payment  decimal(12,2),
  c_payment_cnt  integer,
  c_delivery_cnt integer,
  c_street_1     varchar(20),
  c_street_2     varchar(20),
  c_city         varchar(20),
  c_state        char(2),
  c_zip          char(9),
  c_phone        char(16),
  c_since        timestamp,
  c_middle       char(2),
  c_data         varchar(500)
);
insert into bmsql_customer_0083 select * from bmsql_customer;
create index on bmsql_customer_0083(c_w_id,c_d_id,c_id);
alter table bmsql_customer_0083 cluster on bmsql_customer_0083_c_w_id_c_d_id_c_id_idx;
cluster bmsql_customer_0083 using bmsql_customer_0083_c_last_idx;
```

【预期输出】: cluster成功

【实际输出】:coredump，堆栈请见日志信息

【原因分析】:
1. 这个问题的根因
社区对于sort下盘场景进行优化，提前分配SlabSlot，不再需要通过USEMEM统计内存并且数据结构也发生了变化，cluster下盘场景漏适配导致访问空指针，进程core。
2. 问题推断过程
3. 还有哪些原因可能造成类似现象
4. 该问题是否有临时规避措施
5. 问题解决方案
删除USEMEM，其他场景（readtup_heap）已适配。
![输入图片说明](https://foruda.gitee.com/images/1682490194579749631/03672de2_9379002.png "屏幕截图")
6. 预计修复问题时间

【日志信息】(请附上日志文件、截图、coredump信息):
```
#0  0x0000000001468f58 in sys_wait4 (upid=2016703, stat_addr=0xfffbd1fc62c8, options=1073741824, ru=0x0)
    at bbox_syscall_support.cpp:36
36      __syscall4(long, wait4, pid_t, upid, int*, stat_addr, int, options, struct rusage*, ru);
[Current thread is 1 (Thread 0xfffbd1fcc390 (LWP 2016428))]
Missing separate debuginfos, use: dnf debuginfo-install glibc-2.28-164.el8.aarch64 keyutils-libs-1.5.10-11.oe1.aarch64 libaio-0.3.111-5.oe1.aarch64 libxcrypt-4.1.1-6.el8.aarch64 ncurses-libs-6.1-14.oe1.aarch64 xz-libs-5.2.4-10.oe1.aarch64
(gdb) bt
#0  0x0000000001468f58 in sys_wait4 (upid=2016703, stat_addr=0xfffbd1fc62c8, options=1073741824, ru=0x0) at bbox_syscall_support.cpp:36
#1  0x000000000146a17c in sys_waitpid (pid=2016703, status=0xfffbd1fc62c8, options=1073741824) at bbox_syscall_support.cpp:516
#2  0x000000000146bccc in BBOX_GetClonePidResult (iClonePid=2016703, pstArgs=0xfffbd1fc6340, iCloneErrno=9) at bbox_threads.cpp:572
#3  0x000000000146c5d4 in BBOX_GetAllThreads (enType=GET_TYPE_DUMP, pDone=0x145d634 <BBOX_FinishDumpFile(void*)>, pDoneArgs=0xfffbd1fc6478, pCallback=0x14658d8 <BBOX_DoDumpElfCore(BBOX_GetAllThreadDone, void*, int, pid_t*, va_list)>) at bbox_threads.cpp:700
#4  0x000000000145d9bc in BBOX_CreateCoredump (file_name=0xfffbd1fc65a8 "/core//core-gaussdb-2015362-2023_04_26_13_54_13-bbox.lz4") at bbox_create.cpp:440
#5  0x000000000146e334 in bbox_handler (sig=11, si=0xfffbd1fc6ae0, uc=0xfffbd1fc6b60) at gs_bbox.cpp:112
#6  <signal handler called>
#7  0x00000000011a7c2c in GetMemoryChunkSpace (pointer=0xfffbd2190460) at mcxt.cpp:558
#8  0x00000000011d83bc in readtup_cluster (state=0xfffbd3286060, stup=0xfffbd1fc7e48, tapenum=1, tuplen=540) at tuplesort.cpp:3820
#9  0x00000000011d5930 in mergereadnext (state=0xfffbd3286060, srcTape=1, stup=0xfffbd1fc7e48) at tuplesort.cpp:2916
#10 0x00000000011d5844 in beginmerge (state=0xfffbd3286060) at tuplesort.cpp:2897
#11 0x00000000011d4d60 in mergeruns (state=0xfffbd3286060) at tuplesort.cpp:2703
#12 0x00000000011d2d04 in tuplesort_performsort (state=0xfffbd3286060) at tuplesort.cpp:1883
#13 0x00000000016449d8 in copy_heap_data_internal (OldHeap=0xfffbceae3ab8, OldIndex=0xfffbceaeb110, NewHeap=0xfffbceae9308, OldestXmin=13289, FreezeXid=13289, verbose=false, use_sort=true, memUsage=0xfffbd2957584) at cluster.cpp:2220
#14 0x00000000020d2398 in HeapamRelationCopyForCluster (OldHeap=0xfffbceae3ab8, OldIndex=0xfffbceaeb110, NewHeap=0xfffbceae9308, OldestXmin=13289, FreezeXid=13289, verbose=false, use_sort=true, memUsage=0xfffbd2957584) at tableam.cpp:395
#15 0x000000000163e0d4 in tableam_relation_copy_for_cluster (OldHeap=0xfffbceae3ab8, OldIndex=0xfffbceaeb110, NewHeap=0xfffbceae9308, OldestXmin=13289, FreezeXid=13289, verbose=false, use_sort=true, memUsage=0xfffbd2957584) at ../../../../src/include/access/tableam.h:1013
#16 0x00000000016450b4 in copy_heap_data (OIDNewHeap=16415, OIDOldHeap=16403, OIDOldIndex=16412, freeze_min_age=-1, freeze_table_age=-1, verbose=false, pSwapToastByContent=0xfffbd1fc8289, pFreezeXid=0xfffbd1fc8298, pFreezeMulti=0xfffbd1fc82a8, ptrDeleteTupleNum=0xfffbd1fc82a0, memUsage=0xfffbd2957584) at cluster.cpp:2458
#17 0x000000000163fc60 in rebuild_relation (OldHeap=0xfffbceae3ab8, indexOid=16412, freeze_min_age=-1, freeze_table_age=-1, verbose=false, memUsage=0xfffbd2957584) at cluster.cpp:833
#18 0x000000000163f494 in cluster_rel (tableOid=16403, partitionOid=0, indexOid=16412, recheck=false, verbose=false, freeze_min_age=-1, freeze_table_age=-1, mem_info=0xfffbd2957584, onerel=true) at cluster.cpp:643
#19 0x000000000163e6f4 in cluster (stmt=0xfffbd2957568, isTopLevel=true) at cluster.cpp:299
#20 0x00000000019c82c4 in standard_ProcessUtility (processutility_cxt=0xfffbd1fcacc8, dest=0xfffbd2957730, sent_to_remote=false, completion_tag=0xfffbd1fcb128 "", context=PROCESS_UTILITY_TOPLEVEL, isCTAS=false) at utility.cpp:3630
#21 0x0000fffcf8670d6c in gsaudit_ProcessUtility_hook (processutility_cxt=0xfffbd1fcacc8, dest=0xfffbd2957730, sentToRemote=false, completionTag=0xfffbd1fcb128 "", context=PROCESS_UTILITY_TOPLEVEL, isCTAS=false) at gs_policy_plugin.cpp:819
#22 0x00000000019dd934 in pgaudit_ProcessUtility (processutility_cxt=0xfffbd1fcacc8, dest=0xfffbd2957730, sentToRemote=false, completionTag=0xfffbd1fcb128 "", context=PROCESS_UTILITY_TOPLEVEL, isCTAS=false) at auditfuncs.cpp:1415
#23 0x0000000001a3bfd0 in hypo_utility_hook (processutility_cxt=0xfffbd1fcacc8, dest=0xfffbd2957730, sentToRemote=false, completionTag=0xfffbd1fcb128 "", context=PROCESS_UTILITY_TOPLEVEL, isCtas=false) at hypopg_index.cpp:167
#24 0x00000000019c4f5c in ProcessUtility (processutility_cxt=0xfffbd1fcacc8, dest=0xfffbd2957730, sent_to_remote=false, completion_tag=0xfffbd1fcb128 "", context=PROCESS_UTILITY_TOPLEVEL, isCTAS=false) at utility.cpp:1539
#25 0x00000000019bf664 in PortalRunUtility (portal=0xfffbd298e060, utilityStmt=0xfffbd2957568, isTopLevel=true, dest=0xfffbd2957730, completionTag=0xfffbd1fcb128 "") at pquery.cpp:1723
#26 0x00000000019bfbc0 in PortalRunMulti (portal=0xfffbd298e060, isTopLevel=true, dest=0xfffbd2957730, altdest=0xfffbd2957730, completionTag=0xfffbd1fcb128 "") at pquery.cpp:1901
#27 0x00000000019bdd40 in PortalRun (portal=0xfffbd298e060, count=9223372036854775807, isTopLevel=true, dest=0xfffbd2957730, altdest=0xfffbd2957730, completionTag=0xfffbd1fcb128 "") at pquery.cpp:1181
#28 0x00000000019a1f1c in exec_simple_query (query_string=0xfffbd2956060 "cluster bmsql_customer_0083 using bmsql_customer_0083_c_last_idx;", messageType=QUERY_MESSAGE, msg=0xfffbd1fcb330) at postgres.cpp:2963
#29 0x00000000019b17a8 in PostgresMain (argc=1, argv=0xfffbd29731c0, dbname=0xfffbd29721f8 "yat_test", username=0xfffbd29721b0 "") at postgres.cpp:8973
#30 0x00000000018d54cc in BackendRun (port=0xfffbd1fcb8d8) at postmaster.cpp:9225
#31 0x00000000018e9684 in GaussDbThreadMain<(knl_thread_role)1> (arg=0xfffc1f126fd8) at postmaster.cpp:13603
#32 0x00000000018e3e7c in InternalThreadFunc (args=0xfffc1f126fd8) at postmaster.cpp:14222
#33 0x00000000024d95fc in ThreadStarterFunc (arg=0xfffc1f126fc8) at gs_thread.cpp:382
#34 0x0000fffcf9f87898 in start_thread () from /lib64/libpthread.so.0
#35 0x0000fffcf9ed1ddc in thread_start () from /lib64/libc.so.6
```

【测试代码】: 手工执行发现问题用例

openGauss/openGauss-server

内容风险标识

评论 (8)

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

内容风险标识