SAP Knowledge Base Article - Preview

3111543 - SAP HANA - Out of Memory on Pool/JoinEvaluator/JECreateNTuple

Symptom

You observed an OOM (Out of Memory) dump pointing to heap memory allocator Pool/JoinEvaluator/JECreateNTuple.

From OOM dump trace:  <service>_<host>.<port>.rtedump.<timestamp>.oom.trc

You observed a similar report:

[MEMORY_OOM]  Information about current out of memory situation: (2021-06-10 05:37:05 038 Local)
OUT OF MEMORY occurred.
Host: xxxxx
Executable: hdbindexserver
PID: 72083
Failed to allocate 52866730712 byte.
GLOBAL_ALLOCATION_LIMIT (GAL) = 2.69tb (2968545918976b), SHARED_MEMORY = 66.17gb (71052582912b), CODE_SIZE = 2.05gb (2205351936b), OOM_RESERVATION_ALLOCATOR_SIZE = 288.54mb (302563328b)

Top "M_HEAP_MEMORY" allocators (component, name, size). Ordered descending by exclusive_size_in_use.
 1: Statement Execution & Intermediate Results: Pool/JoinEvaluator/JECreateNTuple                                       249.63gb (268041641168b)


Read more...

Environment

  • SAP HANA, platform edition 1.0 SPS12
  • SAP HANA, platform edition 2.0 SPS01

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

JECreateNTuple, memory allocation, join evaluator , KBA , HAN-DB-ENG , SAP HANA DB Engines , 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 ONE Support launchpad (Login required).

Search for additional results

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