【测试类型：SQL功能】【测试版本：7.0.0】主机执行对含vector字段的表进行truncate，备机core

【标题描述】:主机执行对含vector字段的表进行truncate，备机core

【测试类型：SQL功能】【测试版本：7.0.0】 主机执行对含vector字段的表进行truncate，备机core

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

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

【被测功能】:
向量数据类型表操作

【测试类型】:
功能测试

【数据库版本】(查询命令: gaussdb -V):
gsql (openGauss 7.0.0-RC1 build a44948f6) compiled at 2025-01-02 16:17:13 commit 0 last mr

【预置条件】:
一主两备数据库功能正常

【操作步骤】(请填写详细的操作步骤):
1. 主机进行SQL语句执行
```
CREATE TABLE t (val vector(3));
INSERT INTO t (val) VALUES ('[0,0,0]'), ('[1,2,3]'), ('[1,1,1]'), (NULL);
CREATE INDEX ON t USING hnsw (val vector_l2_ops);
INSERT INTO t (val) VALUES ('[1,2,4]');
SELECT * FROM t ORDER BY val <-> '[3,3,3]';
SELECT COUNT(*) FROM (SELECT * FROM t ORDER BY val <-> (SELECT NULL::vector)) t2;
SELECT COUNT(*) FROM t;
TRUNCATE t;
SELECT * FROM t ORDER BY val <-> '[3,3,3]';
DROP TABLE t;
```

2. 查询集群状态
gs_om -t status --detail

【预期输出】:
1. 主机进行SQL语句执行，成功
2. 查询集群状态，正常

【实际输出】:
1. 主机进行SQL语句执行，成功
![输入图片说明](https://foruda.gitee.com/images/1735814825724045960/1ff11d12_8568116.png "屏幕截图")
2. 查询集群状态，备机异常core
![输入图片说明](https://foruda.gitee.com/images/1735815948051480677/a8b8ee74_8568116.png "屏幕截图")

### core掉后，无法通过start和增量build恢复成功，只能进行全量build才能恢复备节点；

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

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

```
2025-01-02 18:45:40.308 67766de6.6126 [unknown] 140213265364736 dn_6003 0 dn_6001_6002_6003 55000  0 [BACKEND] LOG:  page 1 (lsn: 60064c8) of relation base/15860/16393 (0/4294967295) does not exist
2025-01-02 18:45:40.308 67766de6.6126 [unknown] 140213265364736 dn_6003 0 dn_6001_6002_6003 55000  0 [BACKEND] CONTEXT:  xlog redo lsn 0/60064C8,
2025-01-02 18:45:40.308 67766de6.6126 [unknown] 140213265364736 dn_6003 0 dn_6001_6002_6003 DB010  0 [REDO] LOG:  [REDO_LOG_TRACE]dispatcher : pageWorkerCount 4, state 3, curItemNum 44, maxItemNum 102400
2025-01-02 18:45:40.308 67766de6.6126 [unknown] 140213265364736 dn_6003 0 dn_6001_6002_6003 DB010  0 [REDO] LOG:  [REDO_LOG_TRACE]RedoWorker common info: id 0, originId 0 tid 140213189863168,lastCheckedRestartPoint 100663752, lastReplayedReadRecPtr 100688008, lastReplayedEndRecPtr 100688144, standbyState 3
2025-01-02 18:45:40.308 67766de6.6126 [unknown] 140213265364736 dn_6003 0 dn_6001_6002_6003 DB010  0 [REDO] LOG:  [REDO_LOG_TRACE]queue info: writeHead 78, readTail 78, capacity 4096, mask 4095
2025-01-02 18:45:40.308 67766de6.6126 [unknown] 140213265364736 dn_6003 0 dn_6001_6002_6003 DB010  0 [REDO] LOG:  [REDO_LOG_TRACE]RedoWorker common info: id 1, originId 1 tid 140213150021376,lastCheckedRestartPoint 100663752, lastReplayedReadRecPtr 100688144, lastReplayedEndRecPtr 100688232, standbyState 3
2025-01-02 18:45:40.308 67766de6.6126 [unknown] 140213265364736 dn_6003 0 dn_6001_6002_6003 DB010  0 [REDO] LOG:  [REDO_LOG_TRACE]queue info: writeHead 54, readTail 54, capacity 4096, mask 4095
2025-01-02 18:45:40.308 67766de6.6126 [unknown] 140213265364736 dn_6003 0 dn_6001_6002_6003 DB010  0 [REDO] LOG:  [REDO_LOG_TRACE]RedoWorker common info: id 2, originId 2 tid 140213097068288,lastCheckedRestartPoint 100663752, lastReplayedReadRecPtr 100688616, lastReplayedEndRecPtr 100688712, standbyState 3
2025-01-02 18:45:40.308 67766de6.6126 [unknown] 140213265364736 dn_6003 0 dn_6001_6002_6003 DB010  0 [REDO] LOG:  [REDO_LOG_TRACE]queue info: writeHead 56, readTail 56, capacity 4096, mask 4095
2025-01-02 18:45:40.308 67766de6.6126 [unknown] 140213265364736 dn_6003 0 dn_6001_6002_6003 DB010  0 [REDO] LOG:  [REDO_LOG_TRACE]RedoWorker common info: id 3, originId 3 tid 140213033629440,lastCheckedRestartPoint 100663752, lastReplayedReadRecPtr 100687728, lastReplayedEndRecPtr 100688008, standbyState 3
2025-01-02 18:45:40.308 67766de6.6126 [unknown] 140213265364736 dn_6003 0 dn_6001_6002_6003 DB010  0 [REDO] LOG:  [REDO_LOG_TRACE]queue info: writeHead 9, readTail 9, capacity 4096, mask 4095
2025-01-02 18:45:40.308 67766de6.6126 [unknown] 140213265364736 dn_6003 0 dn_6001_6002_6003 DB010  0 [REDO] LOG:  [REDO_LOG_TRACE]txn : lastReplayedReadRecPtr 100688712, lastReplayedEndRecPtr 100689096, replayEndRecPtr 100689096, lastCheckPointRecPtr 100663752, lastCheckPoint.redo 100663624
2025-01-02 18:45:40.309 67766de6.6126 [unknown] 140213265364736 dn_6003 0 dn_6001_6002_6003 DB010  0 [REDO] PANIC:  [REDO_LOG_TRACE]DispatchRedoRecord encounter fatal error:rmgrID:32, info:0, indexid:0
2025-01-02 18:45:40.309 67766de6.6126 [unknown] 140213265364736 dn_6003 0 dn_6001_6002_6003 DB010  0 [REDO] BACKTRACELOG:  tid[26441]'s backtrace:
        /data1/peilq_all/peilq_app/peilq_0102/cluster/app/bin/gaussdb(+0xe3987b) [0x5632f21ed87b]
        /data1/peilq_all/peilq_app/peilq_0102/cluster/app/bin/gaussdb(_Z9errfinishiz+0x59b) [0x5632f21e502b]
        /data1/peilq_all/peilq_app/peilq_0102/cluster/app/bin/gaussdb(_Z11StartupXLOGv+0x50b8) [0x5632f2c9a5b8]
        /data1/peilq_all/peilq_app/peilq_0102/cluster/app/bin/gaussdb(_Z18StartupProcessMainv+0x299) [0x5632f27b4bb9]
        /data1/peilq_all/peilq_app/peilq_0102/cluster/app/bin/gaussdb(_Z17GaussDbThreadMainIL15knl_thread_role24EEiP14knl_thread_arg+0x3ca) [0x5632f27a0bca]
        /data1/peilq_all/peilq_app/peilq_0102/cluster/app/bin/gaussdb(+0x13c61c5) [0x5632f277a1c5]
        /lib64/libpthread.so.0(+0x7ea5) [0x7f87649feea5]
        /lib64/libc.so.6(clone+0x6d) [0x7f8764727b0d]
        Use addr2line to get pretty function name and line

2025-01-02 18:45:52.194 67766de8.6142 [unknown] 140212431218432 dn_6003 0 dn_6001_6002_6003 29000  0 [BACKEND] FATAL:  could not receive data from WAL streaming: SSL connection has been closed unexpectedly, remote datanode (null), error: Success

2025-01-02 18:45:52.194 67766de8.6142 [unknown] 140212431218432 dn_6003 0 dn_6001_6002_6003 29000  0 [BACKEND] BACKTRACELOG:  tid[26501]'s backtrace:
        /data1/peilq_all/peilq_app/peilq_0102/cluster/app/bin/gaussdb(+0xe3987b) [0x5632f21ed87b]
        /data1/peilq_all/peilq_app/peilq_0102/cluster/app/bin/gaussdb(_Z9errfinishiz+0x59b) [0x5632f21e502b]
        /data1/peilq_all/peilq_app/peilq_0102/cluster/app/bin/gaussdb(_Z16libpqrcv_receiveiPhPPcPi+0x38f) [0x5632f2e816ef]
        /data1/peilq_all/peilq_app/peilq_0102/cluster/app/bin/gaussdb(_Z18WalRcvrProcessDataPlPb+0x7bf) [0x5632f2e6191f]
        /data1/peilq_all/peilq_app/peilq_0102/cluster/app/bin/gaussdb(_Z15WalReceiverMainv+0x76b) [0x5632f2e62ceb]
        /data1/peilq_all/peilq_app/peilq_0102/cluster/app/bin/gaussdb(_Z17GaussDbThreadMainIL15knl_thread_role41EEiP14knl_thread_arg+0x3ca) [0x5632f27a316a]
        /data1/peilq_all/peilq_app/peilq_0102/cluster/app/bin/gaussdb(+0x13c61c5) [0x5632f277a1c5]
        /lib64/libpthread.so.0(+0x7ea5) [0x7f87649feea5]
        /lib64/libc.so.6(clone+0x6d) [0x7f8764727b0d]
        Use addr2line to get pretty function name and line

2025-01-02 18:45:52.203 67766de8.6142 [unknown] 140212431218432 dn_6003 0 dn_6001_6002_6003 00000  0 [BACKEND] LOG:  waiting walrcvwriter: 140212447999744 terminate
2025-01-02 18:45:52.203 67766de8.6141 [unknown] 140212447999744 dn_6003 0 dn_6001_6002_6003 00000  0 [BACKEND] LOG:  walrcvwriter thread shut down
2025-01-02 18:45:52.213 67766de8.6142 [unknown] 140212431218432 dn_6003 0 dn_6001_6002_6003 00000  0 [BACKEND] LOG:  set local_redo_finish_status to false in WalRcvDie
2025-01-02 18:45:52.213 67766de8.6142 [unknown] 140212431218432 dn_6003 0 dn_6001_6002_6003 00000  0 [BACKEND] LOG:  walreceiver thread shut down
~

```

core堆栈

```
(gdb) bt
#0  BBOX_CreateCoredump (file_name=file_name@entry=0x0) at bbox_create.cpp:404
#1  0x00005632f2457c21 in bbox_handler (sig=<optimized out>, si=<optimized out>, uc=<optimized out>) at gs_bbox.cpp:116
#2  bbox_handler (sig=<optimized out>, si=<optimized out>, uc=<optimized out>) at gs_bbox.cpp:103
#3  <signal handler called>
#4  0x00007f876465f387 in raise () from /lib64/libc.so.6
#5  0x00007f8764660a78 in abort () from /lib64/libc.so.6
#6  0x00005632f21e513d in errfinish (dummy=<optimized out>) at elog.cpp:803
#7  0x00005632f2c9a5b8 in StartupXLOG () at xlog.cpp:10475
#8  0x00005632f27b4bb9 in StartupProcessMain () at startup.cpp:374
#9  0x00005632f27a0bca in GaussDbAuxiliaryThreadMain<(knl_thread_role)24> (arg=0x7f8630e0b570) at postmaster.cpp:12143
#10 GaussDbThreadMain<(knl_thread_role)24> (arg=0x7f8630e0b570) at postmaster.cpp:14396
#11 0x00005632f277a1c5 in InternalThreadFunc (args=<optimized out>) at postmaster.cpp:15002
#12 0x00007f87649feea5 in start_thread () from /lib64/libpthread.so.0
#13 0x00007f8764727b0d in clone () from /lib64/libc.so.6

```

【测试代码】:

openGauss/openGauss-server

内容风险标识

评论 (3)

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

内容风险标识