SAP Knowledge Base Article - Preview

2789764 - Spids hanging and cannot be killed - zombie processes - SAP ASE


  • Unexplained zombie (hung processes).

fid  spid      status   loginame origname hostname blk_spid  dbname     tempdbname                  cmd  block_xloid threadpool
--- -----     --------  ----------  ----------  --------------------  ---------     --------------- ------------------  -------------------------- --
0     67  lock sleep mylogin mylogin    7   tempdb     tempdb            CREATE TABLE           0   syb_default_pool
0     75  latch sleep login2     login2    0   tempdb     tempdb            CREATE TABLE           0   syb_default_pool

  • Neither of the above items can be killed.
  • ASE errorlog shows:

Killing spid:  <value> will not be immediate because it is waiting for a latch held by spid:  <value>.



  • SAP Adaptive Server Enterprise  (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0


SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0


CR818538, CR#818538, 818538, temporary, table, allocation page, lock, hang , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.