Coldfusion hangs

[Snaijer]

Hi everybody,

Since a while it looks like our Coldfusion server random decides to hang. After looking in the CF-log files we cannot point out what causes the hanging. Since the end of May an error message appears in the Application- and Exception-log files:

Application-log:
"Error","jrpp-5623","07/13/06","03:54:31",,"Error Executing Database Query.Timed out trying to establish connection The specific sequence of files included or processed is: /toolbox/test/http/cfajax/AJAX.cfm, line: 6 "

Exception-log:
"Error","jrpp-5623","07/13/06","03:54:31",,"Error Executing Database Query.Timed out trying to establish connection The specific sequence of files included or processed is: /toolbox/test/http/cfajax/AJAX.cfm, line: 6 "
coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query.
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:579)
at cfip_check2ecfm1523298093.runPage(/toolbox/test/http/cf/ip_check.cfm:6)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915)
at cfApplication2ecfm1941991993.runPage(/toolbox/test/http/Application.cfm:40)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:33)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:156)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115)
at coldfusion.CfmServlet.service(CfmServlet.java:107)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204)
at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426)
at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

These two messages are the last entries before the Coldfusion server hangs. When we look in the mentioned file AJAX.CFM on line 6 there is nothing strange. It is a line in the middle of a query.

Does anybody have a clue where we can search for what is causing the problem? Or does anybody have a solution?

Thanx allready!!!

Kind regards,
Paul de Snaijer

[Guest]

Three questions: Is the datasource you are querying on the same server as /toolbox/test/http/cfajax/AJAX.cfm or is it on a different box? How are you connecting to the datasource (ODBC, etc.)? Is the datasource used by other processes?

It appears from the application.log entry that the datasource is hung.

[Snaijer]

Hi,

Thanx for your quick answer. Here are my answers:

Is the datasource you are querying on the same server as /toolbox/test/http/cfajax/AJAX.cfm or is it on a different box?
The database is installed on another server. The Coldfusion server runs on a UNIX machine and the Oracle database runs on a Windows machine

How are you connecting to the datasource (ODBC, etc.)?
We are connecting to the database thru the Oracle driver (chosen in the CF Administrator)

Is the datasource used by other processes?
The datasource is used by this application only. But in the application it is used serveral times and also at the same time.

Thanx again!

Kind regards,
Paul de Snaijer

[Snaijer]

Does anyone have an idea where to look for the problem / how to solve this problem??

THANX!

[JMGibson3]

I recall threads mentioning issues with the Macromedia Oracle driver in certain situations, Stored Procedures amongst others. Workarounds were to isolate/change the failing SQL and/or switch to native drivers from Oracle. Hate to say it but the solution is search, search and more search unless you can posy your exact configuration, Oracle version, driver version, failing SQL, etc. and someone else has run across that exact symptom and post a quick answer.

[Snaijer]

Thanx for the quick answer. I am going to look for the native drivers for Oracle. Unfortunately I cannot get all the information of the operating system. But I will ask a few colleques if they can help me with that.

Thanx again.

[SandyVohra]

Check the HEAP size in jvm.config and if you have IIS 6.0 as web server there is a know problem with WriteClient API. There are MS patches available at Microsoft KB site..

Thanks.

[Snaijer]

Thanx for your answer!

Unfortunately I cannot look in the jvm.config file because I don't have access to the install directory of Coldfusion. But in the Coldfusion Administrator on the 'Server Settings' --> 'Java and JVM'-page there is a setting called "Maximum JVM Heap Size (MB)". This setting is set to 512. As what I read on forums this should be enough or not?

We are not running IIS 6.0, but Apache on a UNIX machine.

Thanx again!

[SandyVohra]

512 should be fine..Anything more allocated might cause startup problems...Sorry I thought you had IIS.

Just that I could recollect another problem we faced sometime back ..- This was problem with CF 5.0 when we had the database sitting in a different LAN and there is a VPN connection between the web server and database, Attimes the VPN goes down which hangs any requests coming to CF. This cannot be corrected unless we have VPN up and restart CF Server..

Thanks.