2471725 - Long running spid in "recv sleep" blocking other sessions and/or stopping log truncation due to open tran - SAP ASE

• In an ASE server, there is a long running process (spid) with
  • a status of "recv sleep" and
  • cmd showing "AWAITING COMMAND" and
  • a starttime that is well before the current time
    
    
• This process shows a transaction name of $user_transaction or $chained_transaction
• This process is blocking other ASE spids, which can show as "lock sleep" and/or
• This process is causing the transaction log to fill up as a dump tran is not releasing log space

SAP Adaptive Server Enterprise (ASE) - All Versions.

“done command” , "sp_transactions", "commit transaction", "rollback transaction", "sp_who" ,  $user_transaction , $chained_transaction , chained , set chained on , chained mode , chained transaction mode , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem