为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】: 达梦8,arm版本
【操作系统】: 麒麟10
【CPU】: arm
【问题描述】*:
系统在日终任务时,宕机。 有halt文件,没有core文件。
halt文件内容:
instance: DMSERVER
process_ID: 0002550465
sigterm_handler receive signal 11
<fatal thrd info>
thread_ID: 132373
session: 0x5d178678
n_resource: 0
n_slock: 0
n_xlock: 0
enable_page_cache: 0
n_total_access: 0
recent_n_page: 0
recent_buf_ctls: 0xfff79fcf9400
pages_n_fixed: 0xfff79fcf9600
worker_type: N
local_time_zone: 480
uthr: 0xfffe3a8fd100
lthd_cell: (nil)
pha: (nil)
<fatal session info>
sql: select /*+no_use_cvt_var */ mh.address, mh.region_id,mh.region_name,mh.build_id,mh.build_name,mh.cell_no,mh.cell_name,mos.owner_names,mh.deposit_sign,mh.id,mh.division_code,mh.area_code,
case when sum(mh.pre_construct_area) > 0 then sum(mh.pre_construct_area) else 0 end as pre_construct_area,sum(mh.construct_area) construct_area,
mh.deposit_no,mh.deposit_name,sum(case when mh.deposit_sign in ('Y','N') then nvl(mh.deposit_area,0) else null end) as deposit_area,mh.due_amount,mh.house_prop,mh.house_type,
sum( nvl(t.dep_total_num,0) ) as dep_total_num,sum( nvl(t.exp_total_num,0) ) as exp_total_num,sum( nvl(t.drw_total_num,0) ) as drw_total_num,
sum( nvl(t.dep_total_amount,0) ) as dep_total_amount,sum( nvl(t.drw_total_amount,0) ) as drw_total_amount,sum( nvl(t.accr_total_amount,0) ) as accr_total_amount,
sum( nvl(t.exp_total_amount,0) ) as exp_total_amount,sum( nvl(t.interest_added,0) ) as interest_added,sum( nvl(t.income_total_amount,0) ) as income_total_amount,mh ... by mh.address, mh.region_id,mh.region_name,mh.build_id,mh.build_name,mh.cell_no,mh.cell_name,mos.owner_names,mh.deposit_sign,mh.id,mh.division_code,mh.area_code,
mh.house_prop,mh.house_type,mh.sale_status,mh.deposit_no,mh.deposit_name,mh.due_amount
trx: 0xfffe324439d8(trx_id: 57587228)
esess: null

尊敬的客户您好,该问题我们安排技术服务工程师与您对接,请保持联系方式畅通。