Forum Themes:
Welcome !

 SQL Server deadlock error

Author Message
Tony

  • Total Posts : 2
  • Reward points : 0
  • Joined: Mar 06 '03
  • Status: offline
SQL Server deadlock error Thu. Mar 6, '03 9:09 AM (permalink)
0
I' m getting every now and then following error:

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

File is: tt.asp and stored procedure: spTreeM4TopUltra1

Is this a common error in aspplayground?

 
#1
Samuel

  • Total Posts : 11853
  • Reward points : 180670
  • Joined: May 23 '01
  • Status: offline
RE: SQL Server deadlock error Thu. Mar 6, '03 1:22 PM (permalink)
0
no, it is not. and we do not use such stored procedure: spTreeM4TopUltra1

Let me know the forum address so I can take a look.
ASPPlayground.NET
~ see our Version 4 plans here

 
#2
Tony

  • Total Posts : 2
  • Reward points : 0
  • Joined: Mar 06 '03
  • Status: offline
RE: SQL Server deadlock error Tue. Mar 11, '03 5:22 AM (permalink)
0

The forum is in finnish, and it' s error handling prevents user from seeing the error message. The version of asp playground is 1.99.24. (sp 2?)
 
#3
Samuel

  • Total Posts : 11853
  • Reward points : 180670
  • Joined: May 23 '01
  • Status: offline
RE: SQL Server deadlock error Tue. Mar 11, '03 12:13 PM (permalink)
0
Please upgrade to the latest sp4 and see if it helps. I haven' t seen this problem before but we did make quite a few changes in sp4. Where is your forum located?
ASPPlayground.NET
~ see our Version 4 plans here

 
#4
Online Bookmarks Sharing: Share/Bookmark

Jump to:

Current active users

There are 0 members and 1 guests.

Icon Legend and Permission

  • New Messages
  • No New Messages
  • Hot Topic w/ New Messages
  • Hot Topic w/o New Messages
  • Locked w/ New Messages
  • Locked w/o New Messages
  • Read Message
  • Post New Thread
  • Reply to message
  • Post New Poll
  • Submit Vote
  • Post reward post
  • Delete my own posts
  • Delete my own threads
  • Rate post

2000-2012 ASPPlayground.NET Forum Version 3.9