Deadlocks in Nginn

[sunil kumar]

Hi all,

We are seeing below deadlocks in the sql server continuously which was raised from Nginn. GPSRuelactionqueue is nothing but the sql message queue which was created for our application 

update top (1000) GPSRuleActionQueue with(READPAST) set subqueue='I' where subqueue='R' and retry_time <= getdate()

select top 1 id, correlation_id, from_endpoint, to_endpoint, retry_count, msg_text, msg_headers, unique_id, retry_time from GPSRuleActionQueue with (UPDLOCK, READPAST) where subqueue='I' order by retry_time

Can you please help us to avoid this deadlocks.

[Rafal Gwizdala]

Hi, do you have an exception / stack trace?

And what exactly is deadlocking - the queries you sent?

They are using 'READPAST' hint which prevents the query from accessing locked rows so i need more details to find out what's causing the deadlock

Thanks

R

--
You received this message because you are subscribed to the Google Groups "nginn-messagebus" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nginn-messageb...@googlegroups.com.
To post to this group, send email to nginn-me...@googlegroups.com.
Visit this group at http://groups.google.com/group/nginn-messagebus.

[sunil kumar]

Hi,

We don't have any error or stack trace however in the sql server we are seeing that the below mentioned queries are blocking each other which is hampering our sql server performance.

Thank you,

Sunil 

[Rafal Gwizdala]

If you don't have an error then you dont have a deadlock - SQL would detect the deadlock and raise an error in such situation.

What you are seing are row locks, which are part of normal operation of the database and message bus. The locks are held for the duration of transaction so if you see the rows are always locked it means the system is active and busy processing messages. So far everything looks normal.

Maybe you can tell what problem exactly are you trying to solve?

R