nebula2.0导入CSV数据失败

问答 问题
1
  • nebula 版本：2.0-beta
  • 部署方式（分布式 / 单机 / Docker / DBaaS）：单机
  • 出问题的 Space 的创建方式：执行 D:\>docker run --rm -ti --network=host -v /D/task/CSV_import_nebula/node/per.yaml:/D/task/CSV_import_nebula/node/per.yaml -v /D/task/CSV_import_nebula/node/per.csv:/D/task/CSV_import_nebula/node/per.csv vesoft/nebula-importer:v2 --config /D/task/CSV_import_nebula/node/per.yaml;
  • 问题的具体描述
    导入CSV数据出错
/task/CSV_import_nebula/node/per.yaml
2020/12/17 08:15:18 --- START OF NEBULA IMPORTER ---
2020/12/17 08:15:28 Client(0) fails to execute commands (UPDATE CONFIGS storage:wal_ttl=3600;
UPDATE CONFIGS storage:rocksdb_column_family_options = { disable_auto_compactions = true };
CREATE SPACE IF NOT EXISTS zwdb(partition_num=5, replica_factor=1);
USE zwdb;
CREATE TAG Per(PerID string, name string, verbose string, gender string, ethnic string, resume_src string, resume string, pic string);
), error: read tcp 192.168.65.3:42652->192.168.218.10:3699: i/o timeout
2

你是用什么导入的，go importer还是studio 啊

3

docker

4

创建space的时候要指定vid长度，像这样
`

CREATE SPACE my_space_4(vid_type = FIXED_STRING(30))

`

5

好的，我试一下

6

2.0必须指定VID长度吗，文档中也有的没指定
image

7

还是报这个错：

/task/CSV_import_nebula/node/per.yaml
2020/12/17 08:47:47 — START OF NEBULA IMPORTER —
2020/12/17 08:47:58 Client(0) fails to execute commands (UPDATE CONFIGS storage:wal_ttl=3600;
UPDATE CONFIGS storage:rocksdb_column_family_options = { disable_auto_compactions = true };
CREATE SPACE IF NOT EXISTS zwdb(partition_num=5, replica_factor=1, vid_type = FIXED_STRING(30));
USE zwdb;
CREATE TAG Per(PerID string, name string, verbose string, gender string, ethnic string, resume_src string, resume string, pic string);
), error: read tcp 192.168.65.3:53148->192.168.218.10:3699: i/o timeout
2020/12/17 08:47:59 — END OF NEBULA IMPORTER —

8

没有指定的话默认是8，vid超过8个字节时就会报错

9

长度指定为30，100, 500 还是报这个错

10

目前2.0只支持string类型的vid，而且csv是不能有header的，csv里面的数据只能用,分隔

11

什么时候会支持其他字符分割呢

12

我导入官方的course.csv还是报下面这个错：
D:>docker run --rm -ti --network=host -v /E/nebula-importer/examples/example1.yaml:/E/nebula-importer/examples/example1.yaml -v /E/nebula-importer/examples/v2/course.csv:/E/nebula-importer/examples/v2/course.csv vesoft/nebula-importer:v2 --config /E/nebula-importer/examples/example1.yaml
2020/12/17 09:27:58 — START OF NEBULA IMPORTER —
2020/12/17 09:28:08 Client(0) fails to execute commands (UPDATE CONFIGS storage:wal_ttl=3600;
UPDATE CONFIGS storage:rocksdb_column_family_options = { disable_auto_compactions = true };
DROP SPACE IF EXISTS importer_test;
CREATE SPACE IF NOT EXISTS importer_test(partition_num=5, replica_factor=1, vid_type=FIXED_STRING(10));
USE importer_test;
CREATE TAG course(name string, credits int);
CREATE TAG building(name string);
), error: read tcp 192.168.65.3:35258->192.168.218.10:3699: i/o timeout
2020/12/17 09:28:09 — END OF NEBULA IMPORTER —

13

试试这里的数据，记得把header删掉，FIXED_STRING(10)值设大点，比如100
14

还是导不进去：
D:>docker run --rm -ti --network=host -v /E/nebula-importer/examples/config1.yaml:/E/nebula-importer/examples/config1.yaml -v /E/nebula-importer/examples/v2/player.csv:/E/nebula-importer/examples/v2/player.csv vesoft/nebula-importer:v2 --config /E/nebula-importer/examples/config1.yaml
2020/12/17 09:41:45 — START OF NEBULA IMPORTER —
2020/12/17 09:41:46 — END OF NEBULA IMPORTER —

15

看一下nebula的log报什么错

16

哪里的日志呢

17

nebula服务logs目录下面

18

应该看哪个呢

image
image1344×241 76.6 KB

19

graph和storage的error日志都看一下

20

image
image1649×259 68 KB