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 for Me (Login required).

Search for additional results

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