Thanks for the suggestions. I will follow up on both tomorrow in the office. I will see if there are any other networking issues when this happens.
Thanks again and if there are any other suggestions, please keep them coming. On Wed, Jun 23, 2010 at 4:01 PM, Matthew Small <[email protected]>wrote: > > It sounds like a networking error more than an app error. You might try > running Wireshark with a limited-size looping buffer to try to capture a > trace of the problem. > > Also, do you have any other network issues during the time of the issue? > > > > We have been dealing with a MySQL error for a little while and can't > > seem to > > figure out what is causing it. > > This error appears on our production server: > > > > Red Hat Linux Enterprise 64 bit > > MySQL 5.0.77 > > CF 9 > > > > This error happens any time, day or night and sometimes in multiple > > occurrences and from different pages. I am guessing that normal site > > operations continues after the user gets this error and refreshes > > their > > browser as we don't hear any complaints from users about it. The > > error > > appears in our logs and we would love to get rid of it. > > > > The main error is: > > * > > **Error Executing Database Query. Communications link failure Last > > packet > > sent to the server was 0 ms ago. <br>The error occurred on line 6. * > > > > Stack Trace: > > > > Message > > > > Can not read response from server. Expected to read 4 bytes, read 0 > > bytes > > before connection was unexpectedly lost. > > > > StackTrace > > > > java.io.EOFException: Can not read response from server. Expected to > > read 4 > > bytes, read 0 bytes before connection was unexpectedly lost. at > > com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2455) at > > com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2906) at > > com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2895) at > > com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3438) at > > com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951) at > > com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101) at > > com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554) at > > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement. > > java:1761) > > at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement. > > java:1021) at > > coldfusion.server.j2ee.sql.JRunPreparedStatement. > > execute(JRunPreparedStatement.java:91) > > at coldfusion.sql.Executive.executeQuery(Executive.java:1245) at > > coldfusion.sql.Executive.executeQuery(Executive.java:1008) at > > coldfusion.sql.Executive.executeQuery(Executive.java:939) at > > coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at > > coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:843) at > > coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:533) at > > cfaction2epage2edefault2ecfm19563856._factor4(/var/www/html/action. > > page.default.cfm:6) > > at > > cfaction2epage2edefault2ecfm19563856.runPage(/var/www/html/action.page. > > default.cfm:1) > > at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at > > coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at > > coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at > > cfindex2ecfm500695976.runPage(/var/www/html/index.cfm:56) at > > coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at > > coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at > > coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at > > coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:363) > > at > > coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter. > > java:48) > > at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) > > at > > coldfusion.filter.PathFilter.invoke(PathFilter.java:87) 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.filter.CachingFilter.invoke(CachingFilter.java:53) at > > coldfusion.CfmServlet.service(CfmServlet.java:200) 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) > > > > When going to the page that thew this error, I can't force the error. > > > > Suggestions? Anyone? > > > > Thanks, > > > > Mal > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334801 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
