摘要：load data infile 'ftp://gbase:gbase@172.16.128.11//home/gbase/2.txt' into table test.tmp_lxj_1212_test data_format 3 max_bad_recor

南大通用GBase 8a数据库常见加载错误及原因：

6、报Access denied to remote resource

用例：

gbase> load data infile 'ftp://gbase:gbase@172.16.128.11/home/gbase/2.txt' into table test.tmp_lxj_1212_test data_format 3 max_bad_records 0; ERROR 1733 (HY000): (GBA-01EX-700) Gbase general error: I/O operation on ftp://gbase:*****@172.16.128.11/home/gbase/2.txt failed with error - Access denied to remote resource, File name ftp://gbase:*****@172.16.128.11/home/gbase/2.txt

错误原因：/home/gbase/2.txt路径错误

7、报Too many bad records

用例：

load data infile 'ftp://gbase:gbase@172.16.128.11//home/gbase/2.txt' into table test.tmp_lxj_1212_test data_format 3 max_bad_records 0; ERROR 1733 (HY000): (GBA-01EX-700) Gbase general error: Task 262162 failed, [172.16.128.12: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指定值

8、报read operation timeout

用例：

2016-12-15 14:52:47.253 [SQLDISP][ERROR][S:83876][Q:696407]:Query failed, THD(0x4b9f6000) HOST(10.17.6.52:5050->50885) reason: (GBA-01-600) Gbase internal error: I/O operation on ftp://doubass:*********@10.255.219.24//data3/asiainfo/interface/12300/data/s_12300_BAS_04002_20161214_011_00_016.dat failed with error - read operation timeout

错误原因：如果填充一个数据块（8M）的时间超过[gbase_loader_read_timeout]参数值，加载任务将报错停止

9、报Timeout was reached

用例：

2016-12-15 15:49:52.221 [SQLDISP][ERROR][S:191527][Q:1487078]: Query failed, THD(0x429ae000) HOST(10.17.6.95:5050->110938) reason: (GBA-01-600) Gbase internal error: Task 622072, I/O operation on ftp://doubass:*********@10.255.219.26//data6/asiainfo/interface/12900/data/a_12900_BAS_01002_20161214_00.verf failed with error - Timeout was reached

错误原因：ftp服务器端超时

10、报Unsupport local file for loader

用例：

gbase> load data infile '//home/gbase/1.txt' into table test.tmp_lxj_1212_test data_format 3; ERROR 1733 (HY000): (GBA-01EX-700) Gbase general error: Unsupport local file for loader

错误原因：不支持本地文件加载，即file_list参数部分必须填写ip地址和登录用户信息

11、报Line length is more than gbase_loader_max_line_lengt

用例:

gbase> load data infile 'ftp://gbase:gbase@172.16.128.11//home/gbase/024123_0' into table test.tmp_lxj_1220_test data_format 3; ERROR 1733 (HY000): (GBA-01EX-700) Gbase general error: Task 393223 failed, [172.16.128.12: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:*****@172.16.128.11//home/gbase/024123_0' 1024*1024

错误原因：行长度超过参数gbase_loader_max_line_length值。

来源：GBASE南大通用