Restart MySQL and Error is thrown... all ok afterrefresh

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

  1. #1

    Default Restart MySQL and Error is thrown... all ok afterrefresh

    Hello Folks,

    I have a variety of sites on my server all accessing the MySQL database.
    Whenever I restart MySQL and attempt to access one of the sites via (IE)
    browser the attached error is encountered. After that, when I refresh the
    browser, all is ok... the connection has been established and we go on our
    merry way. (at least that's what i think)

    How can I avoid this "Communications link failure due to underlying exception"?

    Environment:
    Windows 2003 Server
    MySQL 5.0.20 DB
    CF 6.1 (using jdbc connect -- "useUnicode=true&characterEncoding=utf8" &
    Maintain Connections in checked (in CF admin)
    IIS 6.0



    Error Executing Database Query.
    Communications link failure due to underlying exception: ** BEGIN NESTED
    EXCEPTION ** java.io.EOFException STACKTRACE: java.io.EOFException at
    com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1842 ) at
    com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO. java:2288) at
    com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:2784) at
    com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:15 31) at
    com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1622) at
    com.mysql.jdbc.Connection.execSQL(Connection.java: 2370) at
    com.mysql.jdbc.Connection.execSQL(Connection.java: 2297) at
    com.mysql.jdbc.Statement.execute(Statement.java:90 2) 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:236) at
    coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.j ava:447) at
    cfindex2ecfm326061290._factor8(D:\http\monitor\mys ql\index.cfm:...

    weblingual Guest

  2. Similar Questions and Discussions

    1. #38996 [NEW]: PDO persistant connection breaks on mysql restart
      From: fifthnormal at hotmail dot com Operating system: Linux PHP version: 5.1.6 PHP Bug Type: PDO related Bug description: ...
    2. error A License Exception has been thrown
      :D I have been experiencing the same License Exception problem myself, with a new installation of Coldfusion 6.1. Enterprise Edition. As...
    3. No error message on manually thrown exceptions
      Why, if I throw a System.Exception in my web method, do I see the standard IE 500 error page, rather than the stack trace as I do with other errors...
    4. Why is there no error thrown in these 3 lines of code?
      $MyVar=1; if (MyVar ==1){ $var2="abc"; } Notice I left out the "$" in the IF statement. No error. It drops into the statement and sets the...
    5. @transaction=required - results in hang after error thrown
      I have an asp page that uses the @TRANSACTION=REQUIRED directive. Within the page I create two of my vb com+ components that are marked require...
  3. #2

    Default Re: Restart MySQL and Error is thrown... all ok afterrefresh

    any ideas on this?
    weblingual 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