Solved

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

Posted on 2011-03-03
11
2,443 Views
Last Modified: 2012-05-11
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!!
0
Comment
Question by:MFredin
  • 5
  • 3
  • 2
  • +1
11 Comments
 
LVL 39

Expert Comment

by:gdemaria
ID: 35033513

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
 

Author Comment

by:MFredin
ID: 35033563
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
 
LVL 11

Expert Comment

by:Brijesh Chauhan
ID: 35033579
0
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 

Author Comment

by:MFredin
ID: 35033597
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
 
LVL 11

Expert Comment

by:Brijesh Chauhan
ID: 35033619
0
 
LVL 11

Expert Comment

by:Brijesh Chauhan
ID: 35033627

>> 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
 

Author Comment

by:MFredin
ID: 35033640
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
 

Author Comment

by:MFredin
ID: 35033728
I spoke too soon... same errors.  When I let the application sit for about 20 min and refresh, it triggers the error.
0
 
LVL 52

Expert Comment

by:_agx_
ID: 35033948
(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
 
LVL 52

Accepted Solution

by:
_agx_ earned 500 total points
ID: 35034084
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
 

Author Comment

by:MFredin
ID: 35060451
Thanks _agx_ !  

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

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

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 …
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.

773 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