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

cpimport picks up the wrong file

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 6.2.3
    • Icebox
    • cpimport
    • None
    • CentOS 7.9.2009

    Description

      When attempting to import a table from a file in /tmp using cpimport it appears to pick up an unrelated file on node 1 which is owned by root and fails:

      cpimport -m2 ssb supplier -l /tmp -f /tmp/supplier.tbl
      

      Relevant log entry from debug.log:

      Feb 23 16:19:58 [localhost] cpimport.bin[12457]: 58.929765 |0|0|0| E 34 CAL0087: BulkLoad Error: Error opening import file /tmp/yum_save_tx.2022-02-22.17-01.8g1THt.yumtx. Permission denied

      contents of /tmp:

      [root@mdblab2-columnstore-node tmp]# ls -lrt
      total 388436
      -rw-------. 1 root  root      31597 Feb 22 17:01 yum_save_tx.2022-02-22.17-01.8g1THt.yumtx
      drwx------. 3 root  root         16 Feb 22 18:19 systemd-private-4d4c081d8773432c8db1aa2f9bb48d5c-chronyd.service-Jbcsh9
      -rw-r--r--. 1 mysql mysql    110847 Feb 23 16:14 supplier.tbl
      -rw-r--r--. 1 mysql root  397604596 Feb 23 16:35 lineorder.tbl
      drwxrwxrwx. 5 mysql mysql      4096 Feb 23 16:42 columnstore_tmp_files

      The yum transaction file isn't present on the other two nodes and doesn't throw an error. When the file is moved out of tmp the import succeeds.

      Attachments

        Activity

          People

            Unassigned Unassigned
            Ali.maria Alasdair Haswell
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.