• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 605
  • Last Modified:

Datasource TestDB1 could not be found.

I've got another website that when you go to it will throw an error and say:

Datasource TestDB1 could not be found.

But if you refresh it, it will load correctly.

Application.log:

Datasource TestDB1 could not be found. The specific sequence of files included or processed is: /var/www/vhosts/exampledomian.org/httpdocs/about-us/index.cfm, line: 1

exception.log

"Error","jrpp-54897","04/25/11","17:26:22",,"Datasource TestDB1 could not be found. The specific sequence of files included or processed is: /var/www/vhosts/exampledomain.com/httpdocs/index.cfm, line: 1 "
      coldfusion.tagext.sql.QueryTag$DataSourceException: Datasource TestDB1 could not be found.
       at coldfusion.tagext.sql.QueryTag.doStartTag(QueryTag.java:480)
      at cfindex2ecfm928221571.runPage(/var/www/vhosts/exampledomain.com/httpdocs/index.cfm:1)
      at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196)
      at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370)
       at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
       at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279)
       at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
       at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
       at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
       at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
       at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
       at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
       at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
       at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
       at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
       at coldfusion.CfmServlet.service(CfmServlet.java:175)
       at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
       at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
       at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
       at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
       at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
       at jrun.servlet.FilterChain.service(FilterChain.java:101)
       at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
       at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
       at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
       at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
       at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
       at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)
       at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
       at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)
       at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
       Caused by: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:
0
binarybilly
Asked:
binarybilly
  • 4
  • 3
1 Solution
 
_agx_Commented:
Caused by: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

.... But if you refresh it, it will load correctly.


It's entirely possible this is a slightly different manifestation of the same problem as in your other thread.  What's the rest of the error beyond that line?
0
 
binarybillyAuthor Commented:
** BEGIN NESTED EXCEPTION **
36       java.io.EOFException
37       STACKTRACE:
38       java.io.EOFException
39       at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1963)
40       at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2375)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2874)
42       at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623)
43       at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)
44       at com.mysql.jdbc.Connection.execSQL(Connection.java:3243)
45       at com.mysql.jdbc.Connection.setCatalog(Connection.java:5442)
46       at coldfusion.server.j2ee.sql.JRunConnection.setCatalog(JRunConnection.java:484)
47       at coldfusion.server.j2ee.sql.JRunConnectionHandle.setCatalog(JRunConnectionHandle.java:134)
48       at coldfusion.tagext.sql.QueryTag.doStartTag(QueryTag.java:471)
49       at cfindex2ecfm928221571.runPage(/var/www/vhosts/exampledomain.com/httpdocs/index.cfm:1)
50       at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196)
51       at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370)
52       at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
53       at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279)
54       at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
55       at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
56       at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
57       at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
58       at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
59       at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
60       at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
61       at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
62       at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
63       at coldfusion.CfmServlet.service(CfmServlet.java:175)
64       at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
65       at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
66       at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
67       at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
68       at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
69       at jrun.servlet.FilterChain.service(FilterChain.java:101)
70       at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
71       at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
72       at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
73       at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
74       at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
75       at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)
76       at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
77       at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)
78       at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
79       ** END NESTED EXCEPTION **
0
 
_agx_Commented:
Yeah, I think it's the same driver issue.  This person reported that adding the same validation query (ie "SELECT 1") solved the EOF error for them

http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/Cold_Fusion_Markup_Language/Q_26863169.html?sfQueryTermInfo=1+10+30+agx+coldfus+mysql+sporad
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
binarybillyAuthor Commented:
I will give it a shot.
0
 
_agx_Commented:
Ok. While I've seen 2 or 3 error messages related to this mysql driver issue,  the one thing they tend to have in common is the sporadic nature of the problem. ie "If you refresh, the problem goes away."  That's what makes me suspect it's the same underlying driver problem.
0
 
Gurpreet Singh RandhawaWeb DeveloperCommented:
if you are on shared host ask your provider to update the driver, it will resolve th issue as agx has rightly said
0
 
binarybillyAuthor Commented:
select 1 seemed to be the fix again. I'm going to apply this to all my datasources. Thanks agx!
0
 
_agx_Commented:
Yeah, if they're all mySQL dsn's .. probably a good idea  :) AFAIK it's only an issue w/the MySQL drivers. Cheers

0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now