SAP Knowledge Base Article - Preview

3221435 - Delta merge for a table fails due to "exception 2030111: System is running low on persistent memory"

Symptom

During Delta merge, the following lines are shown in the indexserver trace:

2022-07-05 14:19:00.238798 e delta_merge      SaveMergedAttributeJob.cpp(00090) : Caught exception in save merged column job: table = ***::***:<TABLE_NAME> (t 669690), rc = 2201, exception = exception  1: no.2030111  (Basis/MemoryManager/impl/NVMProvider.cpp:2997) TID: 320344
    System is running low on persistent memory, failed to allocate 142796334116B
exception throw location:
 1: 0x00007f863cfb9d58 in MemoryManager::NVMProviderSPI::createBlock(char const*, unsigned long, System::NUMAPolicy, System::NUMAPolicy&)+0x1ca4 at NVMProvider.cpp:2997 (libhdbbasis.so)
 2: 0x00007f86474ff562 in UnifiedTable::MainColumnFragmentObject::createNvmBlock(UnifiedTable::NvmBlockCreationState&, unsigned long, int)+0x190 at NvmBlockHelper.cpp:140 (libhdbunifiedtable.so)
 3: 0x00007f86474e4167 in UnifiedTable::MainColumnFragmentReader::createNvmBlock(UnifiedTable::NvmBlockCreationState&, unsigned long, int)+0x53 at ColumnFragmentReaderImpl.cpp:596 (libhdbunifiedtable.so)
 4: 0x00007f86590e3c31 in AttributeEngine::MemoryAvc2NvmWriter::actualWrite(AttributeEngine::AvcNvmWriter::Mode, unsigned long, bool&)+0xa0 at MemoryAvc2NvmWriter.cpp:141 (libhdbcs.so)
 5: 0x00007f86596708f7 in AttributeEngine::AvcNvmWriter::write(AttributeEngine::AvcNvmWriter::Mode)+0xb3 at AvcNvmWriter.cpp:135 (libhdbcs.so)
 6: 0x00007f865968621a in AttributeEngine::MemoryAvc2::save(AttributeEngine::MemoryAvc2::TpcVersion, bool)+0x246 at MemoryAvc2NvmWriter.h:32 (libhdbcs.so)
 7: 0x00007f8659686b9c in AttributeEngine::MemoryAvc2::prepareDeltaMergeSave(bool)+0x68 at AttributeValueContainer.cpp:3064 (libhdbcs.so)
 8: 0x00007f8659717901 in AttributeEngine::AttributeApi::prepareDeltaMergeSave(bool)+0x90 at AttributeApi.cpp:1403 (libhdbcs.so)
 9: 0x00007f864ff496c5 in TRexAPI::SaveMergedAttributeJob::doSave(TRexAPI::MergeAttributeInfo&, TRexAPI::DeltaMergeState&)+0x31 at SaveMergedAttributeJob.cpp:141 (libhdbcsapi.so)
10: 0x00007f864ff49efe in TRexAPI::SaveMergedAttributeJob::run(Execution::Context&, Execution::JobObject&)+0x5ea at SaveMergedAttributeJob.cpp:185 (libhdbcsapi.so)
11: 0x00007f863d10acbf in Execution::JobObjectImpl::run(Execution::JobWorker*)+0x218b at JobExecutorImpl.cpp:1194 (libhdbbasis.so)
12: 0x00007f863d0f41ea in Execution::JobWorker::runJob(ltt::smartptr_handle<Execution::JobObjectForHandle>&)+0x336 at JobExecutorThreads.cpp:382 (libhdbbasis.so)
13: 0x00007f863d0ee678 in Execution::JobWorker::run(void*&)+0x764 at JobExecutorThreads.cpp:1282 (libhdbbasis.so)
14: 0x00007f863d0acd8d in Execution::Thread::staticMainImp(Execution::Thread*)+0x529 at Thread.cpp:522 (libhdbbasis.so)
15: 0x00007f863d09cdc9 in Execution::pthreadFunctionWrapper(Execution::Thread*)+0x165 at ThreadInterposition.cpp:639 (libhdbbasis.so)
16: 0x00007f863c718509 in start_thread+0xd5 (libpthread.so.0)
17: 0x00007f863add2ecf in __GI___clone+0x3b (libc.so.6)
exception type information:
 - 0: public ltt::exception@0x7f863c67ec70
2022-07-05 14:19:00.365275 e delta_merge      CsTableMerge.cpp(07163) : do rollbackDeltaMerge merge for ***::***:<TABLE_NAME> (t 669690)
[390169]{-1}[3592/15636398825] 2022-07-05 14:19:02.232959 e Mergedog         Mergedog.cpp(01300) : Automerge failed: {IndexName: ***:<TABLE_NAME> , Trigger: 6, Critical: 0, ReclaimDelta: false, DeltaMerge: true, OptimizeCompression: false, MainSize: 153336919805}, error: Not enough persistent memory available.; table = ***::***:<TABLE_NAME> (t 669690), exception = exception 2030111: System is running low on persistent memory, failed to allocate 142796334116B(2201)


Read more...

Product

SAP NetWeaver all versions

Keywords

exception 2030111: System is running low on persistent memory, failed to allocate;  , 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.