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