Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > .NET > .NET 1.0 and Visual Studio.NET > VS.NET 2002/2003
Password Reminder
Register
Register | FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #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

Reply With Quote
  #2 (permalink)  
Old December 12th, 2005, 10: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

Reply With Quote
  #3 (permalink)  
Old December 12th, 2005, 10: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.


Reply With Quote
  #4 (permalink)  
Old February 7th, 2006, 03: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

Reply With Quote
  #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?
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

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



All times are GMT -4. The time now is 04:00 AM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.