SAP Knowledge Base Article - Preview

3424808 - High memory consumption under Pool/Statistics/Others

Symptom

  • The HANA system's indexserver and/or nameserver traces show high memory consumption on the 'Pool/Statistics/Others' allocator

    GLOBAL_ALLOCATION_LIMIT (GAL) = 262.31gb (281659473920b), SHARED_MEMORY = 5.59gb (6008467456b), CODE_SIZE = 3.34gb (3591475200b), NVM_ALLOCATED_SIZE = 0b, OOM_RESERVATION_ALLOCATOR_SIZE = 96.14mb (100810752b)
    PID=1342499 (hdbindexserver), PAL=262.44gb (281793691648b), AB=214.85gb (230701150208b), UA=0, U=193.86gb (208161113364b), FSL=0b, FMC=0b
    [Some processes may have been skipped]
    Total allocated memory= 261.87gb (281182674944b)
    Total used memory     = 237.27gb (254776221535b)
    Sum AB                = 271582732288
    Sum Used              = 245176278879

    Top "M_HEAP_MEMORY" allocators (component, name, size). Ordered descending by exclusive_size_in_use.
     1: Monitoring & Statistical Data:              Pool/Statistics/Others   78.56gb (84356804784b)

  • Other secondary heap allocators consumed by the backup catalog are observed to have high memory consumption also :
     2: System:                                     Pool/BackupRecoveryAllocator                                             50.71gb (54458097264b)
    3: Monitoring & Statistical Data:              Pool/RowEngine/MonitorView/StatisticsMonitors/M_DEV_BACKUP_CATALOG_LOG   22.01gb (23643517440b)
     4: Monitoring & Statistical Data:              Pool/Statistics                                                          17.16gb (18436880464b)


 

  • hdbcons output reveals that the largest contributors to 'Pool/Statistics/Others' are on the log backup catalog entries (44 GB & 39 GB in this example) :

    > mm bl -t Pool/Statistics/Others
    ## Start command at: 2024-01-24 14:07:15.231
    44825095680b (87549015 blocks) in use at: Dumping saved stack trace 9223511782203028926, 1 frames:
       0: 0x00007f18ffd775be in Backup::BackupCatalog_LogBackupStartEntry_V5::writeToView() const+0x38a at Backup/Catalog/impl/BackupCatalog_LogBackupStartEntry.cpp:422 (libhdbbackup.so)

    39221958720b (87549015 blocks) in use at: Dumping saved stack trace 9223511782203028125, 1 frames:
       0: 0x00007f18ffd7729d in Backup::BackupCatalog_LogBackupStartEntry_V5::writeToView() const+0x69 at Backup/Catalog/impl/BackupCatalog_LogBackupStartEntry.cpp:407 (libhdbbackup.so)
    91658560b (28476 blocks) in use at: Dumping saved stack trace 9223511778763300288, 1 frames:
     0: 0x00007f1832d15dc0 in <no symbol>+0x0 (<unknown>)
    90562752b (14741 blocks) in use at: Dumping saved stack trace 9223511778761988480, 1 frames:
     0: 0x00007f1832bd5980 in <no symbol>+0x0 (<unknown>)
    42563232b (147789 blocks) in use at: Dumping saved stack trace 9223511781797602519, 1 frames:
     0: 0x00007f18e7ad24d7 in UnifiedTable::UnifiedTablePageStatsProxy::initUnifiedTableStatisticsInStartup(ltt::refcounted_handle<DataAccess::PersistenceManager>&)+0x503 at UnifiedTable/impl/UnifiedTablePageStatsProxy.cpp:169 (libhdbunifiedtable.so)
    9770496b (19083 blocks) in use at: Dumping saved stack trace 9223511782202951347, 1 frames:
     0: 0x00007f18ffd646b3 in Backup::BackupCatalog_CatalogBackupStartEntry::writeToView() const+0x370 at Backup/Catalog/impl/BackupCatalog_CatalogBackupStartEntry.cpp:191 (libhdbbackup.so)
    8549184b (19083 blocks) in use at: Dumping saved stack trace 9223511782202950557, 1 frames:
     0: 0x00007f18ffd6439d in Backup::BackupCatalog_CatalogBackupStartEntry::writeToView() const+0x59 at Backup/Catalog/impl/BackupCatalog_CatalogBackupStartEntry.cpp:178 (libhdbbackup.so)
    1827840b (357 blocks) in use at: Dumping saved stack trace 9223511781705041581, 1 frames:
     0: 0x00007f18e228c6ad in Diagnose::impl::FeatureUsageStatisticsSingleton::FeatureUsageStatisticsSingleton(char const*, char const*, char const*, int, unsigned long (*)())+0x19 at Basis/Diagnose/impl/FeatureUsageStatistics.cpp:475 (libhdbbasis.so)
    1048576b (1024 blocks) in use at: Dumping saved stack trace 9223511781709446378, 1 frames:
     0: 0x00007f18e26bfcea in MemoryManager::OOMEventContainer::resize(unsigned long)+0x1066 at Basis/MemoryManager/impl/mmReportMemoryProblems.cpp:443 (libhdbbasis.so)
    537920b (3362 blocks) in use at: Dumping saved stack trace 9223511781704358751, 1 frames:
     0: 0x00007f18e21e5b5f in Configuration::ParameterRegistry::registerParameter(Configuration::ParameterBase&)+0x29b at Basis/Configuration/impl/ParameterRegistry.cpp:46 (libhdbbasis.so)
    Top 20 allocators:
    Pool/Statistics/Others: 78.50gb (84297569520b) (175342956 blocks)
    [OK]
    ## Finish command at: 2024-01-24 14:11:50.750 command took: 4.592 min


Read more...

Environment

SAP HANA Platform Edition 2.0

Keywords

KBA , HAN-DB , SAP HANA Database , HAN-DB-BAC , SAP HANA Backup & Recovery , 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.