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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.