Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Use Unique Connections checked in sub transformation for MySQL

  1. #1

    Default Use Unique Connections checked in sub transformation for MySQL

    Hi,

    Has anyone tried to set Use Unique Connections checked in sub transformation for MySQL? optionally also checking it for the parent transformation?

    So far I havent been able to get it to work - I have gotten different errors sometimes Lock wait time exceeded exceptions or simply hanging job or lingering connection threads in the database. Here is the latest exception

    2008/11/18 16:40:39 - Upsert MAP.0 - ERROR (version 3.1.0, build 826 from 2008/10/30 17:23:39) : Unexpected error :
    2008/11/18 16:40:39 - Upsert MAP.0 - ERROR (version 3.1.0, build 826 from 2008/10/30 17:23:39) : org.pentaho.di.core.exception.KettleStepException:
    2008/11/18 16:40:39 - Upsert MAP.0 - ERROR (version 3.1.0, build 826 from 2008/10/30 17:23:39) : Error in step, asking everyone to stop because of:
    2008/11/18 16:40:39 - Upsert MAP.0 - ERROR (version 3.1.0, build 826 from 2008/10/30 17:23:39) :
    2008/11/18 16:40:39 - Upsert MAP.0 - ERROR (version 3.1.0, build 826 from 2008/10/30 17:23:39) : Error looking up row in database
    2008/11/18 16:40:39 - Upsert MAP.0 - ERROR (version 3.1.0, build 826 from 2008/10/30 17:23:39) : Streaming result set com.mysql.jdbc.RowDataDynamic@16026a9 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.
    2008/11/18 16:40:39 - Upsert MAP.0 - ERROR (version 3.1.0, build 826 from 2008/10/30 17:23:39) :
    2008/11/18 16:40:39 - Upsert MAP.0 - ERROR (version 3.1.0, build 826 from 2008/10/30 17:23:39) :
    2008/11/18 16:40:39 - Upsert MAP.0 - ERROR (version 3.1.0, build 826 from 2008/10/30 17:23:39) : at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.processRow(InsertUpdate.java:291)
    2008/11/18 16:40:39 - Upsert MAP.0 - ERROR (version 3.1.0, build 826 from 2008/10/30 17:23:39) : at org.pentaho.di.trans.step.BaseStep.runStepThread(BaseStep.java:2664)
    2008/11/18 16:40:39 - Upsert MAP.0 - ERROR (version 3.1.0, build 826 from 2008/10/30 17:23:39) : at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.run(InsertUpdate.java:485)
    2008/11/18 16:40:39 - Upsert MAP.0 - ERROR (version 3.1.0, build 826 from 2008/10/30 17:23:39) : Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
    2008/11/18 16:40:39 - Upsert MAP.0 - ERROR (version 3.1.0, build 826 from 2008/10/30 17:23:39) : Error looking up row in database
    2008/11/18 16:40:39 - Upsert MAP.0 - ERROR (version 3.1.0, build 826 from 2008/10/30 17:23:39) : Streaming result set com.mysql.jdbc.RowDataDynamic@16026a9 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.
    2008/11/18 16:40:39 - Upsert MAP.0 - ERROR (version 3.1.0, build 826 from 2008/10/30 17:23:39) :
    2008/11/18 16:40:39 - Upsert MAP.0 - ERROR (version 3.1.0, build 826 from 2008/10/30 17:23:39) : at org.pentaho.di.core.database.Database.getLookup(Database.java:3184)
    2008/11/18 16:40:39 - Upsert MAP.0 - ERROR (version 3.1.0, build 826 from 2008/10/30 17:23:39) : at org.pentaho.di.core.database.Database.getLookup(Database.java:3157)
    2008/11/18 16:40:39 - Upsert MAP.0 - ERROR (version 3.1.0, build 826 from 2008/10/30 17:23:39) : at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.lookupValues(InsertUpdate.java:78)
    2008/11/18 16:40:39 - Upsert MAP.0 - ERROR (version 3.1.0, build 826 from 2008/10/3

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    A MySQL concurrency limitation I'm afraid.
    You need to uncheck the "Result streaming" checkbox in the Database dialog and hope you don't run out of memory.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.