Star

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

浙ICP备20010487号