根据时间段与表名精确解析，发生 core

**问题描述：** 
版本：PostgreSQL 13.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit

创建表，插入数据，执行多次 checkpoint，根据时间段与表名精确解析，发生 core，如下：

postgres=# create table t(id int);
CREATE TABLE
postgres=# insert into t select 1;
INSERT 0 1
postgres=# checkpoint;
CHECKPOINT
postgres=# insert into t select 2;
INSERT 0 1
postgres=# checkpoint;
CHECKPOINT
postgres=# insert into t select 3;
INSERT 0 1
postgres=# checkpoint;
CHECKPOINT
postgres=# insert into t select 4;
INSERT 0 1
postgres=# checkpoint;
CHECKPOINT
postgres=# insert into t select 5;

select wal2sql('2021-11-23 00:00:00', '2021-11-25 00:00:00','true','t'::regclass::oid);

```
Program terminated with signal 11, Segmentation fault.
#0  0x00002ac359b2e344 in wal2sql_front_read () at wal2sql.c:1050
1050                    if(ckpinfo->chp_start_lsn >= walminer_decode_context->swpro.read_lsn)
Missing separate debuginfos, use: debuginfo-install glibc-2.17-324.el7_9.x86_64
(gdb) bt
#0  0x00002ac359b2e344 in wal2sql_front_read () at wal2sql.c:1050
#1  0x00002ac359b2682e in prepare_read (issearch=false, point_end_lsn=0) at walreader.c:704
#2  0x00002ac359b2abf5 in decode_wal () at walminer_decode.c:1722
#3  0x00002ac359b1ebff in pg_walminer (fcinfo=0x27f0478) at walminer.c:171
#4  0x00002ac359b31db0 in wal2sql_internal (fcinfo=0x27f0478) at wal2sql.c:2060
#5  0x0000000000701ef9 in ExecInterpExpr (state=0x27f0390, econtext=0x27f0090, isnull=0x7fffe245aac7) at execExprInterp.c:680
#6  0x0000000000703ca2 in ExecInterpExprStillValid (state=0x27f0390, econtext=0x27f0090, isNull=0x7fffe245aac7) at execExprInterp.c:1807
#7  0x000000000075372c in ExecEvalExprSwitchContext (state=0x27f0390, econtext=0x27f0090, isNull=0x7fffe245aac7) at ../../../src/include/executor/executor.h:322
#8  0x0000000000753795 in ExecProject (projInfo=0x27f0388) at ../../../src/include/executor/executor.h:356
#9  0x0000000000753984 in ExecResult (pstate=0x27eff78) at nodeResult.c:136
#10 0x00000000007184bf in ExecProcNodeFirst (node=0x27eff78) at execProcnode.c:450
#11 0x000000000070ca27 in ExecProcNode (node=0x27eff78) at ../../../src/include/executor/executor.h:248
#12 0x000000000070f4db in ExecutePlan (estate=0x27efd40, planstate=0x27eff78, use_parallel_mode=false, operation=CMD_SELECT, sendTuples=true, numberTuples=1,
    direction=ForwardScanDirection, dest=0x27e7728, execute_once=true) at execMain.c:1632
#13 0x000000000070d04b in standard_ExecutorRun (queryDesc=0x27e9530, direction=ForwardScanDirection, count=1, execute_once=true) at execMain.c:350
#14 0x000000000070ce73 in ExecutorRun (queryDesc=0x27e9530, direction=ForwardScanDirection, count=1, execute_once=true) at execMain.c:294
#15 0x0000000000723dc3 in postquel_getnext (es=0x27e91b0, fcache=0x27e3cc0) at functions.c:884
#16 0x00000000007243d9 in fmgr_sql (fcinfo=0x27da3b8) at functions.c:1170
#17 0x0000000000701ef9 in ExecInterpExpr (state=0x27da2d0, econtext=0x27d9fd0, isnull=0x7fffe245b017) at execExprInterp.c:680
#18 0x0000000000703ca2 in ExecInterpExprStillValid (state=0x27da2d0, econtext=0x27d9fd0, isNull=0x7fffe245b017) at execExprInterp.c:1807
#19 0x000000000075372c in ExecEvalExprSwitchContext (state=0x27da2d0, econtext=0x27d9fd0, isNull=0x7fffe245b017) at ../../../src/include/executor/executor.h:322
#20 0x0000000000753795 in ExecProject (projInfo=0x27da2c8) at ../../../src/include/executor/executor.h:356
#21 0x0000000000753984 in ExecResult (pstate=0x27d9eb8) at nodeResult.c:136
#22 0x00000000007184bf in ExecProcNodeFirst (node=0x27d9eb8) at execProcnode.c:450
#23 0x000000000070ca27 in ExecProcNode (node=0x27d9eb8) at ../../../src/include/executor/executor.h:248
#24 0x000000000070f4db in ExecutePlan (estate=0x27d9c80, planstate=0x27d9eb8, use_parallel_mode=false, operation=CMD_SELECT, sendTuples=true, numberTuples=0,
    direction=ForwardScanDirection, dest=0x27dc3e0, execute_once=true) at execMain.c:1632
#25 0x000000000070d04b in standard_ExecutorRun (queryDesc=0x272e710, direction=ForwardScanDirection, count=0, execute_once=true) at execMain.c:350
#26 0x000000000070ce73 in ExecutorRun (queryDesc=0x272e710, direction=ForwardScanDirection, count=0, execute_once=true) at execMain.c:294
#27 0x0000000000933ee0 in PortalRunSelect (portal=0x2772a50, forward=true, count=0, dest=0x27dc3e0) at pquery.c:919
#28 0x0000000000933b99 in PortalRun (portal=0x2772a50, count=9223372036854775807, isTopLevel=true, run_once=true, dest=0x27dc3e0, altdest=0x27dc3e0, qc=0x7fffe245b390)
    at pquery.c:763
#29 0x000000000092ddb2 in exec_simple_query (query_string=0x2709ed0 "select wal2sql('2021-11-23 00:00:00', '2021-11-25 00:00:00','true','t'::regclass::oid);")
    at postgres.c:1239
#30 0x0000000000931df2 in PostgresMain (argc=1, argv=0x27369e8, dbname=0x2706ad8 "postgres", username=0x2736908 "antdb") at postgres.c:4339
#31 0x0000000000881966 in BackendRun (port=0x272ec80) at postmaster.c:4526
#32 0x0000000000881156 in BackendStartup (port=0x272ec80) at postmaster.c:4210
#33 0x000000000087d814 in ServerLoop () at postmaster.c:1739
#34 0x000000000087d0eb in PostmasterMain (argc=3, argv=0x2704a50) at postmaster.c:1412
#35 0x00000000007842a3 in main (argc=3, argv=0x2704a50) at main.c:210
```

**问题分析**
该问题发生在 PG13，PG12 未出现，根据 core 文件信息，初步判断是 List 类型的实现方式，在 PG12 是链表，到了 PG13 变成数组实现，在 List 动态增长时，指向 List 元素的指针会失效。

![输入图片说明](https://images.gitee.com/uploads/images/2021/1124/172328_d89b550a_9658097.png "屏幕截图.png")

Movead/WalMiner

内容风险标识

评论 (0)

Movead/WalMiner .gitee-modal { width: 500px !important; }

内容风险标识