3422036 - Open transaction in 'commit' not moving on and blocking other processes - SAP ASE - SAP ASE

• A process is idle and sp_who reports it as "AWAITING COMMAND" and in 'recv sleep'
• This spid is not not moving on and blocking other processes as it is holding lock(s)
• The transaction will never commit, but it is killable.
• The spid has to be killed before other processes can progress

• Below some typical outputs that show the issue
  Some outputs are truncated for clarity
  
  
  • Long running transaction in syslogshold / sp_transaction
    
    select * from master..syslogshold
    
    dbid   reserved    spid   page     ...  starttime                       name
    ------ ----------- ------ ---------- ------------------------------- ------------------------
         6           0    210    1063235      Jun 16 2023  3:29AM    $user_transaction
    
    
  • dbcc stacktrace on the spid includes stack functions:
    
    upsleepgeneric
    usrfill
    
    
  • dbcc pss and/or dbcc sqltext show SQL Text last command was COMMIT TRAN

SAP Adaptive Server Enterprise (ASE) 16.x

CR828165, CR#828165, 828165 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem