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

Search for additional results

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