| Author |
 Topic  |
|
|
scollis
Starting Member
7 Posts |
 Posted - 02 September 2008 : 04:31:12
|
Getting a lot of deadlock errors on our forum, coming out of inc_func_common.asp, specifically at the end of UpdateLastHereDate.
Does anyone know how to fix this one? I thought maybe adding adRunAsync might (at the risk of loss of "last here" information) solve the problem.
Database server is SQL 2000 and the forum software is the latest version.< |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 02 September 2008 : 04:38:44
|
| That is very weird, I have never heard anyone else complaining, even in very busy forums. UpdateLastHere does a single update statement, so it's hard to figure out how that would degenerate into a deadlock situation.< |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 02 September 2008 : 04:57:54
|
| did you create your database using the forums setup.asp or did you migrate it from Access ?< |
|
|
|
scollis
Starting Member
7 Posts |
Posted - 02 September 2008 : 05:00:32
|
| Just done a bit more looking through the error logs and I note that it's just after a timeout expires, which might explain things. Looks like i might need to do a dbcc compact on this database, if nothing else...< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
scollis
Starting Member
7 Posts |
Posted - 02 September 2008 : 05:04:34
|
Yes we created it through setup.asp
< |
|
|
|
scollis
Starting Member
7 Posts |
Posted - 02 September 2008 : 05:06:15
|
| Timeouts seem to be down to the loading of the server - it's running about 40 different sites. I think it's maybe time I recommended they upgrade their web server< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
scollis
Starting Member
7 Posts |
Posted - 02 September 2008 : 05:07:35
|
| Looking through the logs we're getting timeouts on other scripts too, and even on static pages, so now I look into it this isn't the issue. Looks like people are trying to log in, getting a timeout, then trying again, and this is causing the deadlock.< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 02 September 2008 : 05:09:24
|
| Seems like a server issue, then, indeed. I've seen quite a few tens of forums running on SQL server and never saw a deadlock, even after a server timeout, so the situation there must be really serious.< |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 02 September 2008 : 05:12:16
|
| can you tell from the logs what may have caused the timeout ?< |
|
|
|
scollis
Starting Member
7 Posts |
Posted - 02 September 2008 : 05:48:35
|
| No because the only logs I get are emailed by the 404 page :-(< |
|
|
|
scollis
Starting Member
7 Posts |
Posted - 02 September 2008 : 06:41:25
|
The main problem is that there are about 30-40 global level sites with hundreds of thousands of hits a day running on that server, and because it's a client's server, not mine, I don't have access to performance monitors and similar.
Thanks for your help guys - I'll turn over to their internal techies and see what they can come up with.< |
|
|
| |
Topic |
|
Topic Locked
