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)
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?
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
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
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
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.