Error Executing Database Query. Communications link failure

Posted on 2014-07-12
Last Modified: 2014-07-16
I use  CF 10, MySQL 5 on my mac, it crashed the other day, I used Time Machine to restore my system but now I'm getting this when I try to run a site on my local server. I don't know what happen, I thought Time Machine was like a clone?

Error Executing Database Query.
Communications link failure The last packet successfully received from the server was 315 milliseconds ago. The last packet sent successfully to the server was 312 milliseconds ago.

om.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 414 milliseconds ago.  The last packet sent successfully to the server was 411 milliseconds ago.
      at sun.reflect.GeneratedConstructorAccessor63.newInstance(Unknown Source)
      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(
      at java.lang.reflect.Constructor.newInstance(
      at com.mysql.jdbc.Util.handleNewInstance(
      at com.mysql.jdbc.SQLError.createCommunicationsException(
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(
      at com.mysql.jdbc.MysqlIO.sendCommand(
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(
      at com.mysql.jdbc.ConnectionImpl.execSQL(
      at com.mysql.jdbc.ConnectionImpl.execSQL(
      at com.mysql.jdbc.StatementImpl.execute(
      at com.mysql.jdbc.StatementImpl.execute(
      at coldfusion.server.j2ee.sql.JRunStatement.execute(
      at coldfusion.sql.Executive.executeQuery(
      at coldfusion.sql.Executive.executeQuery(
      at coldfusion.sql.Executive.executeQuery(
      at coldfusion.sql.SqlImpl.execute(
      at coldfusion.tagext.sql.QueryTag.executeQuery(
      at coldfusion.tagext.sql.QueryTag.doEndTag(
      at cfdesign_step2ecfm1444990369.runPage(/Applications/ColdFusion10/cfusion/wwwroot/obcre/www/step.cfm:8)
      at coldfusion.runtime.CfJspPage.invoke(
      at coldfusion.tagext.lang.IncludeTag.doStartTag(
      at coldfusion.filter.CfincludeFilter.invoke(
      at coldfusion.filter.IpFilter.invoke(
      at coldfusion.filter.ApplicationFilter.invoke(
      at coldfusion.filter.RequestMonitorFilter.invoke(
      at coldfusion.filter.MonitoringFilter.invoke(
      at coldfusion.filter.PathFilter.invoke(
      at coldfusion.filter.LicenseFilter.invoke(
      at coldfusion.filter.ExceptionFilter.invoke(
      at coldfusion.filter.BrowserDebugFilter.invoke(
      at coldfusion.filter.ClientScopePersistenceFilter.invoke(
      at coldfusion.filter.BrowserFilter.invoke(
      at coldfusion.filter.NoCacheFilter.invoke(
      at coldfusion.filter.GlobalsFilter.invoke(
      at coldfusion.filter.DatasourceFilter.invoke(
      at coldfusion.filter.CachingFilter.invoke(
      at coldfusion.CfmServlet.service(
      at coldfusion.bootstrap.BootstrapServlet.service(
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(
      at coldfusion.monitor.event.MonitoringServletFilter.doFilter(
      at coldfusion.bootstrap.BootstrapFilter.doFilter(
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(
      at org.apache.catalina.core.StandardWrapperValve.invoke(
      at org.apache.catalina.core.StandardContextValve.invoke(
      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(
      at org.apache.catalina.core.StandardHostValve.invoke(
      at org.apache.catalina.valves.ErrorReportValve.invoke(
      at org.apache.catalina.valves.AccessLogValve.invoke(
      at org.apache.catalina.core.StandardEngineValve.invoke(
      at org.apache.catalina.connector.CoyoteAdapter.service(
      at org.apache.coyote.http11.AbstractHttp11Processor.process(
      at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(
      at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(
      at java.util.concurrent.ThreadPoolExecutor$
Caused by: 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(
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(
      ... 55 more
Question by:overcolor
    LVL 15

    Accepted Solution

    Hi Overcolor, Its an issue with the latest mysql driver, update the driver and check that same in the coldfusion datasource you will be good to go. Here is the link for the reference:

    Author Comment

    When I do a "Verify all connections" in CF admin they all say "ok", I don't understand what you mean by update the MySQL driver.
    LVL 15

    Expert Comment

    did you read the Forums post, please check
    LVL 51

    Assisted Solution


    @overcolor -

    So was it working correctly before the restore? Silly question: I assume you already tried restarting CF + MySQL and your computer? If not, do that first, just to make sure it's not something simple like stale connections, etc... being cached somewhere.

    That link talks about problems with the CF9 drivers. You're using CF10.  If you never saw this error before doing the restore, that suggests it's a different problem. I don't use MAC, but this thread says it's not actually a full clone of your system. So perhaps something is missing? That's just a guess though ...

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Random Update 5 36
    Sequel Pro v. MySQL Workbench 4 28
    MySQL Trigger 8 25
    move records one table to another 14 36
    Recently while working on a project I got a very annoying cfdocument has no body error message. I had never seen this error before. So I checked the code. The code was pretty simple; it was Just showing me the cfdocumnt tag and inside that tag a …
    Do you come here a lot? Are you lazy like me and don't want to go through the "trouble" of having to click your Dock's Safari icon and then having to click your Experts Exchange Favorites bookmark to get here? Well then this article is for you.
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now