Jrun Closed Connection after Windows updates

[frustratedTech]

I just recently updated my windows 2003 web server to SP1 and ran a few
hotfixes after that as well since there has been a rise in IIS attacks towards
our website. After I did this about every 6 hours the site pops up this error.
I've noticed Jrun will exceed 50 Megs of memory and all I have to do is kill
the process to bring the site back up. The version is 6,1,0,63958 Here's an
insert from default-err. log

12/21 14:41:33 error Connection reset
java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(SocketInputStream. java:168)
at java.io.BufferedInputStream.fill(BufferedInputStre am.java:183)
at java.io.BufferedInputStream.read1(BufferedInputStr eam.java:222)
at java.io.BufferedInputStream.read(BufferedInputStre am.java:277)
at jrun.servlet.jrpp.ProxyEndpoint.readFully(ProxyEnd point.java:530)
at jrun.servlet.jrpp.ProxyEndpoint.readFully(ProxyEnd point.java:522)
at jrun.servlet.jrpp.ProxyEndpoint.readInt(ProxyEndpo int.java:540)
at jrun.servlet.jrpp.ProxyEndpoint.readRequest(ProxyE ndpoint.java:229)
at jrun.servlet.jrpp.JRunProxyService.swapRunnable(JR unProxyService.java:144)
at
jrunx.scheduler.ThreadPool$DownstreamMetrics.swapR unnable(ThreadPool.java:320)
at jrunx.scheduler.ThreadPool$ThreadThrottle.swapRunn able(ThreadPool.java:433)
at
jrunx.scheduler.ThreadPool$UpstreamMetrics.swapRun nable(ThreadPool.java:280)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java :76)

A non-SQL error occurred while requesting a connection from ClientVariables
Timed out trying to establish connection
A non-SQL error occurred while requesting a connection from ClientVariables
Timed out trying to establish connection
A non-SQL error occurred while requesting a connection from ClientVariables
Timed out trying to establish connection
A non-SQL error occurred while requesting a connection from ClientVariables
Timed out trying to establish connection
java.lang.RuntimeException: Request timed out waiting for an available thread
to run. You may want to consider increasing the number of active threads in the
thread pool.
at jrunx.scheduler.ThreadPool$Throttle.enter(ThreadPo ol.java:125)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRu nnable(ThreadPool.java:448)
at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeR unnable(ThreadPool.java:294)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java :66)

Here's another from the application.log

"Error", "jrpp-192", "01/01/07", "20:02:48", "***", "The request has exceeded
the allowable time limit Tag: CFQUERY The specific sequnce of files included or
processed is:
"path to file"

This is from the server.log

"Warning", "jrpp-192", "01/01/07", "20:02:47",, " Thread:jrpp-192, processing
template: "path to file", complated in 503 seconds, exceeding the 30 second
warning limit"

The site was working properly before this. I assume it's a Windows update, but
I was wondering if anyone could help me pinpoint which one would affect this
the most, so I don't just uninstall every one. I also have an image of the
server if I need to revert back, but I'd like to get if figured out. If you
need any other logs or anything else please let me know.

[ke4pym]

None of the Windows updates should have caused your issue. How many threads do
you have set to run in the administrator?

50 megs of memory for the JRun process is nothing. I wouldn't be too overly
concerned about it.

Check the Windows Event viewer and see if the registry might be full.

[Jochem van Dieten **AdobeCommunityExpert**]

frustratedTech wrote:

> A non-SQL error occurred while requesting a connection from ClientVariables
> Timed out trying to establish connection
> A non-SQL error occurred while requesting a connection from ClientVariables
> Timed out trying to establish connection
> A non-SQL error occurred while requesting a connection from ClientVariables
> Timed out trying to establish connection
> A non-SQL error occurred while requesting a connection from ClientVariables
> Timed out trying to establish connection

Are you using client variables? Where do you store them? Do you get the
same error on pages without client variables.

Jochem


--
Jochem van Dieten
Adobe Community Expert for ColdFusion

[frustratedTech]

I checked the event log and didn't see anything about the registry although I
did notice some things in the application event log from the past few days.

The description for Event ID ( 263 ) in Source ( ColdFusion MX Application
Server ) cannot be found. The local computer may not have the necessary
registry information or message DLL files to display messages from a remote
computer. You may be able to use the /AUXSOURCE= flag to retrieve this
description; see Help and Support for details. The following information is
part of the event: ColdFusion MX Application Server, 2028.

I got this on the 28th, and it started there.

The description for Event ID ( 0 ) in Source ( ColdFusion MX ODBC Server )
cannot be found. The local computer may not have the necessary registry
information or message DLL files to display messages from a remote computer.
You may be able to use the /AUXSOURCE= flag to retrieve this description; see
Help and Support for details. The following information is part of the event:
ColdFusion MX ODBC Server@LOCALHOST,ErrorCode=2310,ErrorMessage=TCP/IP,
connection reset by peer.

Now I've been getting these and it looks like it may correspond with the times
that I got the Jrun Closed Connection error, but I updated the website on the
19th, so I've been having problems before these events started showing up. I
looked through past events and it seems I've never gotten these errors with
these ErrorCodes. In fact the last error event I've gotten was October 3

[frustratedTech]

I'm actually not the webmaster of the site. The webmaster is an outside
company, and he is suggesting to take the updates off and put them back on one
by one until I find the one that breaks the site. I've never even really worked
with ColdFusion before, so I wouldn't know where to begin. What I can do is
when the error pops up try the other pages and see what happens, unless there
is a way to see what pages use clientvariables and which ones don't. I'm sorry
I'm not being much help, but I don't design sites. I just don't want to have to
revert back to before I put the updates on I would rather try to figure this
out.

[frustratedTech]

Well I finally talked to my boss and he asked the webmaster to remote in and
take a look and told us how to get into Coldfusion. I showed him the logs and
the clientvariables errors. He took a look at the database and it was 600 meg
in size and had 6000 entries. He told us to try and compact and repair the
database. We did that and now it's only 3 meg, so I don't know if it has fixed
it yet or not, but hopefully it did. Any other thoughts would be appreciative.

[ke4pym]

You really should consider a SQL based approach for your clientvars. Access databases, in a word, suck. Either that or move the clientvars to cookies.

[ke4pym]

You really should consider a SQL based approach for your clientvars. Access databases, in a word, suck. Either that or move the clientvars to cookies.

[frustratedTech]

Do you have any links to tutorials on hwo to do this. Me and my boss had
thought of this as soon as I showed him the access database, but I'm not for
sure how to do it. If I could show him the steps maybe I could get him on board
and he could get our webmaster to do it, or me try it.

[frustratedTech]

That didn't fix it at all. Here' s exactly the errors I'm recieving in the log
files. I now have access to ColdFusion so I can tell you what u need.

Jan 4, 2007 8:11 AM Error 0
The request has exceeded the allowable time limit Tag: CFQUERY The specific
sequence of files included or processed is:
Jan 4, 2007 8:11 AM Error 0
The request has exceeded the allowable time limit Tag: CFQUERY The specific
sequence of files included or processed is:

Jan 4, 2007 8:11 AM Error 0
The request has exceeded the allowable time limit Tag: CFQUERY The specific
sequence of files included or processed is:
Jan 4, 2007 8:09 AM Error 0
Operation failed on the data source named ""ClientVariables"".Reason of
failure ""Timed out trying to establish connection"" The specific sequence of
files included or processed is:
Jan 4, 2007 8:08 AM Error 0
Operation failed on the data source named ""ClientVariables"".Reason of
failure ""Timed out trying to establish connection"" The specific sequence of
files included or processed is:
Jan 4, 2007 8:07 AM Error 0
Operation failed on the data source named ""ClientVariables"".Reason of
failure ""Timed out trying to establish connection"" The specific sequence of
files included or processed is:
Jan 4, 2007 8:05 AM Error 0
Operation failed on the data source named ""ClientVariables"".Reason of
failure ""Timed out trying to establish connection"" The specific sequence of
files included or processed is:
Jan 4, 2007 8:02 AM Error 0
Error Executing Database Query.Timed out trying to establish connection The
specific sequence of files included or processed
Jan 4, 2007 8:02 AM Error 0
Error Executing Database Query.Timed out trying to establish connection The
specific sequence of files included or processed
Jan 4, 2007 8:01 AM Error 0
The request has exceeded the allowable time limit Tag: CFQUERY The specific
sequence of files included or processed is: C:\websites\site04\careers.cfm

The request has exceeded the allowable time limit Tag: CFQUERY The specific
sequence of files included or processed is:
Jan 4, 2007 8:01 AM Error 0
The request has exceeded the allowable time limit Tag: CFQUERY The specific
sequence of files included or processed is:

Jan 4, 2007 8:01 AM Error 0
The request has exceeded the allowable time limit Tag: CFQUERY The specific
sequence of files included or processed is:
Jan 4, 2007 8:01 AM Error 0
The request has exceeded the allowable time limit Tag: CFQUERY The specific
sequence of files included or processed is:
Jan 4, 2007 8:01 AM Error 0
The request has exceeded the allowable time limit Tag: CFQUERY The specific
sequence of files included or processed is: \\

Server log

Jan 4, 2007 8:11 AM Warning 0
Thread: jrpp-90, processing template: , completed in 603 seconds, exceeding
the 30 second warning limit
Jan 4, 2007 8:11 AM Warning 0
Thread: jrpp-108, processing template: , completed in 237 seconds, exceeding
the 30 second warning limit
Jan 4, 2007 8:11 AM Warning 0
Thread: jrpp-97, processing template: , completed in 177 seconds, exceeding
the 30 second warning limit
Jan 4, 2007 8:11 AM Warning 0
Thread: jrpp-107, processing template: , completed in 115 seconds, exceeding
the 30 second warning limit
Jan 4, 2007 8:09 AM Warning 0
Thread: jrpp-115, processing template: , completed in 269 seconds, exceeding
the 30 second warning limit
Jan 4, 2007 8:08 AM Warning 0
Thread: jrpp-95, processing template: , completed in 269 seconds, exceeding
the 30 second warning limit
Jan 4, 2007 8:07 AM Warning 0
Thread: jrpp-104, processing template: , completed in 269 seconds, exceeding
the 30 second warning limit
Jan 4, 2007 8:05 AM Warning 0
Thread: jrpp-92, processing template: , completed in 180 seconds, exceeding
the 30 second warning limit
Jan 4, 2007 8:02 AM Warning 0
Thread: jrpp-85, processing template: , completed in 36 seconds, exceeding the
30 second warning limit
Jan 4, 2007 8:01 AM Warning 0
Thread: jrpp-87, processing template: , completed in 180 seconds, exceeding
the 30 second warning limit
Jan 4, 2007 8:01 AM Warning 0
Thread: jrpp-90, processing template:, completed in 162 seconds, exceeding the
30 second warning limit
Jan 4, 2007 8:01 AM Warning 0
Thread: jrpp-88, processing template: , completed in 176 seconds, exceeding
the 30 second warning limit
Jan 4, 2007 8:01 AM Warning 0
Thread: jrpp-91, processing template: completed in 161 seconds, exceeding the
30 second warning limit
Jan 4, 2007 8:01 AM Warning 0
Thread: jrpp-86, processing template:, completed in 180 seconds, exceeding the
30 second warning limit
Jan 4, 2007 8:01 AM Warning
0
Thread: jrpp-89, processing template: C:\websites\site04\index.cfm, completed
in 166 seconds, exceeding the 30 second warning limit

[Jochem van Dieten **AdobeCommunityExpert**]

frustratedTech wrote:

> That didn't fix it at all. Here' s exactly the errors I'm recieving in the log
> files. I now have access to ColdFusion so I can tell you what u need.

> Jan 4, 2007 8:11 AM Error 0
> The request has exceeded the allowable time limit Tag: CFQUERY The specific
> sequence of files included or processed is:
> Jan 4, 2007 8:09 AM Error 0
> Operation failed on the data source named ""ClientVariables"".Reason of
> failure ""Timed out trying to establish connection"" The specific sequence of
> files included or processed is:

You still have problems with your client variables. If you can not
switch your client store to cookies go into the CF Administrator and
disable global updates for client variables and try to reduce the purge
interval. Then compact your client variables database.

Jochem

--
Jochem van Dieten
Adobe Community Expert for ColdFusion

[frustratedTech]

Well I took off the updates slowly and it turned up to be Service Pack 1. Is there any cause for this? I took off SP1 and the site's been working like a charm for 5 da ys.

[klcoyne]

Help, I am having the same problem and am running the SP1. We have changed all
of our variables to session variables and I changed the client variables to
cookies. I do not want to have to remove sp1 on my windows 2003 server for
security reasons. Please give a solution if you find one.

[frustratedTech]

I didn't want to either, but I wanted our site working. I have it posted on a newsgorup as well. If I find one I will post it here.

[klcoyne]

Has anyone come up wiyh a solution yet?