Conversation Group Lock not Releasing

• David Fowler

  Grasshopper

  Points: 23

  More actions

  September 7, 2009 at 3:18 am

  #209742

  We're having a problem with conversation group locks, a stored procedure runs the statement,

  declare @conversationGroupId UNIQUEIDENTIFIER;

  WAITFOR(GET CONVERSATION GROUP @conversationGroupId FROM SCMSToEnterpriseSmartCardReceiveQueue), TIMEOUT 500

  This receives the conversation group ID fine the first time that it's run but any subsequent execution of the statement or any attempt to receive a message on the corresponding conversation group id will fail as there is a lock on the conversation group.

  I've pegged this down to the lock not being released with a transaction commits, I'm able to run the statement multiple times and receive messages from within the same transaction but as soon at that transaction is commited, the conversation group is locked and I can't get at the messages. Incidently rolling back the transaction does seem to release the lock.

  Killing the process that the lock is assigned to has no effect in causing SQL to realease the lock.

  I've got identical code running on other databases and servers so it's got me stumped.

  Cheers all