加载中…
个人资料
  • 博客等级:
  • 博客积分:
  • 博客访问:
  • 关注人气:
  • 获赠金笔:0支
  • 赠出金笔:0支
  • 荣誉徽章:
正文 字体大小:

hanaOOM分析

(2022-10-17 15:01:55)
1、检查trace log  (indexserver_alert_lqhdb01.trc)

exception type information:
 - 0: public ltt::bad_alloc@0x7f737a532c08 VMI
   - 0: public ltt::exception@0x7f737a532c40
   - 72: public std::bad_alloc@0x7f7379864f80 SI
     - 72: public std::exception@0x7f73798651b0
[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.
 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)
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

0

阅读 收藏 喜欢 打印举报/Report
  

新浪BLOG意见反馈留言板 欢迎批评指正

新浪简介 | About Sina | 广告服务 | 联系我们 | 招聘信息 | 网站律师 | SINA English | 产品答疑

新浪公司 版权所有