[MCOL-4198] 10.5.4 bulk api not working - Connection failure: ECONNREFUSED Created: 2020-07-20  Updated: 2021-04-19  Resolved: 2020-09-12

Status: Closed
Project: MariaDB ColumnStore
Component/s: N/A
Affects Version/s: 1.0.0
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: David Hill (Inactive) Assignee: Unassigned
Resolution: Won't Do Votes: 0
Labels: None
Environment:

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/



 Comments   
Comment by Todd Stoffel (Inactive) [ 2020-09-12 ]

Not supported in 1.5. mcsapi is deprecated. Use cpimport or LDI.

Generated at Thu Feb 08 02:48:32 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.