java.io.EOFException: Can not read response from server.
Posted on 2011-03-03
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!!