7.0.0-RC3版本报I/O error错,6.0.5 (LTS)正常

问题求助
1

部署了7.0.0-RC3的极简版镜像,springboot2项目配置如下:

image
image930×348 32.7 KB

启动后,大部分sql正常,有2个表的分页sql出现如下错误,7.0.0-RC3尝试过切换驱动为org.opengauss.Driver,报错方言存在,项目比较老,不好改. 最后切换6.0.5后正常.

2026-05-28 17:23:36 [pool-1-定时任务-8] WARN traceId com.zaxxer.hikari.pool.PoolBase -HikariPool-1 - Failed to validate connection org.postgresql.jdbc.PgConnection@6ea75f75 (This connection has been closed.). Possibly consider using a shorter maxLifetime value.
2026-05-28 17:23:36 [http-nio-18080-exec-89] WARN traceId[0a234297202605281723231980e0e3f6] c.zaxxer.hikari.pool.ProxyConnection -HikariPool-1 - Connection org.postgresql.jdbc.PgConnection@5dcbf15e marked as broken because of SQLSTATE(08006), ErrorCode(0)
org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:458)

2

看着时JDBC连接超时了，业务有做保活吗

3

@wzy_openGauss 有的,我也尝试了重启数据库,重启项目后直接去访问,也是报这个错. 别的sql都正常,就2个字段比较多的表出现这个问题. 跟我使用pg的驱动有关吗?

4

你们没用openGauss自己的驱动吗

5

@wzy_openGauss

刚看了下,每次执行有问题的sql后,容器崩溃又自动恢复了.docker状态OOMKilled是false,ExitCode是0,容器资源也没有被打爆. 我看了pg_log目录下的日志,看不出来错误.下面是日志文件:

2026-06-01 03:01:39.663 [unknown] [unknown] localhost 140420664045568 0[0:0#0] 0 [BACKEND] LOG: auditor process 0 started, pid=140416723969536
2026-06-01 03:01:39.666 [unknown] [unknown] localhost 140420664045568 0[0:0#0] 0 [BACKEND] WARNING: datavec PQ init failed, ret: -1
2026-06-01 03:01:39.666 [unknown] [unknown] localhost 140420664045568 0[0:0#0] 0 [BACKEND] WARNING: datavec diskann PQ init failed, ret: -1
2026-06-01 03:01:39.666 [unknown] [unknown] localhost 140420664045568 0[0:0#0] 0 [BACKEND] LOG: exrto_clean_dir: start to clean dir.
2026-06-01 03:01:39.667 [unknown] [unknown] localhost 140420664045568 0[0:0#0] 0 [BACKEND] LOG: start create thread!
2026-06-01 03:01:39.667 [unknown] [unknown] localhost 140420664045568 0[0:0#0] 0 [BACKEND] LOG: create thread end!
2026-06-01 03:01:39.670 [unknown] [unknown] localhost 140420664045568 0[0:0#0] 0 [BACKEND] WARNING: could not fork new process for connection due to PMstate PM_STARTUP
2026-06-01 03:01:39.670 [unknown] [unknown] localhost 140420664045568 0[0:0#0] 0 [BACKEND] LOG: not ready to start snapshot capturer.
2026-06-01 03:01:39.670 [unknown] [unknown] localhost 140416689108480 0[0:0#0] 0 [BACKEND] LOG: reaper backend started.
2026-06-01 03:01:39.674 [unknown] [unknown] localhost 140416723969536 0[0:0#0] 0 [BACKEND] LOG: audit_process_cxt_init enter
2026-06-01 03:01:39.674 [unknown] [unknown] localhost 140416723969536 0[0:0#0] 0 [BACKEND] LOG: audit_process_cxt_init pipe init successfully for pipe : 0 file descriptor: 22
2026-06-01 03:01:39.677 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [REDO] LOG: [mpfl_ulink_file]: unlink global/max_page_flush_lsn sucessfully! ret:4294967295
2026-06-01 03:01:39.677 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [BACKEND] LOG: StartupXLOG: biggest_lsn_in_page is set to 7FFFFFFF/FFFFFFFF, enable_update_max_page_flush_lsn:0
2026-06-01 03:01:39.677 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [BACKEND] LOG: database system timeline: 29
2026-06-01 03:01:39.677 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [BACKEND] LOG: database system was interrupted; last known up at 2026-06-01 03:00:58 UTC
2026-06-01 03:01:39.679 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [DBL_WRT] LOG: Init of double write for ext finished.
2026-06-01 03:01:39.679 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [DBL_WRT] LOG: Double Write init
2026-06-01 03:01:39.679 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [DBL_WRT] LOG: Found a valid batch meta file info: dw_file_num [1], dw_file_size [256] MB, dw_version [92568]
2026-06-01 03:01:39.680 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [DBL_WRT] LOG: Found a valid batch meta file info: dw_file_num [1], dw_file_size [256] MB, dw_version [92568]
2026-06-01 03:01:39.689 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [DBL_WRT] LOG: Found a valid batch file header: id 0, file_head[dwn 13, start 14860]
2026-06-01 03:01:39.691 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [DBL_WRT] LOG: DW batch flush file recovery start.
2026-06-01 03:01:39.739 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [DBL_WRT] LOG: DW recovery state: “Empty”, file start page[dwn 13, start 14860], now access page 0, current [page_id 14860, dwn 13, checksum verify res is 1, page_num orig 0, page_num fixed 0]
2026-06-01 03:01:39.739 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [DBL_WRT] LOG: DW recovery state: “Finish”, file start page[dwn 13, start 14860], now access page 0, current [page_id 14860, dwn 13, checksum verify res is 1, page_num orig 0, page_num fixed 0]
2026-06-01 03:01:39.739 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [DBL_WRT] LOG: DW batch flush file recovery finish.
2026-06-01 03:01:39.739 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [DBL_WRT] LOG: DW single flush file recovery start.
2026-06-01 03:01:39.762 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 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-06-01 03:01:39.773 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [DBL_WRT] LOG: [second version] DW single flush file valid item num is 0.
2026-06-01 03:01:39.774 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [DBL_WRT] LOG: DW single flush file recovery finish.
2026-06-01 03:01:39.774 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [DBL_WRT] LOG: DW single flush finish recovery, reset the file head[dwn 62, start 0].
2026-06-01 03:01:39.775 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [DBL_WRT] LOG: DW single flush finish recovery [second version], reset the file head[dwn 62, start 0].
2026-06-01 03:01:39.798 [unknown] [unknown] localhost 140416723969536 0[0:0#0] 0 [BACKEND] LOG: audit_process_cxt_init success
2026-06-01 03:01:39.875 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [UNDO] LOG: [exrto_recycle_residual_undo_file:720]exrto_recycle_residual_undo_file begin uZoneCount is 0, FuncName:recovery_meta.
2026-06-01 03:01:39.875 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [UNDO] LOG: [exrto_recycle_residual_undo_file:725]exrto_recycle_residual_undo_file uZoneCount is zero or uZones is null.
2026-06-01 03:01:39.875 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [BACKEND] LOG: recovery_meta: undo recovery finish.
2026-06-01 03:01:39.875 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [BACKEND] LOG: redo record is at 0/7DD05DF0; shutdown FALSE
2026-06-01 03:01:39.875 [MOT] TID:00037/----- SID:-----/----- [INFO] start check if there are mot tables
2026-06-01 03:01:39.876 [MOT] TID:00037/----- SID:-----/----- [INFO] CheckpointControlFile: init - a previous checkpoint was not found
2026-06-01 03:01:39.876 [MOT] TID:00037/----- SID:-----/----- [WARNING] CheckpointUtils: invalid ctrl file id
2026-06-01 03:01:39.875 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [BACKEND] LOG: GTM-Free Mode: start local next csn from checkpoint 13255, next xid 36575
2026-06-01 03:01:39.875 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [BACKEND] LOG: Startup: write global globalRecycleXid 36219 from checkpoint 36219
2026-06-01 03:01:39.875 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [BACKEND] LOG: Startup: write hotStandbyRecycleXid 0
2026-06-01 03:01:39.875 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [BACKEND] LOG: Mark CBM Writer reset is true.
2026-06-01 03:01:39.875 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [BACKEND] LOG: startup csnlog without extend at xid:36574, pageno:35
2026-06-01 03:01:39.876 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [BACKEND] LOG: ===Not in the streaming DR switchover===
2026-06-01 03:01:39.876 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [BACKEND] LOG: database system was not properly shut down; automatic recovery in progress
2026-06-01 03:01:39.876 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [BACKEND] LOG: StartupXLOG PrintCkpXctlControlFile: [checkPoint] oldCkpLoc:0/7DD05E70, oldRedo:0/7DD05DF0, newCkpLoc:0/7DD05E70, newRedo:0/7DD05DF0, preCkpLoc:0/7DD05CD0
2026-06-01 03:01:39.877 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [BACKEND] LOG: [Pgstat] remove statfiles in pg_stat_tmp/pgstat.stat, global/pgstat.stat
2026-06-01 03:01:39.883 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [BACKEND] LOG: redo minRecoveryPoint at 0/0; backupStartPoint at 0/0; backupEndPoint at 0/0;backupEndRequired FALSE
2026-06-01 03:01:39.883 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [BACKEND] LOG: redo starts at 0/7DD05DF0
2026-06-01 03:01:39.883 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [BACKEND] LOG: set knl_g_set_redo_finish_status to false when starting redo
2026-06-01 03:01:39.888 [unknown] [unknown] localhost 140420664045568 0[0:0#0] 0 [BACKEND] LOG: not ready to start snapshot capturer.
2026-06-01 03:01:39.891 [unknown] [unknown] localhost 140416579532288 0[0:0#0] 0 [BACKEND] LOG: checkpointer started, CheckPointTimeout is 60
2026-06-01 03:01:39.894 [unknown] [unknown] localhost 140416494073344 0[0:0#0] 0 [INCRE_CKPT] LOG: pagewriter started, thread id is 0
2026-06-01 03:01:39.895 [unknown] [unknown] localhost 140416472512000 0[0:0#0] 0 [INCRE_CKPT] LOG: pagewriter started, thread id is 1
2026-06-01 03:01:39.897 [unknown] [unknown] localhost 140416562750976 0[0:0#0] 0 [BACKEND] LOG: invalidate buffer bgwriter started
2026-06-01 03:01:39.983 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [BACKEND] LOG: set knl_g_set_redo_finish_status to true when redo done
2026-06-01 03:01:39.983 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [BACKEND] LOG: redo done at 0/7DD05F40, end at 0/7DD05F90
2026-06-01 03:01:39.983 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [REDO] LOG: [PR]: Recoverying elapsed: 100402 us, redoTotalBytes:416,EndRecPtr:2110807952, redoStartPtr:2110807536,speed:0 MB/s, totalTime:100402
2026-06-01 03:01:39.983 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [REDO] LOG: [REDO_STATS]redo_unlink_stats_file: unlink redo.state sucessfully!, ret:-1
2026-06-01 03:01:39.983 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [REDO] LOG: [REDO_STATS]redo_dump_all_stats: the basic statistic during redo are as follows : redo_start_ptr:00000000/7DD05DF0, redo_start_time:833598099679179, min_recovery_point:00000000/00000000, read_ptr:00000000/7DD05F40, last_replayed_read_Ptr:00000000/7DD05F90, speed:0 KB/s
2026-06-01 03:01:39.983 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [REDO] LOG: [REDO_STATS]redo_dump_all_stats WAIT_READ_XLOG: the event io statistic during redo are as follows : total_duration:22, counter:1
2026-06-01 03:01:39.983 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 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-06-01 03:01:39.983 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 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-06-01 03:01:39.983 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 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-06-01 03:01:39.983 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 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-06-01 03:01:39.984 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [BACKEND] LOG: startup shut down datareceiver.
2026-06-01 03:01:39.989 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [REDO] LOG: btree_xlog_cleanup is over, it takes time:1 microseconds
2026-06-01 03:01:39.989 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [REDO] LOG: UBTreeXlogCleanup is over, it takes time:0 microseconds
2026-06-01 03:01:39.998 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [BACKEND] LOG: redo done, nextXid: 36930, startupMaxXid: 36930, recentLocalXmin: 36575, recentGlobalXmin: 36575, PendingPreparedXacts: 0, NextCommitSeqNo: 13255, cutoff_csn_min: 0.
2026-06-01 03:01:40.1 [postmaster][reaper][140420664045568] LOG: startupprocess exit
2026-06-01 03:01:40.019 [unknown] [unknown] localhost 140416355137024 0[0:0#0] 0 [BACKEND] LOG: walwriterauxiliary started
2026-06-01 03:01:40.020 [unknown] [unknown] localhost 140416290125312 0[0:0#0] 0 [BACKEND] LOG: job scheduler started
2026-06-01 03:01:40.027 [unknown] [unknown] localhost 140416338355712 0[0:0#0] 0 [BACKEND] LOG: imcstore vacuum worker started
2026-06-01 03:01:40.028 [unknown] [unknown] localhost 140420664045568 0[0:0#0] 0 [BACKEND] LOG: gaussdb: fsync file “/var/lib/opengauss/data/gaussdb.state.temp” success
2026-06-01 03:01:40.29 [postmaster][reaper][140420664045568] LOG: update gaussdb state file: db state(NORMAL_STATE), server mode(Normal)
2026-06-01 03:01:40.29 [postmaster][reaper][140420664045568] LOG: database system is ready to accept connections
2026-06-01 03:01:40.032 [unknown] [unknown] localhost 140416640345600 0[0:0#0] 0 [BACKEND] LOG: walwriter started
2026-06-01 03:01:40.032 [unknown] [unknown] localhost 140416315815424 0[0:0#0] 0 [BACKEND] LOG: autovacuum launcher started
2026-06-01 03:01:40.034 [unknown] [unknown] localhost 140416265483776 0[0:0#0] 0 [BACKEND] LOG: undo launcher started
2026-06-01 03:01:40.036 [unknown] [unknown] localhost 140416197846528 0[0:0#0] 0 [BACKEND] LOG: CfsShrinker started
2026-06-01 03:01:40.040 [unknown] [unknown] localhost 140416214627840 0[0:0#0] 0 [BACKEND] LOG: [Pgstat] statfile global/pgstat.stat is missing, using empty dbhash.
2026-06-01 03:01:40.043 omm postgres localhost 140416290125312 0[0:0#0] 0 [BACKEND] LOG: m_global_systupcaches not init, m_isShared: 0, relation oid: 1261.
2026-06-01 03:01:40.044 omm postgres localhost 140416290125312 0[0:0#0] 0 [BACKEND] LOG: m_global_systupcaches not init, m_isShared: 0, relation oid: 3460.
2026-06-01 03:01:40.044 omm postgres localhost 140416290125312 0[0:0#0] 0 [BACKEND] LOG: m_global_systupcaches not init, m_isShared: 0, relation oid: 3460.
2026-06-01 03:01:40.051 [unknown] [unknown] localhost 140415901103616 0[0:0#0] 0 [UNDO] LOG: [UndoRecycleMain:770]undo recycle started.
2026-06-01 03:01:40.058 omm postgres localhost 140416163771904 0[0:0#0] 0 [BACKEND] LOG: instrumention percentile started
2026-06-01 03:01:40.061 omm postgres localhost 140416137033216 0[0:0#0] 0 [BACKEND] LOG: ASP thread start
2026-06-01 03:01:40.065 omm postgres localhost 140416005895680 0[0:0#0] 0 [BACKEND] LOG: process wlm thread starting up.
2026-06-01 03:01:40.066 omm postgres localhost 140416005895680 0[0:0#0] 0 [BACKEND] LOG: build user data finished
2026-06-01 03:01:40.067 omm postgres localhost 140415946651136 0[0:0#0] 0 [BACKEND] LOG: WLMarbiter thread is starting up.
2026-06-01 03:01:40.067 omm postgres localhost 140415968736768 0[0:0#0] 0 [BACKEND] LOG: WLMmonitor thread is starting up.
2026-06-01 03:01:40.068 omm postgres localhost 140416099284480 0[0:0#0] 0 [BACKEND] LOG: statement flush thread start
2026-06-01 03:01:40.071 gaussdb asset3 10.35.66.151 140415779993088 0[0:0#0] 0 [BACKEND] LOG: m_global_systupcaches not init, m_isShared: 0, relation oid: 1261.
2026-06-01 03:01:40.072 gaussdb asset3 10.35.66.151 140415779993088 0[0:0#0] 0 [BACKEND] LOG: m_global_systupcaches not init, m_isShared: 0, relation oid: 3460.
2026-06-01 03:01:50.076 [unknown] [unknown] localhost 140415901103616 0[0:0#0] 0 [UNDO] LOG: [UndoRecycleMain:864]sleep 10s, ensure the snapcapturer can give the undorecyclemain a valid recycleXmin.
2026-06-01 03:01:50.076 [unknown] [unknown] localhost 140415901103616 0[0:0#0] 0 [UNDO] LOG: [exrto_recycle_residual_undo_file:714]exrto_recycle_residual_undo_file skip, FuncName:recycle_main.
2026-06-01 03:01:50.089 [unknown] [unknown] localhost 140415901103616 0[0:0#0] 0 [UNDO] LOG: [UndoRecycleMain:987]update globalRecycleXid: oldestXmin=36575, recycleXmin=36575, globalFrozenXid=36219, globalRecycleXid=36219, newRecycleXid=36575.
2026-06-01 03:01:55.001 [unknown] [unknown] localhost 140416579532288 0[0:0#0] 0 [BACKEND] LOG: database first startup and recovery finish, so do checkpointer.
2026-06-01 03:01:55.048 [unknown] [unknown] localhost 140416472512000 0[0:0#0] 0 [BACKEND] LOG: Postmaster shutdown, the last standby snapshot is written, thread role is 47.
2026-06-01 03:01:55.211 [unknown] [unknown] localhost 140416579532288 0[0:0#0] 0 [DBL_WRT] LOG: [batch flush] DW truncate end: file_head[dwn 13, start 14863], total_pages 0
2026-06-01 03:01:55.212 [unknown] [unknown] localhost 140416579532288 0[0:0#0] 0 [UNDO] LOG: [CheckPointUndoSystemMeta:368]undo metadata checkPointRedo = 2110809776, oldestXmin = 36575, recycleXmin = 36575, globalFrozenXid = 36219, globalRecycleXid = 36575.
2026-06-01 03:01:55.216 [unknown] [unknown] localhost 140416579532288 0[0:0#0] 0 [BACKEND] LOG: Postmaster shutdown, the last standby snapshot is written, thread role is 38.
2026-06-01 03:01:55.216 [unknown] [unknown] localhost 140416579532288 0[0:0#0] 0 [BACKEND] LOG: CreateCheckPoint PrintCkpXctlControlFile: [checkPoint] oldCkpLoc:0/7DD05E70, oldRedo:0/7DD05DF0, newCkpLoc:0/7DD067B0, newRedo:0/7DD066B0, preCkpLoc:0/7DD05E70
2026-06-01 03:01:55.217 [unknown] [unknown] localhost 140416579532288 0[0:0#0] 0 [BACKEND] LOG: will update control file (create checkpoint), shutdown:0
2026-06-01 03:01:55.217 [unknown] [unknown] localhost 140416579532288 0[0:0#0] 0 [BACKEND] LOG: attempting to remove WAL segments older than log file 00000001000000000000006B
2026-06-01 03:02:10.378 [unknown] [unknown] localhost 140416472512000 0[0:0#0] 0 [BACKEND] LOG: Postmaster shutdown, the last standby snapshot is written, thread role is 47.
2026-06-01 03:02:40.140 omm omm ::1 140415522895360 0[0:0#0] 0 [BACKEND] LOG: m_global_systupcaches not init, m_isShared: 0, relation oid: 1261.
2026-06-01 03:02:40.141 omm omm ::1 140415522895360 0[0:0#0] 0 [BACKEND] LOG: m_global_systupcaches not init, m_isShared: 0, relation oid: 3460.
2026-06-01 03:02:40.289 omm postgres localhost 140415522895360 0[0:0#0] 0 [BACKEND] LOG: clean statement thread start
2026-06-01 03:02:55.475 [unknown] [unknown] localhost 140416579532288 0[0:0#0] 0 [DBL_WRT] LOG: [batch flush] DW truncate end: file_head[dwn 13, start 14863], total_pages 0
2026-06-01 03:02:55.476 [unknown] [unknown] localhost 140416579532288 0[0:0#0] 0 [UNDO] LOG: [CheckPointUndoSystemMeta:368]undo metadata checkPointRedo = 2110810320, oldestXmin = 36575, recycleXmin = 36575, globalFrozenXid = 36219, globalRecycleXid = 36575.
2026-06-01 03:02:55.481 [unknown] [unknown] localhost 140416579532288 0[0:0#0] 0 [BACKEND] LOG: Postmaster shutdown, the last standby snapshot is written, thread role is 38.
2026-06-01 03:02:55.481 [unknown] [unknown] localhost 140416579532288 0[0:0#0] 0 [BACKEND] LOG: CreateCheckPoint PrintCkpXctlControlFile: [checkPoint] oldCkpLoc:0/7DD067B0, oldRedo:0/7DD066B0, newCkpLoc:0/7DD06950, newRedo:0/7DD068D0, preCkpLoc:0/7DD05E70
2026-06-01 03:02:55.481 [unknown] [unknown] localhost 140416579532288 0[0:0#0] 0 [BACKEND] LOG: will update control file (create checkpoint), shutdown:0
2026-06-01 03:02:55.482 [unknown] [unknown] localhost 140416579532288 0[0:0#0] 0 [BACKEND] LOG: attempting to remove WAL segments older than log file 00000001000000000000006B
2026-06-01 03:02:56.161 [unknown] [unknown] localhost 140416472512000 0[0:0#0] 0 [BACKEND] LOG: Postmaster shutdown, the last standby snapshot is written, thread role is 47.
2026-06-01 03:03:40.487 omm postgres localhost 140415522895360 0[0:0#0] 0 [BACKEND] LOG: clean statement thread start
2026-06-01 03:03:55.745 [unknown] [unknown] localhost 140416579532288 0[0:0#0] 0 [DBL_WRT] LOG: [batch flush] DW truncate end: file_head[dwn 13, start 14863], total_pages 0
2026-06-01 03:03:55.746 [unknown] [unknown] localhost 140416579532288 0[0:0#0] 0 [UNDO] LOG: [CheckPointUndoSystemMeta:368]undo metadata checkPointRedo = 2110810736, oldestXmin = 36575, recycleXmin = 36575, globalFrozenXid = 36219, globalRecycleXid = 36575.
2026-06-01 03:03:55.750 [unknown] [unknown] localhost 140416579532288 0[0:0#0] 0 [BACKEND] LOG: Postmaster shutdown, the last standby snapshot is written, thread role is 38.
2026-06-01 03:03:55.751 [unknown] [unknown] localhost 140416579532288 0[0:0#0] 0 [BACKEND] LOG: CreateCheckPoint PrintCkpXctlControlFile: [checkPoint] oldCkpLoc:0/7DD06950, oldRedo:0/7DD068D0, newCkpLoc:0/7DD06AF0, newRedo:0/7DD06A70, preCkpLoc:0/7DD067B0
2026-06-01 03:03:55.751 [unknown] [unknown] localhost 140416579532288 0[0:0#0] 0 [BACKEND] LOG: will update control file (create checkpoint), shutdown:0
2026-06-01 03:03:55.751 [unknown] [unknown] localhost 140416579532288 0[0:0#0] 0 [BACKEND] LOG: attempting to remove WAL segments older than log file 00000001000000000000006B
2026-06-01 03:03:57.184 [unknown] [unknown] localhost 140416472512000 0[0:0#0] 0 [BACKEND] LOG: Postmaster shutdown, the last standby snapshot is written, thread role is 47.
2026-06-01 03:04:40.677 omm postgres localhost 140415555466752 0[0:0#0] 0 [BACKEND] LOG: clean statement thread start
2026-06-01 03:04:56.007 [unknown] [unknown] localhost 140416579532288 0[0:0#0] 0 [DBL_WRT] LOG: [batch flush] DW truncate end: file_head[dwn 13, start 14863], total_pages 0
2026-06-01 03:04:56.008 [unknown] [unknown] localhost 140416579532288 0[0:0#0] 0 [UNDO] LOG: [CheckPointUndoSystemMeta:368]undo metadata checkPointRedo = 2110811152, oldestXmin = 36575, recycleXmin = 36575, globalFrozenXid = 36219, globalRecycleXid = 36575.
2026-06-01 03:04:56.012 [unknown] [unknown] localhost 140416579532288 0[0:0#0] 0 [BACKEND] LOG: Postmaster shutdown, the last standby snapshot is written, thread role is 38.
2026-06-01 03:04:56.013 [unknown] [unknown] localhost 140416579532288 0[0:0#0] 0 [BACKEND] LOG: CreateCheckPoint PrintCkpXctlControlFile: [checkPoint] oldCkpLoc:0/7DD06AF0, oldRedo:0/7DD06A70, newCkpLoc:0/7DD06C90, newRedo:0/7DD06C10, preCkpLoc:0/7DD06950
2026-06-01 03:04:56.013 [unknown] [unknown] localhost 140416579532288 0[0:0#0] 0 [BACKEND] LOG: will update control file (create checkpoint), shutdown:0
2026-06-01 03:04:56.014 [unknown] [unknown] localhost 140416579532288 0[0:0#0] 0 [BACKEND] LOG: attempting to remove WAL segments older than log file 00000001000000000000006B
2026-06-01 03:04:56.855 [unknown] [unknown] localhost 140416472512000 0[0:0#0] 0 [BACKEND] LOG: Postmaster shutdown, the last standby snapshot is written, thread role is 47.
2026-06-01 03:05:40.870 omm postgres localhost 140415522895360 0[0:0#0] 0 [BACKEND] LOG: clean statement thread start

6

能抓一下崩溃的core堆栈吗

7

@shenzheng 麻烦您说一下抓取方法

8

image
image666×277 12.5 KB