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
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.