SAP Knowledge Base Article - Preview

2303462 - "HK GC” & “HK CHORES” blocking processes in tempdb - SAP ASE

Symptom

  • Tempdb log space fills up with error 1105 reported in the errorlog.
  • A number of processes were blocked by system spid 'Housekeepr Garbage Collector' (HK GC)
  • Using lct_admin or kill command to abort all processes which were holding tempdb log space did not release the blocking
  • Adding more log space did not release the blocking
  • dbcc stacktrace on the "HK GC" spid shows this stack:

    upsleepgeneric
    uppause
    pg_test_allocator
    pg__deallpage
    pg_deallpage
    bt__pgdealloc
    bt__shrinkleaf
    bt__shrink
    bt_gccommon_hkreorg
    hkgc__processindex
    hkgc__processelem
    hk_gc_handler
    hkgc_garbagecollect
    hk_gc_proc


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
    • Only instance observed on SP63
    • Other versions may show the same symptoms

Product

SAP Adaptive Server Enterprise 12.5

Keywords

HK GC , blocking , pg_test_allocator,temp database, temporary db , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.