SAP Knowledge Base Article - Preview

3367235 - "_SYS_STATISTICS"."ALERT_ADMISSION_CONTROL_ENQUEUE_EVENT" fails with a composite out of memory event

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.