473,320 Members | 1,694 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

asp/iis hanging and failing without error message!

Hi all,

I have a largish asp-driven site that's crashing intermittently in a way
that's just causing me to scratch my head a lot. I've not seen this happen in
about five years of developing asp apps. This is what happens:
asp v3
access 2000 database
win 2003 server.

1. It runs on my server and on my test server just fine. Complete test of
every page completes fine.
2. On the production server, it just fails a few times a day. When I say
fails, you don't get any error message, but it just doesn't serve pages. It
sits there and w3wp.exe consumes slowly more memory (About 50k a second), not
returning any pages.
The user experiences a page that is requested, but nothing comes back,
doesn't even timeout.
3. recycling the worker process or restarting IIS clears the problem and it
runs again.
4. It's definitely asp-related becuase when the box is locked up, it still
returns .htm pages and you can still login using remote desktop.
5. I'm pretty good at closing and disposing of objects.
6. We moved the production server to a different box and it made no
difference, still these intermittent freezes.
7. This is the only site on the box.
8. Don't think its an 'infinite loop' problem (where I omitted rs.movenext).
I've been logged into the box by remote access a couple of times when it's
been reported to me by the client and there hasn't been anything like the
100% cpu utilisation I've seen with that problem 1-2% at most.
Questions:
a) Has anyone seen this before? Does anyone know what could be causing it?
b) could using an inappropriate locktype in db connection strings cause this
problem? If not, could connections (But not recordsets) left open cause this
error?
c) is there any way I can get IIS or any other tool to record exactly what
is causing this lurch, or, failing that, record response times for page
requests. Basically, any profiling tips would be really good. I have remote
desktop access to the machine.

Any help greatly appreciated. I'm tearing chunks of hair out here and the
client is livid.

Cheers,
frank
Jul 22 '05 #1
4 1894
frank wrote:
Hi all,

I have a largish asp-driven site that's crashing intermittently in a
way that's just causing me to scratch my head a lot. I've not seen

Questions:
a) Has anyone seen this before? Does anyone know what could be
causing it? b) could using an inappropriate locktype in db connection
strings cause this problem? If not, could connections (But not
recordsets) left open cause this error?
You aren't closing and destroying your connections on each page? Why not?
You are preventing connection pooling from working by doing this.
c) is there any way I can get IIS or any other tool to record exactly
what is causing this lurch, or, failing that, record response times
for page requests. Basically, any profiling tips would be really
good. I have remote desktop access to the machine.

You don't mention whether you've checked the Event log on the machine.

Are you using On Error Resume Next to mask any errors that occur?

IIS logs all requests so you should check the IIS logs.

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Jul 22 '05 #2
"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:eM**************@TK2MSFTNGP11.phx.gbl...
IIS logs all requests so you should check the IIS logs.


Just look for the last ASP to execute ...
Jul 22 '05 #3
Hi guys,

thanks for the suggestions.
Nope: not using on error resume next for just that reason: it masks errors
and makes debugging a nightmare.

I'm pretty sure it's not a coding error as such - checking the logs hasn't
helped me so far. At one point I was able to make the box lurch pretty much
at will by throwing it a complex search query that would return a few
thousand row and perform a reg-ex pattern match on each field. The script
took a few seconds to run, and when it returned to zero the box was locked
up, but again, it doesn't happen every time I run the script. I did this
whilst logged into the server using remote access and cpu useage went up to
100% for a few seconds, then back down. When it's locked-up, it still serves
html pages, just not asp. Actually, next time it dies I'm going to see if it
still serves asp pages that don't contain database hits. When I ran the same
script on my test server, it performed fine, but I can't simulate multiple
users on my test box.

Any ideas?

Cheers,

FRank
"Tom Kaminski [MVP]" wrote:
"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:eM**************@TK2MSFTNGP11.phx.gbl...
IIS logs all requests so you should check the IIS logs.


Just look for the last ASP to execute ...

Jul 22 '05 #4
"=?Utf-8?B?ZnJhbms=?=" <fr***@discussions.microsoft.com> wrote in
news:33**********************************@microsof t.com:

what sort of script timeout have you got? I've come across this kind of
issue once or twice, and forcing the script to stop after a matter of
seconds has helped by allowing me to track down where the hang happens.

Hi guys,

thanks for the suggestions.
Nope: not using on error resume next for just that reason: it masks
errors and makes debugging a nightmare.

I'm pretty sure it's not a coding error as such - checking the logs
hasn't helped me so far. At one point I was able to make the box lurch
pretty much at will by throwing it a complex search query that would
return a few thousand row and perform a reg-ex pattern match on each
field. The script took a few seconds to run, and when it returned to
zero the box was locked up, but again, it doesn't happen every time I
run the script. I did this whilst logged into the server using remote
access and cpu useage went up to 100% for a few seconds, then back
down. When it's locked-up, it still serves html pages, just not asp.
Actually, next time it dies I'm going to see if it still serves asp
pages that don't contain database hits. When I ran the same script on
my test server, it performed fine, but I can't simulate multiple users
on my test box.

Any ideas?

Cheers,

FRank
"Tom Kaminski [MVP]" wrote:
"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:eM**************@TK2MSFTNGP11.phx.gbl...
> IIS logs all requests so you should check the IIS logs.


Just look for the last ASP to execute ...


Jul 22 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: omission9 | last post by:
Any advice on the following would be much appreciated. I have thrown everything I have at it and am completely stumped. I apologize for the length, I have tried to be as succint as possible. I...
7
by: Simon | last post by:
My webhosting company cut off my website the other day because i had "too many hanging processes" What does this mean and what can i do to prevent this from happening. They gave me the following...
6
by: zzapper | last post by:
Hi, If I make a mistake designing a JavaScript Form Checker, ie get the name (or case) of a form Field wrong, JavaScript seems to default to immediately returning true and the form is submitted...
1
by: Rick Brown | last post by:
After reading 30+ threads on the subject and implementing pertinent changes I still have an instance of Excel that won't close. I hope its due to my poor coding and someone can spot the error....
3
by: Michael Tissington | last post by:
I'm using LoadLibrary to import a DLL in a asp.net application. The dll was written in c++ and is located in the bin folder I have been testing the website on my development machine and our...
5
by: David C. Allen | last post by:
I have a vb.net app that is controling excel 2000 thru the com interop interface. I have referenced the excel 9.0 library and have cut down the code in the problem subroutine to this: Dim...
4
by: Mike | last post by:
Hi We are developing an ASP.NET 2.0 application and using the in built Crystal report system that it comes with. We have everything running fine on our development server but when we publish...
1
by: ARC | last post by:
I have some functions that will allow a user to attach to a different back-end database. I added this functionality to the program Ribbon in a custom Access 2007 app. I have 2 ways to attach to a...
3
by: Microsoft | last post by:
Hi I have a c# program that continually runs 24/7 and performs a variety of tasks based on a timer. There is one routine that hangs every Saturday morning without fail. If I restart the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.