为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:dm8_20250506_x86_rh7_64
【操作系统】:centos
【CPU】:
【问题描述】*:
file dm.key not found, use default license!
version info: develop
csek2_vm_t = 1440
nsql_vm_t = 328
prjt2_vm_t = 176
ltid_vm_t = 216
nins2_vm_t = 1136
nset2_vm_t = 272
ndlck_vm_t = 192
ndel2_vm_t = 768
slct2_vm_t = 352
nli2_vm_t = 200
aagr2_vm_t = 304
pscn_vm_t = 376
dist_vm_t = 992
DM Database Server 64 V8 03134284368-20250430-272000-20149 startup...
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
Database mode = 0, oguid = 0
License will expire on 2026-04-30
begin redo pwr log collect, last ckpt lsn: 36849451151 ...
redo pwr log collect finished
main rfil[/home/dmdba/dmData/SPECUSER/SPECUSER01.log]'s grp collect 359 valid pwr record, discard 139 invalid pwr record
main rfil[/home/dmdba/dmData/SPECUSER/SPECUSER01.log]'s grp discard 0 invalid recv_pwr record
EP[0]'s cur_lsn[36849453476], file_lsn[36849453476]
begin redo log recover, last ckpt lsn: 36849451151 ...
redo log recover finished 0
ndct db load finished, code:100
ndct fill fast pool finished
pseg_set_gtv_trxid_low next_trxid in mem:[24257066]
pseg_collect_mgr_items, total collect 19 active_trxs, 5 cmt_trxs, 0 pre_cmt_trxs, 0 to_release_trxs, 19 active_pages, 5 cmt_pages, 0 pre_cmt_pages, 0 to_release_pages, 5 mgr pages, 24 mgr recs!
next_trxid in mem:[24259068]
next_trxid = 24261070.
total 19 active crash trx, pseg_crash_trx_rollback sys_only(0) begin ...
trx: 24256726 rollbacking...
total [1/19] page rollbacked, rollback percent: 5%
total [1/19] trx rollbacked, rollback percent: 5%
trx: 24256726 rollback 1 upages, 6 urecs end
trx: 24256727 rollbacking...
total [2/19] page rollbacked, rollback percent: 10%
total [2/19] trx rollbacked, rollback percent: 10%
trx: 24256727 rollback 1 upages, 6 urecs end
trx: 24256729 rollbacking...
total [3/19] page rollbacked, rollback percent: 15%
total [3/19] trx rollbacked, rollback percent: 15%
trx: 24256729 rollback 1 upages, 6 urecs end
trx: 24256730 rollbacking...
2025-07-30 09:05:03.025 [INFO] database P0000001639 T0000000000000022310 ifun_altts_state_online ts[5] to_state[0]begin
2025-07-30 09:05:03.026 [INFO] database P0000001639 T0000000000000022310 ifun_altts_state_online ts[5] to_state[0] end
2025-07-30 09:05:03.031 [INFO] database P0000001639 T0000000000000022310 backup control file /ssd/dmdba/dmData/SPECUSER/dm.ctl to file /ssd/dmdba/dmData/SPECUSER/dm_20250730090503_031168.ctl
2025-07-30 09:05:03.043 [INFO] database P0000001639 T0000000000000022310 backup control file /ssd/dmdba/dmData/SPECUSER/dm.ctl to file /ssd/dmdba/dmData/SPECUSER/ctl_bak/dm_20250730090503_037745.ctl succeed
2025-07-30 09:06:35.580 [FATAL] database P0000001639 T0000000000000001666 [for dem]SYSTEM SHUTDOWN ABORT.
2025-07-30 09:06:35.581 [FATAL] database P0000001639 T0000000000000001666 flst_remove: ts[5] flst corrupt error, selfaddr(0, 198656, 4116)'s nextaddr(0, 3508224, 1108), but nextaddr(0, 3508224, 1108)'s prevaddr(-1, 65535, 65535)
2025-07-30 09:06:35.581 [FATAL] database P0000001639 T0000000000000001666 code = -100, dm_sys_halt now!!!
2025-07-30 09:06:35.581 [INFO] database P0000001639 T0000000000000001666 total 2 rfil opened!
2025-07-30 09:06:35.582 [INFO] database P0000001639 T0000000000000001666 os_sema2_free, sema_id:49, sema_value:1!
2025-07-30 09:06:35.582 [FATAL] database P0000001639 T0000000000000001666 sigterm_handler receive signal 8
2025-07-30 09:06:35.583 [FATAL] database P0000001639 T0000000000000001666 [for dem]SYSTEM SHUTDOWN ABORT.
看起来是库的页对不上了
2025-07-30 09:06:35.581 [FATAL] database P0000001639 T0000000000000001666 flst_remove: ts[5] flst corrupt error, selfaddr(0, 198656, 4116)'s nextaddr(0, 3508224, 1108), but nextaddr(0, 3508224, 1108)'s prevaddr(-1, 65535, 65535)
建议做一下dbcheck吧