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

/tmp/columnstore_tmp_files can be owned by root when CS is clustered

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Fixed
    • 5.6.2
    • 23.02.1
    • cpimport
    • None

    Description

      I am getting this error:

      2021-09-14 08:27:28 (2763) INFO : Running distributed import (mode 1) on all PMs...
      writeenginesplit[2763]: 28.568250 |0|0|0| I 33 CAL0000: Send EOD message to All PMs
      writeenginesplit[2763]: 28.613584 |0|0|0| E 33 CAL0000: Received a Cpimport Failure from PM1
      2021-09-14 08:27:28 (2763) ERR  : Received a Cpimport Failure from PM1
      writeenginesplit[2763]: 28.613718 |0|0|0| E 33 CAL0087: BulkLoad Error: Received a Cpimport Failure from PM1
      2021-09-14 08:27:28 (2763) INFO : Please verify error log files in PM1
      2021-09-14 08:27:28 (2763) INFO : Canceling outstanding cpimports
      writeenginesplit[2763]: 28.813513 |0|0|0| I 33 CAL0098: Received a Cpimport Pass from PM2.
      writeenginesplit[2763]: 28.907437 |0|0|0| I 33 CAL0000: Released Table Lock
      2021-09-14 08:27:28 (2763) INFO : Table inventory.products: (OID-3000) was NOT successfully loaded.
      2021-09-14 08:27:28 (2763) INFO : Bulk load completed, total run time : 0.411774 seconds
      

      On the second node of my two node cluster, I see that the directory for temporary files is owned by root.

      root@cs2:~$ ls -ld /tmp/columnstore_tmp_files/
      drwxr-xr-x 3 root root 4096 Sep 14 08:18 /tmp/columnstore_tmp_files/
      

      This is a new install. The cpimport command was run once successfully. The nodes were rebooted, then this happened on a second attempt to run cpimport.

      Possible solution: chown mysql:mysql; chmod -R 777
      can be included in the programming of cpimport.

      Attachments

        Issue Links

          Activity

            People

              alan.mologorsky Alan Mologorsky
              edward Edward Stoever
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.