Symptom
Errors 3307 and 6103 along with a zombie spid may occur during periods when there are many concurrent users logging into an ASE server
server Error: 3307, Severity: 21, State: 1
server Process 138 was expected to hold logical lock on page 305 in database master for object syslogins, index number 2.
server Error: 3307, Severity: 21, State: 1
server Process 138 was expected to hold logical lock on page 305 in database master for object syslogins, index number 2.
server update of syslogins failed
server Error: 21, Severity: 21, State: 1
server WARNING - Fatal Error 3307 occurred at Apr 9 2014 12:20PM. Please note the error and time, and contact a user with System Administrator (SA) authorization.
server Error: 3307, Severity: 21, State: 1
server Process 138 was expected to hold logical lock on page 305 in database master for object syslogins, index number 2.
server Error while undoing log row in database 'master'. Rid pageid = 0x38c5; row num = 0x1.
server WARNING: Pss 0x0x00002aaabe06d4a0 found with open sdes. pspid 138, psuid 3, pcurdb 1, system table entry 2, sdesp 0x0x00002aaabbace4c0, objid 8.
server Error: 6103, Severity: 17, State: 1
server Unable to do cleanup for the killed process; received Msg 3300.
server WARNING: spid 138 with suid 3 and curdbid 1 has an active transaction in dbid 1 with xactid (14532, 17).
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 12.5.4
Product
Keywords
KBA , 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.