Gbase 8a数据加载常见错误

Gbase 8a数据加载常见错误

1.Login denied uri
测试用例：gbase> load data infile 'ftp://gbase:gbase123@192.168.5.25//home/gbase/1.txt'  into table test.t1 data_format 3;
ERROR 1733 (HY000): (GBA-01EX-700) Gbase general error: Expanding wildcard operation failed with error - Login denied  : ftp://gbase:********@ 192.168.5.25//home/gbase/1.txt
错误原因：gbase用户密码错误
2.failed to get table distribution information
测试用例：
gbase> load data infile 'ftp://gbase:gbase@192.168.5.25//home/gbase/2.txt'  into table test.t2 data_format 3;
ERROR 1733 (HY000): (GBA-01EX-700) Gbase general error: failed to get table distribution information.
报错原因：所涉及加载表不存在
3.Could not get file size
测试用例：
gbase> load data infile 'ftp://gbase:gbase@192.168.5.25//home/gbase/3.txt'  into table test.t3data_format 3;
ERROR 1733 (HY000): (GBA-01EX-700) Gbase general error: I/O operation on ftp://gbase:*****@ 192.168.5.25//home/gbase/3.txt failed with error - 550 Could not get file size., File name ftp://gbase:*****@ 192.168.5.25//home/gbase/3.txt

错误原因：/home/gbase/4.txt 这个文件不存在
4.Remote file not found uri
测试用例：
gbase> load data infile 'ftp://gbase:gbase@192.168.5.25//home/gbase/*.tbl'  into table test.tt data_format 3;
ERROR 1733 (HY000): (GBA-01EX-700) Gbase general error: Expanding wildcard operation failed with error - Remote file not found uri : ftp://gbase:*****@ 192.168.5.25//home/gbase/%2a.tbl.

错误原因：/home/gbase/*.tbl 没有匹配到文件，通配符文件不存在
5.Too many bad records
测试用例：
load data infile 'ftp://gbase:gbase@192.168.5.25//home/gbase/2.txt'  
into table test.t4 data_format 3 max_bad_records 0;
ERROR 1733 (HY000): (GBA-01EX-700) Gbase general error: Task 262162 failed, [192.168.5.25:5050](GBA-02AD-0005)Failed to query in gnode:
DETAIL: (GBA-01-600) Gbase internal error: Task 262162, Too many bad records!

错误原因：错误数据行数超过max_bad_records指定值

6. Timeout was reached
错误原因：ftp服务器端超时
7. Line length is more than gbase_loader_max_line_length
测试用例:
gbase> load data infile 'ftp://gbase:gbase@192.168.5.25//home/gbase/len.txt'  into table test.length data_format 3;
ERROR 1733 (HY000): (GBA-01EX-700) Gbase general error: Task 393223 failed, [192.168.5.25:5050](GBA-02AD-0005)Failed to query in gnode:
DETAIL: (GBA-01-600) Gbase internal error: Line length 8388608 is more than gbase_loader_max_line_length ( 4194304 ) in file 'ftp://gbase:*****@ 192.168.5.25//home/gbase/len.txt'
错误原因：行长度超过参数gbase_loader_max_line_length值。
8. Access denied to remote resource
测试用例：
gbase> load data infile 'ftp://gbase:gbase@192.168.5.25/home/gbase/test/2.txt'  into table test.t2 data_format 3 max_bad_records 0;
ERROR 1733 (HY000): (GBA-01EX-700) Gbase general error: I/O operation on ftp://gbase:*****@ 192.168.5.25/home/gbase/test/2.txt failed with error - Access denied to remote resource, File name ftp://gbase:*****@ 192.168.5.25/home/gbase/2.txt

错误原因：/home/gbase/test/2.txt路径错误
9 .text parser error
错误原因：表列数与文件列数不一致，文件列数多于表列数
10. data column size less than defined size
错误原因：文件列数少于表的列数