Dear All,
Our development server has been running with RedHat ES 3, apache and CFMX
6.1 for a couple of months without a problem, now all of a sudden CF can't
seem to connect to any database server, the CF server is fine, the netwrok
seems fine, I haven't made any changes recently but any time CF tries to
open a database connection I'm getting a JDBC timeout error.
When I tail the cfserver.log and restart the service I notice that 2
"sessions" seem to "persist" which then get recovered when the server starts
up again. This is REALLY weird and I'm wondering if any of you have any
experience of this problem because I'm pulling my hair out trying to solve
it.
I've enclosed two portions of log output, the first is the error I get when
trying to access a page with SQL on it, the second is the output of
cfserver.log when I restart cold fusion.
Any help you can offer would be greatly appreciated.
Thanks in advance,
-= Ed
~~~~~~~~~~~~~~~~~~~~~
1. Log output when trying to access a page with a SQL query on it:
java.sql.SQLException: Timed out trying to establish connection
at
coldfusion.server.j2ee.sql.pool.JDBCPool.requestConnection(JDBCPool.java:687
)
at
coldfusion.server.j2ee.sql.pool.JDBCManager.requestConnection(JDBCManager.ja
va:123)
at
coldfusion.server.j2ee.sql.JRunDataSource.getConnection(JRunDataSource.java:
138)
at
coldfusion.server.j2ee.sql.JRunDataSource.getConnection(JRunDataSource.java:
125)
at
coldfusion.sql.DataSrcImpl.getCachedConnection(DataSrcImpl.java:120)
at coldfusion.sql.DataSrcImpl.getConnection(DataSrcImpl.java:75)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:207)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:447)
at
cf_header2ecfm1247259433.runPage(/var/www/virtual/tiof/_header.cfm:77)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1871)
at
cf_main2dheader2ecfm223870943.runPage(/var/www/virtual/tiof/_main-header.cfm
:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1871)
at
cfwelcome2ecfm1822573824._factor7(/var/www/virtual/tiof/welcome.cfm:4)
at
cfwelcome2ecfm1822573824.runPage(/var/www/virtual/tiof/welcome.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62)
at
coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:80)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47)
at
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistence
Filter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43)
at
coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:105)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at
jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252)
at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192)
at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:
348)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451
)
at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:29
4)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
~~~~~~~~~~~~~~~~~~~~~~~
2. Output of cfserver.log when the server restarts:
04/02 08:46:30 user CFCServlet: destroy
04/02 08:46:30 user FlashGateway: destroy
04/02 08:46:30 info 2 session(s) persisted
Starting Macromedia JRun 4 (Build 63824), default server
04/02 08:46:44 warning Unable to open
/opt/coldfusionmx/runtime/lib/license.properties
04/02 08:46:45 info JRun Naming Service listening on *:2901
04/02 08:46:46 info No JDBC data sources have been configured for this
server (see jrun-resources.xml)
Running on JRun4...
Starting ColdFusion services...
- Starting logging...
0 [main] INFO coldfusion.server - Starting logging...
04/02 08:46:57 info JRun Proxy Server listening on *:51010
04/02 08:46:57 info Deploying enterprise application "Macromedia ColdFusion
MX" from: file:/opt/coldfusionmx/
04/02 08:46:58 info Deploying web application "ColdFusion Web Application"
from: file:/opt/coldfusionmx/
04/02 08:46:59 info Web Services in coldfusionmx#wwwroot:
04/02 08:46:59 info (No web services found.)
04/02 08:46:59 user JSPServlet: init
04/02 08:46:59 user FlashGateway: init
04/02 08:47:00 user CFCServlet: init
04/02 08:47:00 info Recovering 2 session(s)
Server default ready (startup time: 18 seconds)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta
http://www.houseoffusion.com/banners/view.cfm?bannerid=40
Message: http://www.houseoffusion.com/lists.cfm/link=i:14:3829
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/14
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:14
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.14
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
