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                                                                                                                                                                             

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                                                                                                                                                                              

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)                                                                                                                                                                             

Cheers Dulali!                                                                                                                                                                             

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

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                                                                                                                                                                             

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                                                                                                                                                                             

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?                                                                                                                                                                             

Had a few! hic                                                                                                                                                                             

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.                                                                                                                                                                             

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                                                                                                                                                                              

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
                                                                                                                                                                             

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                                                                                                                                                                               

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

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                                                                                                                                                                             

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

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.                                                                                                                                                                             

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                                                                                                                                                                             

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!!!   :-(                                                                                                                                                                             

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.