Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-4198

10.5.4 bulk api not working - Connection failure: ECONNREFUSED

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Do
    • 1.0.0
    • N/A
    • N/A
    • None
    • MariaDB ColumnStore API to ColumnStore docker image

    Description

      Customer reported problem with Bulk load API not working in new and latest release.
      They are getting: | Exception com.mariadb.columnstore.api.ColumnStoreException: Connection failure: ECONNREFUSED

      There was discussion that in this Gamma release version that the APIs havent been fully tested, so this might be the issue. Or maybe they just don't have it fully configured correctly with the correct setup.

      Customer info:
      [root@f3d7dd436f06 /]# mariadb

      Welcome to the MariaDB monitor. Commands end with ; or \g.

      Your MariaDB connection id is 4

      Server version: 10.5.4-MariaDB MariaDB Server

      javamcsapi-1.2.2.jar

      I'm trying to use the MariaDB ColumnStore API to do bulk inserts. I have the docker ColumnStore image running and the Java API running on a separate Ubuntu docker container. I've followed the documentation to modify the Columnstore.xml with the correct IP of the container. When attempting to create a bulk insert I get the following:

      ```
      jshell> import com.mariadb.columnstore.api.*;
      jshell> ColumnStoreDriver d = new ColumnStoreDriver("Columnstore_new.xml");
      d ==> com.mariadb.columnstore.api.ColumnStoreDriver@5ce65a89
      jshell> ColumnStoreBulkInsert bulkInsert = d.createBulkInsert("mcs", "idbtest", (short)0, 0);

      Exception com.mariadb.columnstore.api.ColumnStoreException: Connection failure: ECONNREFUSED
      ```

      I am able to to open a MariaDB console from Ubuntu the columnstore server just fine. I believe I need to set the credentials somewhere, I just don't know where.

      https://github.com/mariadb-corporation/mariadb-columnstore-api
      https://mariadb.com/kb/en/columnstore-bulk-write-sdk/#environment-configuration
      https://hub.docker.com/r/mariadb/columnstore/

      Attachments

        Activity

          People

            Unassigned Unassigned
            hill David Hill (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.