Symptom
HANA system generates OOM dump continuously with procedure "_SYS_STATISTICS"."ALERT_ADMISSION_CONTROL_ENQUEUE_EVENT", content from OOM is like below:
Top "limited composite allocator" allocators (component, name, size). Ordered descending by exclusive_size_in_use.
1: System: WorkloadCtx/<identifer>/Statement/<statement_id>/Pool/RowEngine/QueryExecution/SearchAlloc <memory_size>gb
2: Statement Execution & Intermediate Results: WorkloadCtx/<identifer>/Statement/<statement_id>
SQL:
/* procedure: "_SYS_STATISTICS"."ALERT_ADMISSION_CONTROL_ENQUEUE_EVENT" variable: ADMISSION_CONTROL_ENQUEUE line: 19 col: 1 (at pos 1663) */ SELECT
history.host,
history.port,
history.host || '.' || history.port AS host_port,
history.admission_control_queue_size as current_size,
config.value AS max_queue_size
FROM _SYS_STATISTICS.source_alert_131_load_history_service AS history,
( SELECT
myservices.host,
myservices.port,
config.value
FROM _SYS_STATISTICS.source_alert_131_configuration_parameter_values AS config,
_SYS_STATISTICS.source_alert_131_services AS myservices
WHERE config.key = 'max_queue_size'
and config.section = 'admission_control' ) AS config
WHERE (history.host,
history.port,
history.time) in ( SELECT
host,
port,
max(time)
from _SYS_STATISTICS.source_alert_131_load_history_service
WHERE time > CAST('yyyy-mm-dd hh:mm:ss' AS TIMESTAMP)
group by host,
port )
and history.host = config.host
and history.port = config.port
and history.time > CAST('yyyy-mm-dd hh:mm:ss' AS TIMESTAMP) WITH HINT(IGNORE_PLAN_CACHE)
Read more...
Environment
SAP HANA database 2.0
Keywords
OOM, call _SYS_STATISTICS.STATISTICS_SCHEDULABLEWRAPPER('Timer', ?, ?, ?, ?), ADMISSION_CONTROL_ENQUEUE, 05bcdb48df2a6071bb01ddcc270b3f08, d6fd6678833f9a2e25e7b53239c50e9a , KBA , HAN-DB-MON , SAP HANA Monitoring , HAN-DB-PERF , SAP HANA Database Performance , 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.