G base 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.t 3 data_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.t t  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.t 4  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.t 2  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

错误原因：文件列数少于表的列数