hanaOOM分析
(2022-10-17 15:01:55)
1、检查trace log (indexserver_alert_lqhdb01.trc)
- 0: public ltt::bad_alloc@0x7f737a532c08
VMI
- 0: public
ltt::exception@0x7f737a532c40
- 72: public
std::bad_alloc@0x7f7379864f80 SI
- 72:
public std::exception@0x7f73798651b0
1: System:
AggregatedStatement
3.90tb
(4294880829367b)
(limit=3.90tb, limitSumAllocated=3.85tb))
2: Statement Execution & Intermediate
Results: Connection/324799/Statement/1395005022735523/IMPLICIT
178.29gb (191445773568b)
3: Statement Execution & Intermediate
Results: Connection/349043/Statement/1499129118653325/IMPLICIT
175.79gb (188761411408b)
4: Statement Execution & Intermediate
Results: Connection/364977/Statement/1567565577020555/IMPLICIT
158.12gb (169789349072b)
5: Statement Execution & Intermediate
Results: Connection/363125/Statement/1559613555720763/IMPLICIT
139.79gb (150099705376b)
6: Statement Execution & Intermediate
Results: Connection/312702/Statement/1343045634595038/IMPLICIT
91.39gb (98132798584b)
7: Statement Execution & Intermediate
Results: Connection/361286/Statement/1551715155153415/IMPLICIT
91.24gb (97968967376b)
8: Statement Execution & Intermediate
Results: Connection/342844/Statement/1472504580472636/IMPLICIT
80.11gb (86026963728b)
9: Statement Execution & Intermediate
Results: Connection/317384/Statement/1363156727732640/IMPLICIT
76.95gb (82629900352b)
exception type information:
[271401]{-1}[-1/-1] 2022-10-17 09:29:36.052089 e
OOMFlagPropagati JobExecutorUtil.cpp(00726) :
JobFinalObjectImpl::transferError: oom flag transferred
[290964]{309087}[465/-1] 2022-10-17 09:27:11.758769 e
Memory
mmReportMemoryProblems.cpp(01834) : Top "limited
composite allocator" allocators (component, name, size). Ordered
descending by exclusive_size_in_use.
10: Statement Execution & Intermediate Results:
Connection/348909/Statement/1498552865554644/IMPLICIT 75.25gb
(80802755448b
2、 查询到相关的SQL 信息
SELECT TOP 200000 * FROM
"_SYS_STATISTICS"."HOST_SERVICE_THREAD_SAMPLES_STATEMENTS_BASE"
where statement_ID='1395005022735523'
3、 导入Note
1969700,查询SQL信息
参考
2332170 - How-To: Analyzing SAP HANA
composite OOM dump