【TiDB版本】5.7.25-TiDB-v4.0.0
【问题描述】执行以下 SQL 导致了 TiDB Server 崩溃
replace into hidden.hidden_mongo_tel_analysis_apply
(orderid, inserttimespan, lc_countrate, lc_3countrate, lc_6countrate, call_3time_15srate,
top10_call_count, top10_call_3count, top10_call_6time, call_6time, call_count, call_3count,
call_type_countrate, call_type_6countrate, total_3fee, create_time)
select a.orderid,
date_sub(str_to_date(json_unquote(json_extract(d.thedata, ‘$.create_date’)), ‘%Y-%m-%d %h:%i:%s’), interval ‘8’ hour) inserttimespan,
json_unquote(json_extract(a.thedata, ‘$.lc_countrate’)) lc_countrate,
json_unquote(json_extract(a.thedata, ‘$.lc_3countrate’)) lc_3countrate,
json_unquote(json_extract(a.thedata, ‘$.lc_6countrate’)) lc_6countrate,
json_unquote(json_extract(a.thedata, ‘$.call_3time_15srate’)) call_3time_15srate,
json_unquote(json_extract(a.thedata, ‘$.top10_call_count’)) top10_call_count,
json_unquote(json_extract(a.thedata, ‘$.top10_call_3count’)) top10_call_3count,
json_unquote(json_extract(a.thedata, ‘$.top10_call_6time’)) top10_call_6time,
json_unquote(json_extract(a.thedata, ‘$.call_6time’)) call_6time,
json_unquote(json_extract(a.thedata, ‘$.call_count’)) call_count,
json_unquote(json_extract(a.thedata, ‘$.call_3count’)) call_3count,
json_unquote(json_extract(a.thedata, ‘$.call_type_countrate’)) call_type_countrate,
json_unquote(json_extract(a.thedata, ‘$.call_type_6countrate’)) call_type_6countrate,
json_unquote(json_extract(a.thedata, ‘$.total_3fee’)) total_3fee,
d.create_time
from mongo.mongo_mobile_report_data_recent_analysis a
join mongo.mongo_mobile_datas d on a.orderid=d.orderid
where d.create_time > ‘2015-01-01 00:00:00’
这个 SQL 其实没什么特殊，类似的 SQL 我之前在 3.0.* 上也运行过多次。
这是相关的 tidb.log.zip (999.2 KB) 和 tidb_stderr.log.zip (414.7 KB)
问题挺严重的，请帮忙尽快看一下。
