EOFException with jdbc driver
Hi all, I have a Java webapp using a mysql database. It all used to run well, but I now frequently get the following error: 2005-09-15 11:33:32,115 [Thread-23] ERROR rotation - com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.io.EOFException STACKTRACE: java.io.EOFException at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1842) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2288) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2784) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622) at com.mysql.jdbc.Connection.execSQL(Connection.java:2370) at com.mysql.jdbc.Connection.execSQL(Connection.java:2297) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1183) I cannot really say when this started, but I did not get the impression that I changed anything in my software. It also seems that this is not restricted to certain queries, but is accidental. My configuration is Suse Linux 9.1, MySQL-Max-4.1.5-0 (the binary rpm from mysql.com), mysql-connector-java-3.1.7, Java 1.4.2. I did not find anything about how to resolve this and also not a real explanation what the error means. Any ideas? Thanks, Stefan -- Stefan Kuhn M. A. Cologne University BioInformatics Center (http://www.cubic.uni-koeln.de) Zülpicher Str. 47, 50674 Cologne Tel: +49(0)221-470-7428 Fax: +49 (0) 221-470-7786 My public PGP key is available at http://pgp.mit.edu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: EOFException with jdbc driver
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stefan Kuhn wrote: Hi all, I have a Java webapp using a mysql database. It all used to run well, but I now frequently get the following error: 2005-09-15 11:33:32,115 [Thread-23] ERROR rotation - com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.io.EOFException STACKTRACE: java.io.EOFException at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1842) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2288) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2784) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622) at com.mysql.jdbc.Connection.execSQL(Connection.java:2370) at com.mysql.jdbc.Connection.execSQL(Connection.java:2297) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1183) I cannot really say when this started, but I did not get the impression that I changed anything in my software. It also seems that this is not restricted to certain queries, but is accidental. My configuration is Suse Linux 9.1, MySQL-Max-4.1.5-0 (the binary rpm from mysql.com), mysql-connector-java-3.1.7, Java 1.4.2. I did not find anything about how to resolve this and also not a real explanation what the error means. Any ideas? Thanks, Stefan Stefan, Something is closing the network connection abrubtly between JDBC and your MySQL server. Things to check are: 1) Connections don't sit longer than 'wait_timeout' on the server. 2) If the mysql server is on a different machine than your application: 2a) There are no network hardware issues 2b) There isn't a firewall between the server and your application that times-out connections 3) MySQL isn't crashing in between queries (see your mysql server error log) -Mark - -- Mark Matthews MySQL AB, Software Development Manager - Connectivity www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFDKXaetvXNTca6JD8RAoojAJ9rC9QqM5WEBgASOJPagUuv3DF+hACfRv9j M/WMHIbCvVJdhmXNzHijjWM= =OPzU -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: EOFException with jdbc driver
Hi Mark, thanks for your answer. See comments. Stefan, Something is closing the network connection abrubtly between JDBC and your MySQL server. Things to check are: 1) Connections don't sit longer than 'wait_timeout' on the server. I am actually using connection pooling (the torque system, in case you know this). After I get this error, my app is still running fine, and also doing dtabase queries. Something interesting: When I do a query ... where x like %y% the error occurs. Doing where x regexp y works fine, even if I do the regular expression query after the like one, without restarting server or similar things. 2) If the mysql server is on a different machine than your application: Same machine 2a) There are no network hardware issues 2b) There isn't a firewall between the server and your application that times-out connections 3) MySQL isn't crashing in between queries (see your mysql server error log) Nothing in the log -Mark -- Mark Matthews MySQL AB, Software Development Manager - Connectivity www.mysql.com -- Stefan Kuhn M. A. Cologne University BioInformatics Center (http://www.cubic.uni-koeln.de) Zülpicher Str. 47, 50674 Cologne Tel: +49(0)221-470-7428 Fax: +49 (0) 221-470-7786 My public PGP key is available at http://pgp.mit.edu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]