[MCOL-571] CS provides incorrect path in logs to bad and err files when using load data infile Created: 2017-02-15 Updated: 2021-02-19 Resolved: 2021-02-19 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | cpimport |
| Affects Version/s: | None |
| Fix Version/s: | 5.5.2 |
| Type: | Bug | Priority: | Major |
| Reporter: | Justin Swanhart (Inactive) | Assignee: | Roman |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||
| Epic Link: | ColumnStore Compatibility Improvements | ||||||||
| Sprint: | 2021-1, 2021-2, 2021-3 | ||||||||
| Description |
|
I am trying to load a dump created by "mysqldump -T ..." and CS is throwing error -1 during the load process. I am using the LOAD DATA INFILE command, no using cpimport directly. Looking at the logs I see: However the files mentioned in the above error can not be found on the filesystem: root@qfarm-dev2:/usr/local/mariadb/columnstore# ls /usr/local/mariadb/columnstore/bin/quser.tbl.Job_3626_3379.bad |
| Comments |
| Comment by Justin Swanhart (Inactive) [ 2017-02-15 ] |
|
The files appear to be created in a different location and they have an _1 suffix: |
| Comment by David Thompson (Inactive) [ 2017-02-16 ] |
|
By default LDI is internally converted to a cpimport job and thus it uses the cpimport style file names and the files are created under the mysql/db directory. Also the LDI kb article (https://mariadb.com/kb/en/mariadb/columnstore-load-data-infile/) did not cover this so have added a section at the end to document where the bad and err files are written to. |
| Comment by Justin Swanhart (Inactive) [ 2017-02-16 ] |
|
my point is the log files point to files that don't exist. You read the log file, it says go look HERE for output and that output doesn't exist. This should be an open bug. |
| Comment by David Thompson (Inactive) [ 2017-02-17 ] |
|
Good point, agreed. |
| Comment by Ben Thompson (Inactive) [ 2021-01-26 ] |
|
While fixing |
| Comment by David Hall (Inactive) [ 2021-02-19 ] |
|
Fixed as part of |