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 - Forums [Biker Match]

URGENT: Site errors - deadlock victim - Forums [Biker Match]

Biker Match ► Forum ► BM Website Issues/Help Requests ► URGENT: Site errors - deadlock victim

Home / Search Forums / BM Website Issues/Help Requests /

URGENT: Site errors - deadlock victim

Posts: 121 Pages: 1/7

Matt
In: Veldhoven
Posts: 8053
Karma:

Hey all. I'm investigating a problem we have with the database server. We might simply be overloading the server, but I need to investigate fully with the webhost. Please can I ask all members to reply here if they receive the following error message (only this error though)... Microsoft OLE DB Provider for SQL Server error '80004005'Transaction (Process ID 123) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction./sites/bm/***A URL HERE***.asp, line 1234 Please include the full error, including the exact time it happened. The bits above in RED are the minimum details that I need. It often happens in the forum and chatroom, but I need to know what lines of code are locking the database. Please respond asap as we are investigating now. Thanks everyone

Matt @ 25/07/2007 15:04

Dulali
In: Harwich
Posts: 34
Karma:

Hi, just read your message and then very soon afterwards got this error for the very first time! I Copied and pasted it so this exactly as it was: Microsoft OLE DB Provider for SQL Server error '80004005' Transaction (Process ID 94) 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 58

Dulali @ 25/07/2007 15:13

Matt
In: Veldhoven
Posts: 8053
Karma:

Kwak got it on 13th July at 22.48.55. No further details about URL though. Graham had it today 10:06am today Again no URL or code line to check though. All times are in GMT (For the benefit of the webhost)

Matt @ 25/07/2007 15:15

Matt
In: Veldhoven
Posts: 8053
Karma:

Cheers Dulali!

Matt @ 25/07/2007 15:16

lcotgrave
In: Birkenhead
Posts: 398
Karma:

Yes i have it matt on two occassions around 6.30 tonight.

lcotgrave @ 25/07/2007 15:17

Matt
In: Veldhoven
Posts: 8053
Karma:

Jesus it's more serious than I thought. Thanks for replying. Please monitor it and copy the details next time (Mainly the URL and code line number). Thanks

Matt @ 25/07/2007 15:19

Matt
In: Veldhoven
Posts: 8053
Karma:

Right - im now particularly interested in knowing if you ever get the message in the forums or chatroom. I want to see if some changes ive made will fix the problem. Cheers

Matt @ 25/07/2007 16:23

Matt
In: Veldhoven
Posts: 8053
Karma:

might have fixed now the following... searches, forums, chatroom, communicator page (inbox), popular member pages. Let me know how you're all getting on. Have you had a night free of errors or have you had a few?

Matt @ 25/07/2007 16:40

Di
In: Wellingborough
Posts: 4452
Karma:

Had a few! hic

Di @ 25/07/2007 16:52

Cruiser gal
In: Tamworth
Posts: 2011
Karma:

Matt I have had it a few times when I have pressed send in the chatroom, never had it on the forum but then I don't post much on there. Sorry I cant tell you what times or anything though.

Cruiser gal @ 25/07/2007 17:02

Wills
In: New Brighton
Posts: 3265
Karma:

Here's another from a minute back: All forum topics Title Posts Views Started By Last post Microsoft OLE DB Provider for SQL Server error '80004005' Transaction (Process ID 70) 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 58

Wills @ 25/07/2007 17:33

Matt
In: Veldhoven
Posts: 8053
Karma:

dammit - was hoping that wouldn't happen again now on that page.

ok thanks, will keep investigating.

Please keep the posts coming for me though, thanks

Matt @ 25/07/2007 17:57

Deleted Member
In: NA
Posts: 0
Karma:

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/forum/all_topics.asp, line 128 Just now on the forum the time showing on my computer was 22.10pm

Deleted Member @ 25/07/2007 18:12

Oggy
In: Ely. Cambs
Posts: 2116
Karma:

I've had it a few times too Matt,only since the new chatroom started.Didnt realise it was such a big problem though.

Oggy @ 25/07/2007 18:55

Cruiser gal
In: Tamworth
Posts: 2011
Karma:

Just got this message at 01.02am Microsoft OLE DB Provider for SQL Server error '80040e14' Invalid column name 'undefined'. /sites/bm/chat/chatdata.asp, line 13 Looks like it signed me off with out me doing anything I was in the chatroom

Cruiser gal @ 25/07/2007 21:04

fjr_graham
In: Sheffield/Barnsl
Posts: 381
Karma:

Sorry matt there was no url or code line what i put down was what i could see the screen froze

fjr_graham @ 26/07/2007 06:37

Matt
In: Veldhoven
Posts: 8053
Karma:

no probs graham, thanks for letting me know at the time tho (most people dont). I need to know about these things always, because they make the site look bad.

Matt @ 26/07/2007 13:13

fjr_graham
In: Sheffield/Barnsl
Posts: 381
Karma:

Microsoft VBScript runtime error '800a0035' File not found /sites/bm/myaccount/showphotos.asp, line 216 Matt just recived this trying to delite some pictures at 21:52

fjr_graham @ 26/07/2007 17:55

Matt
In: Veldhoven
Posts: 8053
Karma:

Earthwind received it at 11:36 GMT on /sites/bm/forum/all_topics.asp... Microsoft OLE DB Provider for SQL Server error '80004005' Transaction (Process ID 221) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. ARRRGHHHH!!! :-(

Matt @ 27/07/2007 03:39

Matt
In: Veldhoven
Posts: 8053
Karma:

graham - only worried about the deadlock SQL error here. The webhosts in the US are looking at this topic in the forum. With your error there - I'd need to go through each step you did. I'll try and replicate it tonight. Though it sounds like its trying to access the file you deleted.

Matt @ 27/07/2007 03:41

Posts: 121 Pages: 1/7

Bringing friendly UK motorcycle enthusiasts together since 2006. Events, social, dating, news and more.