Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > .NET 1.0 and Visual Studio.NET > VS.NET 2002/2003
| Search | Today's Posts | Mark Forums Read
VS.NET 2002/2003 Discussions about the Visual Studio.NET programming environment, the 2002 (1.0) and 2003 (1.1). ** Please don't post code questions here ** For issues specific to a particular language in .NET, please see the other forum categories.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VS.NET 2002/2003 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old October 13th, 2005, 10:34 PM
Registered User
 
Join Date: Oct 2005
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Transaction (Process ID 59) was deadlocked

Transaction (Process ID 59) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction

kindly help me

  #2 (permalink)  
Old December 12th, 2005, 11:04 AM
Registered User
 
Join Date: Dec 2005
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Pl. let me know once you have a solution. I am also running into same issues.

thanks in advance

Quote:
quote:Originally posted by aksvls
 Transaction (Process ID 59) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction

kindly help me

  #3 (permalink)  
Old December 12th, 2005, 11:37 AM
Registered User
 
Join Date: Jun 2004
Location: London, n/a, United Kingdom.
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Deadlocks usually happen when 2 processes are vying for control of 2 of the same objects, EG:

Process 1 acesses object A, and holds it whilst trying to access object B.
In the meantime process 2 acesses object B and holds it whilst trying to access object A.

This means that both of them are waiting for access to an object that the other is holding and a deadlock occurs.

The best way around this is to make sure that both of the processes access the objects in the same order, so in this case either process 1 and 2 try to access first A then B, or process 1 and 2 try to access B then A.

Other possible options are to avoid user interaction in these processes, keep any transactions short & try to keep as low an isolation level for transactions as possible.


  #4 (permalink)  
Old February 7th, 2006, 04:05 AM
Registered User
 
Join Date: Feb 2006
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

if ur using Explicit UPDATE STATISTICS Command's.... then you might want to have a look at this...

http://support.microsoft.com/kb/826754

  #5 (permalink)  
Old April 2nd, 2011, 03:35 PM
Registered User
 
Join Date: Apr 2011
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Red face visual Basic .net transaction ISBN: 1-861005-95-4

Where are the code examples for this book?


Similar Threads
Thread Thread Starter Forum Replies Last Post
Getting the Process ID Bill_Thompson C# 2005 3 January 28th, 2008 04:05 AM
sql server transaction prrocess id 635 benn Reporting Services 0 March 22nd, 2006 07:06 AM
Run-time Error 59 Aine Catherine Beginning VB 6 0 March 10th, 2005 09:22 AM
Auto submit after 59 seconds steeve_1001 HTML Code Clinic 2 March 8th, 2005 01:08 PM
COM+ Transaction Process and programming concept ervs VB.NET 1 April 14th, 2004 08:03 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.