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.
SAP Knowledge Base Article - Preview