Uploaded image for project: 'Pentaho Data Integration - Kettle'
  1. Pentaho Data Integration - Kettle
  2. PDI-6677

MySQL: Error getting row information from database / Streaming result set [...] is still active

    XMLWordPrintable

    Details

    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.
    • Operating System/s:
      Windows 7

      Description

      The error I am receiving is essentially the same as http://jira.pentaho.com/browse/PDI-1081, which is marked as a duplicate of PDI-1060:

      2011/09/01 16:00:09 - Table input.0 - SQL query : select * from test;
      2011/09/01 16:00:09 - test - ERROR (version 4.2.0-GA, build 15694 from 2011-08-24 11.46.44 by buildguy) : ERROR executing query: org.pentaho.di.core.exception.KettleDatabaseException:
      2011/09/01 16:00:09 - test - ERROR (version 4.2.0-GA, build 15694 from 2011-08-24 11.46.44 by buildguy) : Error getting row information from database:
      2011/09/01 16:00:09 - test - ERROR (version 4.2.0-GA, build 15694 from 2011-08-24 11.46.44 by buildguy) : Streaming result set com.mysql.jdbc.RowDataDynamic@767a209 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.
      2011/09/01 16:00:09 - test - ERROR (version 4.2.0-GA, build 15694 from 2011-08-24 11.46.44 by buildguy) : ERROR in part: openQuery : get rowinfo
      2011/09/01 16:00:09 - Table input.0 - ERROR (version 4.2.0-GA, build 15694 from 2011-08-24 11.46.44 by buildguy) : Unexpected error
      2011/09/01 16:00:09 - Table input.0 - ERROR (version 4.2.0-GA, build 15694 from 2011-08-24 11.46.44 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException:
      2011/09/01 16:00:09 - Table input.0 - ERROR (version 4.2.0-GA, build 15694 from 2011-08-24 11.46.44 by buildguy) : An error occurred executing SQL in part [openQuery : get rowinfo]:
      2011/09/01 16:00:09 - Table input.0 - ERROR (version 4.2.0-GA, build 15694 from 2011-08-24 11.46.44 by buildguy) : select * from test;
      2011/09/01 16:00:09 - Table input.0 - ERROR (version 4.2.0-GA, build 15694 from 2011-08-24 11.46.44 by buildguy) :
      2011/09/01 16:00:09 - Table input.0 - ERROR (version 4.2.0-GA, build 15694 from 2011-08-24 11.46.44 by buildguy) : Error getting row information from database:
      2011/09/01 16:00:09 - Table input.0 - ERROR (version 4.2.0-GA, build 15694 from 2011-08-24 11.46.44 by buildguy) : Streaming result set com.mysql.jdbc.RowDataDynamic@767a209 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.
      2011/09/01 16:00:09 - Table input.0 - ERROR (version 4.2.0-GA, build 15694 from 2011-08-24 11.46.44 by buildguy) :
      2011/09/01 16:00:09 - Table input.0 - ERROR (version 4.2.0-GA, build 15694 from 2011-08-24 11.46.44 by buildguy) :
      2011/09/01 16:00:09 - Table input.0 - ERROR (version 4.2.0-GA, build 15694 from 2011-08-24 11.46.44 by buildguy) : at org.pentaho.di.core.database.Database.openQuery(Database.java:1918)
      2011/09/01 16:00:09 - Table input.0 - ERROR (version 4.2.0-GA, build 15694 from 2011-08-24 11.46.44 by buildguy) : at org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:223)
      2011/09/01 16:00:09 - Table input.0 - ERROR (version 4.2.0-GA, build 15694 from 2011-08-24 11.46.44 by buildguy) : at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:133)
      2011/09/01 16:00:09 - Table input.0 - ERROR (version 4.2.0-GA, build 15694 from 2011-08-24 11.46.44 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
      2011/09/01 16:00:09 - Table input.0 - ERROR (version 4.2.0-GA, build 15694 from 2011-08-24 11.46.44 by buildguy) : at java.lang.Thread.run(Thread.java:662)
      2011/09/01 16:00:09 - Table input.0 - ERROR (version 4.2.0-GA, build 15694 from 2011-08-24 11.46.44 by buildguy) : Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
      2011/09/01 16:00:09 - Table input.0 - ERROR (version 4.2.0-GA, build 15694 from 2011-08-24 11.46.44 by buildguy) : Error getting row information from database:
      2011/09/01 16:00:09 - Table input.0 - ERROR (version 4.2.0-GA, build 15694 from 2011-08-24 11.46.44 by buildguy) : Streaming result set com.mysql.jdbc.RowDataDynamic@767a209 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.
      2011/09/01 16:00:09 - Table input.0 - ERROR (version 4.2.0-GA, build 15694 from 2011-08-24 11.46.44 by buildguy) :
      2011/09/01 16:00:09 - Table input.0 - ERROR (version 4.2.0-GA, build 15694 from 2011-08-24 11.46.44 by buildguy) : at org.pentaho.di.core.database.Database.getRowInfo(Database.java:2444)
      2011/09/01 16:00:09 - Table input.0 - ERROR (version 4.2.0-GA, build 15694 from 2011-08-24 11.46.44 by buildguy) : at org.pentaho.di.core.database.Database.openQuery(Database.java:1905)
      2011/09/01 16:00:09 - Table input.0 - ERROR (version 4.2.0-GA, build 15694 from 2011-08-24 11.46.44 by buildguy) : ... 4 more
      2011/09/01 16:00:09 - Table input.0 - ERROR (version 4.2.0-GA, build 15694 from 2011-08-24 11.46.44 by buildguy) : Caused by: java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@767a209 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.
      2011/09/01 16:00:09 - Table input.0 - ERROR (version 4.2.0-GA, build 15694 from 2011-08-24 11.46.44 by buildguy) : at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:934)
      2011/09/01 16:00:09 - Table input.0 - ERROR (version 4.2.0-GA, build 15694 from 2011-08-24 11.46.44 by buildguy) : at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
      2011/09/01 16:00:09 - Table input.0 - ERROR (version 4.2.0-GA, build 15694 from 2011-08-24 11.46.44 by buildguy) : at com.mysql.jdbc.MysqlIO.checkForOutstandingStreamingData(MysqlIO.java:2735)
      2011/09/01 16:00:09 - Table input.0 - ERROR (version 4.2.0-GA, build 15694 from 2011-08-24 11.46.44 by buildguy) : at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1899)
      2011/09/01 16:00:09 - Table input.0 - ERROR (version 4.2.0-GA, build 15694 from 2011-08-24 11.46.44 by buildguy) : at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
      2011/09/01 16:00:09 - Table input.0 - ERROR (version 4.2.0-GA, build 15694 from 2011-08-24 11.46.44 by buildguy) : at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2619)
      2011/09/01 16:00:09 - Table input.0 - ERROR (version 4.2.0-GA, build 15694 from 2011-08-24 11.46.44 by buildguy) : at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2569)
      2011/09/01 16:00:09 - Table input.0 - ERROR (version 4.2.0-GA, build 15694 from 2011-08-24 11.46.44 by buildguy) : at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1521)
      2011/09/01 16:00:09 - Table input.0 - ERROR (version 4.2.0-GA, build 15694 from 2011-08-24 11.46.44 by buildguy) : at com.mysql.jdbc.ConnectionImpl.getMaxBytesPerChar(ConnectionImpl.java:3003)
      2011/09/01 16:00:09 - Table input.0 - ERROR (version 4.2.0-GA, build 15694 from 2011-08-24 11.46.44 by buildguy) : at com.mysql.jdbc.Field.getMaxBytesPerCharacter(Field.java:602)
      2011/09/01 16:00:09 - Table input.0 - ERROR (version 4.2.0-GA, build 15694 from 2011-08-24 11.46.44 by buildguy) : at com.mysql.jdbc.ResultSetMetaData.getColumnDisplaySize(ResultSetMetaData.java:213)
      2011/09/01 16:00:09 - Table input.0 - ERROR (version 4.2.0-GA, build 15694 from 2011-08-24 11.46.44 by buildguy) : at org.pentaho.di.core.database.Database.getValueFromSQLType(Database.java:2627)
      2011/09/01 16:00:09 - Table input.0 - ERROR (version 4.2.0-GA, build 15694 from 2011-08-24 11.46.44 by buildguy) : at org.pentaho.di.core.database.Database.getRowInfo(Database.java:2437)
      2011/09/01 16:00:09 - Table input.0 - ERROR (version 4.2.0-GA, build 15694 from 2011-08-24 11.46.44 by buildguy) : ... 5 more

      The test table has two fields:

      mysql> describe test;
      -----------------------------------+

      Field Type Null Key Default Extra

      -----------------------------------+

      sField tinytext YES   NULL  
      bField longblob YES   NULL  

      -----------------------------------+
      2 rows in set (0.01 sec)

      mysql> select * from test;
      --------------+

      sField bField

      --------------+

      sValue bValue

      --------------+
      1 row in set (0.00 sec)

      If I change the query to only select the String field, I am successful, but if I want to include the longblob field, I get the error in PDI.

      Note: I am using mysq version 5.1.48 with driver 5.1.17 - I thought that I should be fine with a difference in point release

        Attachments

        1. validate.ktr
          12 kB
        2. validate.ktr
          12 kB

          Issue Links

            Activity

              People

              • Assignee:
                sflatley Sean Flatley (Inactive)
                Reporter:
                bhagan Brian Hagan (Inactive)
              • Votes:
                3 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: