SAP Knowledge Base Article - Preview

2608960 - Deadlock between two processes with shared lock - SAP ASE

Symptom

  • SAP ASE database server reported deadlock on processes both with shared locks.
  • server Deadlock Id 10 detected
    Deadlock Id 10 detected. 1 deadlock chain(s) involved.
    Deadlock Id 10: Process (Familyid 0, Spid 841, Suid 45) was executing a INSERT command in the procedure '<stored procedure name>' at line 29 at nested level 1.
    Deadlock Id 10: Process 841 was involved in application ''.
    Deadlock Id 10: Process 841 was involved on host name '<host name>'.
    Deadlock Id 10: Process 841 was involved in transaction '$ins'.
    SQL Text: <executing line from the stored procedure>
    Executing procedure: <stored procedure name>
    Subordinate SQL Text:
    .............................
    Deadlock Id 10: Process (Familyid 0, Spid 938, Suid 45) was executing a SELECT command in the procedure '<stored procedure name>' at line 279 at nested level 1.
    Deadlock Id 10: Process 938 was involved in application ''.
    Deadlock Id 10: Process 938 was involved on host name 'host name>.
    SQL Text: etl_curr
    Executing procedure: <stored procedure name>
    Subordinate SQL Text:
    ...................................
    Deadlock Id 10: Process (Familyid 0, Spid 938) was waiting for a 'shared page' lock on page 295761 of table 'table name' in database 'database name' but process (Familyid 0, Spid 841) already held a 'shared page' lock on it.
    Deadlock Id 10: Process (Familyid 0, Spid 841) was waiting for a 'shared page' lock on page 295742 of table 'table name' in database 'database name' but process (Familyid 0, Spid 938) already held a 'shared page' lock on it.
    Deadlock Id 10: Process (Familyid 0, Spid 841) was chosen as the victim.
    Victim process host = `host name', user = `user name' program name = `' host processes = `' .
    End of deadlock information.

Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

isolation level 0, dirty reads, dead lock, shared lock , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.