Bug #27914 Error while retrieving resultset
Submitted: 18 Apr 2007 6:20 Modified: 31 Mar 2014 12:40
Reporter: Arijit Chatterjee Email Updates:
Status: Can't repeat Impact on me:
None 
Category:Connector / J Severity:S2 (Serious)
Version:5.0.5 OS:Windows
Assigned to: Alexander Soklakov CPU Architecture:Any

[18 Apr 2007 6:20] Arijit Chatterjee
Description:
I have been using mySQl as a backend for my research project and am performing clustering based on cosine similarity between documents, for which, I am storing word frequencies for each document in the database and comparing two frequency lists for finding similarity. The program works fine for sometime, by comparing documents and then gives the following exception:
Exception in thread main"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:1963)
	at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2428)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2874)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:868)
	at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1351)
	at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:2333)
	at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:435)
	at
com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:2040)
	at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1443)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1777)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:3243)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:3172)
	at com.mysql.jdbc.Statement.executeQuery(Statement.java:1197)
	at mailExtraction.ClusterFile.executeSelect(ClusterFile.java:72)
	at mailExtraction.ClusterFile.getLabel(ClusterFile.java:316)
	at mailExtraction.ClusterFile.clusterFiles(ClusterFile.java:118)
	at mailExtraction.ClusterFile.main(ClusterFile.java:38)

** END NESTED EXCEPTION **

Last packet sent to the server was 479687 ms ago.
	at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2586)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2874)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:868)
	at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1351)
	at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:2333)
	at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:435)
	at
com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:2040)
	at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1443)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1777)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:3243)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:3172)
	at com.mysql.jdbc.Statement.executeQuery(Statement.java:1197)
	at mailExtraction.ClusterFile.executeSelect(ClusterFile.java:72)
	at mailExtraction.ClusterFile.getLabel(ClusterFile.java:316)
	at mailExtraction.ClusterFile.clusterFiles(ClusterFile.java:118)
	at mailExtraction.ClusterFile.main(ClusterFile.java:38)

I am using mysql-5.2.3-falcon-alpha on Windows XP and the JConnector is:mysql-connector-java-5.0.5.zip

--
MySQL AB <http://www.mysql.com/>

How to repeat:
The exception is generated after the Garbage Collection Process of Java starts.
[2 May 2007 6:57] Tonci Grgin
Hi Arijit and thanks for your report.

You seem to be reading beyond end of resultset. Please post small but complete test case showing this error as well as JDK/JRE info.
[2 Jun 2007 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[31 Mar 2014 12:40] Alexander Soklakov
I close this report as "Can't repeat" because there is no feedback for a long time and codebase is too old. Please, feel free to reopen it if the problem still exists in current driver.