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 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>.

• SAP Adaptive Server Enterprise  (ASE) 15.7
• SAP Adaptive Server Enterprise (ASE) 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