SAP Knowledge Base Article - Preview

2686311 - Deadlock involve "update row" locks

Symptom

 
  • Running update command on a DOL table with different where clause.
  • Deadlock detected on "update row" locks on the same object but different pages and row number.
    Example:
    Deadlock Id 3620 detected
    Deadlock Id 3620 detected. 1 deadlock chain(s) involved.
    Deadlock Id 3620 : Process (Familyid 0, Spid 9088, Suid 211) was executing a UPDATE command in the procedure 'objid 1166050492' at line 1 at nested level 1.
    Deadlock Id 3620: Process 9088 was involved in application 'app'.
    Deadlock Id 3620: Process 9088 was involved on host name ''.
    Deadlock Id 3620: Process 9088 was involved in transaction '$chained_transaction'.
    SQL Text: UPDATE table1 set ... where
    Deadlock Id 3620: Process (Familyid 0, Spid 2100, Suid 211) was executing a UPDATE command in the procedure 'objid 1166050492' at line 1 at nested level 1.
    Deadlock Id 3620: Process 2100 was involved in application 'app'.
    Deadlock Id 3620: Process 2100 was involved on host name ''.
    Deadlock Id 3620: Process 2100 was involved in transaction '$chained_transaction'.
    SQL Text: UPDATE table1 set ... where
    Deadlock Id 3620: Process (Familyid 0, Spid 2100) was waiting for a 'update row' lock on row 0 page 563202 of the 'table1' table in database 'DB' but process (Familyid 0, Spid 9088) already held a 'update row' lock on it.
    Deadlock Id 3620: Process (Familyid 0, Spid 9088) was waiting for a 'update row' lock on row 16 page 695320 of the 'tabel1' table in database 'DB' but process (Familyid 0, Spid 2100) already held a 'update row' lock on it.
    Deadlock Id 3620: Process (Familyid 0, Spid 9088) was chosen as the victim.
    Victim process host = `', user = `username' program name = `app' host processes = `17630' .
    End of deadlock information.
 

Read more...

Environment

SAP Adaptive Server Enterprise 16

SAP Adaptive Server Enterprise 15.7

Product

SAP Adaptive Server Enterprise 16.0

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 ONE Support launchpad (Login required).

Search for additional results

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