Skip to main content
Participating Frequently
January 2, 2007
Question

Jrun Closed Connection after Windows updates

  • January 2, 2007
  • 5 replies
  • 1825 views
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(BufferedInputStream.java:183)
at java.io.BufferedInputStream.read1(BufferedInputStream.java:222)
at java.io.BufferedInputStream.read(BufferedInputStream.java:277)
at jrun.servlet.jrpp.ProxyEndpoint.readFully(ProxyEndpoint.java:530)
at jrun.servlet.jrpp.ProxyEndpoint.readFully(ProxyEndpoint.java:522)
at jrun.servlet.jrpp.ProxyEndpoint.readInt(ProxyEndpoint.java:540)
at jrun.servlet.jrpp.ProxyEndpoint.readRequest(ProxyEndpoint.java:229)
at jrun.servlet.jrpp.JRunProxyService.swapRunnable(JRunProxyService.java:144)
at jrunx.scheduler.ThreadPool$DownstreamMetrics.swapRunnable(ThreadPool.java:320)
at jrunx.scheduler.ThreadPool$ThreadThrottle.swapRunnable(ThreadPool.java:433)
at jrunx.scheduler.ThreadPool$UpstreamMetrics.swapRunnable(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(ThreadPool.java:125)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:448)
at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(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.

Update: I took off the updates from December 2006 and that seemed to have broken the site completely. Right after the reboot, all I could get was Jrun Closed Connection. I put the updates back on and the site is working again. It has to be that one of these updates fixed something that another update broke, but didn't fully fix it.
    This topic has been closed for replies.

    5 replies

    Known Participant
    January 29, 2007
    Has anyone come up wiyh a solution yet?
    January 3, 2007
    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.
    Participating Frequently
    January 3, 2007
    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.
    Participating Frequently
    January 5, 2007
    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:

    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




    January 3, 2007
    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.
    Inspiring
    January 2, 2007
    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
    Participating Frequently
    January 3, 2007
    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.

    Alright I took a look around and it looks like the clientvariables are stored in an access database on the server called cvariables.mdb. I tried going to some of the other sitese and it didn't help. I couldn't remember all of them, so I didn't get to try them all.
    Participating Frequently
    January 3, 2007
    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.
    January 2, 2007
    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.
    Participating Frequently
    January 2, 2007
    Unfortunately I don't have the administrator password to ColdFusion because the webmaster has it. Is there any other way to see what it's set at? I will try to get it as soon as I can. I did check 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