SAP Knowledge Base Article - Preview

2643704 - Deadlock between INSERT...SELECT and DELETE commands

Symptom

00:0000:00000:00488:2018/03/20 17:55:20.90 server Deadlock Id 143 detected
Deadlock Id 143 detected. 1 deadlock chain(s) involved.

Deadlock Id 143: Process (Familyid 0, Spid 693, Suid 3) was executing a INSERT command in the procedure 'objid 1286763762' at line 1 at nested level 1.
Deadlock Id 143: Process 693 was involved in application 'xxx'.
Deadlock Id 143: Process 693 was involved on host name 'abc'.
Deadlock Id 143: Process 693 was involved in transaction '$ins'.
SQL Text: ?
Executing procedure: *sq1286763762_1316904774ss*
Subordinate SQL Text:
insert into <userdb>..<table name>(...)
select ... from <userdb>..<view table> where iDevId = ?

Deadlock Id 143: Process (Familyid 0, Spid 488, Suid 3) was executing a DELETE command at line 1.
Deadlock Id 143: Process 488 was involved in application 'xxx'.
Deadlock Id 143: Process 488 was involved on host name ''.
Deadlock Id 143: Process 488 was involved in transaction '$del'.
SQL Text:

DELETE <table1> WHERE cID = 36435
Deadlock Id 143: Process (Familyid 0, Spid 488) was waiting for a 'exclusive page' lock on page 18529 of table 'table1' in database '<userdb>' but process (Familyid 0, Spid 693) already held a 'shared page' lock on it.
Deadlock Id 143: Process (Familyid 0, Spid 693) was waiting for a 'shared page' lock on page 17793 of table 'table1' , indid 2 in database '<userdb>' but process (Familyid 0, Spid 488) already held a 'exclusive page' lock on it.

Deadlock Id 143: Process (Familyid 0, Spid 488) was chosen as the victim.
Victim process host = `', user = `dbuser' program name = `xxx' host processes = `57818' .


Read more...

Environment

SAP ASE 16.0

Product

SAP Adaptive Server Enterprise 12.5 ; SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To

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.