SAP Knowledge Base Article - Preview

2785814 - HANA high CPU utilization caused by large backup catalog

Symptom

  • High cpu utilization by HANA hdbindexserver process
  • Runtime dumps collected during high cpu are showing e.g:

    671347[thr=97002]: SqlExecutor, TID: 106, UTID: -1, CID: 202084, LCID: 202084, parent: ---, SQLUserName: "SYSTEM", AppUserName: "joe-adm", AppName: "HDBStudio", ConnCtx: 202084 {LDBID: 2, LCID: 202084}, StmtCtx: (1) 867947425905061 {Parent: 202084, MemoryLimit: 0, ObjHdl: 139944950352896, User: "SYSTEM", Schema: "SYSTEM, SesCtx: {ObjHdl: 139007399698944, CID: 202084, LCID: 202084, User: "SYSTEM", Schema: "SYSTEM, Ver: 7, CtxID: 329726}}, type: "SqlExecutor", method: "", detail: "", command: "
    {
    SQL: SELECT TOP 1 t1.BACKUP_ID, ( SELECT sum(t2.BACKUP_SIZE) FROM public.M_BACKUP_CATALOG_FILES t2 WHERE t2.BACKUP_ID = t1.BACKUP_ID GROUP BY t2.BACKUP_ID ) as BBSIZE, t1.UTC_START_TIME, t1.UTC_END_TIME, t1.ENTRY_TYPE_NAME FROM public.M_BACKUP_CATALOG AS t1 WHERE t1.STATE_NAME = 'successful' AND ( t1.ENTRY_TYPE_NAME = 'complete data backup' OR t1.ENTRY_TYPE_NAME = 'data snapshot' ) ORDER BY t1.UTC_START_TIME DESC

    QUERY PLAN:
    |OPERATOR_NAME|OPERATOR_DETAILS|OPERATOR_PROPERTIES|EXECUTION_ENGINE|DATABASE_NAME|SCHEMA_NAME|TABLE_NAME|TABLE_TYPE|TABLE_SIZE|OUTPUT_SIZE|SUBTREE_SIZE|OPERATOR_ID|PARENT_OPERATOR_ID|LEVEL|POSITION|HOST|PORT|BUFFER_ID|
    |ROW SEARCH|M_BACKUP_CATALOG.BACKUP_ID, SUM(SUM(M_BACKUP_CATALOG_FILES.BACKUP_SIZE)), M_BACKUP_CATALOG.UTC_START_TIME, M_BACKUP_CATALOG.UTC_END_TIME, SUBSTR(T0.ENTRY_TYPE_NAME, 0, 64)|
    ....


    RELATED OBJECTS:
    -TABLE:SYS.P_PRIVILEGES_(aaa-bbb-hdb1:32003),SYS.DUMMY(aaa-bbb-hdb1:32003)
    -VIEW:SYS.HAS_NEEDED_SYSTEM_PRIV_INCL_SYS_STAT,SYS.M_BACKUP_CATALOG,SYS.M_BACKUP_CATALOG_FILES
    -SYNONYM:M_BACKUP_CATALOG,M_BACKUP_CATALOG_FILES
    -USER:SYSTEM

    ...
    }..

    " at 0x00007f5cae0ca7f9 in syscall+0x19 (libc.so.6)

  • Large number of entries in backup catalog (HANA_BACKUP_Catalog_Size.txt shows CATALOG_SIZE_MB over 1000 (1Gb)) 

Read more...

Environment

SAP HANA Enterprise Edition 1.0

Product

SAP HANA, enterprise edition 1.0

Keywords

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 ONE Support launchpad (Login required).

Search for additional results

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