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

Not able to import csv file (LOAD DATA INFILE)

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Cannot Reproduce
    • 1.0.4
    • Icebox
    • MariaDB Server
    • None
    • Ubuntu 16.04.1 LTS (Linux db-imsm 4.4.0-45-generic #66-Ubuntu SMP Wed Oct 19 14:12:37 UTC 2016 x86_64 x86_64 x86_64 GNU/Linux)

    Description

      I tried to import a csv file into an existing table. But I get the following error:

      ERROR 1030 (HY000) at line 1: Got error -1 "Internal error < 0 (Not system error)" from storage engine Columnstore
      

      My err.log contains the following lines:

      Oct 30 11:29:15 db-imsm cpimport.bin[25783]: 15.690561 |0|0|0| E 34 CAL0087: BulkLoad Error: Actual error row count(1) exceeds the max error rows(0) allowed for table youtube.videos
      Oct 30 11:29:15 db-imsm cpimport.bin[25783]: 15.700120 |0|0|0| E 34 CAL0087: BulkLoad Error: Bulkload Read (thread 0) Failed for Table youtube.videos.  Terminating this job.
      Oct 30 11:29:15 db-imsm writeengineserver[29681]: 15.715875 |0|0|0| E 32 CAL0000: pushing data : PIPE error .........Broken pipe
      Oct 30 11:29:16 db-imsm writeengineserver[29681]: 16.698631 |0|0|0| E 32 CAL0000: 8418 : cpimport exit on failure (signal -1)
      Oct 30 11:29:16 db-imsm writeenginesplit[25740]: 16.699185 |0|0|0| E 33 CAL0000: #033[0;31mReceived a Cpimport Failure from PM1#033[0m
      Oct 30 11:29:16 db-imsm writeenginesplit[25740]: 16.699469 |0|0|0| E 33 CAL0087: BulkLoad Error: #033[0;31mReceived a Cpimport Failure from PM1#033[0m
      Oct 30 11:29:16 db-imsm writeenginesplit[25740]: 16.700762 |0|0|0| E 33 CAL0000: PM1 : Bulkload Read (thread 0) Failed for Table youtube.videos.  Terminating this job.
      Oct 30 11:29:16 db-imsm writeenginesplit[25740]: 16.700899 |0|0|0| E 33 CAL0087: BulkLoad Error: PM1 : Bulkload Read (thread 0) Failed for Table youtube.videos.  Terminating this job.
      Oct 30 11:29:40 db-imsm cpimport.bin[26010]: 40.493277 |0|0|0| E 34 CAL0087: BulkLoad Error: Actual error row count(1) exceeds the max error rows(0) allowed for table youtube.videos
      Oct 30 11:29:40 db-imsm cpimport.bin[26010]: 40.494443 |0|0|0| E 34 CAL0087: BulkLoad Error: Bulkload Read (thread 0) Failed for Table youtube.videos.  Terminating this job.
      Oct 30 11:29:40 db-imsm writeengineserver[29681]: 40.508467 |0|0|0| E 32 CAL0000: pushing data : PIPE error .........Broken pipe
      Oct 30 11:29:41 db-imsm writeengineserver[29681]: 41.756233 |0|0|0| E 32 CAL0000: 1839 : cpimport exit on failure (signal -1)
      Oct 30 11:29:41 db-imsm writeenginesplit[25967]: 41.756643 |0|0|0| E 33 CAL0000: #033[0;31mReceived a Cpimport Failure from PM1#033[0m
      Oct 30 11:29:41 db-imsm writeenginesplit[25967]: 41.756860 |0|0|0| E 33 CAL0087: BulkLoad Error: #033[0;31mReceived a Cpimport Failure from PM1#033[0m
      Oct 30 11:29:41 db-imsm writeenginesplit[25967]: 41.757576 |0|0|0| E 33 CAL0000: PM1 : Bulkload Read (thread 0) Failed for Table youtube.videos.  Terminating this job.
      Oct 30 11:29:41 db-imsm writeenginesplit[25967]: 41.757766 |0|0|0| E 33 CAL0087: BulkLoad Error: PM1 : Bulkload Read (thread 0) Failed for Table youtube.videos.  Terminating this job.
      

      And my info.log/debug.logs are flooded by messages like the following one (up to 5 per second):

      Oct 30 11:37:19 db-imsm messagequeue[28558]: 19.616034 |0|0|0| W 31 CAL0071: InetStreamSocket::read: timeout during readToMagic: socket read error: Success; InetStreamSocket: sd: 17 inet: 127.0.0.1 port: 40166; Will retry.
      

      Server version: 10.1.18-MariaDB Columnstore 1.0.4-1

      Attachments

        Issue Links

          Activity

            People

              dthompson David Thompson (Inactive)
              inkrement Christian Hotz-Behofsits
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.