【测试类型：并发/压力长稳】【测试版本：6.0.0】问题描述:长稳运行5天异常，数据库产生core

【标题描述】:长稳运行5天异常，数据库产生core
【测试类型：并发/压力长稳】【测试版本：6.0.0】 问题描述:长稳运行5天异常，数据库产生core

【操作系统和硬件信息】(查询命令: cat /etc/system-release, uname -a):
openEuler release 20.03 (LTS)
Linux openGauss141 4.19.90-2003.4.0.0036.oe1.aarch64 #1 SMP Mon Mar 23 19:06:43 UTC 2020 aarch64 aarch64 aarch64 GNU/Linux

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

【被测功能】:压缩表长稳测试

【测试类型】:并发/压力长稳

【数据库版本】(查询命令: gaussdb -V):
gaussdb (openGauss 6.0.0 build e06fb91d) compiled at 2024-06-05 18:08:28 commit 0 last mr

【预置条件】:数据库正常

【操作步骤】(请填写详细的操作步骤):
1. 安装6.0.0 B018数据库并配置数据库参数

```
#TPCC参数
remote_read_mode = non_authentication
update_lockwait_timeout = 1200s
lockwait_timeout = 1200s
session_timeout = 0
recovery_max_workers = 4
password_encryption_type = 1
wal_level = logical
enable_slot_log = on
hot_standby = on
autoanalyze_timeout = 900
client_min_messages = ERROR
query_dop = 8
enable_pbe_optimization = off
enable_bbox_dump = off
max_process_memory = 256GB
shared_buffers = 128GB
wal_buffers = 1GB
max_connections = 12000
wal_sender_timeout = 600s
log_min_messages = log
log_min_duration_statement = 1800000
enable_thread_pool = on
thread_pool_attr = '400,4,(cpubind:0-23,24-47,48-71,72-95)'
checkpoint_segments = 1024
synchronous_commit = on
enable_ustore=on
enable_default_ustore_table=on

```
2. 修改benchmark中的建表语句为压缩表

```
create table bmsql_warehouse (
  w_id        integer   not null,
  w_ytd       decimal(12,2),
  w_tax       decimal(4,4),
  w_name      varchar(10),
  w_street_1  varchar(20),
  w_street_2  varchar(20),
  w_city      varchar(20),
  w_state     char(2),
  w_zip       char(9)
)WITH (FILLFACTOR=80,orientation=row,compresstype=2,compress_level=12,compress_chunk_size=512,compress_prealloc_chunks=0,compress_byte_convert=false,compress_diff_convert=false);
```
3.准备数据并执行测试

```
#!/bin/bash
/bin/bash runDatabaseBuild.sh props.pg
/bin/bash runBenchmark.sh props.pg
```
4.benchmark参数：
![输入图片说明](https://foruda.gitee.com/images/1718593055241900638/070a51c7_8574640.png "20240617-105717(WeLinkPC).png")

【预期输出】:执行测试正常

【实际输出】:执行测试异常，数据库主节点产生core
堆栈：

```
#0  0x0000aaab7463d0d4 in CLogGetStatus (xid=xid@entry=461437524, lsn=lsn@entry=0xffd796ec4d90) at clog.cpp:610
#1  0x0000aaab74649ad4 in GetCSNByCLog (isCommit=false, transactionId=461437524) at transam.cpp:70
#2  TransactionIdGetCommitSeqNo (transactionId=transactionId@entry=461437524, isCommit=isCommit@entry=false, isMvcc=isMvcc@entry=true,
    isNest=isNest@entry=true, snapshot=snapshot@entry=0x0) at transam.cpp:160
#3  0x0000aaab7464a3ec in TransactionIdGetStatus (transactionId=transactionId@entry=461437524) at transam.cpp:714
#4  0x0000aaab745f4644 in UBTreeCheckXid (xid=461437524) at ubtutils.cpp:430
#5  0x0000aaab745f48cc in UBTreeItupGetXminXmax (page=page@entry=0xffe9671a5000 "\027\005", offnum=offnum@entry=24,
    oldest_xmin=oldest_xmin@entry=0, xmin=xmin@entry=0xffd796ec4fe0, xmax=xmax@entry=0xffd796ec4fe8,
    xminCommitted=xminCommitted@entry=0xffd796ec4fda, xmaxCommitted=xmaxCommitted@entry=0xffd796ec4fdb) at ubtutils.cpp:503
#6  0x0000aaab745f4960 in UBTreeVisibilityCheckWrap (scan=scan@entry=0xffd781211850, page=page@entry=0xffe9671a5000 "\027\005",
    offnum=offnum@entry=24, needRecheck=needRecheck@entry=0xffd796ec5140) at ubtutils.cpp:390
#7  0x0000aaab745f4fe4 in UBTreeCheckKeys (scan=scan@entry=0xffd781211850, page=page@entry=0xffe9671a5000 "\027\005", offnum=offnum@entry=24,
    dir=dir@entry=BackwardScanDirection, continuescan=continuescan@entry=0xffd796ec513f, needRecheck=needRecheck@entry=0xffd796ec5140)
    at ubtutils.cpp:340
#8  0x0000aaab745f7530 in UBTreeReadPage (scan=scan@entry=0xffd781211850, dir=dir@entry=BackwardScanDirection, offnum=24) at ubtsearch.cpp:1392
#9  0x0000aaab745f7aac in UBTreeStepPage (scan=scan@entry=0xffd781211850, dir=dir@entry=BackwardScanDirection)
    at ../../../../../src/include/storage/buf/bufpage.h:397
#10 0x0000aaab745f8130 in UBTreeNext (scan=scan@entry=0xffd781211850, dir=dir@entry=BackwardScanDirection) at ubtsearch.cpp:1141
#11 0x0000aaab745f9254 in UBTreeGetTupleInternal (scan=scan@entry=0xffd781211850, dir=dir@entry=BackwardScanDirection) at ubtsearch.cpp:1838
#12 0x0000aaab745e6d38 in ubtgettuple (fcinfo=<optimized out>) at ubtree.cpp:279
#13 0x0000aaab73d09034 in FunctionCall2Coll (flinfo=<optimized out>, collation=<optimized out>, arg1=281301049481296, arg2=<optimized out>)
    at fmgr.cpp:1596
#14 0x0000aaab745c6170 in index_getnext_tid (scan=scan@entry=0xffd781211850, direction=direction@entry=BackwardScanDirection) at indexam.cpp:492
#15 0x0000aaab745c6990 in IndexGetnextSlot (scan=scan@entry=0xffd781211850, direction=direction@entry=BackwardScanDirection,
    slot=slot@entry=0xffd75da981a0, has_cur_xact_write=0xffd78bdb21e0) at indexam.cpp:874
#16 0x0000aaab7438e724 in IndexNext (node=0xffd7ae740050) at nodeIndexscan.cpp:100
#17 0x0000aaab74357ad8 in ExecScan (node=0xffd7ae740050, access_mtd=0xaaab7438e670 <IndexNext(IndexScanState*)>,
    recheck_mtd=0xaaab7438e630 <IndexRecheck(IndexScanState*, TupleTableSlot*)>) at execScan.cpp:172
#18 0x0000aaab743924b8 in ExecProcNode (node=0xffd7ae740050) at ../../../../src/include/executor/executor.h:283
#19 ExecLimit (state=0xffd788542050) at nodeLimit.cpp:91
#20 0x0000aaab743b5474 in ExecProcNode (node=0xffd788542050) at ../../../../src/include/executor/executor.h:283
#21 ExecSetParamPlan (node=0xffd756e3ce40, econtext=0xffd756e3c170) at nodeSubplan.cpp:1003
#22 0x0000aaab74341840 in ExecEvalParamExec (exprstate=<optimized out>, econtext=<optimized out>, isNull=0xffd756e3cb08, isDone=<optimized out>)
    at execQual.cpp:1377
#23 0x0000aaab7434be60 in ExecEvalExpr (isDone=0xffd756e3ce18, isNull=0xffd756e3cb08, econtext=0xffd7aa56ec30, state=<optimized out>)
    at ../../../../src/include/executor/executor.h:370
#24 ExecTargetList (isDone=0xffd78bdb22a0, itemIsDone=0x1fe18, isnull=<optimized out>, values=0xffd756e3cae0, econtext=0xffd7aa56ec30,
    targetlist=<optimized out>) at execQual.cpp:6942
#25 ExecProjectByRecursion (projInfo=<optimized out>, isDone=0xffd78bdb22a0) at execQual.cpp:7194
#26 0x0000aaab7434c5ac in ExecProject (projInfo=<optimized out>, isDone=isDone@entry=0xffd796ec583c) at execQual.cpp:7098
#27 0x0000aaab743a6e0c in ExecResult (state=0xffd756e3c050) at nodeResult.cpp:191
#28 0x0000aaab743b5474 in ExecProcNode (node=0xffd756e3c050) at ../../../../src/include/executor/executor.h:283
#29 ExecSetParamPlan (node=0xffd713ac74d0, econtext=0xffd713ac6840) at nodeSubplan.cpp:1003
--Type <RET> for more, q to quit, c to continue without paging--

```
数据库状态：
![输入图片说明](https://foruda.gitee.com/images/1718592948638637797/758d8515_8574640.png "20240617-105519(WeLinkPC).png")
tpcc截图：
SEVERE: IO Exception.recieved packetType:-1last PacketType:-1connection inf	15400buffer :
buffer is empty
Jun 16, 2024 10:36:47 AM org.postgresql.core.v3.QueryExecutorImpl processResults
SEVERE: IO Exception.recieved packetType:-1last PacketType:-1connection info:Î	J3:15400buffer :
buffer is empty
Jun 16, 2024 10:36:47 AM org.postgresql.core.v3.QueryExecutorImpl processResultse
SEVERE: IO Exception.recieved packetType:68last PacketType:-1connection info:-	15400buffer :
buffer is empty
10:36:47,157 [Thread-30] ERROR jTPCCTData : Unexpected SQLException in DELIVERY_BGe
Jun 16, 2024 10:36:47 AM org.postgresql.core.v3.QueryExecutorImpl processResultse

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

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

【测试代码】:

openGauss/openGauss-server

内容风险标识

评论 (7)

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

内容风险标识