SAP Knowledge Base Article - Preview

2075603 - Execution of function lct_admin() to abort a process fails with "Unable to do cleanup for the killed process ..." - SAP ASE

Symptom

  • Execution of a command similar to:

         select lct_admin("abort", 0, <dbid>)

    or

         select lct_admin("abort", <spid>)
     
  • Attempt was previously made to KILL the process in question
  • The process was in LOG SUSPEND state when KILL was attempted
  • ASE errorlog may report errors similar to:

Error: 4720, Severity: 16, State: 1
The transaction log in database tempdb is almost full.  Your transaction is being suspended until space is made available in the log.

Error: 7437, Severity: 16, State: 1
lct_admin(abort): Your process, with process ID 225, is now being aborted by administrator request. It has been waiting in log-suspend state in database 'tempdb'.

WARNING: Pss 0x0x00000001766b3608 found with open sdes. pspid 225, psuid -1163, pcurdb 2, system table entry 0, sdesp 0x0x0000000162aca490, objid 1920382379.

Unable to do cleanup for the killed process; received Msg 3617.

  • Process is not cleaned up and may cause blocking or other issues in ASE
  • ASE must be recycled to clear this condition


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

sybase, phantom, spid, orphan, CR767295 , 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 for Me (Login required).

Search for additional results

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