Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
-
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.
MariaDB [(none)]> load data infile '/tmp/user.txt' into table quser fields terminated by "\t" enclosed by '"';
ERROR 1030 (HY000): Got error -1 "Internal error < 0 (Not system error)" from storage engine Columnstore
Looking at the logs I see:
{{2017-02-15 13:58:58 (3379) INFO : Number of rows with errors = 1. Row numbers with error reasons are listed in file /usr/local/mariadb/columnstore/bin/quser.tbl.Job_3626_3379.err
2017-02-15 13:58:58 (3379) INFO : Number of rows with errors = 1. Exact error rows are listed in file /usr/local/mariadb/columnstore/bin/quser.tbl.Job_3626_3379.bad
2017-02-15 13:58:58 (3379) ERR : Actual error row count(1) exceeds the max error rows(0) allowed for table quantum.quser [1451]
2017-02-15 13:58:58 (3379) CRIT : Bulkload Read (thread 0) Failed for Table quantum.quser. Terminating this job. [1451]
2017-02-15 13:58:58 (3379) INFO : Bulk load completed, total run time : 618.577 seconds
}}
However the files mentioned in the above error can not be found on the filesystem:
{{# ls /usr/local/mariadb/columnstore/bin/quser.tbl.Job_3626_3379.err
ls: cannot access '/usr/local/mariadb/columnstore/bin/quser.tbl.Job_3626_3379.err': No such file or directory
root@qfarm-dev2:/usr/local/mariadb/columnstore# ls /usr/local/mariadb/columnstore/bin/quser.tbl.Job_3626_3379.bad
ls: cannot access '/usr/local/mariadb/columnstore/bin/quser.tbl.Job_3626_3379.bad': No such file or directory}}
Attachments
Issue Links
- is part of
-
MCOL-4483 Consolidate Log Location
- Closed