2510916 - Deadlocklng in RSSD on rs_databases table - SRS | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2510916 - Deadlocklng in RSSD on rs_databases table - SRS

Symptom

  • ASE hosted RSSD reports deadlocks on the rs_databases table
     
  • Deadlock Id nnn detected. 1 deadlock chain(s) involved.
    Deadlock Id nnn: Process ... was involved in application 'RepServer'.
    Deadlock Id nnn: Process (Familyid 0, Spid ...) was waiting for a 'shared page' lock on page ... of table 'rs_databases' in database '<RSSDname>' but process (Familyid 0, Spid ...) already held a 'exclusive page' lock on it.
    Deadlock Id nnn: Process (Familyid 0, Spid ...) was waiting for a 'exclusive page' lock on page ... of table 'rs_databases' in database '<RSSDname>' but process (Familyid 0, Spid ...) already held a 'shared page' lock on it.
    Deadlock Id nnn: Process (Familyid 0, Spid ...) was chosen as the victim.
    Victim process host = '<hostname>', user = '<RSSD_maintuser>' program name = 'RepServer' host processes = '...'.

Read more...

Environment

  • SAP Replication Server (SRS) 15.2 and lower
  • SAP Adaptive Server Enterprise (ASE) 

Product

SAP Replication Server 15.7 ; SAP Replication Server 16.0 ; SAP Sybase Replication Server 15.7, heterogeneous edition ; SAP Sybase Replication Server 15.7, option for IBM DB2 ; SAP Sybase Replication Server 15.7, option for Microsoft SQL Server ; SAP Sybase Replication Server 15.7, option for Oracle ; SAP Sybase Replication Server 15.7, real-time loading edition ; Sybase Replication Server 15.5

Keywords

Datarows datarow lock scheme allpages allpage locking , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Problem

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.