SAP Knowledge Base Article - Preview

2004787 - Errors 3307 and 6103 along with a zombie spid may occur during periods when there are many concurrent users logging into the server - ASE

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

SAP Adaptive Server Enterprise 12.5

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.