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.
SAP Knowledge Base Article - Preview