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

MonetDB Bulk Loader error with MonetDB Jan 2014-SP2 bugfix release

    Details

    • Type: Improvement
    • Status: Closed
    • Severity: High
    • Resolution: Fixed
    • Affects Version/s: 5.1.0 GA, 5.2.1.0, 5.3.0 GA
    • Fix Version/s: 5.4.0 GA
    • Component/s: Step
    • Labels:
    • Story Points:
      2
    • PDI Sub-component:
    • 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.
    • Sprint Team:
      Yoda
    • CI Build:
      #1211 23-may-2014 17:01:16
    • Sprint:
      Sprint 4 - 5.4 (Yoda) 2, Sprint 4 - 5.4 (Yoda) 3

      Description

      After upgrading MonetDB to version Jan 2014-SP2 bugfix release, my transformations stopped woking. With the error:
      An error occurred writing data to the MonetDB API (MAPI) process
      Connection to server lost!

      It seems that in the new version of MonetDB comes this change:
      http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d633b25eb73e

      To make it work again I had to adjust MonetDBBulkLoader.java commenting the second attempt to data.out.writeLine( "" ).

      // write an empty line, forces the flush of the stream
      data.out.writeLine( "" );

      // again...
      error = data.in.waitForPrompt();
      if ( error != null )

      { throw new KettleException( "Error loading data: " + error ); }

      // data.out.writeLine( "" );

      // and again, making sure we commit all the records
      // error = data.in.waitForPrompt();
      // if ( error != null )

      { // throw new KettleException( "Error loading data: " + error ); // }

      if ( log.isRowLevel() )

      { logRowlevel( Const.CR ); }

      Juan Carlos

      1. ReproduceTR.ktr
        19 kB
        Tatsiana Kasiankova

        Issue Links

          Activity

          Hide
          enricomariam42 Enrico Maria Carmona added a comment - - edited

          I have the same issue with MonetDB Jan2014-SP3.
          I can confirm the patch fix it (comment row # 505)
          Enrico

          Show
          enricomariam42 Enrico Maria Carmona added a comment - - edited I have the same issue with MonetDB Jan2014-SP3. I can confirm the patch fix it (comment row # 505) Enrico
          Hide
          nelsonsousa Nelson Sousa added a comment - - edited

          I too found the same issue while running a bulk loading step against a brand new installation of monetdb (Oct 2014 release).

          Upon applying the fix in the text of the comment, the step now works flawlessly.

          I can't test it against older MonetDB versions, though.

          EDIT: affected versions: 5.0 and 5.2.

          Show
          nelsonsousa Nelson Sousa added a comment - - edited I too found the same issue while running a bulk loading step against a brand new installation of monetdb (Oct 2014 release). Upon applying the fix in the text of the comment, the step now works flawlessly. I can't test it against older MonetDB versions, though. EDIT: affected versions: 5.0 and 5.2.
          Hide
          mattcarter Matt Carter added a comment -
          Show
          mattcarter Matt Carter added a comment - See pull request for fix https://github.com/pentaho/pentaho-kettle/pull/916
          Hide
          dnedev Dimitar Nedev added a comment - - edited

          Hey Matt, I am glad to see more people a looking to have this issue fixed. There is similar pull request, that proposes fixes for PDI-12278, in addition to PDI-12014 and PDI-10169.
          https://github.com/pentaho/pentaho-kettle/pull/841

          Show
          dnedev Dimitar Nedev added a comment - - edited Hey Matt, I am glad to see more people a looking to have this issue fixed. There is similar pull request, that proposes fixes for PDI-12278 , in addition to PDI-12014 and PDI-10169 . https://github.com/pentaho/pentaho-kettle/pull/841

            People

            • Assignee:
              gdavid Golda Thomas
              Reporter:
              j__c__ JC
            • Votes:
              5 Vote for this issue
              Watchers:
              19 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Agile