注册

必现宕机只要查询系统视图就宕机

牛牛 2024/04/08 590 4 已解决

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM Database Server x64 V8 DB Version: 0x7000c
【操作系统】:Kylin Linux Advanced Server V10 (Lance)
【CPU】:aarch64 Kunpeng-920
【问题描述】*:
只要查询系统视图systeminfo就会宕机。(最开始是发现 只要在PC的管理工具里同时打开2个连接,db就死了,后面分析core日志发现是下面sql引起的,手动执行下面的sql也能复现

select * from v$systeminfo ;

实在是懵逼了,各位大佬给看看。谢谢了。

系统日志/var/log/message提示如下。 只显示被kill,不清楚原因。

Apr 8 12:03:51 cloud systemd-coredump[2108419]: Process 2080323 (dmserver) of user 1001 dumped core.#012#012Stack trace of thread 2106403:#012#0 0x000000000125a614 n/a (/home/dmdba/d mdbms/bin/dmserver)#012#1 0x000000000125a610 n/a (/home/dmdba/dmdbms/bin/dmserver)#012#2 0x000000000125a74c n/a (/home/dmdba/dmdbms/bin/dmserver)#012#3 0x0000fffd27f1079c n/a (n/a)# 012#4 0x000000000044ce18 n/a (/home/dmdba/dmdbms/bin/dmserver)#012#5 0x000000000102a834 n/a (/home/dmdba/dmdbms/bin/dmserver)#012#6 0x0000000000f01294 n/a (/home/dmdba/dmdbms/bin/dm server)#012#7 0x0000000000f012cc n/a (/home/dmdba/dmdbms/bin/dmserver)#012#8 0x0000000000f01514 n/a (/home/dmdba/dmdbms/bin/dmserver)#012#9 0x0000000000ec3df4 n/a (/home/dmdba/dmdbm s/bin/dmserver)#012#10 0x0000000000ec3fb0 n/a (/home/dmdba/dmdbms/bin/dmserver)#012#11 0x0000000000ec4100 n/a (/home/dmdba/dmdbms/bin/dmserver)#012#12 0x00000000012846e4 n/a (/home/dmd ba/dmdbms/bin/dmserver)#012#13 0x00000000012850b4 n/a (/home/dmdba/dmdbms/bin/dmserver)#012#14 0x000000000128c514 n/a (/home/dmdba/dmdbms/bin/dmserver)#012#15 0x00000000011adf10 n/a (/ home/dmdba/dmdbms/bin/dmserver)#012#16 0x0000fffd27e6878c n/a (n/a)#012#17 0x0000fffd27b0508c n/a (n/a) Apr 8 12:03:51 cloud systemd[1]: systemd-coredump@8-2108418-0.service: Succeeded. Apr 8 12:03:51 cloud systemd[1]: DmServiceDMSERVER.service: Main process exited, code=killed, status=11/SEGV Apr 8 12:03:51 cloud systemd[1]: DmServiceDMSERVER.service: Failed with result 'signal'.

达梦错误日志提示如下

2024-04-08 12:03:47.193 [FATAL] database P0002080323 T0000000000002106403 sigterm_handler receive signal 11

分析core文件

#core文件内全都是业务sql,包含v$systeminfo视图的sql。 没有任何系统相关的打印。 类似下面这样 !#%&*^$@[2106403]:select * from v$systeminfo ;^@^@^@^@^@^@^@^@^@^@^@^@ !#%&*^$@[2081190]:set schema "cloud_channel_info"^@^@^@^@^@^@^@^@^@^@^@^@ !#%&*^$@[2081045]:set schema "cloud_resource_infostore"^@^@^@^@^@^@^@^@^@^@^@^@ !#%&*^$@[2084599]:SELECT f_room_id FROM t_room_info WHERE true AND f_address_id=? ORDER BY f_create_time DESC,f_room_id DESC LIMIT ?,?;

dbdbchk检查没有任何问题

#整体检查 [2024-04-08 13:56:00] --------check iid end--------------------- [2024-04-08 13:56:00] DM DB CHECK END...... [2024-04-08 13:56:00] error count is 0 #sema信号量 [2024-04-08 13:56:58] check os semaphore finished: [2024-04-08 13:56:58] total_cnt:0, active_cnt:0, check_err_cnt:0, need_del:0, real_del:0, del_err_cnt:0! #shm共享内存的 [2024-04-08 13:57:50] check os shared memory finished: [2024-04-08 13:57:50] total_cnt:16, active_cnt:16, check_err_cnt:0, need_del:0, real_del:0, del_err_cnt:0!
回答 0
暂无回答
扫一扫
联系客服