I'm getting these sporadic time-out errors on this web application that is
supposed to be a very sophisticated assessment tool. It uses quite a few
ColdFusion queries. It's not failing at exactly the same spot, it's been
sporadic and I'm not sure what the cause is. I'm wondering if I might have too
many queries or too much cfscript. Here's one of the errors in detail:
Error Occurred While Processing Request
Error Executing Database Query.
Timed out trying to establish connection
The error occurred in E:\Web Sites\Manners Matrix\www\MMS\P\S1\Q3\qF.cfm: line
17
Called from E:\Web Sites\Manners Matrix\www\MMS\P\S1\Q3\qF.cfm: line 1
Called from E:\Web Sites\Manners Matrix\www\MMS\P\S1\Q3\qF.cfm: line 17
Called from E:\Web Sites\Manners Matrix\www\MMS\P\S1\Q3\qF.cfm: line 1
15 : SELECT JHQTY3, EQTY3
16 : FROM ParQuestions
17 : WHERE District = '#District#'
18 : </cfquery>
19 : <cfquery name="MSD" datasource="#DSNOut#">
SQL SELECT JHQTY3, EQTY3 FROM ParQuestions WHERE District = '999'
DATASOURCE ILOut1
Please try the following:
* Check the ColdFusion documentation to verify that you are using the
correct syntax.
* Search the Knowledge Base to find a solution to your problem.
Browser Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.7)
Gecko/20060909 Firefox/1.5.0.7
Remote Address 67.167.112.135
Referrer
http://www.mannersmatrix.com/mms/P/S1/Q3/qE.cfm?State=Illinois&District=999&SchoolID=ILMN999J01&DSNOut=ILOut1&DSNIn=IL999In&RandPK=E3SD5GX6TJ&qYN=NNYYYYYYYY&QTY3L=+e+g+i+k&QTY3TPW=2&QTY3IOY=+b+&QTY3D=+m+o+q&QTY3BW=&QTY3R=
Date/Time 30-Oct-06 01:24 PM
Stack Trace
at cfqF2ecfm629700511._factor2(E:\Web Sites\Manners
Matrix\www\MMS\P\S1\Q3\qF.cfm:17) at cfqF2ecfm629700511.runPage(E:\Web
Sites\Manners Matrix\www\MMS\P\S1\Q3\qF.cfm:1) at
cfqF2ecfm629700511._factor2(E:\Web Sites\Manners
Matrix\www\MMS\P\S1\Q3\qF.cfm:17) at cfqF2ecfm629700511.runPage(E:\Web
Sites\Manners Matrix\www\MMS\P\S1\Q3\qF.cfm:1)
java.sql.SQLException: Timed out trying to establish connection
at
coldfusion.server.j2ee.sql.pool.JDBCPool.requestConnection(JDBCPool.java:750)
at
coldfusion.server.j2ee.sql.pool.JDBCManager.requestConnection(JDBCManager.java:123)
at
coldfusion.server.j2ee.sql.JRunDataSource.getConnection(JRunDataSource.java:138)
at
coldfusion.server.j2ee.sql.JRunDataSource.getConnection(JRunDataSource.java:125)
at coldfusion.sql.CFDataSource.getConnection(CFDataSource.java:37)
at coldfusion.sql.DataSrcImpl.getCachedConnection(DataSrcImpl.java:149)
at coldfusion.sql.DataSrcImpl.getConnection(DataSrcImpl.java:103)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:214)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:498)
at cfqF2ecfm629700511._factor2(E:\Web Sites\Manners
Matrix\www\MMS\P\S1\Q3\qF.cfm:17)
at cfqF2ecfm629700511.runPage(E:\Web Sites\Manners
Matrix\www\MMS\P\S1\Q3\qF.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:343)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at
coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:210)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:50)
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.CfmServlet.service(CfmServlet.java:105)
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:527)
at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204)
at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:349)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:457)
at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:295)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259665
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
