【测试类型：SQL功能】【测试版本：6.0.0】【可靠性】一主两备在极致RTO&逻辑复制场景下，执行sql语句后，备机产生core

【标题描述】: xstore场景，一主两备，在极致RTO&逻辑复制场景下，执行sql语句后，备机产生core
【测试类型：SQL功能】【测试版本：6.0.0】【可靠性】xstore场景，一主两备在极致RTO&逻辑复制场景下，执行sql语句后，备机产生core

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

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

【被测功能】:
ustore极致RTO

【测试类型】:
功能测试

【数据库版本】(查询命令: gaussdb -V):
gaussdb (openGauss 6.0.0 build 8d33e9eb) compiled at 2024-07-12 10:06:29 commit 0 last mr

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

【操作步骤】(请填写详细的操作步骤):
1. 设置参数，重启集群
gs_guc set -N all -I all -c "replication_type=1" && 
gs_guc set -N all -I all -c "recovery_parse_workers=4" && 
gs_guc set -N all -I all -c "recovery_redo_workers=4" && 
gs_guc set -N all -I all -c "hot_standby=off"&& 
gs_guc set -N all -I all -c "wal_level=logical";
gs_om -t stop && gs_om -t start
2. 执行SQL语句
drop table if exists t_RTO_Dbsys_Case041;
create table t_RTO_Dbsys_Case041(id int);
begin
for i in 1..10000 loop
insert into t_RTO_Dbsys_Case041 values(i);
end loop;
end;
/
3. 查询集群状态
gs_om -t status --detail

【预期输出】:
1. 设置参数，重启集群，成功
2. 执行SQL语句,成功
3. 查询集群状态，正常

【实际输出】:
1. 设置参数，重启集群，成功
2. 执行SQL语句,报warning
WARNING:  canceling wait for synchronous replication due to syncmaster standalone.
DETAIL:  The transaction has already committed locally, but might not have been replicated to the standby.
ANONYMOUS BLOCK EXECUTE
3. 查询集群状态，备机异常core

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

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

```
(gdb) bt
#0  BBOX_CreateCoredump (file_name=file_name@entry=0x0) at bbox_create.cpp:404
#1  0x000055cd0633b6b1 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  0x00007f736692a6eb in raise () from /lib64/libc.so.6
#5  0x00007f736692ba11 in abort () from /lib64/libc.so.6
#6  0x000055cd060cb91d in errfinish (dummy=<optimized out>) at elog.cpp:797
#7  0x000055cd06c3cea7 in CheckLastRecordSize (xlundometa=0x7f715e946180, lastRecordSize=<optimized out>) at knl_uundovec.cpp:553
#8  PrepareUndoRecord (urecvec=urecvec@entry=0x7f71877823f8, upersistence=upersistence@entry=UNDO_PERMANENT, xlundohdr=xlundohdr@entry=0x7f715e946150,
    xlundometa=xlundometa@entry=0x7f715e946180) at knl_uundovec.cpp:665
#9  0x000055cd06c16147 in UHeapPrepareUndoInsert (relOid=<optimized out>, partitionOid=<optimized out>, relfilenode=<optimized out>, tablespace=<optimized out>,
    persistence=persistence@entry=UNDO_PERMANENT, xid=xid@entry=1403985, cid=0, prevurpInOneBlk=0, prevurpInOneXact=0, blk=0, xlundohdr=0x7f715e946150,
    xlundometa=0x7f715e946180) at knl_uheap.cpp:4505
#10 0x000055cd06c4d616 in RedoUndoInsertBlock (blockdatarec=0x7f715e946124, bufferinfo=<optimized out>, blockhead=<optimized out>) at knl_uextremeredo.cpp:1674
#11 0x000055cd06bfcde6 in XLogBlockRedoForExtremeRTO (redoblocktate=redoblocktate@entry=0x7f715e9460cc, bufferinfo=bufferinfo@entry=0x7f718a129830,
    notfound=notfound@entry=false, readBufCost=..., redoCost=...) at redo_xlogutils.cpp:1841
#12 0x000055cd06ac2885 in extreme_rto::RedoPageWorkerMain () at page_redo.cpp:1574
#13 0x000055cd06ac66e5 in extreme_rto::RedoMainLoop () at page_redo.cpp:2545
#14 0x000055cd06ac69ea in extreme_rto::ParallelRedoThreadMain () at page_redo.cpp:2660
#15 0x000055cd0666fc1a in GaussDbAuxiliaryThreadMain<(knl_thread_role)22> (arg=0x7f7232bcd6f8) at postmaster.cpp:13746
#16 GaussDbThreadMain<(knl_thread_role)22> (arg=0x7f7232bcd6f8) at postmaster.cpp:14227
#17 0x000055cd06642385 in InternalThreadFunc (args=<optimized out>) at postmaster.cpp:14819
#18 0x00007f7366abafed in ?? () from /lib64/libpthread.so.0
#19 0x00007f73669ee18f in clone () from /lib64/libc.so.6
(gdb) quit

```

【测试代码】:

openGauss/openGauss-server

内容风险标识

评论 (1)

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

内容风险标识