为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
DM Database Server 64 V8
8.4
安全版
DB Version: 0x7000d
05134284604-20260918-350084-20228
Msg Version: 6
Gsu level(5) cnt: 102
【操作系统】:
NAME="Kylin"
VERSION="银河麒麟桌面操作系统V10 (SP1)"
VERSION_US="Kylin Linux Desktop V10 (SP1)"
【CPU】:
root@greatwall-pc:/home/dmdba/dmdbms/data/DMTEST# cat /proc/cpuinfo
processor : 0
model name : Phytium D3000
BogoMIPS : 100.00
Features : fp asimd evtstrm aes pmull sha1 sha2 crc32 atomics fphp asimdhp cpuid asimdrdm lrcpc dcpop sha3 sm3 sm4 asimddp sha512
CPU implementer : 0x70
CPU architecture: 8
CPU variant : 0x0
CPU part : 0x862
CPU revision : 0
【问题描述】*:
有这么一个sql语句。
SELECT
'energyefficiencyextremecount' AS modellabel,
"energyefficiencyextremecount"."id" AS "id",
"energyefficiencysetid",
"extremecycle",
"extremetime",
"aggregationcycle",
"extremetype",
"extremevalue",
"logtime",
"objectid",
"objectlabel"
FROM "energyefficiencyextremecount"
WHERE ("energyefficiencysetid" = 2 AND "aggregationcycle" = 20 AND "extremecycle" = 12 AND "objectid" = 1 AND "objectlabel" = 'project' AND "extremetype" = 2)
执行成功。
当我加了order by id之后,数据库服务直接崩溃停止。
SELECT
'energyefficiencyextremecount' AS modellabel,
"energyefficiencyextremecount"."id" AS "id",
"energyefficiencysetid",
"extremecycle",
"extremetime",
"aggregationcycle",
"extremetype",
"extremevalue",
"logtime",
"objectid",
"objectlabel"
FROM "energyefficiencyextremecount"
WHERE ("energyefficiencysetid" = 2 AND "aggregationcycle" = 20 AND "extremecycle" = 12 AND "objectid" = 1 AND "objectlabel" = 'project' AND "extremetype" = 2)
order by id asc
root@greatwall-pc:/home/dmdba/dmdbms/data/DMTEST# systemctl status DmServiceDMTEST.service
● DmServiceDMTEST.service - DM Instance Service(DmServiceDMTEST).
Loaded: loaded (/lib/systemd/system/DmServiceDMTEST.service; enabled; vendor preset: enabled)
Active: failed (Result: signal) since Fri 2026-11-06 19:10:51 CST; 5s ago
Process: 2367848 ExecStart=/home/dmdba/dmdbms/bin/DmServiceDMTEST start (code=exited, status=0/SUCCESS)
Main PID: 2367870 (code=killed, signal=TRAP)
11月 06 19:10:16 greatwall-pc systemd[1]: Starting DM Instance Service(DmServiceDMTEST)....
11月 06 19:10:31 greatwall-pc DmServiceDMTEST[2367848]: [37B blob data]
11月 06 19:10:31 greatwall-pc systemd[1]: Started DM Instance Service(DmServiceDMTEST)..
11月 06 19:10:51 greatwall-pc systemd[1]: DmServiceDMTEST.service: Main process exited, code=killed, status=5/TRAP
11月 06 19:10:51 greatwall-pc systemd[1]: DmServiceDMTEST.service: Failed with result 'signal'.
对应数据库服务信息。
数据库日志记录
2026-11-06 19:01:13.179 [INFO] database P0002295296 T0000000000002295474 checkpoint requested by INI_INTERVAL, rlog free space[8574021632], used space[15904768]
2026-11-06 19:01:13.179 [INFO] database P0002295296 T0000000000002295474 checkpoint generate by ckpt_interval
2026-11-06 19:01:13.179 [INFO] database P0002295296 T0000000000002295405 checkpoint begin, used_space[15904768], free_space[8574021632]...
2026-11-06 19:01:13.179 [INFO] database P0002295296 T0000000000002295405 checkpoint end, 1 pages flushed, used_space[15904768], free_space[8574021632].
2026-11-06 19:01:14.179 [INFO] database P0002295296 T0000000000002295474 checkpoint requested by INI_INTERVAL, rlog free space[8574021632], used space[15904768]
2026-11-06 19:01:14.179 [INFO] database P0002295296 T0000000000002295474 checkpoint generate by ckpt_interval
2026-11-06 19:01:14.179 [INFO] database P0002295296 T0000000000002295405 checkpoint begin, used_space[15904768], free_space[8574021632]...
2026-11-06 19:01:14.204 [INFO] database P0002295296 T0000000000002295405 ckpt2_log_adjust: full_status: 160, ptx_reserved: 0
2026-11-06 19:01:14.204 [INFO] database P0002295296 T0000000000002295405 ckpt2_log_adjust: ckpt_lsn(208909320), ckpt_fil(1), ckpt_off(1851887616), cur_lsn(208940627), l_next_seq(11111539), g_next_seq(11111539), cur_free(1865904128), total_space(8589926400), used_space(14016512), free_space(8575909888), n_ep(1), db_open_id(49)
2026-11-06 19:01:14.204 [INFO] database P0002295296 T0000000000002295405 checkpoint end, 0 pages flushed, used_space[14016512], free_space[8575909888].
2026-11-06 19:01:41.358 [FATAL] database P0002295296 T0000000000002332668 [EID:326]sigterm_handler receive signal 11
2026-11-06 19:01:41.358 [FATAL] database P0002295296 T0000000000002332668 [EID:316][for dem]SYSTEM SHUTDOWN ABORT.
这是什么情况啊,很普通的一个sql。
对应的异常dump文件内容。

您好,我们将安排工程师与您对接。后续问题处理完成后,如方便欢迎在帖子中同步一下结果,这样其他遇到类似情况的用户也能参考,感谢您的支持。