GBASE南大通用技术分享：GBase 8a数据库加载常见问题原因浅析（一）

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

1、报Login denied uri
用例：
gbase> load data infile 'ftp://gbase:gbase123@172.16.128.11//home/gbase/*.tbl' into table test.tmp_lxj_1212_test data_format 3;
ERROR 1733 (HY000): (GBA-01EX-700) Gbase general error: Expanding wildcard operation failed with error - Login denied uri : ftp://gbase:********@172.16.128.11//home/gbase/*.tbl.
错误原因：gbase用户密码错误

2、报Couldn't connect to server
用例：
gbase> load data infile 'ftp://gbase:gbase@172.16.128.11//home/gbase/1.txt' into table test.tmp_lxj_1212_test data_format 3;
ERROR 1733 (HY000): (GBA-01EX-700) Gbase general error: I/O operation on ftp://gbase:*****@172.16.128.11//home/gbase/1.txt failed with error - Couldn't connect to server,

File name ftp://gbase:*****@172.16.128.11//home/gbase/1.txt
报错原因：ip地址错误或者vsftpd服务没有启动

3、报failed to get table distribution information.
用例：
gbase> load data infile 'ftp://gbase:gbase@172.16.128.11//home/gbase/1.txt' into table test.tmp_lxj_0621_test data_format 3;
ERROR 1733 (HY000): (GBA-01EX-700) Gbase general error: failed to get table distribution information.
报错原因：所涉及加载表不存在

4、报550 Could not get file size.
用例：
gbase> load data infile 'ftp://gbase:gbase@172.16.128.11//home/gbase/4.txt' into table test.tmp_lxj_1212_test data_format 3;
ERROR 1733 (HY000): (GBA-01EX-700) Gbase general error: I/O operation on ftp://gbase:*****@172.16.128.11//home/gbase/4.txt failed with error - 550 Could not get file size.,

File name ftp://gbase:*****@172.16.128.11//home/gbase/4.txt
错误原因：/home/gbase/4.txt 这个文件不存在

5、报Remote file not found uri
用例：
gbase> load data infile 'ftp://gbase:gbase@172.16.128.11//home/gbase/*.tbl' into table test.tmp_lxj_1212_test 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:*****@172.16.128.11//home/gbase/*.tbl.

错误原因：/home/gbase/*.tbl 没有匹配到文件，通配符文件不存在