一主一备，备节点启动不了报错

问题求助
1

[omm@gauss118 om_monitor]$ gs_ctl start -D /data/opengaussdb/install/data/dn -M standby
[2026-02-04 15:11:44.260][3563639][gs_ctl]: gs_ctl started,datadir is /data/opengaussdb/install/data/dn
[2026-02-04 15:11:44.283][3563639][gs_ctl]: waiting for server to start…
.0 LOG: [Alarm Module]can not read GAUSS_WARNING_TYPE env.

0 LOG: [Alarm Module]Host Name: gauss118

0 LOG: [Alarm Module]Host IP: gauss118. Copy hostname directly in case of taking 10s to use ‘gethostbyname’ when /etc/hosts does not contain

0 LOG: [Alarm Module]Cluster Name: HK_TEST

0 LOG: [Alarm Module]Invalid data in AlarmItem file! Read alarm English name failed! line: 58

0 WARNING: failed to open feature control file, please check whether it exists: FileName=gaussdb.version, Errno=2, Errmessage=No such file or directory.
0 WARNING: failed to parse feature control file: gaussdb.version.
0 WARNING: Failed to load the product control file, so gaussdb cannot distinguish product version.
0 LOG: bbox_dump_path is set to /data/opengaussdb/corefile/
2026-02-04 15:11:44.330 6982f130.1 [unknown] 281473000898592 [unknown] 0 dn_6001_6002 00000 0 [BACKEND] LOG: base_page_saved_interval is 400, ori is 400.
2026-02-04 15:11:44.334 6982f130.1 [unknown] 281473000898592 [unknown] 0 dn_6001_6002 DB010 0 [REDO] LOG: Recovery parallelism, cpu count = 4, max = 4, actual = 4
2026-02-04 15:11:44.334 6982f130.1 [unknown] 281473000898592 [unknown] 0 dn_6001_6002 DB010 0 [REDO] LOG: ConfigRecoveryParallelism, true_max_recovery_parallelism:4, max_recovery_parallelism:4
2026-02-04 15:11:44.339 6982f130.1 [unknown] 281473000898592 [unknown] 0 dn_6001_6002 00000 0 [BACKEND] LOG: [Alarm Module]can not read GAUSS_WARNING_TYPE env.

2026-02-04 15:11:44.339 6982f130.1 [unknown] 281473000898592 [unknown] 0 dn_6001_6002 00000 0 [BACKEND] LOG: [Alarm Module]Host Name: gauss118

2026-02-04 15:11:44.339 6982f130.1 [unknown] 281473000898592 [unknown] 0 dn_6001_6002 00000 0 [BACKEND] LOG: [Alarm Module]Host IP: gauss118. Copy hostname directly in case of taking 10s to use ‘gethostbyname’ when /etc/hosts does not contain

2026-02-04 15:11:44.339 6982f130.1 [unknown] 281473000898592 [unknown] 0 dn_6001_6002 00000 0 [BACKEND] LOG: [Alarm Module]Cluster Name: HK_TEST

2026-02-04 15:11:44.339 6982f130.1 [unknown] 281473000898592 [unknown] 0 dn_6001_6002 00000 0 [BACKEND] LOG: [Alarm Module]Invalid data in AlarmItem file! Read alarm English name failed! line: 58

2026-02-04 15:11:44.344 6982f130.1 [unknown] 281473000898592 [unknown] 0 dn_6001_6002 00000 0 [BACKEND] LOG: loaded library “security_plugin”
2026-02-04 15:11:44.347 6982f130.1 [unknown] 281473000898592 [unknown] 0 dn_6001_6002 01000 0 [BACKEND] WARNING: could not create any HA TCP/IP sockets
2026-02-04 15:11:44.352 6982f130.1 [unknown] 281473000898592 [unknown] 0 dn_6001_6002 00000 0 [BACKEND] LOG: InitNuma numaNodeNum: 1 numa_distribute_mode: none inheritThreadPool: 0.
2026-02-04 15:11:44.353 6982f130.1 [unknown] 281473000898592 [unknown] 0 dn_6001_6002 01000 0 [BACKEND] WARNING: Failed to initialize the memory protect for g_instance.attr.attr_storage.cstore_buffers (128 Mbytes) or shared memory (4583 Mbytes) is larger.
2026-02-04 15:11:44.353 6982f130.1 [unknown] 281473000898592 [unknown] 0 dn_6001_6002 00000 0 [BACKEND] LOG: shared memory that key is 15400001 is owned by pid 3532749
2026-02-04 15:11:44.627 6982f130.1 [unknown] 281473000898592 [unknown] 0 dn_6001_6002 00000 0 [CACHE] LOG: set data cache size(100663296)
2026-02-04 15:11:45.005 6982f130.1 [unknown] 281473000898592 [unknown] 0 dn_6001_6002 00000 0 [SEGMENT_PAGE] LOG: Segment-page constants: DF_MAP_SIZE: 8156, DF_MAP_BIT_CNT: 65248, DF_MAP_GROUP_EXTENTS: 4175872, IPBLOCK_SIZE: 8168, EXTENTS_PER_IPBLOCK: 1021, IPBLOCK_GROUP_SIZE: 4090, BMT_HEADER_LEVEL0_TOTAL_PAGES: 8323072, BktMapEntryNumberPerBlock: 2038, BktMapBlockNumber: 25, BktBitMaxMapCnt: 512
2026-02-04 15:11:45.052 6982f130.1 [unknown] 281473000898592 [unknown] 0 dn_6001_6002 00000 0 [BACKEND] LOG: gaussdb: fsync file “/data/opengaussdb/install/data/dn/gaussdb.state.temp” success
2026-02-04 15:11:45.053 6982f130.1 [unknown] 281473000898592 [unknown] 0 dn_6001_6002 00000 0 [BACKEND] LOG: create gaussdb state file success: db state(STARTING_STATE), server mode(Standby), connection index(1)
2026-02-04 15:11:45.165 6982f130.1 [unknown] 281473000898592 [unknown] 0 dn_6001_6002 00000 0 [BACKEND] LOG: max_safe_fds = 974, usable_fds = 1000, already_open = 16
bbox_dump_path is set to /data/opengaussdb/corefile/
.[2026-02-04 15:11:46.285][3563639][gs_ctl]: waitpid 3563649 failed, exitstatus is 0, ret is 2

[2026-02-04 15:11:46.285][3563639][gs_ctl]: stopped waiting
[2026-02-04 15:11:46.285][3563639][gs_ctl]: could not start server
Examine the log output.

2

[omm@gauss102 dn]$ gs_om -t status --detail
[ CMServer State ]

node node_ip instance state

1 gauss102 172.16.0.XX 1 /data/opengaussdb/install/cm/cm_server Primary
2 gauss118 172.16.0.XX 2 /data/opengaussdb/install/cm/cm_server Standby

[ Cluster State ]

cluster_state : Degraded
redistributing : No
balanced : Yes
current_az : AZ_ALL

[ Datanode State ]

node node_ip instance state

1 gauss102 172.16.0.XX 6001 15400 /data/opengaussdb/install/data/dn P Primary Normal
2 gauss118 172.16.0.XX 6002 15400 /data/opengaussdb/install/data/dn S Down Manually stopped

3

[omm@gauss118 dn_6002]$ find $pglogdir -name ‘postgresql*.log’ -type f | xargs grep -nEH “database system is ready to accept connections|fast shutdown request” | sort
./postgresql-2026-02-04_144725.log:83:2026-02-04 14:47:25.825 6982eb7c.1 [unknown] 281473512988704 [unknown] 0 dn_6001_6002 00000 0 [BACKEND] LOG: received fast shutdown request
./postgresql-2026-02-04_151145.log:59:2026-02-04 15:11:45.310 6982f130.1 [unknown] 281473000898592 [unknown] 0 dn_6001_6002 00000 0 [BACKEND] LOG: received fast shutdown request

4

[omm@gauss118 om_monitor]$ free -g
total used free shared buff/cache available
Mem: 6 0 4 0 1 4
Swap: 0 0 0
[omm@gauss118 om_monitor]$ uname -a
Linux gauss118 5.10.0-60.139.0.166.oe2203.aarch64 #1 SMP Thu May 30 05:18:35 UTC 2024 aarch64 aarch64 aarch64 GNU/Linux
[omm@gauss118 om_monitor]$ cat /etc/os-release
NAME=“openEuler”
VERSION=“22.03 LTS”
ID=“openEuler”
VERSION_ID=“22.03”
PRETTY_NAME=“openEuler 22.03 LTS”
ANSI_COLOR=“0;31”

[omm@gauss118 om_monitor]$
opengaussdb 6.0.3

5

pg_log子目录下的启动失败时候的日志发一下看看

6

2026-02-04 14:23:20.405 6982e5d7.1 [unknown] 281473403101216 [unknown] 0 dn_6001_6002 00000 0 [BACKEND] LOG: auditor process 0 started, pid=281468145282688
2026-02-04 14:23:20.409 6982e5d8.6125 [unknown] 281468145282688 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] LOG: audit_process_cxt_init enter
2026-02-04 14:23:20.409 6982e5d8.6125 [unknown] 281468145282688 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] LOG: audit_process_cxt_init pipe init successfully for pipe : 0 file descriptor: 28
2026-02-04 14:23:20.411 6982e5d8.10000 [unknown] 281468111924864 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] LOG: reaper backend started.
2026-02-04 14:23:20.412 [MOT] TID:3480048/----- SID:-----/----- [INFO] Startup: Loading configuration from /data/opengaussdb/install/data/dn/mot.conf
2026-02-04 14:23:20.422 [MOT] TID:3480048/----- SID:-----/----- [INFO] Configuring total memory for relative memory values to: 2048 MB
2026-02-04 14:23:20.422 [MOT] TID:3480048/----- SID:-----/----- [INFO] Loading max_connections from envelope into MOTEngine: 5000
2026-02-04 14:23:20.422 [MOT] TID:3480048/----- SID:-----/----- [WARNING] Adjusted maximum number of threads to 4096 due to maximum limit
2026-02-04 14:23:20.422 [MOT] TID:3480048/----- SID:-----/----- [INFO] Configuring asynchronous redo-log handler due to synchronous_commit=off
2026-02-04 14:23:20.422 [MOT] TID:3480048/----- SID:-----/----- [WARNING] Adjusting MOT memory limits: global = 128 MB, local = 64 MB, session large store = 0 MB, total = 192 MB
2026-02-04 14:23:20.422 [MOT] TID:3480048/----- SID:-----/----- [INFO] Global Memory Limit is configured to: 0 MB → 128 MB
2026-02-04 14:23:20.422 [MOT] TID:3480048/----- SID:-----/----- [INFO] Local Memory Limit is configured to: 0 MB → 64 MB
2026-02-04 14:23:20.422 [MOT] TID:3480048/----- SID:-----/----- [INFO] Session Memory Limit is configured to: 0 KB → 0 KB (maximum 5000 sessions)
2026-02-04 14:23:20.422 [MOT] TID:3480048/----- SID:-----/----- [INFO] Configured automatic chunk allocation policy to ‘LOCAL’ on single node machine
2026-02-04 14:23:20.422 [MOT] TID:3480048/----- SID:-----/----- [WARNING] Allowing MOT to work in minimal memory mode
2026-02-04 14:23:20.428 6982e5d8.6125 [unknown] 281468145282688 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] LOG: audit_process_cxt_init success
2026-02-04 14:23:20.442 [MOT] TID:3480048/----- SID:-----/----- [INFO] Startup: Affinity initialized - numaNodes = 1, coresPerCpu = 4, sessionAffinityMode = 1, taskAffinityMode = 1
2026-02-04 14:23:20.464 [MOT] TID:3480048/04095 SID:-----/----- [INFO] Startup: All core services Initialized successfully
2026-02-04 14:23:20.464 [MOT] TID:3480048/04095 SID:-----/----- [INFO] Using synchronous redo log handler
2026-02-04 14:23:20.464 [MOT] TID:3480048/04095 SID:-----/----- [INFO] Using external logger
2026-02-04 14:23:20.464 [MOT] TID:3480048/04095 SID:-----/----- [INFO] Startup: Redo-log handler initialized successfully
2026-02-04 14:23:20.464 [MOT] TID:3480048/04095 SID:-----/----- [INFO] CheckpointControlFile: init - a previous checkpoint was not found
2026-02-04 14:23:20.464 [MOT] TID:3480048/04095 SID:-----/----- [INFO] MTLSRecoveryManager: Initialized successfully
2026-02-04 14:23:20.464 [MOT] TID:3480048/04095 SID:-----/----- [INFO] Startup: Recovery manager initialized successfully
2026-02-04 14:23:20.464 [MOT] TID:3480101/----- SID:-----/----- [INFO] CheckpointWorker0 - Starting
2026-02-04 14:23:20.465 [MOT] TID:3480101/00000 SID:00000/00000 [INFO] GC PARAMS:
2026-02-04 14:23:20.465 [MOT] TID:3480101/00000 SID:00000/00000 [INFO] QUEUE0:DELETE_QUEUE SizeLimit = 1KB, SizeLimitHigh = 8192KB, Count = 500
2026-02-04 14:23:20.465 [MOT] TID:3480101/00000 SID:00000/00000 [INFO] QUEUE1:VERSION_QUEUE SizeLimit = 100KB, SizeLimitHigh = 8192KB, Count = 1000
2026-02-04 14:23:20.465 [MOT] TID:3480101/00000 SID:00000/00000 [INFO] QUEUE2:UPDATE_COLUMN_QUEUE SizeLimit = 0KB, SizeLimitHigh = 8192KB, Count = 100000
2026-02-04 14:23:20.465 [MOT] TID:3480101/00000 SID:00000/00000 [INFO] QUEUE3:GENERIC_QUEUE SizeLimit = 100KB, SizeLimitHigh = 8192KB, Count = 1000
2026-02-04 14:23:20.466 [MOT] TID:3480102/----- SID:-----/----- [INFO] CheckpointWorker1 - Starting
2026-02-04 14:23:20.469 [MOT] TID:3480103/----- SID:-----/----- [INFO] CheckpointWorker2 - Starting
2026-02-04 14:23:20.471 [MOT] TID:3480048/04095 SID:-----/----- [INFO] Startup: Checkpoint manager initialized successfully
2026-02-04 14:23:20.471 [MOT] TID:3480048/04095 SID:-----/----- [INFO] Startup: MOT Engine initialization finished successfully
2026-02-04 14:23:20.471 [MOT] TID:3480048/04095 SID:-----/----- [INFO] Switching to External snapshot manager
2026-02-04 14:23:20.470 6982e5d7.1 [unknown] 281473403101216 [unknown] 0 dn_6001_6002 01000 0 [BACKEND] WARNING: Incremental Checkpoint is enabled, cannot create and operate on MOT tables (MOT does not support incremental checkpoint)
2026-02-04 14:23:20.471 [MOT] TID:3480048/04095 SID:-----/----- [INFO] MOT JIT execution is disabled by user configuration
2026-02-04 14:23:20.470 6982e5d7.1 [unknown] 281473403101216 [unknown] 0 dn_6001_6002 00000 0 [BACKEND] LOG: exrto_clean_dir: start to clean dir.
2026-02-04 14:23:20.471 6982e5d7.1 [unknown] 281473403101216 [unknown] 0 dn_6001_6002 00000 0 [BACKEND] LOG: start create thread!
2026-02-04 14:23:20.471 6982e5d7.1 [unknown] 281473403101216 [unknown] 0 dn_6001_6002 00000 0 [BACKEND] LOG: create thread end!
2026-02-04 14:23:20.471 6982e5d7.1 [unknown] 281473403101216 [unknown] 0 dn_6001_6002 01000 0 [BACKEND] WARNING: could not fork new process for connection due to PMstate PM_STARTUP
2026-02-04 14:23:20.471 6982e5d7.1 [unknown] 281473403101216 [unknown] 0 dn_6001_6002 00000 0 [BACKEND] LOG: not ready to start snapshot capturer.
2026-02-04 14:23:20.475 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 DB010 0 [REDO] LOG: [mpfl_ulink_file]: unlink global/max_page_flush_lsn sucessfully! ret:4294967295
2026-02-04 14:23:20.475 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 DB010 0 [BACKEND] LOG: StartupXLOG: biggest_lsn_in_page is set to FFFFFFFF/FFFFFFFF, enable_update_max_page_flush_lsn:0
2026-02-04 14:23:20.475 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] LOG: database system timeline: 11
2026-02-04 14:23:20.475 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] LOG: database system was interrupted while in recovery at log time 2026-02-04 11:58:27 CST
2026-02-04 14:23:20.475 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] HINT: If this has occurred more than once some data might be corrupted and you might need to choose an earlier recovery target.
2026-02-04 14:23:20.482 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] LOG: entering standby mode
2026-02-04 14:23:20.482 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 00000 0 [DBL_WRT] LOG: Init of double write for ext finished.
2026-02-04 14:23:20.482 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 00000 0 [DBL_WRT] LOG: Double Write init
2026-02-04 14:23:20.488 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 00000 0 [DBL_WRT] LOG: Found a valid batch meta file info: dw_file_num [1], dw_file_size [256] MB, dw_version [92568]
2026-02-04 14:23:20.501 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 00000 0 [DBL_WRT] LOG: Found a valid batch meta file info: dw_file_num [1], dw_file_size [256] MB, dw_version [92568]
2026-02-04 14:23:20.513 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 00000 0 [DBL_WRT] LOG: Found a valid batch file header: id 0, file_head[dwn 13, start 17940]
2026-02-04 14:23:20.518 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 00000 0 [DBL_WRT] LOG: Found a valid single file header: id 0, file_head[dwn 7, start 0]
2026-02-04 14:23:20.522 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 00000 0 [DBL_WRT] LOG: Found a valid single file header: id 0, file_head[dwn 7, start 0]
2026-02-04 14:23:20.528 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 00000 0 [DBL_WRT] LOG: DW batch flush file recovery start.
2026-02-04 14:23:20.537 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 00000 0 [DBL_WRT] LOG: DW recovery state: “Empty”, file start page[dwn 13, start 17940], now access page 0, current [page_id 17940, dwn 13, checksum verify res is 1, page_num orig 0, page_num fixed 0]
2026-02-04 14:23:20.537 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 00000 0 [DBL_WRT] LOG: DW recovery state: “Finish”, file start page[dwn 13, start 17940], now access page 0, current [page_id 17940, dwn 13, checksum verify res is 1, page_num orig 0, page_num fixed 0]
2026-02-04 14:23:20.537 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 00000 0 [DBL_WRT] LOG: DW batch flush file recovery finish.
2026-02-04 14:23:20.537 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 00000 0 [DBL_WRT] LOG: DW single flush file recovery start.
2026-02-04 14:23:20.538 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 00000 0 [DBL_WRT] LOG: [single flush] recovery, [first version] dw page is new, break this recovery: buf_tag[rel 0/0/0 blk 0 fork 0], compress: 0
2026-02-04 14:23:20.539 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 00000 0 [DBL_WRT] LOG: [second version] DW single flush file valid item num is 0.
2026-02-04 14:23:20.539 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 00000 0 [DBL_WRT] LOG: DW single flush file recovery finish.
2026-02-04 14:23:20.542 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 00000 0 [DBL_WRT] LOG: DW single flush finish recovery, reset the file head[dwn 8, start 0].
2026-02-04 14:23:20.551 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 00000 0 [DBL_WRT] LOG: DW single flush finish recovery [second version], reset the file head[dwn 8, start 0].
2026-02-04 14:23:20.590 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 00000 0 [UNDO] LOG: [exrto_recycle_residual_undo_file:720]exrto_recycle_residual_undo_file begin uZoneCount is 25, FuncName:recovery_meta.
2026-02-04 14:23:20.590 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 00000 0 [UNDO] LOG: [exrto_recycle_residual_undo_file:738]exrto_recycle_residual_undo_file release record_file_cnt:0, slot_file_cnt:0.
2026-02-04 14:23:20.590 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 22000 0 [BACKEND] LOG: recovery_meta: undo recovery finish.
2026-02-04 14:23:20.590 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] LOG: redo record is at 1/1EED8848; shutdown TRUE
2026-02-04 14:23:20.591 [MOT] TID:3480104/00003 SID:00003/00003 [INFO] Starting MOT recovery

7

2026-02-04 14:23:20.591 [MOT] TID:3480104/00003 SID:00003/00003 [INFO] Registered current thread for proc-exit callback for thread 0xfffe38dcae80
2026-02-04 14:23:20.591 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] LOG: GTM-Free Mode: start local next csn from checkpoint 9076974, next xid 9144766
2026-02-04 14:23:20.591 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] LOG: Startup: write global globalRecycleXid 9144753 from checkpoint 9144753
2026-02-04 14:23:20.591 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] LOG: Startup: write hotStandbyRecycleXid 0
2026-02-04 14:23:20.591 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] LOG: last CBM file name “pg_xlog_3_0000000091643760_0000000000000000.cbm”, seqnum 3, start LSN 00000000/91643760, end LSN 00000000/00000000
2026-02-04 14:23:20.591 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] LOG: last CBM file name “pg_xlog_3_0000000091643760_0000000000000000.cbm”, lastfileSize 12405248, tracked LSN 00000001/1EED7CF0
2026-02-04 14:23:20.591 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] LOG: set CBM tracked LSN point: 00000001/1EED7CF0
2026-02-04 14:23:20.593 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] LOG: startup csnlog without extend at xid:9144765, pageno:8930
2026-02-04 14:23:20.593 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 DB010 0 [REDO] LOG: Recovery parallelism, cpu count = 4, max = 4, actual = 4
2026-02-04 14:23:20.593 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 DB010 0 [REDO] LOG: ConfigRecoveryParallelism, true_max_recovery_parallelism:4, max_recovery_parallelism:4
2026-02-04 14:23:20.593 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] LOG: ===Not in the streaming DR switchover===
2026-02-04 14:23:20.593 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] LOG: StartupXLOG PrintCkpXctlControlFile: [checkPoint] oldCkpLoc:1/1EED8848, oldRedo:1/1EED8848, newCkpLoc:1/1EED8848, newRedo:1/1EED8848, preCkpLoc:1/1EED8848
2026-02-04 14:23:20.598 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] LOG: [Pgstat] remove statfiles in pg_stat_tmp/pgstat.stat, global/pgstat.stat
2026-02-04 14:23:20.612 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] LOG: redo minRecoveryPoint at 1/1EED8848; backupStartPoint at 0/0; backupEndPoint at 0/0;backupEndRequired FALSE
2026-02-04 14:23:20.612 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] LOG: consistent recovery state reached at 1/1EED88E8
2026-02-04 14:23:20.612 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 DB010 0 [REDO] LOG: [REDO_STATS]redo_dump_all_stats: the basic statistic during redo are as follows : redo_start_ptr:00000001/1EED8848, redo_start_time:823501400482214, min_recovery_point:00000001/1EED8848, read_ptr:00000001/1EED8848, last_replayed_read_Ptr:00000000/00000000, speed:0 KB/s
2026-02-04 14:23:20.612 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 DB010 0 [REDO] LOG: [REDO_STATS]redo_dump_all_stats WAIT_READ_XLOG: the event io statistic during redo are as follows : total_duration:8, counter:1
2026-02-04 14:23:20.612 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 DB010 0 [REDO] LOG: [REDO_STATS]redo_dump_all_stats WAIT_READ_DATA: the event io statistic during redo are as follows : total_duration:0, counter:0
2026-02-04 14:23:20.612 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 DB010 0 [REDO] LOG: [REDO_STATS]redo_dump_all_stats WAIT_WRITE_DATA: the event io statistic during redo are as follows : total_duration:0, counter:0
2026-02-04 14:23:20.612 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 DB010 0 [REDO] LOG: [REDO_STATS]redo_dump_all_stats WAIT_PROCESS_PENDING: the event io statistic during redo are as follows : total_duration:0, counter:0
2026-02-04 14:23:20.612 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 DB010 0 [REDO] LOG: [REDO_STATS]redo_dump_all_stats WAIT_APPLY: the event io statistic during redo are as follows : total_duration:0, counter:0
2026-02-04 14:23:20.612 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 DB010 0 [REDO] LOG: [REDO_STATS]redo_unlink_stats_file: unlink redo.state sucessfully!, ret:-1
2026-02-04 14:23:20.612 6982e5d8.6126 [unknown] 281467340762752 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] LOG: send signal to be hot standby at 1/1EED88E8
2026-02-04 14:23:20.618 6982e5d8.6129 [unknown] 281467096379008 dn_6002 0 dn_6001_6002 00000 0 [INCRE_CKPT] LOG: pagewriter started, thread id is 0
2026-02-04 14:23:20.620 6982e5d8.6131 [unknown] 281467079536256 dn_6002 0 dn_6001_6002 00000 0 [INCRE_CKPT] LOG: pagewriter started, thread id is 1
2026-02-04 14:23:20.623 6982e5d8.6133 [unknown] 281467122134656 dn_6002 0 dn_6001_6002 00000 0 [INCRE_CKPT] LOG: pagewriter started, thread id is 2
2026-02-04 14:23:20.628 6982e5d8.6134 [unknown] 281467030843008 dn_6002 0 dn_6001_6002 00000 0 [INCRE_CKPT] LOG: pagewriter started, thread id is 3
2026-02-04 14:23:20.628 6982e5d7.1 [unknown] 281473403101216 [unknown] 0 dn_6001_6002 00000 0 [BACKEND] LOG: gaussdb: fsync file “/data/opengaussdb/install/data/dn/gaussdb.state.temp” success
2026-02-04 14:23:20.628 6982e5d7.1 [unknown] 281473403101216 [unknown] 0 dn_6001_6002 00000 0 [BACKEND] LOG: update gaussdb state file: db state(NORMAL_STATE), server mode(Standby)
2026-02-04 14:23:20.628 6982e5d7.1 [unknown] 281473403101216 [unknown] 0 dn_6001_6002 00000 0 [BACKEND] LOG: database system is ready to accept read only connections
2026-02-04 14:23:20.628 6982e5d8.6130 [unknown] 281467147824768 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] LOG: cbm writer started
2026-02-04 14:23:20.628 6982e5d8.6130 [unknown] 281467147824768 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] LOG: The xlog LSN to be parsed 00000001/1EED8848 is larger than already tracked xlog LSN 00000001/1EED7CF0. Do CBM track one time
2026-02-04 14:23:20.629 6982e5d7.1 [unknown] 281473403101216 [unknown] 0 dn_6001_6002 00000 0 [BACKEND] LOG: sigusr1_handler create WalWriterAuxiliary(281466878340736) after local recovery is done. pmState:3, ServerMode:3
2026-02-04 14:23:20.629 6982e5d8.6130 [unknown] 281467147824768 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] LOG: reach CBM parse end. The next xlog record starts at 00000001/1EED8848
2026-02-04 14:23:20.631 6982e5d8.6127 [unknown] 281467187670656 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] LOG: checkpointer started, CheckPointTimeout is 60
2026-02-04 14:23:20.633 6982e5d8.6128 [unknown] 281467170827904 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] LOG: invalidate buffer bgwriter started
2026-02-04 14:23:20.634 6982e5d8.5069 [unknown] 281466861497984 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] LOG: CfsShrinker started
2026-02-04 14:23:20.635 6982e5d8.6132 [unknown] 281467053977216 dn_6002 0 dn_6001_6002 00000 0 [INCRE_CKPT] LOG: pagewriter started, thread id is 4
2026-02-04 14:23:20.636 6982e5d8.6136 [unknown] 281466827812480 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] LOG: heartbeat thread started
2026-02-04 14:23:20.638 6982e5d8.1225 [unknown] 281467010854528 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] LOG: [Pgstat] statfile global/pgstat.stat is missing, using empty dbhash.
2026-02-04 14:23:20.639 6982e5d8.6130 [unknown] 281467147824768 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] LOG: set CBM tracked LSN point: 00000001/1EED8848
2026-02-04 14:23:20.649 6982e5d8.6137 [unknown] 281466878340736 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] LOG: walwriterauxiliary started
2026-02-04 14:23:20.658 6982e5d8.5067 [unknown] 281466810969728 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] LOG: global stats collector started
2026-02-04 14:23:20.672 6982e5d8.5068 postgres 281466844655232 Statement flush thread 0 dn_6001_6002 00000 0 [BACKEND] LOG: statement flush thread start
2026-02-04 14:23:20.673 6982e5d7.1 [unknown] 281473403101216 [unknown] 0 dn_6001_6002 00000 0 [BACKEND] LOG: received fast shutdown request
2026-02-04 14:23:20.673 6982e5d7.1 [unknown] 281473403101216 [unknown] 0 dn_6001_6002 00000 0 [BACKEND] LOG: send to startup shutdown request
2026-02-04 14:23:20.673 6982e5d7.1 [unknown] 281473403101216 [unknown] 0 dn_6001_6002 00000 0 [BACKEND] LOG: wlm collect worker process shutting down.
2026-02-04 14:23:20.674 6982e5d7.1 [unknown] 281473403101216 [unknown] 0 dn_6001_6002 00000 0 [BACKEND] LOG: aborting any active transactions
2026-02-04 14:23:20.674 6982e5d8.6128 [unknown] 281467170827904 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] LOG: invalidate buffer bgwriter thread shut down
2026-02-04 14:23:20.674 6982e5d8.5069 [unknown] 281466861497984 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] LOG: CfsShrinker signaled: SIGTERM
2026-02-04 14:23:20.674 6982e5d8.5069 [unknown] 281466861497984 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] LOG: cfs shrinker is shutting down.
2026-02-04 14:23:20.676 6982e5d8.5066 postgres 281466728590976 gs_ctl 0 dn_6001_6002 57P01 0 [BACKEND] FATAL: terminating connection due to administrator command
2026-02-04 14:23:20.676 [postmaster][reaper][281473403101216] WARNING: Did not found reaper thread id 281466861497984 in backend list, with 0 thread still alive,last thread role 0, may has leak occurs
2026-02-04 14:23:20.676 6982e5d8.5067 [unknown] 281466810969728 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] LOG: global stats shutting down
2026-02-04 14:23:20.684 6982e5d8.5068 postgres 281466844655232 Statement flush thread 0 dn_6001_6002 00000 0 [BACKEND] LOG: Mem-file chain of standby_statement_history_fast init done and online.
2026-02-04 14:23:20.689 6982e5d8.5068 postgres 281466844655232 Statement flush thread 0 dn_6001_6002 00000 0 [BACKEND] LOG: Mem-file chain of standby_statement_history_slow init done and online.
2026-02-04 14:23:20.689 6982e5d8.5068 postgres 281466844655232 Statement flush thread 0 dn_6001_6002 00000 0 [INSTR] LOG: MemFileChain destory start, clean is 0.
2026-02-04 14:23:20.689 6982e5d8.5068 postgres 281466844655232 Statement flush thread 0 dn_6001_6002 00000 0 [BACKEND] LOG: Mem-file chain of standby_statement_history_fast light destory.
2026-02-04 14:23:20.691 6982e5d8.5068 postgres 281466844655232 Statement flush thread 0 dn_6001_6002 00000 0 [INSTR] LOG: MemFileChain destory start, clean is 0.
2026-02-04 14:23:20.691 6982e5d8.5068 postgres 281466844655232 Statement flush thread 0 dn_6001_6002 00000 0 [BACKEND] LOG: Mem-file chain of standby_statement_history_slow light destory.
2026-02-04 14:23:21.515 6982e5d7.1 [unknown] 281473403101216 [unknown] 0 dn_6001_6002 01000 0 [BACKEND] WARNING: could not fork new process for connection due to PMstate PM_WAIT_BACKENDS
2026-02-04 14:23:21.576 [postmaster][reaper][281473403101216] LOG: startupprocess exit
2026-02-04 14:23:21.576 6982e5d7.1 [unknown] 281473403101216 [unknown] 0 dn_6001_6002 DB010 0 [REDO] LOG: page workers all exit or not open parallel redo
2026-02-04 14:23:21.576 6982e5d7.1 [unknown] 281473403101216 [unknown] 0 dn_6001_6002 00000 0 [BACKEND] LOG: all build walsenders exited
2026-02-04 14:23:21.588 6982e5d8.6127 [unknown] 281467187670656 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] LOG: shutting down
2026-02-04 14:23:21.652 6982e5d8.6129 [unknown] 281467096379008 dn_6002 0 dn_6001_6002 00000 0 [INCRE_CKPT] LOG: waiting all the pagewriter sub threads to exit
2026-02-04 14:23:21.652 6982e5d8.6134 [unknown] 281467030843008 dn_6002 0 dn_6001_6002 00000 0 [INCRE_CKPT] LOG: pagewriter thread shut down, id is 3
2026-02-04 14:23:21.652 6982e5d8.6133 [unknown] 281467122134656 dn_6002 0 dn_6001_6002 00000 0 [INCRE_CKPT] LOG: pagewriter thread shut down, id is 2
2026-02-04 14:23:21.652 6982e5d8.6132 [unknown] 281467053977216 dn_6002 0 dn_6001_6002 00000 0 [INCRE_CKPT] LOG: pagewriter thread shut down, id is 4
2026-02-04 14:23:21.653 6982e5d8.6131 [unknown] 281467079536256 dn_6002 0 dn_6001_6002 00000 0 [INCRE_CKPT] LOG: pagewriter thread shut down, id is 1
2026-02-04 14:23:21.654 6982e5d8.6129 [unknown] 281467096379008 dn_6002 0 dn_6001_6002 00000 0 [INCRE_CKPT] LOG: pagewriter thread shut down, id is 0
2026-02-04 14:23:21.659 6982e5d8.6127 [unknown] 281467187670656 dn_6002 0 dn_6001_6002 00000 0 [DBL_WRT] LOG: Double write exit
2026-02-04 14:23:21.659 6982e5d8.6127 [unknown] 281467187670656 dn_6002 0 dn_6001_6002 00000 0 [DBL_WRT] LOG: Double write exit
2026-02-04 14:23:21.660 6982e5d8.6127 [unknown] 281467187670656 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] LOG: database system is shut down
2026-02-04 14:23:21.661 [postmaster][reaper][281473403101216] LOG: checkpoint thread exit and nowait for sharestorage
2026-02-04 14:23:21.661 6982e5d7.1 [unknown] 281473403101216 [unknown] 0 dn_6001_6002 00000 0 [BACKEND] LOG: All obsArch and obsBarrier exit.
2026-02-04 14:23:21.662 6982e5d7.1 [unknown] 281473403101216 [unknown] 0 dn_6001_6002 00000 0 [BACKEND] LOG: All obsArch and obsBarrier exit.
2026-02-04 14:23:21.685 6982e5d8.6125 [unknown] 281468145282688 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] LOG: auditor thread exit, id : 0
2026-02-04 14:23:21.685 6982e5d8.6125 [unknown] 281468145282688 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] LOG: auditor shutting down
2026-02-04 14:23:21.687 6982e5d7.1 [unknown] 281473403101216 [unknown] 0 dn_6001_6002 00000 0 [BACKEND] LOG: All obsArch and obsBarrier exit.
2026-02-04 14:23:22.554 6982e5d7.1 [unknown] 281473403101216 [unknown] 0 dn_6001_6002 01000 0 [BACKEND] WARNING: could not fork new process for connection due to PMstate PM_SHUTDOWN_2
2026-02-04 14:23:22.680 6982e5d8.6136 [unknown] 281466827812480 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] LOG: Stop the heartbeat server.
2026-02-04 14:23:22.680 6982e5d8.6136 [unknown] 281466827812480 dn_6002 0 dn_6001_6002 00000 0 [BACKEND] LOG: heartbeat thread shut down
2026-02-04 14:23:22.681 6982e5d7.1 [unknown] 281473403101216 [unknown] 0 dn_6001_6002 00000 0 [BACKEND] LOG: All obsArch and obsBarrier exit.
2026-02-04 14:23:22.681 6982e5d7.1 [unknown] 281473403101216 [unknown] 0 dn_6001_6002 00000 0 [BACKEND] LOG: All Audit threads exit.
2026-02-04 14:23:22.681 6982e5d7.1 [unknown] 281473403101216 [unknown] 0 dn_6001_6002 00000 0 [BACKEND] LOG: All obsArch and obsBarrier exit.
2026-02-04 14:23:22.682 [MOT] TID:3480048/04095 SID:-----/----- [INFO] Shutdown: Shutting down MOT Engine
2026-02-04 14:23:22.682 [MOT] TID:3480048/04095 SID:-----/----- [INFO] Shutdown: All background tasks stopped
2026-02-04 14:23:22.682 [MOT] TID:3480048/04095 SID:-----/----- [INFO] Destroying the Checkpoint Manager
2026-02-04 14:23:22.683 [MOT] TID:3480101/----- SID:-----/----- [INFO] CheckpointWorker0 - Exiting
2026-02-04 14:23:22.683 [MOT] TID:3480103/----- SID:-----/----- [INFO] CheckpointWorker2 - Exiting
2026-02-04 14:23:22.684 [MOT] TID:3480102/----- SID:-----/----- [INFO] CheckpointWorker1 - Exiting
2026-02-04 14:23:22.684 [MOT] TID:3480048/04095 SID:-----/----- [INFO] Destroying the Recovery Manager
2026-02-04 14:23:22.684 [MOT] TID:3480048/04095 SID:-----/----- [INFO] Destroying the Redo Log Handler
2026-02-04 14:23:22.684 [MOT] TID:3480048/04095 SID:-----/----- [INFO] Shutdown: All tables cleared
2026-02-04 14:23:22.684 [MOT] TID:3480048/04095 SID:-----/----- [INFO] Shutdown: Key surrogate manager destroyed
2026-02-04 14:23:22.684 [MOT] TID:3480048/04095 SID:-----/----- [INFO] Shutdown: Table manager destroyed
2026-02-04 14:23:22.684 [MOT] TID:3480048/04095 SID:-----/----- [INFO] Shutdown: Session manager destroyed
2026-02-04 14:23:22.684 [MOT] TID:3480048/04095 SID:-----/----- [INFO] Kernel allocation MM Layer Pre-Shutdown Report report:
NUMA Interleaved memory usage: Current = 1 MB, Peak = 1 MB
NUMA Local memory usage: Current = 41 MB, Peak = 61 MB

2026-02-04 14:23:22.690 [MOT] TID:3480048/04095 SID:-----/----- [INFO] Huge memory: 0 MB Used, 0 MB Requested, 0 objects

2026-02-04 14:23:22.690 [MOT] TID:3480048/04095 SID:-----/----- [INFO] Kernel allocation MM Layer Post-Shutdown Report report:
NUMA Interleaved memory usage: Current = 0 MB, Peak = 1 MB
NUMA Local memory usage: Current = 0 MB, Peak = 61 MB

2026-02-04 14:23:22.690 [MOT] TID:3480048/04095 SID:-----/----- [INFO] Memory Management Layer destroyed
2026-02-04 14:23:22.691 [MOT] TID:3480048/04095 SID:-----/----- [INFO] Shutdown: Statistics module Destroyed
2026-02-04 14:23:22.691 [MOT] TID:3480048/----- SID:-----/----- [INFO] Shutdown: All core services Destroyed
2026-02-04 14:23:22.691 [MOT] TID:3480048/----- SID:-----/----- [INFO] Shutdown: Configuration module Destroyed
2026-02-04 14:23:22.691 [MOT] TID:3480048/----- SID:-----/----- [INFO] Shutdown: MOT Engine shutdown finished
2026-02-04 14:23:22.857 6982e5d7.1 [unknown] 281473403101216 [unknown] 0 dn_6001_6002 00000 0 [BACKEND] LOG: FiniNuma allocIndex: 0.
2026-02-04 14:23:22.858 6982e5d7.1 [unknown] 281473403101216 [unknown] 0 dn_6001_6002 00000 0 [BACKEND] LOG: Gaussdb exit(0)

8

postgresql-2026-02-04_142320.txt (33.7 KB)

9

启动时候的gs_ctl … -l logfile，发一下启动的logfile看看