Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
6.2.3
-
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.