为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:
【CPU】:
【问题描述】*:数据库异常宕机
025-01-10 08:23:48.693 [INFO] database P0003082429 T0000000000003082471 rfil_grp_file_switch while flush rlog_pkg lsn range[168906236457, 168906277369], l_seqno[186764017], g_seqno[186764017]
2025-01-10 08:23:48.694 [INFO] database P0003082429 T0000000000003082471 rfil file switch from /appdata/dmdb/dmdb02.log to /appdata/dmdb/dmdb01.log, cur_lsn:[168906299723], l_next_seq:[186764018], g_next_seq:[186764018], ckpt_fil[0], ckpt_off[834703360]
2025-01-10 08:23:48.887 [INFO] database P0003082429 T0000000000003082470 ckpt2_log_adjust: full_status: 160, ptx_reserved: 0
2025-01-10 08:23:48.887 [INFO] database P0003082429 T0000000000003082470 ckpt2_log_adjust: ckpt_lsn(168893662861), ckpt_fil(0), ckpt_off(838452224), cur_lsn(168906315072), l_next_seq(186764018), g_next_seq(186764018), cur_free(2188800), total_space(4294959104), used_space(3471588864), free_space(823370240), n_ep(1)
2025-01-10 08:23:49.627 [INFO] database P0003082429 T0000000000003082470 ckpt2_log_adjust: full_status: 160, ptx_reserved: 0
2025-01-10 08:23:49.627 [INFO] database P0003082429 T0000000000003082470 ckpt2_log_adjust: ckpt_lsn(168893677185), ckpt_fil(0), ckpt_off(838500864), cur_lsn(168906368884), l_next_seq(186764020), g_next_seq(186764020), cur_free(21405184), total_space(4294959104), used_space(3489558016), free_space(805401088), n_ep(1)
2025-01-10 08:23:50.133 [INFO] database P0003082429 T0000000000003082470 ckpt2_log_adjust: full_status: 160, ptx_reserved: 0
2025-01-10 08:23:50.133 [INFO] database P0003082429 T0000000000003082470 ckpt2_log_adjust: ckpt_lsn(168893696950), ckpt_fil(0), ckpt_off(838675456), cur_lsn(168906393527), l_next_seq(186764027), g_next_seq(186764027), cur_free(41074688), total_space(4294959104), used_space(3498752512), free_space(796206592), n_ep(1)
2025-01-10 08:23:50.306 [INFO] database P0003082429 T0000000000003082470 ckpt2_log_adjust: full_status: 160, ptx_reserved: 0
2025-01-10 08:23:50.306 [INFO] database P0003082429 T0000000000003082470 ckpt2_log_adjust: ckpt_lsn(168893710776), ckpt_fil(0), ckpt_off(841521664), cur_lsn(168906407008), l_next_seq(186764034), g_next_seq(186764034), cur_free(46197248), total_space(4294959104), used_space(3501288960), free_space(793670144), n_ep(1)
2025-01-10 08:23:50.481 [INFO] database P0003082429 T0000000000003082470 ckpt2_log_adjust: full_status: 160, ptx_reserved: 0
2025-01-10 08:23:50.481 [INFO] database P0003082429 T0000000000003082470 ckpt2_log_adjust: ckpt_lsn(168893717118), ckpt_fil(0), ckpt_off(841521664), cur_lsn(168906421444), l_next_seq(186764039), g_next_seq(186764039), cur_free(53989888), total_space(4294959104), used_space(3508299264), free_space(786659840), n_ep(1)
2025-01-10 08:23:50.681 [INFO] database P0003082429 T0000000000003082470 ckpt2_log_adjust: full_status: 160, ptx_reserved: 0
2025-01-10 08:23:50.681 [INFO] database P0003082429 T0000000000003082470 ckpt2_log_adjust: ckpt_lsn(168893720656), ckpt_fil(0), ckpt_off(841521664), cur_lsn(168906438305), l_next_seq(186764043), g_next_seq(186764043), cur_free(59653120), total_space(4294959104), used_space(3514106368), free_space(780852736), n_ep(1)
2025-01-10 08:23:50.942 [INFO] database P0003082429 T0000000000003082470 ckpt2_log_adjust: full_status: 160, ptx_reserved: 0
2025-01-10 08:23:50.942 [INFO] database P0003082429 T0000000000003082470 ckpt2_log_adjust: ckpt_lsn(168893723353), ckpt_fil(0), ckpt_off(843995136), cur_lsn(168906461677), l_next_seq(186764047), g_next_seq(186764047), cur_free(66570752), total_space(4294959104), used_space(3519325696), free_space(775633408), n_ep(1)
2025-01-10 08:23:56.597 [INFO] database P0003082429 T0000000000003082470 ckpt2_log_adjust: full_status: 160, ptx_reserved: 0
2025-01-10 08:23:56.598 [INFO] database P0003082429 T0000000000003082470 ckpt2_log_adjust: ckpt_lsn(168893729572), ckpt_fil(0), ckpt_off(843995136), cur_lsn(168906840341), l_next_seq(186764050), g_next_seq(186764050), cur_free(145342976), total_space(4294959104), used_space(3661601792), free_space(633357312), n_ep(1)
2025-01-10 08:24:26.726 [INFO] database P0003303780 T0000000000003303780 ini_set_lic_lit, SECURITY SERIES set mpp_flag value 0
2025-01-10 08:24:26.726 [INFO] database P0003303780 T0000000000003303780 ini_set_lic_lit, SECURITY SERIES set hpc_node value 1
2025-01-10 08:24:26.733 [INFO] database P0003303780 T0000000000003303780 INI parameter DW_PORT changed, the original value 0, new value 7536
2025-01-10 08:24:26.754 [INFO] database P0003303780 T0000000000003303780 INI parameter DPC_2PC changed, the original value 1, new value 0
2025-01-10 08:24:26.758 [INFO] database P0003303780 T0000000000003303780 version info: security
2025-01-10 08:24:26.770 [INFO] database P0003303780 T0000000000003303780 os_sema2_create_low, create and inc sema success, key:47103508, sem_id:163842, sem_value:1!
2025-01-10 08:24:26.818 [INFO] database P0003303780 T0000000000003303780 Database's huge_with_delta is 1, and rlog_gen_for_huge is 0!
2025-01-10 08:24:27.659 [INFO] database P0003303780 T0000000000003303780 DM Database Server 64 V8 05134283968-20230110-179227-20033 startup...
2025-01-10 08:24:27.659 [INFO] database P0003303780 T0000000000003303780 INI parameter RECYCLE_POOLS changed, the original value 29, new value 21
2025-01-10 08:24:27.659 [INFO] database P0003303780 T0000000000003303780 INI parameter ROLLSEG_POOLS changed, the original value 19, new value 1
2025-01-10 08:24:27.728 [WARNING] database P0003303780 T0000000000003303780 fail to load libproj.so, libproj.so: cannot open shared object file: No such file or directory
2025-01-10 08:24:27.794 [WARNING] database P0003303780 T0000000000003303780 fail to load libxqilla.so, libnsl.so.1: cannot open shared object file: No such file or directory
2025-01-10 08:24:27.811 [INFO] database P0003303780 T0000000000003303780 fil_sys_init
看看宕机时间点的日志,info信息一般都是正常的