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

cpimport picks up the wrong file

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 6.2.3
    • Fix Version/s: Icebox
    • Component/s: cpimport
    • Labels:
      None
    • Environment:
      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

            Assignee:
            Unassigned Unassigned
            Reporter:
            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.