SAP Knowledge Base Article - Preview

2006080 - Error 1251 and 6103. A killed spid failed to rollback and resulted in a phantom spid with blocking locks - ASE

Symptom

  • Spid 279 was terminated using the tsql command,  'kill 279'.  
  • The spid failed to cleanly rollback and left a phantom spid with blocking locks and logged ASE errors 21, 1251 and 6103. 
  • Immediately after the kill ASE began logging these errors. 

server  Process id 279 killed by Hostname anyhost, Host process id 541.
server  Error: 21, Severity: 26, State: 1
server  Error: 1251, Severity: 26, State: 1
server  An in-use preallocated semaphore cursor was encountered.
server  Error while undoing log row in database 'asedatabase'.  Rid pageid = 0x0; row num = 0x0.
server  WARNING: Pss 0x00000001701a9248 found with open sdes. pspid 279, psuid 1874, pcurdb 10, system table entry 0,sdesp 0x000000016b89e3e8, objid 8.
server  WARNING: Pss 0x00000001701a9248 found with open sdes. pspid 279, psuid 1874, pcurdb 10, system table entry 1,sdesp 0x000000016b89b9b0, objid 1.
server  WARNING: Pss 0x00000001701a9248 found with open sdes. pspid 279, psuid 1874, pcurdb 10, system table entry 2,sdesp 0x000000016b89e3e8, objid 8.
server  WARNING: Pss 0x00000001701a9248 found with open sdes. pspid 279, psuid 1874, pcurdb 10, system table entry 3,sdesp 0x000000016b89b9b0, objid 1.
server  WARNING: Pss 0x00000001701a9248 found with open sdes. pspid 279, psuid 1874, pcurdb 10, system table entry 5,sdesp 0x000000016b89b3a8, objid 99.
server  Error: 6103, Severity: 17, State: 1
server  Unable to do cleanup for the killed process; received Msg 3300.
server  WARNING: spid 279 with suid 1874 and curdbid 10 has an active transaction in dbid 10 with xactid (34450, 0).


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0
  • Sybase Adaptive Server Enterprise (ASE) 15.0
  • Sybase Adaptive Server Enterprise (ASE) 15.5

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5

Keywords

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.