SAP Knowledge Base Article - Preview

3391515 - HANA server Log backup failing intermittently with error "Allocation failed" error

Symptom

Total allocated memory= 238.48gb (256067989504b)
Total used memory     = 189.83gb (203835447231b)
Sum AB                = 236636102656
Sum Used              = 184403560383
Heap memory fragmentation: 20% (this value may be high if defragmentation does not help solving the current memory request)

 

Top "M_HEAP_MEMORY" allocators (component, name, size). Ordered descending by exclusive_size_in_use.
1: Column Store Tables:                        Pool/ColumnStore/Main/Dictionary/RoDict                              28.23gb (30312706167b)
2: System:                                     Pool/PersistenceManager/PersistentSpace/DefaultLPA/DataPage          9.36gb (10051284992b) (64mb (67108864b) precharged, 256kb (262144b) in preparation)
3: Row Store Tables:                           Pool/RowStoreTables/CpbTree                                          6.05gb (6502303968b)
4: Column Store Tables:                        Pool/PersistenceManager/UnifiedTableContainer                        3.88gb (4167581784b)
5: System:                                     Pool/PersistenceManager/PersistentSpace/DefaultLPA/ShadowPage        3.82gb (4110417920b) (64mb (67108864b) precharged, 16mb (16777216b) in preparation)
6: System:                                     Pool/ColumnStore/System                                              2.01gb (2168289968b)
7: Caches:                                     Pool/RowEngine/SQLPlan                                               1.82gb (1965004880b)
8: Monitoring & Statistical Data:              Pool/Statistics                                                      1.71gb (1841145920b)
9: System:                                     AllocateOnlyAllocator-unlimited/FLA-UL<24592,1>/MemoryMapLevel3Nodes 1.52gb (1632687472b)
10: Column Store Tables:                        Pool/ColumnStore/Delta                                               1.25gb (1346378544b)
11: Statement Execution & Intermediate Results: Pool/malloc/libhdbcsapi.so                                           1.14gb (1228637093b)
12: System:                                     Pool/malloc/libhdbcsmd.so                                            1.09gb (1176763136b)
13: System:                                     Pool/RowEngine/QueryExecution/SearchAlloc                            1.04gb (1125519640b)
14: Column Store Tables:                        Pool/ColumnStore/Main/Uncompressed                                   989.98mb (1038076336b)


Read more...

Environment

HANA 2.0

HANA 1.0

Keywords

KBA , HAN-DB , SAP HANA Database , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.