Symptom
- Alerts for a HANA secondary site are observed on the currently running primary site :
"Delta Merge was not executed successfully on host:port for table /<>/table_name in schema SAPABAP1 for 1 occurrences in the last 24 hours." - (2445867 - How-To: Interpreting and Resolving SAP HANA Alerts)
('Host:port' have been obfuscated in the image for confidentiality reasons)
- Traces from the indexserver on the Secondary site shows memory exhaustion in the form of Resource Container shrinks and a lack of delta merge tokens :
indexserver_host.port.529.trc
++++++++
[114737]{-1}[-1/9223372036854775806] 2022-07-19 12:38:20.897169 e delta_merge CsTableMerge.cpp(02329) : Error in local merge: not enough merge tokens for delta merge or optimize compression : table = SID::SAPABAP1:<table_name> (t 215523), merge motivation =
[96656]{-1}[-1/-1] 2022-07-19 12:39:19.192782 w ResMan ResourceContainerShrink.cpp(03167) : Information about shrink at 2022-07-19 12:39:19 188 Local:
Reason for shrink: IPMM (other process). Request ID= 24068893
ShrinkCaller
0: 0x00007f429c7e39fb in ResourceManager::ShrinkInformation::updateShrinkInformation(char const*, unsigned long, bool)+0x97 at Basis/ResourceManager/impl/ResourceContainerShrink.cpp:1042 (libhdbbasis.so)
1: 0x00007f429c7f1641 in ResourceManager::ResourceContainerImpl::genericShrink(unsigned long, unsigned long, char const*, unsigned long, MemoryManager::ReclaimMemoryTaskType)+0x29a0 at Basis/ResourceManager/impl/ResourceContainerShrink.cpp:3166 (libhdbbasis.so)
2: 0x00007f429c6c98ec in MemoryManager::CompactionThread::compactCompactors(unsigned long, bool&, char const*, unsigned long, MemoryManager::ReclaimMemoryTaskType)+0x518 at Basis/MemoryManager/impl/mmCompactionThread.cpp:269 (libhdbbasis.so)
3: 0x00007f429c6cad0b in MemoryManager::CompactionThread::doCompactionIntern(MemoryManager::Precharge&, unsigned long, unsigned long, unsigned long, unsigned long&, char const*, unsigned long, MemoryManager::ReclaimMemoryTaskType, bool)+0x8b7 at Basis/MemoryManager/impl/mmCompactionThread.cpp:433 (libhdbbasis.so)
4: 0x00007f429c6cc691 in MemoryManager::CompactionThread::doIpmmCompactionIntern(unsigned long, int, unsigned long, unsigned long, unsigned long, MemoryManager::ProcessSlot::RequestedTask)+0x320 at Basis/MemoryManager/impl/mmCompactionTrigger.cpp:458 (libhdbbasis.so)
5: 0x00007f429c6cd7ce in MemoryManager::CompactionThread::run(Execution::ThreadRC&)+0x22a at Basis/MemoryManager/impl/mmCompactionTrigger.cpp:413 (libhdbbasis.so)
6: 0x00007f429c52c6c6 in Execution::Thread::staticMainImp(Execution::Thread*)+0x542 at Basis/Execution/impl/Thread.cpp:574 (libhdbbasis.so)
7: 0x00007f429c533ca5 in Execution::pthreadFunctionWrapper(Execution::Thread*)+0x1c1 at Basis/Execution/impl/ThreadInterposition.cpp:693 (libhdbbasis.so)
8: 0x0000000000000000 in <no symbol>+0x0 (<unknown>)
IPMM short info:
GLOBAL_ALLOCATION_LIMIT (GAL) = 699.87gb (751485059072b), SHARED_MEMORY = 22.92gb (24621215744b), CODE_SIZE = 3.21gb (3456172032b), NVM_ALLOCATED_SIZE = 0b, OOM_RESERVATION_ALLOCATOR_SIZE = 96.14mb (100810752b)
PID=96540 (hdbindexserver), PAL=1.90tb (2094153310208b), AB=661.68gb (710475743232b), UA=0, U=645.16gb (692738926253b), FSL=0b, FMC=0b
[Some processes may have been skipped]
Total allocated memory= 699.76gb (751366168576b)
Total used memory = 681.54gb (731801395748b)
Sum AB = 723288780800
Sum Used = 703724007972
Heap memory fragmentation: 2
. . . . .
Top "M_HEAP_MEMORY" allocators (component, name, size). Ordered descending by exclusive_size_in_use.
1: Column Store Tables: Pool/ColumnStore/Main/Dictionary/RoDict 211.93gb (227569076706b)
2: Column Store Tables: Pool/ColumnStore/Main/Compressed/Indirect 86.95gb (93373054952b)
3: Column Store Tables: Pool/ColumnStore/Main/Index/Single 80.83gb (86798670156b)
4: Column Store Tables: Pool/ColumnStore/Main/Uncompressed 62.86gb (67498445656b)
5: Column Store Tables: Pool/ColumnStore/Main/Rowid 61.11gb (65627156544b)
6: System: Pool/PersistenceManager/PersistentSpace/DefaultPageProvider:DataPage 23.35gb (25080799232b)
7: Column Store Tables: Pool/ColumnStore/Main/Dictionary/ValueDict 19.30gb (20734209968b)
8: Column Store Tables: Pool/ColumnStore/Main/Compressed/Sparse 19.07gb (20477639832b)
9: Column Store Tables: Pool/ColumnStore/Main/Compressed/Rle 9.26gb (9953156512b)
10: Column Store Tables: Pool/PersistenceManager/UnifiedTableContainer 8.60gb (9235985183b)
11: System: AllocateOnlyAllocator-unlimited/FLA-UL<24592,1>/MemoryMapLevel3Nodes 8.02gb (8617184352b)
12: System: Pool/PersistenceManager/DisasterRecoverySecondary/ReplayLogCache 5.27gb (5661156736b)
13: Column Store Tables: Pool/PersistenceManager/UnifiedTableContainer/MVCC 4.16gb (4475320936b)
14: Row Store Tables: Pool/RowStoreTables/CpbTree 4.06gb (4361942160b)
15: Column Store Tables: Pool/ColumnStore/Main/Compressed/Cluster 3.29gb (3534329312b)
16: Column Store Tables: Pool/ColumnStore/Main/Compressed/Prefix 3.16gb (3395067408b)
17: System: Pool/PersistenceManager/MidSizeLOBContainerFileIDMapping/Map 2.54gb (2732705008b)
18: System: Pool/PersistenceManager/ContainerFileIDMapping/FileIDBackMapper 2.50gb (2684830208b)
19: System: Pool/PersistenceManager/ContainerFileIDMapping/FileIDMapper 2gb (2147942912b)
20: System: Pool/ColumnStore/System 1.80gb (1937359024b)
Process: AB=661.68gb (710475743232b), U=645.16gb (692738926253b), fragmentation=2%.
Read more...
Environment
SAP HANA, platform edition 2.0
Product
SAP HANA, platform edition 2.0 ; SAP S/4HANA 2020
Keywords
KBA , HAN-DB , SAP HANA Database , HAN-DB-HA , SAP HANA High Availability (System Replication, DR, etc.) , 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.