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

Not able to import CSV file in multi server architecture.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Not a Bug
    • Affects Version/s: 1.0.9
    • Fix Version/s: Icebox
    • Component/s: writeengine
    • Labels:
      None
    • Environment:
      AWS EC2 Instances - Ubuntu 16.04 - 64 Bit

      Description

      Dear Support Team,

      We have configured mariadb columnstore with multi server architecture in AWS with below configuration and server status shows everything is in running/active mode.
      UM1 - 172.31.7.171 ( Ubuntu 16.04 64 Bit )
      PM1 - 172.31.0.155 ( Ubuntu 16.04 64 Bit )
      PM2 - 172.31.7.211 ( Ubuntu 16.04 64 Bit )
      DB Root : Mount AWS EFS with specific dbroot along with /etc/fstab entries.

      Below is the Error which we receive while import .CSV files using below command on UM1 :-
      LOAD DATA INFILE '/home/ubuntu/ferrero_mults/fgroup.csv' INTO TABLE fgroup FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\n';

      ++++++++++++++++++++++++++++++++++++++++++
      Jun 16 20:11:48 ip-172-31-7-171 writeenginesplit[7451]: 48.355327 |0|0|0| E 33 CAL0000: #033[0;31mReceived a Cpimport Failure from PM2#033[0m
      Jun 16 20:11:48 ip-172-31-7-171 writeenginesplit[7451]: 48.355411 |0|0|0| E 33 CAL0087: BulkLoad Error: #033[0;31mReceived a Cpimport Failure from PM2#033[0m
      Jun 16 20:13:14 ip-172-31-7-171 writeenginesplit[7515]: 14.580518 |0|0|0| E 33 CAL0000: #033[0;31mReceived a Cpimport Failure from PM1#033[0m
      Jun 16 20:13:14 ip-172-31-7-171 writeenginesplit[7515]: 14.580587 |0|0|0| E 33 CAL0087: BulkLoad Error: #033[0;31mReceived a Cpimport Failure from PM1#033[0m
      Jun 16 20:15:00 ip-172-31-7-171 writeenginesplit[7585]: 00.155368 |0|0|0| E 33 CAL0000: #033[0;31mReceived a Cpimport Failure from PM1#033[0m
      Jun 16 20:15:00 ip-172-31-7-171 writeenginesplit[7585]: 00.155471 |0|0|0| E 33 CAL0087: BulkLoad Error: #033[0;31mReceived a Cpimport Failure from PM1#033[0m
      +++++++++++++++++++++++++++++++++++++++++++++++

      Here i have also attached "columnstoreSupportReport" which is generated from UM1.
      Please help me to resolve this as i could find much more help to resolve this issue.

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            prakash Prakash Padhiyar
            Votes:
            0 Vote for this issue
            Watchers:
            6 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.