SAP Knowledge Base Article - Preview

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

Symptom

  • Unexplained zombie (hung processes).

fid  spid      status   loginame origname hostname blk_spid  dbname     tempdbname                  cmd  block_xloid threadpool
--- -----     --------  ----------  ----------  --------------------  ---------     --------------- ------------------  -------------------------- --
0     67  lock sleep mylogin mylogin hostname.xxx.xxx    7   tempdb     tempdb            CREATE TABLE           0   syb_default_pool
0     75  latch sleep login2     login2 hostname.xxx.xxx    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>.


Read more...

Environment

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

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

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.