java.io.EOFException error

[prdeepak]

Hi,

I have developed a kettle script which would create a flat file by joining a set of input tables which are highly normalized. The script works fine for records upto 20,000.But when the script is run of more number of records it runs for long time and throws the below error :

Couldn't close query: resultset or prepared statements
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:1934 )
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO. java:2380)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:2909)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:798)
at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1316)
at com.mysql.jdbc.RowDataDynamic.nextRecord(RowDataDy namic.java:370)
at com.mysql.jdbc.RowDataDynamic.next(RowDataDynamic. java:360)
at com.mysql.jdbc.RowDataDynamic.close(RowDataDynamic .java:150)
at com.mysql.jdbc.ResultSet.realClose(ResultSet.java: 6314)
at com.mysql.jdbc.ResultSet.close(ResultSet.java:749)
at org.pentaho.di.core.database.Database.closeQuery(D atabase.java:2430)
at org.pentaho.di.trans.steps.tableinput.TableInput.c losePreviousQuery(TableInput.java:202)
at org.pentaho.di.trans.steps.tableinput.TableInput.d ispose(TableInput.java:252)
at org.pentaho.di.trans.step.BaseStep.runStepThread(B aseStep.java:2918)
at org.pentaho.di.trans.steps.tableinput.TableInput.r un(TableInput.java:345)


Could you please help me to solve this issue.

Thanks
Deepak

[prdeepak]

I am adding more details on what the error reads:

Streaming result set com.mysql.jdbc.RowDataDynamic@2136bdda is still active. No statements may be issued when any streaming result sets are open and in use on a given connection. Ensure that you have called .close() on any active streaming result sets before attempting more queries.

It seems to be some configuration related error. Please clarify.

Thanks
Deepak

[prdeepak]

I was able to resolve this error by refering to one of the thread in this forum posted some time back .. given below
http://forums.pentaho.org/showthread.php?t=68795

sorry for spamming....

Thanks
Deepak