?
Solved

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

Posted on 2011-03-03
11
Medium Priority
?
2,752 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
AWS Certified Solutions Architect - Associate

This course has been developed to provide you with the requisite knowledge to not only pass the AWS CSA certification exam but also gain the hands-on experience required to become a qualified AWS Solutions architect working in a real-world environment.

 

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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

764 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