Did you try using the timeout attribute of cfquery?
KOla
-----Original Message-----
From: Frank Mamone [mailto:[EMAIL PROTECTED]
Sent: 18 June 2004 21:36
To: CF-Talk
Subject: Re: Help with CF5 Queued Requests
Mark,
I found the processes that lockup in SQL Server. When I kill them it
returns to normal. What I don't understand is why the query timeout set
in CFADMIN doesn't take care of this automatically?
Our DBA is looking at the offending queries in the meantime.
Thanks for your tips!
-Frank
----- Original Message -----
From: Mark A. Kruger - CFG
To: CF-Talk
Sent: Friday, June 18, 2004 3:23 PM
Subject: RE: Help with CF5 Queued Requests
Frank,
You should be looking for code that "waits" for a response from a
third party process. Culprits are (typically) db
access, ftp, ldap, pop, file access (cffile), cfhttp etc. All of
these services must connect to a service or process
"outside" the CF engine - cf awaits their response... sometimes
indefinitely if its set up that way. That's why such
tags often include a "timeout" value. Slow pages is a good place to
start. Also look at the scheduled task folder and
find out if there's a regular "data import" or web scraping
application or some other ap put there for utility reasons.
Sometimes these tasks run for years with no one noticing them and then
suddenly start hanging.
-Mark
-----Original Message-----
From: Frank Mamone [mailto:[EMAIL PROTECTED]
Sent: Friday, June 18, 2004 12:06 PM
To: CF-Talk
Subject: Help with CF5 Queued Requests
I have been tasked with stabilizing a legacy CF 5 application which
had several problems including CF restarts and
loss of client variables etc.
I managed to solve most of the issues -- many caused by application
variables not being locked.
There is one issue which I need help with. Using Perfmon, I notice
that, at times, ColdFusion requests stay queued and
are not processed. They just stay there - forcing me to restart CF.
I am tryng to track down what in the code could be causing this by
looking at the log entries showing slow page
warnings.
Is there any known causes for this symptom? What else should I be
looking for?
Thanks for your help.
Frank
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
