如何查看doris有哪些任务导致服务卡住,并杀死该任务

Viewed 132

在使用doris的过程中,发现be日志一直刷:导致后续所有的sql都没法执行。

I20240918 11:32:31.641733 2377666 topic_subscriber.cpp:48] handle topic WORKLOAD_SCHED_POLICY successfully
I20240918 11:32:32.008466 1929734 memtable_memory_limiter.cpp:224] reached hard limit, process mem: 28.39 GB (without allocator cache: 27.46 GB), load mem: 680.87 KB, memtable writers num: 1 (active: 0, write: 0, flush: 0)
I20240918 11:32:33.012374 1929734 memtable_memory_limiter.cpp:224] reached hard limit, process mem: 28.39 GB (without allocator cache: 27.46 GB), load mem: 680.87 KB, memtable writers num: 1 (active: 0, write: 0, flush: 0)
I20240918 11:32:34.012400 1929734 memtable_memory_limiter.cpp:224] reached hard limit, process mem: 28.39 GB (without allocator cache: 27.46 GB), load mem: 680.87 KB, memtable writers num: 1 (active: 0, write: 0, flush: 0)

1、请问如何定位到是哪个sql 导致doris被卡住,并且如何杀死该job?

2、在审计日志里面发现了很多用root用户执行的sql,如:

[query] |Client=|User=root|Ctl=internal|Db=__internal_schema|State=OK|ErrorCode=0|ErrorMessage=|Time(ms)=2
96|ScanBytes=2378304|ScanRows=24774|ReturnRows=0|StmtId=0|QueryId=3bd90071a022344a-b3f1723f134e5563|IsQuery=true|isNereids=true|fe
Ip=10.0.11.144|Stmt=SELECT SUBSTRING(CAST(MIN(`modify_time`) AS STRING), 1, 1024) as min, SUBSTRING(CAST(MAX(`modify_time`) AS STR
ING), 1, 1024) as max FROM `ren_pro`.`ods_third_pay_plan` |CpuTimeMS=496|ShuffleSendBytes=52|ShuffleSendRows=1|SqlH
ash=null|peakMemoryBytes=16636192|SqlDigest=|TraceId=|WorkloadGroup=normal|FuzzyVariables=

请问是doris自己会用root执行这些任务吗?

1 Answers