question

neerajdhimansre avatar image
neerajdhimansre asked

Can anybody help me to understand this deadlock.?

unknown (@P0 bigint,@P1 bit,@P2 bigint,@P3 datetime,@P4 bit,@P5 nvarchar(4000),@P6 float,@P7 bigint,@P8 bit,@P9 bit,@P10 float,@P11 bigint,@P12 int,@P13 datetime,@P14 nvarchar(4000),@P15 int,@P16 int,@P17 bigint,@P18 int)update candidate_content_package_mapping set candidate= @P0 , consume_units= @P1 , content_package= @P2 , end_date= @P3 , invalid_score= @P4 , message_id= @P5 , percentile= @P6 , project_id= @P7 , report_available= @P8 , rr_applied= @P9 , score= @P10 , single_use_link_id= @P11 , stage_no= @P12 , start_date= @P13 , status= @P14 , timer= @P15 , version= @P16 where id= @P17 and version= @P18 unknown (@P0 bigint,@P1 bigint,@P2 bigint,@P3 nvarchar(4000),@P4 bigint,@P5 nvarchar(4000),@P6 nvarchar(4000))UPDATE status_history_audit_log SET order_unit_usage_reference= @P0 WHERE ID in (SELECT TOP 1 Id FROM status_history_audit_log (NOLOCK) where project_id = @P1 AND company_id = @P2 AND component_type like @P3 AND candidate_content_package_id = @P4 AND status_before like @P5 AND status_after like @P6 order by id DESC);
deadlockdeadlock-graph
5 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sp_lock avatar image sp_lock commented ·
Are you able to save the deadlock and attached as an xdl?
2 Likes 2 ·
sp_lock avatar image sp_lock commented ·
I mean attach the xdl to your post.
1 Like 1 ·
neerajdhimansre avatar image neerajdhimansre commented ·
I want to know the reason behind this deadlock and how to prevent this situation in future..?
0 Likes 0 ·
neerajdhimansre avatar image neerajdhimansre commented ·
sp_lock, yes its being monitored by a tool.
0 Likes 0 ·
JohnM avatar image JohnM commented ·
You also might want to consider sanitizing the XML as it contains what I would consider sensitive data.
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.