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!!
MFredinAsked:
Who is Participating?
 
_agx_Connect With a Mentor Commented:
sounds suspiciously like a mySQL issue that's been around for a loong while

Here's a more direct link to that discussion
http://forums.adobe.com/message/3396302#3396302
0
 
gdemariaCommented:

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

0
 
MFredinAuthor Commented:
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
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
Brijesh ChauhanStaff IT EngineerCommented:
0
 
MFredinAuthor Commented:
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.
0
 
Brijesh ChauhanStaff IT EngineerCommented:

>> 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...
0
 
MFredinAuthor Commented:
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.
0
 
MFredinAuthor Commented:
I spoke too soon... same errors.  When I let the application sit for about 20 min and refresh, it triggers the error.
0
 
_agx_Commented:
(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

0
 
MFredinAuthor Commented:
Thanks _agx_ !  

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

From novice to tech pro — start learning today.