SAP Knowledge Base Article - Preview

2686311 - Deadlock error involving "update row" locks - SAP ASE

Symptom

 
  • Update commands with different where clauses updating a DOL table.
  • 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 all versions

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 for Me (Login required).

Search for additional results

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