how can I solve select and delete deadlock problems in my project?
deadlock in 2 SQL quiry
(@pr0 int)delete from [table] where [column1] = @pr0
(@pr0 int)select [column1], [column2], [column3], [column4], [column5] from [table] where [column2] = @pr0
I exported deadlock reports. but I still didn’t find the problem.
https://paste.ubuntu.com/p/dnfGzbph7p/
build deadlock graph:
enter image description here
New contributor
Eugene Aleynikov is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.