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.