SAP Knowledge Base Article - Preview

3807720 - Unexpected spikes in data backup size without corresponding data growth

Symptom

  • The complete data backup size was observed increasing but there isn't large table size change. 
  • SQL "HANA_Backups_SizeEstimation" enclosed in note 1969700 shows that the estimated complete data backup sizes is indeed larger without table growth.
  • Following messages can be observed in indexserver trace:
     KernelSentinel   KernelSentinelJob.cpp(01691) : There are too many un-collected versions on table '<schema name>.<table name>' (TABLE_OID = ***, NUM_VERSIONS = ***, MIN_READ_TIMESTAMP = *****).
    The cursor possibly blocks the garbage collection:
    CONNECTION_ID = ***, CONNECTION_STATUS = IDLE, HOST = vhzjehp4db01 : 30240, IDLE_TIME = **** sec,
    STATEMENT_STATUS = SUSPENDED, STATEMENT_LIFE_TIME = ***** sec, ISOLATION_LEVEL = READ COMMITTED.       
  • Following HANA alert is raised:
    Priority:
    4 (High)

    Alert ID:
    42

    Alert Name:
    Long running/idling cursors


Read more...

Environment

  • SAP HANA, platform edition

Product

SAP HANA, platform edition 2.0

Keywords

hana backup size spike, complete data backup large, cleanup file size, long running cursor, idling cursor, suspended statement, garbage collection blocked, idle_cursor_lifetime, mvcc history, hana_garbagecollection_overview, hana_backups_sizeestimation, jdbc client, transactional lobs, backup growth without data growth, cursor timeout , KBA , HAN-DB-BAC , SAP HANA Backup & Recovery , HAN-DB , SAP HANA Database , HAN-DB-PER , SAP HANA Database Persistence , How To

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.