热门搜索
分布式
数据库一体机
云数据库
建设银行
保险核心
密集交易
登录
注册
半夜求救，启动线上企业版达梦出现buf4_page_flush_low_org check error
钢羽
2025/11/26
547
9
为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:dm8.4-x86-linux-企业版2025.12.25
【操作系统】：麒麟10
【CPU】:x86
【问题描述】*：没有启用归档备份，执行了下./dmman BACKUP DATABASE '/dmdata/data/DAMENG/dm.ini' FULL BACKUPSET '/dmdata/dmbak/full_database'; 这个语句，卡住后，我ctrl+c 退出，接着尝试启动数据库实例服务，就报错了
2025-11-26 02:40:18.483 [INFO] database P0003863614 T0000000000003863614 pseg collect items time used 6(ms), mgr_state:1!
2025-11-26 02:40:18.483 [INFO] database P0003863614 T0000000000003863614 next_trxid in mem:[71375922]
2025-11-26 02:40:18.483 [INFO] database P0003863614 T0000000000003863614 pseg_sys_reset_next_trxid_by_slot_ctl set next_trxid to 71377923, value in mem is 71375922.
2025-11-26 02:40:18.483 [INFO] database P0003863614 T0000000000003863614 iid_next_trxid_adjust_if_necessary, next_trxid in mem is 71377924.
2025-11-26 02:40:18.483 [INFO] database P0003863614 T0000000000003863614 pseg_sys_recv_cmtarr_reg first_tid:0
2025-11-26 02:40:18.483 [INFO] database P0003863614 T0000000000003863614 trx4_cmtarr_set_first_tid set first_tid from 0 to 71377924
2025-11-26 02:40:18.483 [INFO] database P0003863614 T0000000000003863614 trx4_min_active_id_opt_set 0 to 0, min_active_id: 71377923, first_tid: 71377924
2025-11-26 02:40:18.483 [INFO] database P0003863614 T0000000000003863614 pseg_crash_trx_rollback all active trx used 0(ms), mgr_state:1!
2025-11-26 02:40:18.483 [INFO] database P0003863614 T0000000000003863614 pseg_sys_recv used 7 ms
2025-11-26 02:40:18.484 [INFO] database P0003863614 T0000000000003863614 pseg recv finished
2025-11-26 02:40:18.488 [INFO] database P0003863614 T0000000000003863614 nsvr_startup end.
2025-11-26 02:40:18.488 [INFO] database P0003863614 T0000000000003863614 dmap init success
2025-11-26 02:40:18.588 [INFO] database P0003863614 T0000000000003863614 uthr_pipe_create, create pipe[read:12, write:13]
2025-11-26 02:40:18.589 [INFO] database P0003863614 T0000000000003863614 uthr_pipe_create, create pipe[read:14, write:15]
2025-11-26 02:40:18.589 [INFO] database P0003863614 T0000000000003863614 uthr_pipe_create, create pipe[read:16, write:17]
2025-11-26 02:40:18.589 [INFO] database P0003863614 T0000000000003863614 uthr_pipe_create, create pipe[read:18, write:19]
2025-11-26 02:40:18.589 [INFO] database P0003863614 T0000000000003863614 uthr_pipe_create, create pipe[read:20, write:21]
2025-11-26 02:40:18.590 [INFO] database P0003863614 T0000000000003863614 uthr_pipe_create, create pipe[read:22, write:23]
2025-11-26 02:40:18.590 [INFO] database P0003863614 T0000000000003863614 uthr_pipe_create, create pipe[read:24, write:25]
2025-11-26 02:40:18.590 [INFO] database P0003863614 T0000000000003863614 uthr_pipe_create, create pipe[read:26, write:27]
2025-11-26 02:40:18.590 [INFO] database P0003863614 T0000000000003863614 uthr_pipe_create, create pipe[read:28, write:29]
2025-11-26 02:40:18.590 [INFO] database P0003863614 T0000000000003863614 uthr_pipe_create, create pipe[read:30, write:31]
2025-11-26 02:40:18.591 [INFO] database P0003863614 T0000000000003863614 uthr_pipe_create, create pipe[read:32, write:33]
2025-11-26 02:40:18.591 [INFO] database P0003863614 T0000000000003863614 uthr_pipe_create, create pipe[read:34, write:35]
2025-11-26 02:40:18.591 [INFO] database P0003863614 T0000000000003863614 uthr_pipe_create, create pipe[read:36, write:37]
2025-11-26 02:40:18.591 [INFO] database P0003863614 T0000000000003863614 uthr_pipe_create, create pipe[read:38, write:39]
2025-11-26 02:40:18.591 [INFO] database P0003863614 T0000000000003863614 uthr_pipe_create, create pipe[read:40, write:41]
2025-11-26 02:40:18.591 [INFO] database P0003863614 T0000000000003863614 uthr_pipe_create, create pipe[read:42, write:43]
2025-11-26 02:40:18.593 [INFO] database P0003863614 T0000000000003863614 aud sys init success.
2025-11-26 02:40:18.593 [INFO] database P0003863614 T0000000000003863614 aud rt sys init success.
2025-11-26 02:40:18.594 [INFO] database P0003863614 T0000000000003863614 systables desc init success.
2025-11-26 02:40:18.594 [INFO] database P0003863614 T0000000000003863614 ndct_db_load_info finished, code:0.
2025-11-26 02:40:18.595 [INFO] database P0003863614 T0000000000003863614 nsvr_process_before_open begin.
2025-11-26 02:40:18.608 [INFO] database P0003863614 T0000000000003863614 nsvr_process_before_open success.
2025-11-26 02:40:18.609 [INFO] database P0003863614 T0000000000003863748 nsvr_lsnr_thread successfully created.
2025-11-26 02:40:18.609 [INFO] database P0003863614 T0000000000003863643 hpc_clear_active_trx adjust n_crash_active_trx from 0 to 0.
2025-11-26 02:40:18.611 [INFO] database P0003863614 T0000000000003863614 backup control file /dmdata/data/DAMENG/dm.ctl to file /dmdata/data/DAMENG/dm_20251126024018_611225.ctl
2025-11-26 02:40:18.617 [INFO] database P0003863614 T0000000000003863614 backup control file /dmdata/data/DAMENG/dm.ctl to file /dmdata/data/DAMENG/ctl_bak/dm_20251126024018_613241.ctl succeed
2025-11-26 02:40:18.617 [INFO] database P0003863614 T0000000000003863614 local instance name is DBSERVER, mode is NORMAL, status is OPEN.
2025-11-26 02:40:18.617 [INFO] database P0003863614 T0000000000003863614 SYSTEM IS READY.
2025-11-26 02:40:18.617 [INFO] database P0003863614 T0000000000003863614 [for dem]SYSTEM IS READY.
2025-11-26 02:40:18.617 [INFO] database P0003863614 T0000000000003863614 set g_dw_stat from UNDEFINED to NONE success, g_dw_recover_stop is 0
2025-11-26 02:40:18.984 [INFO] database P0003863614 T0000000000003863715 purg2_crash_cmt_trx begin
2025-11-26 02:40:18.985 [INFO] database P0003863614 T0000000000003863715 total 1 page purged, percent: 7%
2025-11-26 02:40:18.985 [INFO] database P0003863614 T0000000000003863715 total 1 trx purged, percent: 7%
2025-11-26 02:40:18.985 [INFO] database P0003863614 T0000000000003863715 total 2 page purged, percent: 15%
2025-11-26 02:40:18.985 [INFO] database P0003863614 T0000000000003863715 total 2 trx purged, percent: 15%
2025-11-26 02:40:18.985 [INFO] database P0003863614 T0000000000003863715 total 3 page purged, percent: 23%
2025-11-26 02:40:18.985 [INFO] database P0003863614 T0000000000003863715 total 3 trx purged, percent: 23%
2025-11-26 02:40:18.985 [INFO] database P0003863614 T0000000000003863715 total 4 page purged, percent: 30%
2025-11-26 02:40:18.985 [INFO] database P0003863614 T0000000000003863715 total 4 trx purged, percent: 30%
2025-11-26 02:40:18.986 [INFO] database P0003863614 T0000000000003863715 total 5 page purged, percent: 38%
2025-11-26 02:40:18.986 [INFO] database P0003863614 T0000000000003863715 total 5 trx purged, percent: 38%
2025-11-26 02:40:18.986 [INFO] database P0003863614 T0000000000003863715 total 6 page purged, percent: 46%
2025-11-26 02:40:18.986 [INFO] database P0003863614 T0000000000003863715 total 6 trx purged, percent: 46%
2025-11-26 02:40:18.986 [INFO] database P0003863614 T0000000000003863715 total 7 page purged, percent: 53%
2025-11-26 02:40:18.986 [INFO] database P0003863614 T0000000000003863715 total 7 trx purged, percent: 53%
2025-11-26 02:40:18.986 [INFO] database P0003863614 T0000000000003863715 total 8 page purged, percent: 61%
2025-11-26 02:40:18.986 [INFO] database P0003863614 T0000000000003863715 total 8 trx purged, percent: 61%
2025-11-26 02:40:18.986 [INFO] database P0003863614 T0000000000003863715 total 9 page purged, percent: 69%
2025-11-26 02:40:18.986 [INFO] database P0003863614 T0000000000003863715 total 9 trx purged, percent: 69%
2025-11-26 02:40:18.986 [INFO] database P0003863614 T0000000000003863715 total 10 page purged, percent: 76%
2025-11-26 02:40:18.986 [INFO] database P0003863614 T0000000000003863715 total 10 trx purged, percent: 76%
2025-11-26 02:40:18.986 [INFO] database P0003863614 T0000000000003863715 total 11 page purged, percent: 84%
2025-11-26 02:40:18.986 [INFO] database P0003863614 T0000000000003863715 total 11 trx purged, percent: 84%
2025-11-26 02:40:18.986 [INFO] database P0003863614 T0000000000003863715 total 12 page purged, percent: 92%
2025-11-26 02:40:18.986 [INFO] database P0003863614 T0000000000003863715 total 12 trx purged, percent: 92%
2025-11-26 02:40:18.986 [INFO] database P0003863614 T0000000000003863715 total 13 page purged, percent: 100%
2025-11-26 02:40:18.987 [INFO] database P0003863614 T0000000000003863715 total 13 trx purged, percent: 100%
2025-11-26 02:40:18.990 [INFO] database P0003863614 T0000000000003863715 purge over, total 13 trx, 13 pages purged
2025-11-26 02:40:18.990 [INFO] database P0003863614 T0000000000003863715 n_roll_trx:0, n_purged_trx:13, n_active_trx:0, n_cmt_trx:13, n_pre_cmt_trx:0, n_to_release_trx:0
2025-11-26 02:40:19.609 [INFO] database P0003863614 T0000000000003863644 trx4_min_tid_collect set min_active_id_opt, min_active_id: 71377929, first_tid: 71377924
2025-11-26 02:40:22.611 [INFO] database P0003863614 T0000000000003863643 buf4_page_flush_low_org page(1, 0, 2013), page_lsn(18172422091) < disk_lsn(18172422094)
2025-11-26 02:40:22.612 [FATAL] database P0003863614 T0000000000003863643 [for dem]SYSTEM SHUTDOWN ABORT.
2025-11-26 02:40:22.612 [FATAL] database P0003863614 T0000000000003863643 buf4_page_flush_low_org check error
2025-11-26 02:40:22.612 [FATAL] database P0003863614 T0000000000003863643 code = -1, dm_sys_halt now!!!
2025-11-26 02:40:22.612 [INFO] database P0003863614 T0000000000003863643 total 2 rfil opened!
有没有还没睡的，拜托了，忽略部分不一致数据都可以。
回答 0
暂无回答
钢羽
执行命令导致报错的时间在2025-11-25 18:40 左右
dmctl.txt:
##############################################################################
## please do not adjust parameter order, ensure the ctl have no difference ###
##########################################################################
# database name
dbname=DAMENG
# server mode
svr_mode=0
#OGUID
oguid=0
# db server version
version=117508102
# database version
db_version=458764
# pseg version
pseg_version=458763
#SGUID
sguid=1264654629
#NEXT_TS_ID
next_ts_id=6
#DSC_NODES
dsc_nodes=1
#NEXT_HTS_ID
next_htsid=129
#TIME_FLAG
time_flag=170
#MDIR_FLAG
mdir_flag=31
#STARTUP_CNT
startup_cnt=15
#LAST_STARTUP_TIME
last_startup_time=DATETIME '2025-11-26 02:40:18'
#DM7_DCT_VERSION
dm7_dct_version=11
#DM8_DCT_VERSION
dm8_dct_version=99
#===============================================
#===============================================
# table space name
ts_name=SYSTEM
# table space ID
ts_id=0
# table space status
ts_state=0
# table space cache
ts_cache=
# DSC node number
ts_nth=0
# DSC optimized node number
ts_opt_node=0
# table space quota state
ts_quota_state=0
# table space create time
ts_create_time=DATETIME '2025-07-23 18:50:55'
# table space modify time
ts_modify_time=DATETIME '2025-07-23 18:50:55'
# table space encrypt flag
ts_encrypt_flag=0
# table space copy num
ts_copy_num=3
# table space region size flag
ts_size_flag=0
# table space region huge size flag
ts_huge_size_flag=0
#-----------------------------------------------
.... 略
#===============================================
发布于
2025/11/26 04:36
钢羽
dmtemp.txt
##############################################################################
## please do not adjust parameter order, ensure the ctl have no difference ###
##########################################################################
# database name
dbname=
# server mode
svr_mode=0
#OGUID
oguid=0
# db server version
version=134284368
# database version
db_version=458765
# pseg version
pseg_version=458763
#SGUID
sguid=1767064880
#NEXT_TS_ID
next_ts_id=5
#DSC_NODES
dsc_nodes=0
#NEXT_HTS_ID
next_htsid=129
#TIME_FLAG
time_flag=170
#MDIR_FLAG
mdir_flag=31
#STARTUP_CNT
startup_cnt=0
#LAST_STARTUP_TIME
last_startup_time=DATETIME '0-00-00 00:00:00'
#DM7_DCT_VERSION
dm7_dct_version=11
#DM8_DCT_VERSION
dm8_dct_version=113
#===============================================
#===============================================
# table space name
ts_name=TEMP
# table space ID
ts_id=3
# table space status
ts_state=0
# table space cache
ts_cache=
# DSC node number
ts_nth=0
# DSC optimized node number
ts_opt_node=0
# table space quota state
ts_quota_state=0
# table space create time
ts_create_time=DATETIME '2025-06-23 20:49:52'
# table space modify time
ts_modify_time=DATETIME '0-00-00 46:24:130.016728'
# table space encrypt flag
ts_encrypt_flag=0
# table space copy num
ts_copy_num=3
# table space region size flag
ts_size_flag=0
# table space region huge size flag
ts_huge_size_flag=0
#-----------------------------------------------
# file path
fil_path=/dmdata/data/DAMENG/TEMP.DBF
# mirror path
mirror_path=
# file id
fil_id=0
# whether the file is auto extend
autoextend=1
# file create time
fil_create_time=DATETIME '0-00-00 46:24:130.016728'
# file modify time
fil_modify_time=DATETIME '0-00-00 46:24:130.016728'
# the max size of file
fil_max_size=0
# next size of file
fil_next_size=0
# whether the file is in creating
fil_in_creating=0
#===============================================
发布于
2025/11/26 04:38
钢羽
./dmman BACKUP DATABASE '/dmdata/data/DAMENG/dm.ini' FULL BACKUPSET '/dmdata/dmbak/full_database'; --执行该语句的时候，我是关闭实例了的
发布于
2025/11/26 04:43
钢羽
出现问题过程：
2025-11-25 18:40 左右关闭实例
/home/dmdba/dmdbms/bin/DmServiceLinfen stop
cd /home/dmdba/dmdbms/bin
./dmman BACKUP DATABASE '/dmdata/data/DAMENG/dm.ini' FULL BACKUPSET '/dmdata/dmbak/full_database';
2025-11-25 19点后发现
/home/dmdba/dmdbms/bin/DmServiceLinfen start 无法启动，尝试./dmserver /dmdata/data/DAMENG/dm.ini 启动无果，然后赶紧把当前数据库文件夹，完全备份了，如图还能找到11-25 19：12 的 ctl文件，不知道能不能帮忙还原
后面尝试操作皆是在复制的DAMENG 执行
发布于
2025/11/26 08:39
001
尊敬的客户您好，经过电话与您确认，已经有相关技术人员正在与您沟通，如有任何疑问，请随时联系我们（400 991 6599），我们将竭诚为您服务。
发布于
2025/11/26 09:10
一笑嘴就歪
保护好现场，保证还有一份没有动过的目录备份。
你这是什么环境，有没有项目，可以联系项目上技术支持
发布于
2025/11/26 09:16
扫一扫
联系客服
联系客服
鄂Copyright © 达梦国产化应用创新实验室
达梦在线服务平台社区用户管理规范
鄂ICP备18017926号-1
达梦在线服务平台社区用户管理规范
鄂ICP备18017926号-1
page_lsn(18172422091) < disk_lsn(18172422094
) 两个序号相隔那么小，能否通过修改配置，或者以最低序号为准，然后启动？亦或者有什么方式可以紧急启动，让我把库里的数据弄出来？导入一个新库