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

Not able to import CSV file in multi server architecture.

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 1.0.9
    • Icebox
    • writeengine
    • None
    • 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

        1. columnstoreSupportReport.mycolumnstore1_20_6.tar.gz
          245 kB
          Prakash Padhiyar
        2. columnstoreSupportReport.mycs1.tar.gz
          186 kB
          Prakash Padhiyar
        3. Mariadb_Columnstore_Jira.docx
          67 kB
          Prakash Padhiyar
        4. mariadb.PNG
          62 kB
          Prakash Padhiyar

        Activity

          People

            Unassigned Unassigned
            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.