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 ONE Support launchpad (Login required).

Search for additional results

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