注册

启动失败

彬临程下 2025/04/09 252 9

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:dm8
【操作系统】:麒麟
【CPU】:
【问题描述】:数据库库实例启动崩溃
【问题描述】

今天数据库突然访问不了,一查发现数据库自己关闭了,在次用命令systemctl start DmServiceDMSERVER启动的时候启动不了,下面是启动日志
2025-04-09 17:40:56.578 [INFO] database P0000044216 T0000000000000044216 EP[13] pseg_collect_mgr_items, collect 0 active_trxs, 0 cmt_trxs, 0 pre_cmt_trxs, 0 to_release_trxs, 0 active_pages, 0 cmt_pages, 0 pre_cmt_pages, 0 to_release_pages, 0 mgr pages, 0 mgr recs!
2025-04-09 17:40:56.578 [INFO] database P0000044216 T0000000000000044216 EP[13] pseg collect items end, code:0, time used:0(ms)
2025-04-09 17:40:56.578 [INFO] database P0000044216 T0000000000000044216 EP[14] pseg_state is 2, set pseg state to 2
2025-04-09 17:40:56.578 [INFO] database P0000044216 T0000000000000044216 EP[14] pseg collect items begin, mgr_state=1
2025-04-09 17:40:56.578 [INFO] database P0000044216 T0000000000000044216 EP[14] pseg_collect_mgr_items, collect 0 active_trxs, 0 cmt_trxs, 0 pre_cmt_trxs, 0 to_release_trxs, 0 active_pages, 0 cmt_pages, 0 pre_cmt_pages, 0 to_release_pages, 0 mgr pages, 0 mgr recs!
2025-04-09 17:40:56.578 [INFO] database P0000044216 T0000000000000044216 EP[14] pseg collect items end, code:0, time used:0(ms)
2025-04-09 17:40:56.578 [INFO] database P0000044216 T0000000000000044216 EP[15] pseg_state is 2, set pseg state to 2
2025-04-09 17:40:56.578 [INFO] database P0000044216 T0000000000000044216 EP[15] pseg collect items begin, mgr_state=1
2025-04-09 17:40:56.578 [INFO] database P0000044216 T0000000000000044216 EP[15] pseg_collect_mgr_items, collect 0 active_trxs, 0 cmt_trxs, 0 pre_cmt_trxs, 0 to_release_trxs, 0 active_pages, 0 cmt_pages, 0 pre_cmt_pages, 0 to_release_pages, 0 mgr pages, 0 mgr recs!
2025-04-09 17:40:56.578 [INFO] database P0000044216 T0000000000000044216 EP[15] pseg collect items end, code:0, time used:0(ms)
2025-04-09 17:40:56.578 [INFO] database P0000044216 T0000000000000044216 pseg_collect_mgr_items, total collect 0 active_trxs, 0 cmt_trxs, 0 pre_cmt_trxs, 0 to_release_trxs, 0 active_pages, 0 cmt_pages, 0 pre_cmt_pages, 0 to_release_pages, 0 mgr pages, 0 mgr recs!
2025-04-09 17:40:56.578 [INFO] database P0000044216 T0000000000000044216 pseg collect items time used 3(ms), mgr_state:1!
2025-04-09 17:40:56.578 [INFO] database P0000044216 T0000000000000044216 iid page's trxid[2663308]
2025-04-09 17:40:56.578 [INFO] database P0000044216 T0000000000000044216 pseg_sys_reset_next_trxid_by_slot_ctl set next_trx_id to 2664309, value in iid page is 2663308.
2025-04-09 17:40:56.578 [INFO] database P0000044216 T0000000000000044216 after iid_next_trxid_adjust_if_necessary, value in iid page is 2664310.
2025-04-09 17:40:56.578 [INFO] database P0000044216 T0000000000000044216 pseg_sys_recv_cmtarr_reg first_tid:0
2025-04-09 17:40:56.578 [INFO] database P0000044216 T0000000000000044216 trx4_cmtarr_set_first_tid set first_tid from 0 to 2664310
2025-04-09 17:40:56.578 [INFO] database P0000044216 T0000000000000044216 total 0 active crash trx, pseg_crash_trx_rollbacksys_only(0) begin ...
2025-04-09 17:40:56.578 [INFO] database P0000044216 T0000000000000044216 pseg_crash_trx_rollback end, total 0 active crash trx, include 0 empty_trxs, 0 empty_pages which only need to delete mgr recs.
2025-04-09 17:40:56.578 [INFO] database P0000044216 T0000000000000044216 pseg_crash_trx_rollback end
2025-04-09 17:40:56.578 [INFO] database P0000044216 T0000000000000044216 pseg_crash_trx_rollback all active trx used 1(ms), mgr_state:1!
2025-04-09 17:40:56.578 [INFO] database P0000044216 T0000000000000044216 pseg_sys_recv used 4 ms
2025-04-09 17:40:56.586 [INFO] database P0000044216 T0000000000000044216 pseg recv finished
2025-04-09 17:40:56.588 [INFO] database P0000044216 T0000000000000044216 nsvr_startup end.
2025-04-09 17:40:56.690 [INFO] database P0000044216 T0000000000000044216 aud sys init success.
2025-04-09 17:40:56.690 [INFO] database P0000044216 T0000000000000044216 aud rt sys init success.
2025-04-09 17:40:56.690 [INFO] database P0000044216 T0000000000000044216 systables desc init success.
2025-04-09 17:40:56.691 [INFO] database P0000044216 T0000000000000044216 ndct_db_load_info success.
2025-04-09 17:40:56.692 [INFO] database P0000044216 T0000000000000044216 nsvr_process_before_open begin.
2025-04-09 17:40:56.702 [INFO] database P0000044216 T0000000000000044216 nsvr_process_before_open success.
2025-04-09 17:40:56.703 [INFO] database P0000044216 T0000000000000044216 backup control file /DM8/data/DAMENG/dm.ctl to file /DM8/data/DAMENG/dm_20250409174056_703036.ctl
2025-04-09 17:40:56.703 [INFO] database P0000044216 T0000000000000044348 nsvr_lsnr_thread successfully created.
2025-04-09 17:40:56.703 [INFO] database P0000044216 T0000000000000044324 total 0 active crash trx, pseg_crash_trx_rollbacksys_only(0) begin ...
2025-04-09 17:40:56.703 [INFO] database P0000044216 T0000000000000044324 pseg_crash_trx_rollback end, total 0 active crash trx, include 0 empty_trxs, 0 empty_pages which only need to delete mgr recs.
2025-04-09 17:40:56.703 [INFO] database P0000044216 T0000000000000044324 pseg_crash_trx_rollback end
2025-04-09 17:40:56.703 [INFO] database P0000044216 T0000000000000044324 hpc_clear_active_trx adjust n_crash_active_trx from 0 to 0.
2025-04-09 17:40:56.740 [INFO] database P0000044216 T0000000000000044216 backup control file /DM8/data/DAMENG/dm.ctl to file /DM8/data/DAMENG/ctl_bak/dm_20250409174056_719208.ctl succeed
2025-04-09 17:40:56.740 [INFO] database P0000044216 T0000000000000044216 local instance name is DMSERVER, mode is NORMAL, status is OPEN.
2025-04-09 17:40:56.740 [INFO] database P0000044216 T0000000000000044216 SYSTEM IS READY.
2025-04-09 17:40:56.740 [INFO] database P0000044216 T0000000000000044216 set g_dw_stat from UNDEFINED to NONE success, g_dw_recover_stop is 0
2025-04-09 17:40:57.703 [INFO] database P0000044216 T0000000000000044315 trx4_min_tid_collect set min_active_id_opt, min_active_id: 2664334, first_tid: 2664310
2025-04-09 17:42:06.754 [FATAL] database P0000044216 T0000000000000044216 sigterm_handler receive signal 15
2025-04-09 17:42:06.754 [INFO] database P0000044216 T0000000000000044278 Server is stopping...
2025-04-09 17:42:06.755 [INFO] database P0000044216 T0000000000000044278 listener closed and all sessions disconnected

回答 0
暂无回答
扫一扫
联系客服