asked on

java.io.EOFException: Can not read response from server.

I've got CF 9 standard running on a Red Hat box with MySQL 5 & Apache.

When I first load my site, it immediately throws the following error: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost When I refresh, everything works fine; I think once the SQL query is cached, thus giving a faster response, the page works, but when it has to do a fresh query, it times out.

I've been doing research on the error and have increased the net_read_timeout and net_write_timeout settings in MySQL to 30 seconds.... but the error happens almost immediately so I don't think it's MySQL.

It almost seems more like Coldfusion is simply not waiting long enough for a response from MySQL before closing the connection.

Any help is appreciated!!

gdemaria

try loading a page that has no SQL interactions and see if the error occurs

You can create a simple dummy page that just says "Hello World" test.cfm

You can also try a simple html page that does the same. This will avoid the CF processor. That will help narrow it down between Apache and Coldfusion and SQL. test.html = Hello World

MFredin

ASKER

Couldn't get it to break on the test.cfm and test.html pages you recommended in the last post.

Here's a few other errors with it.

ErrorCode: 0
            Message: Communications link failure
            Last packet sent to the server was 0 ms ago.
            SQLState: 08S01
            StackTrace: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
            Last packet sent to the server was 0 ms ago

DataSource: MYDATA
      Detail: Communications link failure
      Last packet sent to the server was 0 ms ago.
      ErrorCode: 08S01
      Message: Error Executing Database Query

Brijesh Chauhan

Read about the above error '08S01' here

http://dev.mysql.com/doc/refman/5.0/en/connector-j-usagenotes-troubleshooting.html#qandaitem-21-3-5-3-1-3

MFredin

ASKER

Thanks brikeshchauhan,

Seems like the problems they talk about in the article would continuously cause problems, where the errors I get go away after one or two refreshes of the page.

Brijesh Chauhan

Couple of more posts that talk on how to resolve it...

http://forums.mysql.com/read.php?39,199085,219086#msg-219086

http://anuragpatil.wordpress.com/2009/08/03/com-mysql-jdbc-exceptions-jdbc4-communicationsexception-communications-link-failure-last-packet-sent-to-the-server-was-0-ms-ago/

Brijesh Chauhan

>> Seems like the problems they talk about in the article would continuously cause problems, where the errors I get go away after one or two refreshes of the page.

Yes, basically WHY DOES it work on page refresh ? that would probably answer it... I just saw the error codes and thought may be something is in there which could help you...

MFredin

ASKER

Thanks guys. I changed "localhost" to my server name and it seems to have solved the problem. I will come back after some testing time.

MFredin

ASKER

I spoke too soon... same errors. When I let the application sit for about 20 min and refresh, it triggers the error.

_agx_

(not for points ...)

Though the error's different, the sporadic nature of the problem sounds suspiciously like a mySQL issue that's been around for a loong while
http://stackoverflow.com/questions/4500414/coldfusion-9-mysql-communications-link-failure

A total shot in the dark, but is this relevant?
http://forums.mysql.com/read.php?39,277481,286736#msg-286736

ASKER CERTIFIED SOLUTION

_agx_

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

MFredin

ASKER

Thanks _agx_ !

I simply added "SELECT 1" in the connection string on my CF datasource and it's back on track.