Transaction (Process Id 58) was deadlocked

• degrem_m

  SSCommitted

  Points: 1519

  More actions

  March 27, 2006 at 6:06 am

  #168319

  hi ,

  l'm encounter below error in my web application written in ASP.NET Intermittent when trying to select record into sql server.

  I have this message : Transaction (Process ID 58) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

  I don't know why ?

  ---

  Kindest Regards,

  degrem_m
  Degremont

• March 30, 2006 at 8:00 am

  This was removed by the editor as SPAM

• Ryan Hathaway

  SSC Eights!

  Points: 827

  More actions

  March 31, 2006 at 12:03 pm

  #630213

  Sounds like a concurrency / record locking problem.

  Make sure you are committing or rolling back your transactions in the code (and closing your SQLClient.Connection when you are done).