为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:dm8_20240613_x86_rh6_64_rq_ent_8.1.3.140_pack5.tar
【操作系统】:麒麟V10
【CPU】: X86_64
【问题描述】*:Docker部署DM8出现异常宕机,容器内dmserver进程消失,core不生成,没有找到
授权也没到期
之前手动执行一个 update 语句可以必现,我们就不敢执行了,但后续还是又宕机了,这下找不到哪个语句,汗,太脆了,这个时之前必现的语句
UPDATE T_HR_EmpInfo a,
(SELECT FEmployee,
replace(wm_concat(FNameC), ',', ';') AS minzhuyincang
FROM T_BD_PoliticalCodes
JOIN T_HR_Party ON T_BD_PoliticalCodes.FID = T_HR_Party.FPoliParty
WHERE T_HR_Party.FEndDate IS NULL AND T_HR_Party.FPoliParty NOT IN ('01','02','03','13')
GROUP BY FEmployee
) b
,(SELECT FEmployee,
replace(wm_concat(FNameC), ',', ';') AS minzhu
FROM T_BD_PoliticalCodes
JOIN T_HR_Party ON T_BD_PoliticalCodes.FID = T_HR_Party.FPoliParty
WHERE T_HR_Party.FEndDate IS NULL AND T_HR_Party.FPoliParty NOT IN ('01','02','13')
GROUP BY FEmployee
) c
SET a.FPartyTime = CASE
WHEN b.minzhuyincang IS NULL THEN a.FPartyTime
WHEN a.FPartyTime IS NULL OR a.FPartyTime = '' THEN c.minzhu
WHEN a.FPartyTime IS NOT NULL AND a.FPartyTime LIKE '%党%' THEN CONCAT(a.FPartyTime, COALESCE(CONCAT(';', c.minzhu), ''))
ELSE CONCAT(a.FPartyTime, COALESCE(CONCAT(';', b.minzhuyincang), ''))
END
dmserver 宕机时间应该是14.24分,14点33分我就重启了,周围日志都是info,没看出啥
你可以看一下操作系统的日志,看看有没有啥报错,我看你发了一个更新语句,可以把对应创建表的语句发一下吗,我们这边验证一下