注册

服务不能启动

仰望星空 2025/01/15 340 3

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8 2024
【操作系统】:win10
【CPU】:10代i7
【问题描述】*:我生成了很多数据库脚本做测试,突然服务不能启动,看日之后发现是内存分配出现问题,全局SQL池创建失败。请问这是什么原因?这算是达梦数据库的缺陷吗?我认为这是正常的使用!
日志(最后面是FATAL):
2025-01-15 20:00:17.782 [INFO] database P0000013352 T0000000000000011932 EP[3] plog_redo_init(redo_type: 1) by apply info, set rpkg_seq from 0 to 0, rpkg_lsn from 0 to 0
2025-01-15 20:00:17.789 [INFO] database P0000013352 T0000000000000011932 rapply_redo_stdby_seq_lsn_set adjust ep[0] (stdby_seq, lsn) from (0, 0) to (19251, 131008)
2025-01-15 20:00:17.790 [INFO] database P0000013352 T0000000000000011932 main rfil[D:\dm8\install\data\DESIGN\DESIGN01.log]'s sta is active
2025-01-15 20:00:17.791 [INFO] database P0000013352 T0000000000000011932 rlog4_db_open_id_adjust from 0 to 3
2025-01-15 20:00:17.791 [INFO] database P0000013352 T0000000000000011932 rfil[D:\dm8\install\data\DESIGN\DESIGN01.log], first local_rpkg_seqno:18964, global_rpkg_seqno:18964, first_startup:0, clsn_open_id:3, max_lsn:131015
2025-01-15 20:00:17.792 [INFO] database P0000013352 T0000000000000011932 begin redo pwr log collect, last ckpt lsn: 131008 ...
2025-01-15 20:00:17.792 [INFO] database P0000013352 T0000000000000011932 begin redo pwr log collect, l_term_id:0, term_id:0, c_seqno:19251, c_lsn:132504
2025-01-15 20:00:17.817 [INFO] database P0000013352 T0000000000000011932 redo_rapply_stat_fill adjust ep[0] (stdby_seq, lsn) from (19251, 131008) to (18963, 130988)
2025-01-15 20:00:17.818 [INFO] database P0000013352 T0000000000000011932 redo pwr log collect finished
2025-01-15 20:00:17.818 [INFO] database P0000013352 T0000000000000011932 redo_rfil_grp_pwr_collect, set main_rfil's next_seq from 19252 to 19285
2025-01-15 20:00:17.818 [INFO] database P0000013352 T0000000000000011932 redo_rfil_grp_pwr_collect, set EP[0] main_rfil's g_next_seq from 19252 to 19285
2025-01-15 20:00:17.819 [INFO] database P0000013352 T0000000000000011932 redo_rfil_grp_pwr_collect, set main_rfil's c_seqno from 19251 to 19283
2025-01-15 20:00:17.819 [INFO] database P0000013352 T0000000000000011932 redo_rfil_grp_pwr_collect, set main_rfil's c_lsn from 132504 to 132699
2025-01-15 20:00:17.819 [INFO] database P0000013352 T0000000000000011932 redo_rfil_grp_pwr_collect, set main_fil h_seqno from 19251 to 19283, h_lsn from 132504 to 132699.
2025-01-15 20:00:17.819 [INFO] database P0000013352 T0000000000000011932 redo_rfil_grp_pwr_collect, main_fil l_term_id:0, term_id:0, c_seqno:19283, c_lsn:132699, altnd_lsn:0
2025-01-15 20:00:17.819 [INFO] database P0000013352 T0000000000000011932 main rfil [D:\dm8\install\data\DESIGN\DESIGN01.log]'s grp collect 0 valid pwr record, discard 10 invalid pwr record
2025-01-15 20:00:17.819 [INFO] database P0000013352 T0000000000000011932 cur_fil:[D:\dm8\install\data\DESIGN\DESIGN01.log], cur_free:[78004224], l_next_seq:[19285], g_next_seq:[19285]
2025-01-15 20:00:17.819 [INFO] database P0000013352 T0000000000000011932 EP[0]'s cur_lsn[132736], file_lsn[132736]
2025-01-15 20:00:17.819 [INFO] database P0000013352 T0000000000000011932 buf4_redo_max_lsn_set from 0 to 132736
2025-01-15 20:00:17.820 [INFO] database P0000013352 T0000000000000011932 after redo_pwr_collect, rlog->used_space:1314816
2025-01-15 20:00:17.820 [INFO] database P0000013352 T0000000000000011932 EP[0] plog_redo_init(redo_type: 2), set redo_lsn = 0
2025-01-15 20:00:17.820 [INFO] database P0000013352 T0000000000000011932 EP[0] plog_redo_init(redo_type: 2), set rpkg_seq = 0, rpkg_lsn = 0
2025-01-15 20:00:17.820 [INFO] database P0000013352 T0000000000000011932 plog_redo_recv_init, max_ckpt_lsn:131008, max_apply_lsn:0, plog_pwr_hash is NULL: TRUE.
2025-01-15 20:00:17.820 [INFO] database P0000013352 T0000000000000011932 INI parameter REDOS_ENABLE_SELECT changed, the original value 1, new value 0
2025-01-15 20:00:17.820 [INFO] database P0000013352 T0000000000000011932 begin redo log recover, last ckpt lsn: 131008 ...
2025-01-15 20:00:17.838 [INFO] database P0000013352 T0000000000000011932 EP[0] plog_redo_it rlog_pkg load finished, total_rpkgs:321, total_rpkg_bytes:1314816
2025-01-15 20:00:17.839 [INFO] database P0000013352 T0000000000000011932 redo log recover finished
2025-01-15 20:00:17.839 [INFO] database P0000013352 T0000000000000011932 total redo 152 rrec, 0 rrec opt by pwr, code:0
2025-01-15 20:00:17.850 [INFO] database P0000013352 T0000000000000011932 INI parameter REDOS_ENABLE_SELECT changed, the original value 0, new value 1
2025-01-15 20:00:17.851 [INFO] database P0000013352 T0000000000000011932 redo rrec used 33ms
2025-01-15 20:00:17.851 [INFO] database P0000013352 T0000000000000011932 hlog_sys_destroy, n_logs[1], adjust_sta[0]
2025-01-15 20:00:17.852 [INFO] database P0000013352 T0000000000000011932 rlog4_apply_info_clear, arr_clear:0, file_path:D:\dm8\install\data\DESIGN\DESIGN01.log
2025-01-15 20:00:17.852 [INFO] database P0000013352 T0000000000000011932 rlog4_apply_info_clear reset p_db_magic[0], n_apply_ep[0], apply_info_lsn[0], apply_seq_arr:[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], apply_lsn_arr:[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]!
2025-01-15 20:00:17.852 [INFO] database P0000013352 T0000000000000011932 ndct_load_ex_idcls_map load 0 ex_idcls.
2025-01-15 20:00:17.854 [INFO] database P0000013352 T0000000000000011932 ndct db load finished, code:0
2025-01-15 20:00:17.854 [INFO] database P0000013352 T0000000000000011932 hpc_dw_apply_info_check_make, p_db_magic(0), n_apply_ep(0), apply_pkg_seq([0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]), apply_lsn_arr([0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]), db_magic(1740530876), n_ep(1), apply_info_lsn(132736), pkg_seq_arr([19284, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]), file_lsn([132736, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]), startup_flag(1)
2025-01-15 20:00:17.854 [INFO] database P0000013352 T0000000000000011932 ohis_ctl_add success, ctl info: rguid:DESIGN_4, sys_mode:NORMAL, p_iname:DESIGN, c_iname:DESIGN, p_db_magic:1740530876, c_db_magic:1740530876, n_ep:1, pkg_seqno:[19284], lsn_arr:[132736]
2025-01-15 20:00:17.854 [INFO] database P0000013352 T0000000000000011932 rlog4_db_open_id_adjust from 3 to 4
2025-01-15 20:00:17.855 [INFO] database P0000013352 T0000000000000011932 rlog4_apply_info_clear, arr_clear:0, file_path:D:\dm8\install\data\DESIGN\DESIGN01.log
2025-01-15 20:00:17.855 [INFO] database P0000013352 T0000000000000011932 rlog4_apply_info_clear reset p_db_magic[0], n_apply_ep[0], apply_info_lsn[0], apply_seq_arr:[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], apply_lsn_arr:[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]!
2025-01-15 20:00:17.857 [INFO] database P0000013352 T0000000000000011932 ndct second level fill fast pool finished
2025-01-15 20:00:17.857 [INFO] database P0000013352 T0000000000000011932 ndct third level fill fast pool finished
2025-01-15 20:00:17.857 [INFO] database P0000013352 T0000000000000011932 ndct second level fill fast pool finished
2025-01-15 20:00:17.857 [INFO] database P0000013352 T0000000000000011932 ndct third level fill fast pool finished
2025-01-15 20:00:17.858 [INFO] database P0000013352 T0000000000000011932 ndct fill fast pool finished
2025-01-15 20:00:17.859 [ERROR] database P0000013352 T0000000000000011932 mem_malloc_ex2(1073742168) out of memory!, fail to allocate memory from OS. file: ..\mgr\scp.c line: 361
2025-01-15 20:00:17.859 [FATAL] database P0000013352 T0000000000000011932 Fail to create global sql pool
2025-01-15 20:00:17.859 [FATAL] database P0000013352 T0000000000000011932 [for dem]SYSTEM SHUTDOWN ABORT.
2025-01-15 20:00:17.859 [FATAL] database P0000013352 T0000000000000011932 Fail to create global sql pool
2025-01-15 20:00:17.859 [FATAL] database P0000013352 T0000000000000011932 code = -1, dm_sys_halt now!!!
2025-01-15 20:00:17.859 [INFO] database P0000013352 T0000000000000011932 total 2 rfil opened!

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