MySQL Communication link failure

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default MySQL Communication link failure

    I have recently setup a MySQL 4.1.12 database on FreeBSD. I connect to the
    database using Coldfusion on a Windows 2003 computer. The database seems to be
    working fairly well, about 95% of the time. The other time it gives me the
    error below and i have no idea what to do.

    I can't tell if it is MySQL or the connector i am using
    (mysql-connector-java-3.0.16-ga-bin.jar). Any ideas at what to try or do to
    get this working?




    Error Detail:
    Communication link failure: java.io.EOFException, underlying cause: null

    ** BEGIN NESTED EXCEPTION **

    java.io.EOFException

    STACKTRACE:

    java.io.EOFException
    at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1394 )
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO. java:1538)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:1929)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:11 67)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1278)
    at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1224)
    at com.mysql.jdbc.Connection.execSQL(Connection.java: 2248)
    at com.mysql.jdbc.Connection.execSQL(Connection.java: 2196)
    at com.mysql.jdbc.Statement.execute(Statement.java:90 6)
    at coldfusion.server.j2ee.sql.JRunStatement.execute(J RunStatement.java:212)
    at coldfusion.sql.Executive.executeQuery(Executive.ja va:974)
    at coldfusion.sql.Executive.executeQuery(Executive.ja va:886)
    at coldfusion.sql.SqlImpl.execute(SqlImpl.java:229)
    at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.j ava:44...


    rpmon Guest

  2. Similar Questions and Discussions

    1. MySQL 4.1.16 compile failure under Linux 2.6.12.2
      Hello: Trying to upgrade from MySQL 3.23.40 to 4.1.16 and am having no luck getting the sources compiled. If you need further information or...
    2. Failure MySQL JDBC driver 3.1 or 3.2
      I want to use MySQL 5 with ColdFusion MX 7 standard. I tried the JDBC Connector 3.1 and 3.2. Adding a new DSN works fine in administratrion, but if...
    3. Communication App Inspector login failure
      yesterday i could. today i can't. same username, same password. the documentation gives no indication of what to do in the circumstance (it reads...
    4. Error Executing Database Query.Communication link
      Pretty much everyday when I get up now all my coldfusion sites that use MySQL just take forever to load. In fact they never load or even time out,...
    5. #24724 [NEW]: Link failure with --disable-cgi --enable-cli
      From: kyle at putnamcabinets dot com Operating system: Debian GNU/Linux (Sid) PHP version: 4.3.3RC1 PHP Bug Type: Compile...
  3. #2

    Default Re: MySQL Communication link failure

    I am still having this issue but it seems to happen only if the server is idle
    for more than 5 minutes.

    I have a scheduled task running to check the server status. If i set it to
    recur every 5 minutes i do not see this error again. Is there some place i
    need to change a time out setting for this connector?



    rpmon Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139