XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 1.0.8
    • Icebox
    • writeengine
    • None
    • RHEL 6.6

    Description

      Hi, I had an error while using cpimport command. I configured separate modules with 2 PMs and 1 UM. The type of data storage is external. I executed cpimport command on PM #1(parent OAM). Load file(test_1) contains 10,000,000 rows data.

      Error messages are belows:

      [root@cm1 ~]# cpimport input_test mf2ae_log test_1
      2017-03-31 02:58:17 (11610) INFO : Running distributed import (mode 1) on all PMs...
      2017-03-31 02:59:07 (11610) ERR : Received a Cpimport Failure from PM1
      2017-03-31 02:59:07 (11610) INFO : Please verify error log files in PM1
      2017-03-31 02:59:07 (11610) INFO : Canceling outstanding cpimports
      2017-03-31 03:00:12 (11610) INFO : Table input_test.mf2ae_log: (OID-3000) was NOT successfully loaded.
      2017-03-31 03:00:12 (11610) INFO : Bulk load completed, total run time : 115.004 seconds

      Log messages(err.log, debug.log):

      [root@cm1 ~]# cat /var/log/mariadb/columnstore/err.log
      Mar 31 02:59:04 cm1 writeengineserver[3499]: 04.404181 |0|0|0| E 32 CAL0000: pushing data : PIPE error .........Broken pipe
      Mar 31 02:59:07 cm1 writeengineserver[3499]: 07.440615 |0|0|0| E 32 CAL0000: 1905 : cpimport exit on failure (signal 9)
      Mar 31 02:59:07 cm1 writeenginesplit[11610]: 07.440784 |0|0|0| E 33 CAL0000: #033[0;31mReceived a Cpimport Failure from PM1#033[0m
      Mar 31 02:59:07 cm1 writeenginesplit[11610]: 07.491808 |0|0|0| E 33 CAL0087: BulkLoad Error: #033[0;31mReceived a Cpimport Failure from PM1#033[0m

      /var/log/mariadb/columnstore/debug.log

      Mar 31 02:58:17 cm1 writeengineserver[3499]: 17.153209 |0|0|0| D 32 CAL0000: 1905 : onReceiveMode() Setting fMode = 1
      Mar 31 02:58:17 cm1 writeengineserver[3499]: 17.154965 |0|0|0| D 32 CAL0000: 1905 : onReceiveMode() DbRoot Count = 1
      Mar 31 02:58:17 cm1 writeengineserver[3499]: 17.155080 |0|0|0| D 32 CAL0000: 1905 : CMD LINE ARGS came in /usr/local/mariadb/columnstore/bin/cpimport.bin -R /tmp/columnstore_tmp_files/BrmRpt023102581711610.rpt -m 1 -P pm1-11610 -u6a3eae55-54ee-4b59-9114-512e37f363bf input_test mf2ae_log
      Mar 31 02:58:17 cm1 writeengineserver[3499]: 17.157575 |0|0|0| D 32 CAL0000: 1905 : Brm Rpt Filename Arrived /tmp/columnstore_tmp_files/BrmRpt023102581711610.rpt
      Mar 31 02:58:17 cm1 writeengineserver[3499]: 17.157896 |0|0|0| D 32 CAL0000: 1905 : Start Cpimport command reached!!
      Mar 31 02:59:07 cm1 writeengineserver[3499]: 07.324109 |0|0|0| D 32 CAL0000: 1905 : onReceiveEOD : child ID = 11644
      Mar 31 02:59:07 cm1 writeengineserver[3499]: 07.324183 |0|0|0| D 32 CAL0000: 1905 : Message Queue is empty; Stopping CF Thread
      Mar 31 02:59:07 cm1 writeengineserver[3499]: 07.465547 |0|0|0| D 32 CAL0000: 1905 : onCpimportFailure BrmReport Send
      Mar 31 02:59:07 cm1 writeengineserver[3499]: 07.465674 |0|0|0| D 32 CAL0000: 1905 : onReceiveEOD : child ID = 0
      Mar 31 02:59:07 cm1 writeengineserver[3499]: 07.465759 |0|0|0| D 32 CAL0000: 1905 : onReceiveEOD : child ID = 0
      Mar 31 03:00:09 cm1 writeengineserver[3499]: 09.655294 |0|0|0| D 32 CAL0000: 1905 : OnReceiveRollback arrived
      Mar 31 03:00:11 cm1 writeengineserver[3499]: 11.998767 |0|0|0| D 32 CAL0000: 1905 : OnReceiveCleanup arrived

      Could you let me know why this error occured?

      Attachments

        Activity

          People

            Unassigned Unassigned
            yang459 Seungmin Yang
            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.