[MCOL-4998] cpimport picks up the wrong file Created: 2022-02-23  Updated: 2022-03-29

Status: Open
Project: MariaDB ColumnStore
Component/s: cpimport
Affects Version/s: 6.2.3
Fix Version/s: Icebox

Type: Bug Priority: Minor
Reporter: Alasdair Haswell Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None
Environment:

CentOS 7.9.2009

Attachments: Text File debug.log    

 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.
Generated at Thu Feb 08 02:54:35 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.