Symptom
- One INSERT task started 2 days ago and has not finished yet.
- ASE server can't be SHUTDOWN due to active process (The INSERT task).
- The INSERT task can't be killed even with force option as it is in latch sleep:
1> kill 17 with force
2> go
A SHUTDOWN command is already in progress. Please log off.
Msg 6125, Level 16, State 1:
Server 'SID', Line 2:
You cannot kill spid '17' with force option as it is waiting on the latch held by spid '594'. - The latch holder (in this case spid 594) has already gone:
1> kill 594 with force
2> go
A SHUTDOWN command is already in progress. Please log off.
Msg 6106, Level 16, State 1:
Server 'SID', Line 1:
Process '594' is not an active process number.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
Product
SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver 7.5
Keywords
SHUTDOWN, latch, kill, force, nowait , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
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.
SAP Knowledge Base Article - Preview