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
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.
SAP Knowledge Base Article - Preview