MENU LOGIN 
   Redirecting... ...to our OLD website!


We're still in the process of converting the site to the new format.

Apologies for the inconvenience and thank you for your understanding.

-Matt, Admin

5

Ok - go now to OLD site

No thanks - stay on NEW site


BM Website Issues/Help Requests

URGENT: Site errors - deadlock victim

URGENT: Site errors - deadlock victim (3) - Forums [Biker Match] URGENT: Site errors - deadlock victim (3) - Forums [Biker Match]
Home / Search Forums / BM Website Issues/Help Requests /

URGENT: Site errors - deadlock victim

 Posts: 121       Pages: 3/7

Post Reply
time 00.35 Microsoft OLE DB Provider for SQL Server error '80004005' Transaction (Process ID 152) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. /sites/bm/chat/chatdata.asp, line 14

   Update Reply
RC @ 03/08/2007 20:35  

Wills - the BOF/EOF error means that the post was deleted before you opened it, probably by myself or another moderator. Storm - the email transport error is another issue, it's being looked at and I've asked the webhost to give me an update. Please remember that this topic must only contain DEADLOCK errors. Others are important, but please PM or email me with them so that they dont clutter up this thread. Also - if copying and pasting errors, remember to make all the text BLACK in colour before posting it (Even if it already appears black). Cheers again everyone, ill let you know an update on this issue when I get it.

   Update Reply
Matt @ 05/08/2007 14:54  

getting closer to fixing this, it's going to take some time though :-(

   Update Reply
Matt @ 06/08/2007 17:57  

Title Posts Views Started By Last post at 22.05 Microsoft OLE DB Provider for SQL Server error '80040e21' Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. /sites/bm/forum/all_topics.asp, line 58

   Update Reply
storm @ 06/08/2007 18:05  

hmmm, thats a different one again. Dammit. Think its part of the deadlock issue tho (Maybe)

   Update Reply
Matt @ 06/08/2007 18:20  

Ok I REALLY believe that I have fixed this now. For the ALL FORUMS page (Not the individual topics yet though) and the CHATROOM. I'm going to be so gutted if anyone gets an error on these pages now, so please let me know if you do. I'll be working on the threads pages next. You should also notice the site is faster now.

   Update Reply
Matt @ 07/08/2007 15:38  

Just had another one in Chat but wasn't quick enough to copy it!!! 20.12

   Update Reply
Di @ 07/08/2007 16:16  

might not have been the same error, was it a deadlock? Was it at the top, left, right or bottom of the chatroom? (Theres 4 parts). Ok i think ive fixed the threads pages now as well. Or at least started working towards a fix for this. Changing a lot of recordset cursors and lock types by creating stored procedures rather than OLE transactions. Ball ache!

   Update Reply
Matt @ 07/08/2007 16:19  

Dammit no i've got it again, at 22:22pm... Microsoft OLE DB Provider for SQL Server error '80004005' Transaction (Process ID 125) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. /sites/bm/forum/all_topics.asp, line 187 DAMN!

   Update Reply
Matt @ 07/08/2007 17:27  

You should also notice the site is faster now. It deffo is Did ya delete your PMs to make room?

   Update Reply
Sandi @ 07/08/2007 23:00  

no, just the ones from you

   Update Reply
Matt @ 08/08/2007 04:42  

Hey! cheeky monkey I aint sent ya many lately (but I could ) Remember to read ALL of the NL I sent ya or I'll have to punish ya severely if ya tell me later 'I didn't see that bit'

   Update Reply
Sandi @ 08/08/2007 08:39  

Its done, i didnt read any of it lol. Folks: Rest asured that this fault is definitely still being worked on, a lot! I can tell you that it is in very good hands.... obviously not mine! lol.

   Update Reply
Matt @ 08/08/2007 14:10  

Just got this Mat time 19:20 Microsoft OLE DB Provider for SQL Server error '80004005' Transaction (Process ID 147) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. /sites/bm/forum/all_topics.asp, line 187

   Update Reply
Deleted Member @ 08/08/2007 15:22  

"matt" soz ha ha

   Update Reply
Deleted Member @ 08/08/2007 15:26  

ok great thanks, ill pass it on.

   Update Reply
Matt @ 08/08/2007 15:27  

Same error message as Dragon's except process ID was 180 and asp line was 125 Matt, I KNOW ya didn't read the bu**er, ya left the notes in that were from me to you (wally) lol I'm goina make a new topic 'Suggestions for Matt's PUNISHMENT!'

   Update Reply
Sandi @ 08/08/2007 17:34  

12:23 Microsoft OLE DB Provider for SQL Server error '80004005' Transaction (Process ID 111) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. /sites/bm/forum/chat.asp, line 24

   Update Reply
Deleted Member @ 09/08/2007 08:24  

Kwak got... Microsoft OLE DB Provider for SQL Server error '80004005' at top right of page, in chat room at 22.32 on 8th Aug 2007 and Error message at 23.22 ID 73 line 20 looks like its still a problem

   Update Reply
Matt @ 09/08/2007 14:21  

Microsoft OLE DB Provider for SQL Server error '80040e31' /sites/bm/forum/posts.asp, line 392 I clicked on a topic and this came up .....at 18:30

   Update Reply
fjr_graham @ 09/08/2007 14:34  

 Posts: 121       Pages: 3/7

Back to top
Facebook Twitter Google Pinterest Text Email