为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:dm8
【操作系统】:centos8
【CPU】:
【问题描述】*:数据库实例无法启动
2025-02-28 10:00:28.108 [INFO] database P0000006795 T0000000000000006795 backup control file /data/dm8/dm8yxts/dm.ctl to file /data/dm8/dm8yxts/ctl_bak/dm_20250228100028_106887.ctl succeed
2025-02-28 10:00:28.108 [INFO] database P0000006795 T0000000000000006795 local instance name is DMSERVER, mode is NORMAL, status is OPEN.
2025-02-28 10:00:28.108 [INFO] database P0000006795 T0000000000000006795 SYSTEM IS READY.
2025-02-28 10:00:28.108 [INFO] database P0000006795 T0000000000000006795 [for dem]SYSTEM IS READY.
2025-02-28 10:00:28.108 [INFO] database P0000006795 T0000000000000006795 set g_dw_stat from UNDEFINED to NONE success, g_dw_recover_stop is 0
2025-02-28 10:00:28.483 [INFO] database P0000006795 T0000000000000006899 purge over, total 0 trx, 0 pages purged
2025-02-28 10:00:28.484 [INFO] database P0000006795 T0000000000000006899 n_roll_trx:0, n_purged_trx:0, n_active_trx:0, n_cmt_trx:0, n_pre_cmt_trx:0, n_to_release_trx:0
2025-02-28 10:00:29.104 [INFO] database P0000006795 T0000000000000006835 trx4_min_tid_collect set min_active_id_opt, min_active_id: 74102, first_tid: 74097
2025-02-28 10:00:29.129 [INFO] database P0000006795 T0000000000000006828 trx set forddl from 0 to 1, trxid: 74104, current func is: nexe_exec
2025-02-28 10:00:29.130 [ERROR] database P0000006795 T0000000000000006828 tablespace 6 fail to extend. Please check disk space or extend attributes of data files, extend space is 2, free space is 65, reserved extents: 64
2025-02-28 10:00:29.130 [FATAL] database P0000006795 T0000000000000006828 sigterm_handler receive signal 11
2025-02-28 10:00:29.130 [FATAL] database P0000006795 T0000000000000006828 [for dem]SYSTEM SHUTDOWN ABORT.
OS日志如下:
Feb 28 10:33:14 yxdbts1 systemd[1]: Failed to start DM Instance Service(DmServiceDMSERVER)..
Feb 28 10:51:58 yxdbts1 systemd[1]: Starting DM Instance Service(DmServiceDMSERVER)....
Feb 28 10:52:01 yxdbts1 kernel: traps: dm_tskwrk_thd[63363] trap invalid opcode ip:1e09a59 sp:7f5865cd6860 error:0 in dmserver[748000+1fdb000]
Feb 28 10:52:01 yxdbts1 systemd[1]: Started Process Core Dump (PID 63520/UID 0).
Feb 28 10:52:02 yxdbts1 systemd-coredump[63521]: Core file was truncated to 2147483648 bytes.
Feb 28 10:52:03 yxdbts1 systemd-coredump[63521]: Process 63322 (dmserver) of user 12345 dumped core.#012#012Stack trace of thread 63363:#012#0 0x0000000001e09a59 assert_fun (/app/dm/dmdbms/bin/dmserver)#012#012Stack trace of thread 63322:#012#0 0x00007f589a19c3fc n/a (n/a)
Feb 28 10:52:03 yxdbts1 systemd[1]: systemd-coredump@5-63520-0.service: Succeeded.
Feb 28 10:52:13 yxdbts1 DmServiceDMSERVER[63301]: Starting DmServiceDMSERVER: /app/dm/dmdbms/bin/DmServiceDMSERVER: line 539: 63322 Illegal instruction (core dumped) eval exec "$PRE_STARTUP_COMMANDS" ""$EXEC_PROG_FULL_PATH"" "$STARTUP_PARAMS" -noconsole $TMP_START_MODE > "$START_SERVICE_LOG_FILE" 2>&1
Feb 28 10:52:13 yxdbts1 DmServiceDMSERVER[63301]: #033[60G[ #033[1;31mFAILED#033[0;39m ]
Feb 28 10:52:13 yxdbts1 systemd[1]: DmServiceDMSERVER.service: Control process exited, code=exited status=1
Feb 28 10:52:13 yxdbts1 systemd[1]: DmServiceDMSERVER.service: Failed with result 'exit-code'.
Feb 28 10:52:13 yxdbts1 systemd[1]: Failed to start DM Instance Service(DmServiceDMSERVER)..
附件是coredumpcore.dmserver.12345.a874e53da8b1420198e4bce7d46154fb.6795.1740708029000000.lz4.zip
看看数据文件所在的那个盘的空间
2025-02-28 10:00:29.130 [ERROR] database P0000006795 T0000000000000006828 tablespace 6 fail to extend. Please check disk space or extend attributes of data files, extend space is 2, free space is 65, reserved extents: 64
这个表空间tablespace 6是不是做了大小限制?现在满了才导致服务无法启动
看看是不是磁盘空间不足了