Nebula Graph importer 导入csv数据部分失败

  • nebula 版本:2.0.0 GA

  • 部署方式(/ 单机 /):

  • 问题的具体描述
    使用nebula importer导入sf=0.1的ldbc数据,post.csv和comment.csv的部分数据会导入失败,提示"481036337278": (“photo481036337278.jpg”,“2011-03-22T07:46:18.490+0000”,“119.235.7.103”,“Firefox”,"","",0);, ErrMsg: SemanticError: Insert wrong value: `length’., ErrCode: -12
    但如果将length的类型在yaml中修改为string类型,则全部顺利导入,部分失败是否和数据类型int有关?

2021/04/15 21:29:27 [INFO] connection_pool.go:74: [nebula-clients] connection pool is initialized successfully
2021/04/15 21:29:27 [INFO] clientmgr.go:28: Create 1 Nebula Graph clients
2021/04/15 21:29:27 [INFO] reader.go:26: The delimiter of /home/ldbc_snb_datagen/social_network/static/place.csv is U+007C '|'
2021/04/15 21:29:27 [INFO] reader.go:64: Start to read file(1): /home/ldbc_snb_datagen/social_network/static/place.csv, schema: < :VID(string),place.name:string,place.url:string,place.type:string >
2021/04/15 21:29:27 [INFO] reader.go:26: The delimiter of /home/ldbc_snb_datagen/social_network/static/organisation.csv is U+007C '|'
2021/04/15 21:29:27 [INFO] reader.go:26: The delimiter of /home/ldbc_snb_datagen/social_network/dynamic/post.csv is U+007C '|'
2021/04/15 21:29:27 [INFO] reader.go:64: Start to read file(2): /home/ldbc_snb_datagen/social_network/static/organisation.csv, schema: < :VID(string),organization.type:string,organization.name:string,organization.url:string >
2021/04/15 21:29:27 [INFO] reader.go:64: Start to read file(3): /home/ldbc_snb_datagen/social_network/dynamic/post.csv, schema: < :VID(string),post.imageFile:string,post.creationDate:string,post.locationIP:string,post.browserUsed:string,post.language:string,post.content:string,post.length:int >
2021/04/15 21:29:27 [INFO] reader.go:26: The delimiter of /home/ldbc_snb_datagen/social_network/dynamic/comment.csv is U+007C '|'
2021/04/15 21:29:27 [INFO] reader.go:64: Start to read file(4): /home/ldbc_snb_datagen/social_network/dynamic/comment.csv, schema: < :VID(string),comment.creationDate:string,comment.locationIP:string,comment.browserUsed:string,comment.content:string,comment.length:int >
2021/04/15 21:29:27 [INFO] reader.go:26: The delimiter of /home/ldbc_snb_datagen/social_network/dynamic/forum.csv is U+007C '|'
2021/04/15 21:29:27 [INFO] reader.go:26: The delimiter of /home/ldbc_snb_datagen/social_network/dynamic/person_workAt_organisation.csv is U+007C '|'
2021/04/15 21:29:27 [INFO] reader.go:64: Start to read file(18): /home/ldbc_snb_datagen/social_network/dynamic/person_workAt_organisation.csv, schema: < :SRC_VID(string),:DST_VID(string),work_at.workFrom:string >
2021/04/15 21:29:27 [INFO] reader.go:26: The delimiter of /home/ldbc_snb_datagen/social_network/dynamic/comment_replyOf_comment.csv is U+007C '|'
2021/04/15 21:29:27 [INFO] reader.go:64: Start to read file(24): /home/ldbc_snb_datagen/social_network/dynamic/comment_replyOf_comment.csv, schema: < :SRC_VID(string),:DST_VID(string) >
2021/04/15 21:29:27 [INFO] reader.go:26: The delimiter of /home/ldbc_snb_datagen/social_network/static/tag.csv is U+007C '|'
2021/04/15 21:29:27 [INFO] reader.go:26: The delimiter of /home/ldbc_snb_datagen/social_network/dynamic/person.csv is U+007C '|'
2021/04/15 21:29:27 [INFO] reader.go:26: The delimiter of /home/ldbc_snb_datagen/social_network/dynamic/post_isLocatedIn_place.csv is U+007C '|'
2021/04/15 21:29:27 [INFO] reader.go:64: Start to read file(30): /home/ldbc_snb_datagen/social_network/dynamic/post_isLocatedIn_place.csv, schema: < :SRC_VID(string),:DST_VID(string) >
2021/04/15 21:29:27 [INFO] reader.go:26: The delimiter of /home/ldbc_snb_datagen/social_network/static/tagclass.csv is U+007C '|'
2021/04/15 21:29:27 [INFO] reader.go:26: The delimiter of /home/ldbc_snb_datagen/social_network/dynamic/person_likes_post.csv is U+007C '|'
2021/04/15 21:29:27 [INFO] reader.go:26: The delimiter of /home/ldbc_snb_datagen/social_network/dynamic/person_studyAt_organisation.csv is U+007C '|'
2021/04/15 21:29:27 [INFO] reader.go:64: Start to read file(5): /home/ldbc_snb_datagen/social_network/dynamic/forum.csv, schema: < :VID(string),forum.title:string,forum.creationDate:string >
2021/04/15 21:29:27 [INFO] reader.go:26: The delimiter of /home/ldbc_snb_datagen/social_network/dynamic/comment_replyOf_post.csv is U+007C '|'
2021/04/15 21:29:27 [INFO] reader.go:26: The delimiter of /home/ldbc_snb_datagen/social_network/dynamic/forum_hasModerator_person.csv is U+007C '|'
2021/04/15 21:29:27 [INFO] reader.go:64: Start to read file(27): /home/ldbc_snb_datagen/social_network/dynamic/forum_hasModerator_person.csv, schema: < :SRC_VID(string),:DST_VID(string) >
2021/04/15 21:29:27 [INFO] reader.go:26: The delimiter of /home/ldbc_snb_datagen/social_network/dynamic/person_likes_comment.csv is U+007C '|'
2021/04/15 21:29:27 [INFO] reader.go:64: Start to read file(22): /home/ldbc_snb_datagen/social_network/dynamic/person_likes_comment.csv, schema: < :SRC_VID(string),:DST_VID(string),likes_comment.creationDate:string >
2021/04/15 21:29:27 [INFO] reader.go:26: The delimiter of /home/ldbc_snb_datagen/social_network/dynamic/comment_hasTag_tag.csv is U+007C '|'
2021/04/15 21:29:27 [INFO] reader.go:64: Start to read file(21): /home/ldbc_snb_datagen/social_network/dynamic/person_likes_post.csv, schema: < :SRC_VID(string),:DST_VID(string),likes_post.creationDate:string >
2021/04/15 21:29:27 [INFO] reader.go:64: Start to read file(6): /home/ldbc_snb_datagen/social_network/static/tag.csv, schema: < :VID(string),hashtag.name:string,hashtag.url:string >
2021/04/15 21:29:27 [INFO] reader.go:26: The delimiter of /home/ldbc_snb_datagen/social_network/dynamic/post_hasCreator_person.csv is U+007C '|'
2021/04/15 21:29:27 [INFO] reader.go:64: Start to read file(19): /home/ldbc_snb_datagen/social_network/dynamic/post_hasCreator_person.csv, schema: < :SRC_VID(string),:DST_VID(string) >
2021/04/15 21:29:27 [INFO] reader.go:64: Start to read file(0): /home/ldbc_snb_datagen/social_network/dynamic/person.csv, schema: < :VID(string),person.firstName:string,person.lastName:string,person.gender:string,person.birthday:string,person.creationDate:string,person.locationIP:string,person.browserUsed:string >
2021/04/15 21:29:27 [INFO] reader.go:26: The delimiter of /home/ldbc_snb_datagen/social_network/static/place_isPartOf_place.csv is U+007C '|'
2021/04/15 21:29:27 [INFO] reader.go:26: The delimiter of /home/ldbc_snb_datagen/social_network/dynamic/comment_hasCreator_person.csv is U+007C '|'
2021/04/15 21:29:27 [INFO] reader.go:64: Start to read file(20): /home/ldbc_snb_datagen/social_network/dynamic/comment_hasCreator_person.csv, schema: < :SRC_VID(string),:DST_VID(string) >
2021/04/15 21:29:27 [INFO] reader.go:26: The delimiter of /home/ldbc_snb_datagen/social_network/dynamic/comment_isLocatedIn_place.csv is U+007C '|'
2021/04/15 21:29:27 [INFO] reader.go:64: Start to read file(11): /home/ldbc_snb_datagen/social_network/dynamic/comment_isLocatedIn_place.csv, schema: < :SRC_VID(string),:DST_VID(string) >
2021/04/15 21:29:27 [INFO] reader.go:64: Start to read file(9): /home/ldbc_snb_datagen/social_network/static/place_isPartOf_place.csv, schema: < :SRC_VID(string),:DST_VID(string) >
2021/04/15 21:29:27 [INFO] reader.go:26: The delimiter of /home/ldbc_snb_datagen/social_network/dynamic/person_knows_person.csv is U+007C '|'
2021/04/15 21:29:27 [INFO] reader.go:64: Start to read file(8): /home/ldbc_snb_datagen/social_network/dynamic/person_knows_person.csv, schema: < :SRC_VID(string),:DST_VID(string),knows.creationDate:string >
2021/04/15 21:29:27 [INFO] reader.go:26: The delimiter of /home/ldbc_snb_datagen/social_network/static/organisation_isLocatedIn_place.csv is U+007C '|'
2021/04/15 21:29:27 [INFO] reader.go:26: The delimiter of /home/ldbc_snb_datagen/social_network/dynamic/forum_hasMember_person.csv is U+007C '|'
2021/04/15 21:29:27 [INFO] reader.go:26: The delimiter of /home/ldbc_snb_datagen/social_network/dynamic/forum_containerOf_post.csv is U+007C '|'
2021/04/15 21:29:27 [INFO] reader.go:26: The delimiter of /home/ldbc_snb_datagen/social_network/dynamic/person_isLocatedIn_place.csv is U+007C '|'
2021/04/15 21:29:27 [INFO] reader.go:26: The delimiter of /home/ldbc_snb_datagen/social_network/dynamic/forum_hasTag_tag.csv is U+007C '|'
2021/04/15 21:29:27 [INFO] reader.go:64: Start to read file(13): /home/ldbc_snb_datagen/social_network/dynamic/forum_hasTag_tag.csv, schema: < :SRC_VID(string),:DST_VID(string) >
2021/04/15 21:29:27 [INFO] reader.go:26: The delimiter of /home/ldbc_snb_datagen/social_network/static/tag_hasType_tagclass.csv is U+007C '|'
2021/04/15 21:29:27 [INFO] reader.go:26: The delimiter of /home/ldbc_snb_datagen/social_network/static/tagclass_isSubclassOf_tagclass.csv is U+007C '|'
2021/04/15 21:29:27 [INFO] reader.go:26: The delimiter of /home/ldbc_snb_datagen/social_network/dynamic/person_hasInterest_tag.csv is U+007C '|'
2021/04/15 21:29:27 [INFO] reader.go:64: Start to read file(16): /home/ldbc_snb_datagen/social_network/dynamic/person_hasInterest_tag.csv, schema: < :SRC_VID(string),:DST_VID(string) >
2021/04/15 21:29:27 [INFO] reader.go:64: Start to read file(17): /home/ldbc_snb_datagen/social_network/dynamic/person_studyAt_organisation.csv, schema: < :SRC_VID(string),:DST_VID(string),study_at.classYear:string >
2021/04/15 21:29:27 [INFO] reader.go:26: The delimiter of /home/ldbc_snb_datagen/social_network/dynamic/post_hasTag_tag.csv is U+007C '|'
2021/04/15 21:29:27 [INFO] reader.go:64: Start to read file(15): /home/ldbc_snb_datagen/social_network/dynamic/post_hasTag_tag.csv, schema: < :SRC_VID(string),:DST_VID(string) >
2021/04/15 21:29:27 [INFO] reader.go:64: Start to read file(14): /home/ldbc_snb_datagen/social_network/dynamic/comment_hasTag_tag.csv, schema: < :SRC_VID(string),:DST_VID(string) >
2021/04/15 21:29:27 [INFO] reader.go:64: Start to read file(23): /home/ldbc_snb_datagen/social_network/dynamic/comment_replyOf_post.csv, schema: < :SRC_VID(string),:DST_VID(string) >
2021/04/15 21:29:27 [INFO] reader.go:64: Start to read file(25): /home/ldbc_snb_datagen/social_network/dynamic/forum_hasMember_person.csv, schema: < :SRC_VID(string),:DST_VID(string),has_member.joinDate:string >
2021/04/15 21:29:27 [INFO] reader.go:64: Start to read file(26): /home/ldbc_snb_datagen/social_network/dynamic/forum_containerOf_post.csv, schema: < :SRC_VID(string),:DST_VID(string) >
2021/04/15 21:29:27 [INFO] reader.go:64: Start to read file(10): /home/ldbc_snb_datagen/social_network/dynamic/person_isLocatedIn_place.csv, schema: < :SRC_VID(string),:DST_VID(string) >
2021/04/15 21:29:27 [INFO] reader.go:64: Start to read file(28): /home/ldbc_snb_datagen/social_network/static/tag_hasType_tagclass.csv, schema: < :SRC_VID(string),:DST_VID(string) >
2021/04/15 21:29:27 [INFO] reader.go:64: Start to read file(7): /home/ldbc_snb_datagen/social_network/static/tagclass.csv, schema: < :VID(string),tagclass.name:string,tagclass.url:string >
2021/04/15 21:29:27 [INFO] reader.go:64: Start to read file(12): /home/ldbc_snb_datagen/social_network/static/organisation_isLocatedIn_place.csv, schema: < :SRC_VID(string),:DST_VID(string) >
2021/04/15 21:29:27 [INFO] reader.go:64: Start to read file(29): /home/ldbc_snb_datagen/social_network/static/tagclass_isSubclassOf_tagclass.csv, schema: < :SRC_VID(string),:DST_VID(string) >
2021/04/15 21:29:27 [INFO] reader.go:180: Total lines of file(/home/ldbc_snb_datagen/social_network/static/tagclass_isSubclassOf_tagclass.csv) is: 71, error lines: 0
2021/04/15 21:29:37 [INFO] statsmgr.go:61: Tick: Time(10.00s), Finished(500), Failed(0), Latency AVG(3610us), Batches Req AVG(4151us), Rows AVG(50.00/s)
2021/04/15 21:29:38 [ERROR] handler.go:63: Client 0 fail to execute: INSERT VERTEX `comment`(`creationDate`,`locationIP`,`browserUsed`,`content`,`length`) VALUES  "id": ("creationDate","locationIP","browserUsed","content",length), "618475290625": ("2011-08-17T14:26:59.961+0000","46.16.217.105","Chrome","yes",3), "618475290626": ("2011-08-17T11:10:21.570+0000","46.16.217.105","Chrome","thanks",6), "1030792151045": ("2012-07-20T05:22:51.283+0000","46.31.114.181","Chrome","LOL",3), "1030792151046": ("2012-07-20T16:55:45.373+0000","46.31.114.181","Chrome","I see",5), "1030792151047": ("2012-07-20T04:34:17.500+0000","41.138.46.206","Firefox","fine",4), "1030792151048": ("2012-07-20T17:35:11.096+0000","46.16.217.105","Chrome","right",5), "1030792151049": ("2012-07-20T23:08:15.828+0000","41.138.46.206","Firefox","About George Frideric Handel, ful with hisAbout Erwin Rommel, mandy. As onAbout",79), "1030792151050": ("2012-07-20T06:31:37.850+0000","41.138.46.206","Firefox","good",4), "1030792151051": ("2012-07-21T03:07:22.319+0000","46.16.217.105","Chrome","no",2), "1030792151052": ("2012-07-21T01:39:21.227+0000","41.138.46.206","Firefox","About John Howard, died in combaAbout Isabella I of Castile, r right to thAbo",77), "1030792151053": ("2012-07-21T16:46:08.628+0000","46.16.217.105","Chrome","cool",4), "1030792151054": ("2012-07-21T04:06:57.356+0000","41.138.46.206","Firefox","About John Howard, uke of NorfoAbout Saint George,  Roman soldiAbout Isabella I of Castile",90), "1030792151055": ("2012-07-21T13:15:31.146+0000","46.31.114.181","Chrome","good",4), "1030792151056": ("2012-07-20T04:02:05.256+0000","41.138.46.206","Firefox","thx",3), "1030792151057": ("2012-07-20T04:51:23.927+0000","46.31.114.181","Chrome","About Rupert Murdoch, ausing bitter iAbout Jane Austen, s Austen, Jane'About Kurt Vonn",86), "1030792151058": ("2012-07-21T03:41:51.334+0000","212.39.114.248","Chrome","good",4), "1030792151059": ("2012-07-20T07:06:59.931+0000","46.31.114.181","Chrome","duh",3), "1030792151060": ("2012-07-21T07:59:14.322+0000","46.31.114.181","Chrome","About John Howard, attle of Bosworth About Jane Austen, personal and familAbout Eddie Mur",89), "1030792151061": ("2012-07-20T22:43:01.281+0000","46.16.217.105","Chrome","fine",4), "1030792151062": ("2012-07-20T04:50:50.052+0000","46.16.217.105","Chrome","About Rupert Murdoch, Rupert Murdoch, AC, KSG (bornAbout Yasser Arafat, hen he accepted UN Security CAbout Queen V",114), "1030792151063": ("2012-07-20T06:26:26.311+0000","46.16.217.105","Chrome","About Rupert Murdoch, he bought The TAbout Jimmy Carter, reated: the DepAbout Ernest Hemi",89), "412316860441": ("2011-01-05T09:50:24.448+0000","46.16.217.105","Chrome","no",2), "412316860442": ("2011-01-05T05:23:16.226+0000","46.16.217.105","Chrome","great",5), "412316860443": ("2011-01-05T05:31:02.006+0000","41.138.46.206","Firefox","About Freddie Mercury, aced at number 58 in the BBC's pAbout How to Save a Life,  The Fray. Released on SeptemberAbout To Be with You, ard rock band Mr. Big.",157), "412316860444": ("2011-01-05T06:45:02.057+0000","46.16.217.105","Chrome","About Pope Benedict XVI, hich he serveAbout Freddie Mercury,  for his flamAbout How to",86), "412316860445": ("2011-01-05T05:25:18.979+0000","46.16.217.105","Chrome","cool",4), "412316860446": ("2011-01-05T08:44:00.973+0000","46.16.217.105","Chrome","roflol",6), "412316860447": ("2011-01-05T14:20:30.418+0000","41.138.46.206","Firefox","cool",4), "206158430587": ("2010-08-10T21:51:48.327+0000","204.79.199.255","Internet Explorer","About Rogier Wassen, erlands, again with Jeff Coetzee. IAbout Sammy Davis, Jr.,  and in countless articles. After rAbout Traveling Wilburys Vol. 1, ilburys and was record",170), "206158430588": ("2010-08-11T00:06:39.382+0000","204.79.199.255","Internet Explorer","About Josip Broz Tito, the policy of nonalignmentAbout Michel Foucault, nces and the prison systemAbout Sammy Davis, Jr., vis",125), "206158430589": ("2010-08-11T00:07:13.252+0000","204.79.199.255","Internet Explorer","no",2), "206158430590": ("2010-08-11T03:32:08.233+0000","204.79.199.255","Internet Explorer","LOL",3), "206158430591": ("2010-08-11T05:58:07.303+0000","204.79.199.255","Internet Explorer","ok",2), "206158430592": ("2010-08-10T22:22:09.477+0000","204.79.199.255","Internet Explorer","thanks",6), "206158430593": ("2010-08-10T18:24:29.773+0000","204.79.199.255","Internet Explorer","About Josip Broz Tito, the Non-AligAbout Francis of Assisi,  July 16, 12About Rog",81), "206158430595": ("2010-08-31T04:18:00.022+0000","204.79.199.255","Internet Explorer","yes",3), "206158430596": ("2010-08-31T03:26:19.991+0000","204.79.199.255","Internet Explorer","About John Dryden,  to be known iAbout Fred Astaire,  (born FrederiAbout Katha",78), "206158430597": ("2010-08-31T07:14:10.218+0000","204.79.199.255","Internet Explorer","About Che Guevara, Guevara(1928-0About Haile Selassie I, ions in 1936, About Herb",81), "206158430598": ("2010-08-31T03:30:47.660+0000","204.79.199.255","Internet Explorer","LOL",3), "206158430599": ("2010-08-31T12:08:43.062+0000","204.79.199.255","Internet Explorer","good",4), "206158430600": ("2010-08-31T09:10:58.092+0000","204.79.199.255","Internet Explorer","yes",3), "206158430601": ("2010-09-01T01:14:13.592+0000","204.79.199.255","Internet Explorer","maybe",5), "206158430602": ("2010-09-01T02:15:09.423+0000","204.79.199.255","Internet Explorer","About Mark Twain, 35\u00a0– April 21, About Katharine Hepburn, rican Film InstAbout Empir",84), "206158430603": ("2010-09-01T04:58:10.753+0000","204.79.199.255","Internet Explorer","About Che Guevara, s for class sAbout Haile Selassie I, ty that traceAbout Arantxa Sánche",89), "206158430604": ("2010-09-01T06:34:52.925+0000","204.79.199.255","Internet Explorer","About Che Guevara, convicted as warAbout Juan Carlos I of Spain, ay 1962. The couAbout Arantxa Sánchez Vicario, u 'Arantxa",122), "206158430605": ("2010-09-01T02:15:19.616+0000","204.79.199.255","Internet Explorer","ok",2), "206158430606": ("2010-08-31T03:47:46.902+0000","204.79.199.255","Internet Explorer","About Haile Selassie I, vement whose fAbout Oprah Winfrey, ent. OWN is a About Fr",81), "206158430607": ("2010-09-01T06:07:07.613+0000","204.79.199.255","Internet Explorer","roflol",6), "206158430608": ("2010-08-31T08:50:47.195+0000","204.79.199.255","Internet Explorer","About The Wall, hness became so acuAbout England, h west, the Celtic About ",75), "206158430609": ("2010-08-31T06:41:08.603+0000","204.79.199.255","Internet Explorer","cool",4), "206158430611": ("2010-08-30T11:20:01.747+0000","91.201.140.249","Internet Explorer","About Haile Selassie I, ews led About Nicolas Sarkozy, last govAbout Alexandre Dumas,",85), "206158430612": ("2010-08-31T00:05:57.127+0000","204.79.199.255","Internet Explorer","LOL",3), "206158430613": ("2010-08-30T05:35:08.602+0000","204.79.199.255","Internet Explorer","About Diana, Princess of Wales, ies. She remAbout Clint Eastwood, on d'honneurAbout Alice ",90), "206158430614": ("2010-08-30T06:40:09.827+0000","204.79.199.255","Internet Explorer","good",4), "206158430615": ("2010-08-30T13:10:18.583+0000","204.79.199.255","Internet Explorer","I see",5), "206158430616": ("2010-08-30T04:16:52.919+0000","204.79.199.255","Internet Explorer","About Haile Selassie I, sperity. HaAbout Otto von Bismarck,  its affairAbout Thailand, ",87), "206158430617": ("2010-08-30T02:08:18.115+0000","204.79.199.255","Internet Explorer","About Haile Selassie I, elassie iAbout William McKinley, gn in whiAbout The Wall",80), "206158430618": ("2010-08-30T14:23:04.999+0000","204.79.199.255","Internet Explorer","About Nicolas Sarkozy, embersAbout Alexandre Dumas, iter aAbout Amitabh Bachcha",79), "206158430619": ("2010-08-30T14:23:18.230+0000","204.79.199.255","Internet Explorer","good",4), "206158430620": ("2010-08-30T08:22:05.778+0000","204.79.199.255","Internet Explorer","great",5), "206158430621": ("2010-08-30T07:24:59.900+0000","204.79.199.255","Internet Explorer","no way!",7), "206158430622": ("2010-08-30T07:02:02.501+0000","204.79.199.255","Internet Explorer","cool",4), "206158430623": ("2010-08-30T21:00:53.801+0000","204.79.199.255","Internet Explorer","About Alexandre Dumas, ) was aAbout William Morris, as devoAbout John A. Macdonald",82), "206158430624": ("2010-08-30T08:24:08.701+0000","204.79.199.255","Internet Explorer","great",5), "206158430626": ("2010-08-29T22:57:02.429+0000","204.79.199.255","Internet Explorer","About Haile Selassie I, te, among the About The Sickness, udes much moreAbout I S",81), "206158430627": ("2010-08-30T00:42:09.079+0000","204.79.199.255","Internet Explorer","thx",3), "206158430628": ("2010-08-29T23:27:23.473+0000","204.79.199.255","Internet Explorer","About Mustafa Kemal Atatürk, e referred to as About Jack Kirby, t of the DC Comic",81), "206158430629": ("2010-08-30T06:39:57.467+0000","204.79.199.255","Internet Explorer","thanks",6), "206158430630": ("2010-08-30T13:34:31.421+0000","204.79.199.255","Internet Explorer","thx",3), "206158430631": ("2010-08-30T02:09:28.094+0000","204.79.199.255","Internet Explorer","About I Should Be So Lucky, itive to mixed rAbout Peru, and the capital About T",79), "206158430632": ("2010-08-30T21:01:15.401+0000","204.79.199.255","Internet Explorer","right",5), "206158430633": ("2010-08-29T21:54:12.375+0000","204.79.199.255","Internet Explorer","thanks",6), "687194767787": ("2011-10-22T18:55:30.602+0000","91.191.192.127","Firefox","right",5), "687194767788": ("2011-10-23T14:24:38.086+0000","61.17.197.42","Safari","yes",3), "687194767789": ("2011-10-22T21:19:22.911+0000","91.191.192.127","Firefox","no",2), "687194767790": ("2011-10-23T13:22:59.115+0000","61.17.197.42","Safari","About Charlemagne, pean Middle Ages. He is nuAbout Joe Strummer, ion of new music, and eachAbout Niandra Lades and Usually Just a T-Shirt, d synthesizers on a four-tAbout France, ph",181), "687194767791": ("2011-10-22T22:50:48.364+0000","61.17.197.42","Safari","maybe",5), "687194767792": ("2011-10-23T21:25:16.024+0000","91.191.192.127","Firefox","thanks",6), "687194767793": ("2011-10-23T14:42:55.439+0000","61.17.197.42","Safari","I see",5), "687194767794": ("2011-10-24T00:31:24.307+0000","91.191.192.127","Firefox","ok",2), "687194767795": ("2011-10-23T04:03:38.924+0000","61.17.197.42","Safari","About Vladimir Putin, ion of Russia aAbout Joe Strummer, ance, Strummer'About Democr",84), "687194767796": ("2011-10-23T06:41:33.717+0000","91.191.192.127","Firefox","About Two Steps from the Move,  a car accident on DecAbout Getback,  from Little Brothe",87), "687194767797": ("2011-10-23T19:49:24.021+0000","91.191.192.127","Firefox","LOL",3), "687194767798": ("2011-10-23T06:56:00.404+0000","61.17.197.42","Safari","thx",3), "343597384120": ("2010-11-04T02:59:09.708+0000","41.153.161.111","Internet Explorer","About J. R. R. Tolkien, h within it. Between 1951 and 1955, Tolkien aAbout James Stewart",88), "343597384121": ("2010-11-04T11:15:48.726+0000","196.32.227.177","Chrome","About J. R. R. Tolkien,  the great success of The About James Stewart,  in th",77), "206158430651": ("2010-09-01T14:03:35.082+0000","41.153.161.111","Internet Explorer","no way!",7), "206158430652": ("2010-09-01T21:50:19.192+0000","196.32.227.177","Chrome","no way!",7), "206158430653": ("2010-09-01T16:24:07.944+0000","196.32.227.177","Chrome","About J. R. R. Tolkien, cess of The Hobbit and The Lord of the Rings lAbout Music from Van",90), "206158430654": ("2010-09-01T19:09:45.443+0000","196.32.227.177","Chrome","ok",2), "206158430655": ("2010-09-01T23:59:21.704+0000","186.169.83.109","Firefox","About J. R. R. Tolkien, the 5th top-earning dead celebrity in 2009. Nominated for a Nobel Prize in Literature byAbout Thailand, e Vietnam in the Gulf of Thailand to the south",174), "206158430656": ("2010-09-02T02:04:39.306+0000","41.153.161.111","Internet Explorer","fine",4), "206158430657": ("2010-09-01T16:26:17.677+0000","196.32.227.177","Chrome","maybe",5), "206158430658": ("2010-09-01T13:49:27.156+0000","186.169.83.109","Firefox","About Dean Martin, film actor, television star and comedian. Martin's hit singles",81), "206158430659": ("2010-09-02T13:40:13.508+0000","186.169.83.109","Firefox","no",2), "206158430660": ("2010-09-01T16:35:28.630+0000","186.169.83.109","Firefox","great",5), "206158430661": ("2010-09-01T20:54:29.807+0000","196.32.227.177","Chrome","About J. R. R. Tolkien, lished a series of works based on his fathAbout Universal ",82), "206158430662": ("2010-09-02T05:41:57.843+0000","196.32.227.177","Chrome","LOL",3), "206158430663": ("2010-09-02T07:05:33.340+0000","196.32.227.177","Chrome","ok",2);, ErrMsg: SemanticError: Insert wrong value: `length'., ErrCode: -12
2021/04/15 21:29:41 [ERROR] handler.go:63: Client 0 fail to execute: INSERT VERTEX `post`(`imageFile`,`creationDate`,`locationIP`,`browserUsed`,`language`,`content`,`length`) VALUES  "id": ("imageFile","creationDate","locationIP","browserUsed","language","content",length), "618475290624": ("","2011-08-17T06:05:40.595+0000","49.246.218.237","Firefox","uz","About Rupert Murdoch, t newer electronic publishing technoAbout George Frideric Handel,  concertos. Handel was born in 1685,About Kurt Vonne",140), "3": ("","2010-02-14T20:30:21.451+0000","119.235.7.103","Firefox","uz","About Rupert Murdoch, alised US citizen iAbout Napoleon, tinuation of the waAbout Ferdinand II of Aragon, (1",108), "1030792151044": ("","2012-07-20T03:48:53.147+0000","119.235.7.103","Firefox","uz","About Rupert Murdoch, 50s and '60s, he acquAbout George Frideric Handel, man-British Baroque cAbout Jane Austen, estimate o",123), "412316860440": ("","2011-01-05T05:21:15.452+0000","119.235.7.103","Firefox","uz","About Freddie Mercury, s the lead vocalist and lyricist of the rock band Queen. As a perfoAbout To Be with You,  songwriter working for the label at the time (though exactly what About Round Here,  th",200), "481036337184": ("photo481036337184.jpg","2011-04-07T21:06:36.051+0000","119.235.7.103","Firefox","","",0), "481036337185": ("photo481036337185.jpg","2011-04-07T21:06:37.051+0000","119.235.7.103","Firefox","","",0), "481036337186": ("photo481036337186.jpg","2011-04-07T21:06:38.051+0000","119.235.7.103","Firefox","","",0), "481036337187": ("photo481036337187.jpg","2011-04-07T21:06:39.051+0000","119.235.7.103","Firefox","","",0), "481036337188": ("photo481036337188.jpg","2011-04-07T21:06:40.051+0000","119.235.7.103","Firefox","","",0), "481036337189": ("photo481036337189.jpg","2011-04-07T21:06:41.051+0000","119.235.7.103","Firefox","","",0), "481036337190": ("photo481036337190.jpg","2011-04-07T21:06:42.051+0000","119.235.7.103","Firefox","","",0), "481036337191": ("photo481036337191.jpg","2011-04-07T21:06:43.051+0000","119.235.7.103","Firefox","","",0), "481036337192": ("photo481036337192.jpg","2011-04-07T21:06:44.051+0000","119.235.7.103","Firefox","","",0), "481036337193": ("photo481036337193.jpg","2011-04-07T21:06:45.051+0000","119.235.7.103","Firefox","","",0), "481036337194": ("photo481036337194.jpg","2011-04-07T21:06:46.051+0000","119.235.7.103","Firefox","","",0), "481036337195": ("photo481036337195.jpg","2011-04-07T21:06:47.051+0000","119.235.7.103","Firefox","","",0), "481036337196": ("photo481036337196.jpg","2011-04-07T21:06:48.051+0000","119.235.7.103","Firefox","","",0), "481036337197": ("photo481036337197.jpg","2011-04-07T21:06:49.051+0000","119.235.7.103","Firefox","","",0), "481036337198": ("photo481036337198.jpg","2011-04-07T21:06:50.051+0000","119.235.7.103","Firefox","","",0), "481036337199": ("photo481036337199.jpg","2011-04-07T21:06:51.051+0000","119.235.7.103","Firefox","","",0), "481036337200": ("photo481036337200.jpg","2011-04-07T21:06:52.051+0000","119.235.7.103","Firefox","","",0), "481036337201": ("photo481036337201.jpg","2011-04-07T21:06:53.051+0000","119.235.7.103","Firefox","","",0), "481036337202": ("photo481036337202.jpg","2011-04-07T21:06:54.051+0000","119.235.7.103","Firefox","","",0), "755914244147": ("photo755914244147.jpg","2011-12-16T17:48:11.090+0000","119.235.7.103","Firefox","","",0), "755914244148": ("photo755914244148.jpg","2011-12-16T17:48:12.090+0000","119.235.7.103","Firefox","","",0), "755914244149": ("photo755914244149.jpg","2011-12-16T17:48:13.090+0000","119.235.7.103","Firefox","","",0), "755914244150": ("photo755914244150.jpg","2011-12-16T17:48:14.090+0000","119.235.7.103","Firefox","","",0), "755914244151": ("photo755914244151.jpg","2011-12-16T17:48:15.090+0000","119.235.7.103","Firefox","","",0), "755914244152": ("photo755914244152.jpg","2011-12-16T17:48:16.090+0000","119.235.7.103","Firefox","","",0), "755914244153": ("photo755914244153.jpg","2011-12-16T17:48:17.090+0000","119.235.7.103","Firefox","","",0), "755914244154": ("photo755914244154.jpg","2011-12-16T17:48:18.090+0000","119.235.7.103","Firefox","","",0), "755914244155": ("photo755914244155.jpg","2011-12-16T17:48:19.090+0000","119.235.7.103","Firefox","","",0), "755914244156": ("photo755914244156.jpg","2011-12-16T17:48:20.090+0000","119.235.7.103","Firefox","","",0), "755914244157": ("photo755914244157.jpg","2011-12-16T17:48:21.090+0000","119.235.7.103","Firefox","","",0), "755914244158": ("photo755914244158.jpg","2011-12-16T17:48:22.090+0000","119.235.7.103","Firefox","","",0), "755914244159": ("photo755914244159.jpg","2011-12-16T17:48:23.090+0000","119.235.7.103","Firefox","","",0), "755914244160": ("photo755914244160.jpg","2011-12-16T17:48:24.090+0000","119.235.7.103","Firefox","","",0), "755914244161": ("photo755914244161.jpg","2011-12-16T17:48:25.090+0000","119.235.7.103","Firefox","","",0), "755914244162": ("photo755914244162.jpg","2011-12-16T17:48:26.090+0000","119.235.7.103","Firefox","","",0), "1030792151107": ("photo1030792151107.jpg","2012-08-05T07:40:28.150+0000","119.235.7.103","Firefox","","",0), "1030792151108": ("photo1030792151108.jpg","2012-08-05T07:40:29.150+0000","119.235.7.103","Firefox","","",0), "1030792151109": ("photo1030792151109.jpg","2012-08-05T07:40:30.150+0000","119.235.7.103","Firefox","","",0), "1030792151110": ("photo1030792151110.jpg","2012-08-05T07:40:31.150+0000","119.235.7.103","Firefox","","",0), "1030792151111": ("photo1030792151111.jpg","2012-08-05T07:40:32.150+0000","119.235.7.103","Firefox","","",0), "1030792151112": ("photo1030792151112.jpg","2012-08-05T07:40:33.150+0000","119.235.7.103","Firefox","","",0), "1030792151113": ("photo1030792151113.jpg","2012-08-05T07:40:34.150+0000","119.235.7.103","Firefox","","",0), "893353197642": ("photo893353197642.jpg","2012-04-25T13:09:48.868+0000","119.235.7.103","Firefox","","",0), "618475290699": ("photo618475290699.jpg","2011-07-17T19:11:41.380+0000","119.235.7.103","Firefox","","",0), "618475290700": ("photo618475290700.jpg","2011-07-17T19:11:42.380+0000","119.235.7.103","Firefox","","",0), "1030792151117": ("photo1030792151117.jpg","2012-08-31T08:11:03.875+0000","119.235.7.103","Firefox","","",0), "1030792151118": ("photo1030792151118.jpg","2012-08-31T08:11:04.875+0000","119.235.7.103","Firefox","","",0), "1030792151119": ("photo1030792151119.jpg","2012-08-31T08:11:05.875+0000","119.235.7.103","Firefox","","",0), "1030792151120": ("photo1030792151120.jpg","2012-08-31T08:11:06.875+0000","119.235.7.103","Firefox","","",0), "1030792151121": ("photo1030792151121.jpg","2012-08-31T08:11:07.875+0000","119.235.7.103","Firefox","","",0), "1030792151122": ("photo1030792151122.jpg","2012-08-31T08:11:08.875+0000","119.235.7.103","Firefox","","",0), "1030792151123": ("photo1030792151123.jpg","2012-08-31T08:11:09.875+0000","119.235.7.103","Firefox","","",0), "1030792151124": ("photo1030792151124.jpg","2012-08-31T08:11:10.875+0000","119.235.7.103","Firefox","","",0), "1030792151125": ("photo1030792151125.jpg","2012-08-31T08:11:11.875+0000","119.235.7.103","Firefox","","",0), "1030792151126": ("photo1030792151126.jpg","2012-08-31T08:11:12.875+0000","119.235.7.103","Firefox","","",0), "1030792151127": ("photo1030792151127.jpg","2012-08-31T08:11:13.875+0000","119.235.7.103","Firefox","","",0), "1030792151128": ("photo1030792151128.jpg","2012-08-31T08:11:14.875+0000","119.235.7.103","Firefox","","",0), "1030792151129": ("photo1030792151129.jpg","2012-08-31T08:11:15.875+0000","119.235.7.103","Firefox","","",0), "1030792151130": ("photo1030792151130.jpg","2012-08-31T08:11:16.875+0000","119.235.7.103","Firefox","","",0), "1030792151131": ("photo1030792151131.jpg","2012-08-31T08:11:17.875+0000","119.235.7.103","Firefox","","",0), "1030792151132": ("photo1030792151132.jpg","2012-08-31T08:11:18.875+0000","119.235.7.103","Firefox","","",0), "1099511627869": ("photo1099511627869.jpg","2012-09-09T20:23:01.268+0000","119.235.7.103","Firefox","","",0), "1099511627870": ("photo1099511627870.jpg","2012-09-09T20:23:02.268+0000","119.235.7.103","Firefox","","",0), "1099511627871": ("photo1099511627871.jpg","2012-09-09T20:23:03.268+0000","119.235.7.103","Firefox","","",0), "1099511627872": ("photo1099511627872.jpg","2012-09-09T20:23:04.268+0000","119.235.7.103","Firefox","","",0), "1099511627873": ("photo1099511627873.jpg","2012-09-09T20:23:05.268+0000","119.235.7.103","Firefox","","",0), "1099511627874": ("photo1099511627874.jpg","2012-09-09T20:23:06.268+0000","119.235.7.103","Firefox","","",0), "1099511627875": ("photo1099511627875.jpg","2012-09-09T20:23:07.268+0000","119.235.7.103","Firefox","","",0), "1099511627876": ("photo1099511627876.jpg","2012-09-09T20:23:08.268+0000","119.235.7.103","Firefox","","",0), "1099511627877": ("photo1099511627877.jpg","2012-09-09T20:23:09.268+0000","119.235.7.103","Firefox","","",0), "1099511627878": ("photo1099511627878.jpg","2012-09-09T20:23:10.268+0000","119.235.7.103","Firefox","","",0), "1099511627879": ("photo1099511627879.jpg","2012-09-09T20:23:11.268+0000","119.235.7.103","Firefox","","",0), "1099511627880": ("photo1099511627880.jpg","2012-09-09T20:23:12.268+0000","119.235.7.103","Firefox","","",0), "1099511627881": ("photo1099511627881.jpg","2012-09-09T20:23:13.268+0000","119.235.7.103","Firefox","","",0), "1099511627882": ("photo1099511627882.jpg","2012-09-09T20:23:14.268+0000","119.235.7.103","Firefox","","",0), "1099511627883": ("photo1099511627883.jpg","2012-09-09T20:23:15.268+0000","119.235.7.103","Firefox","","",0), "1099511627884": ("photo1099511627884.jpg","2012-09-09T20:23:16.268+0000","119.235.7.103","Firefox","","",0), "1099511627885": ("photo1099511627885.jpg","2012-09-09T20:23:17.268+0000","119.235.7.103","Firefox","","",0), "1099511627886": ("photo1099511627886.jpg","2012-09-09T20:23:18.268+0000","119.235.7.103","Firefox","","",0), "1099511627887": ("photo1099511627887.jpg","2012-09-09T20:23:19.268+0000","119.235.7.103","Firefox","","",0), "1099511627888": ("photo1099511627888.jpg","2012-09-09T20:23:20.268+0000","119.235.7.103","Firefox","","",0), "618475290737": ("photo618475290737.jpg","2011-08-16T05:51:49.460+0000","119.235.7.103","Firefox","","",0), "481036337266": ("photo481036337266.jpg","2011-03-22T07:46:06.490+0000","119.235.7.103","Firefox","","",0), "481036337267": ("photo481036337267.jpg","2011-03-22T07:46:07.490+0000","119.235.7.103","Firefox","","",0), "481036337268": ("photo481036337268.jpg","2011-03-22T07:46:08.490+0000","119.235.7.103","Firefox","","",0), "481036337269": ("photo481036337269.jpg","2011-03-22T07:46:09.490+0000","119.235.7.103","Firefox","","",0), "481036337270": ("photo481036337270.jpg","2011-03-22T07:46:10.490+0000","119.235.7.103","Firefox","","",0), "481036337271": ("photo481036337271.jpg","2011-03-22T07:46:11.490+0000","119.235.7.103","Firefox","","",0), "481036337272": ("photo481036337272.jpg","2011-03-22T07:46:12.490+0000","119.235.7.103","Firefox","","",0), "481036337273": ("photo481036337273.jpg","2011-03-22T07:46:13.490+0000","119.235.7.103","Firefox","","",0), "481036337274": ("photo481036337274.jpg","2011-03-22T07:46:14.490+0000","119.235.7.103","Firefox","","",0), "481036337275": ("photo481036337275.jpg","2011-03-22T07:46:15.490+0000","119.235.7.103","Firefox","","",0), "481036337276": ("photo481036337276.jpg","2011-03-22T07:46:16.490+0000","119.235.7.103","Firefox","","",0), "481036337277": ("photo481036337277.jpg","2011-03-22T07:46:17.490+0000","119.235.7.103","Firefox","","",0), "481036337278": ("photo481036337278.jpg","2011-03-22T07:46:18.490+0000","119.235.7.103","Firefox","","",0);, ErrMsg: SemanticError: Insert wrong value: `length'., ErrCode: -12
2021/04/15 21:29:41 [INFO] reader.go:180: Total lines of file(/home/ldbc_snb_datagen/social_network/static/tagclass.csv) is: 72, error lines: 0
2021/04/15 21:29:42 [INFO] statsmgr.go:61: Done(/home/ldbc_snb_datagen/social_network/static/tagclass_isSubclassOf_tagclass.csv): Time(14.49s), Finished(12571), Failed(200), Latency AVG(2811us), Batches Req AVG(3230us), Rows AVG(867.86/s)
2021/04/15 21:29:42 [INFO] statsmgr.go:61: Done(/home/ldbc_snb_datagen/social_network/static/tagclass.csv): Time(14.63s), Finished(17143), Failed(200), Latency AVG(2773us), Batches Req AVG(3190us), Rows AVG(1171.98/s)
2021/04/15 21:29:42 [INFO] reader.go:180: Total lines of file(/home/ldbc_snb_datagen/social_network/static/place.csv) is: 1461, error lines: 0
2021/04/15 21:29:42 [INFO] statsmgr.go:61: Tick: Time(15.00s), Finished(27643), Failed(200), Latency AVG(2868us), Batches Req AVG(3323us), Rows AVG(1842.79/s)
2021/04/15 21:29:42 [INFO] reader.go:180: Total lines of file(/home/ldbc_snb_datagen/social_network/static/place_isPartOf_place.csv) is: 1455, error lines: 0
2021/04/15 21:29:42 [INFO] reader.go:180: Total lines of file(/home/ldbc_snb_datagen/social_network/dynamic/person_studyAt_organisation.csv) is: 1210, error lines: 0
2021/04/15 21:29:43 [INFO] reader.go:180: Total lines of file(/home/ldbc_snb_datagen/social_network/dynamic/person.csv) is: 1529, error lines: 0
2021/04/15 21:29:43 [INFO] statsmgr.go:61: Done(/home/ldbc_snb_datagen/social_network/static/place.csv): Time(15.43s), Finished(40159), Failed(200), Latency AVG(2873us), Batches Req AVG(3341us), Rows AVG(2603.22/s)
2021/04/15 21:29:43 [INFO] statsmgr.go:61: Done(/home/ldbc_snb_datagen/social_network/static/place_isPartOf_place.csv): Time(15.44s), Finished(40459), Failed(200), Latency AVG(2876us), Batches Req AVG(3344us), Rows AVG(2620.74/s)
2021/04/15 21:29:43 [INFO] reader.go:180: Total lines of file(/home/ldbc_snb_datagen/social_network/dynamic/person_isLocatedIn_place.csv) is: 1529, error lines: 0
2021/04/15 21:29:43 [INFO] statsmgr.go:61: Done(/home/ldbc_snb_datagen/social_network/dynamic/person_studyAt_organisation.csv): Time(15.71s), Finished(48169), Failed(200), Latency AVG(2899us), Batches Req AVG(3374us), Rows AVG(3065.39/s)
2021/04/15 21:29:43 [INFO] statsmgr.go:61: Done(/home/ldbc_snb_datagen/social_network/dynamic/person.csv): Time(15.82s), Finished(51198), Failed(200), Latency AVG(2896us), Batches Req AVG(3374us), Rows AVG(3236.61/s)
2021/04/15 21:29:43 [INFO] statsmgr.go:61: Done(/home/ldbc_snb_datagen/social_network/dynamic/person_isLocatedIn_place.csv): Time(16.07s), Finished(58427), Failed(200), Latency AVG(2898us), Batches Req AVG(3378us), Rows AVG(3636.23/s)
2021/04/15 21:29:44 [INFO] reader.go:180: Total lines of file(/home/ldbc_snb_datagen/social_network/dynamic/person_workAt_organisation.csv) is: 3314, error lines: 0
2021/04/15 21:29:44 [INFO] statsmgr.go:61: Done(/home/ldbc_snb_datagen/social_network/dynamic/person_workAt_organisation.csv): Time(17.28s), Finished(94241), Failed(200), Latency AVG(2889us), Batches Req AVG(3372us), Rows AVG(5454.37/s)
2021/04/15 21:29:47 [INFO] reader.go:180: Total lines of file(/home/ldbc_snb_datagen/social_network/static/organisation_isLocatedIn_place.csv) is: 7956, error lines: 0
2021/04/15 21:29:47 [INFO] statsmgr.go:61: Tick: Time(20.00s), Finished(174741), Failed(200), Latency AVG(2883us), Batches Req AVG(3372us), Rows AVG(8736.83/s)
2021/04/15 21:29:47 [INFO] reader.go:180: Total lines of file(/home/ldbc_snb_datagen/social_network/static/organisation.csv) is: 7956, error lines: 0
2021/04/15 21:29:48 [INFO] statsmgr.go:61: Done(/home/ldbc_snb_datagen/social_network/static/organisation_isLocatedIn_place.csv): Time(20.43s), Finished(187297), Failed(200), Latency AVG(2885us), Batches Req AVG(3375us), Rows AVG(9167.18/s)
2021/04/15 21:29:48 [INFO] statsmgr.go:61: Done(/home/ldbc_snb_datagen/social_network/static/organisation.csv): Time(20.71s), Finished(195553), Failed(200), Latency AVG(2884us), Batches Req AVG(3375us), Rows AVG(9442.14/s)
2021/04/15 21:29:52 [INFO] reader.go:180: Total lines of file(/home/ldbc_snb_datagen/social_network/dynamic/forum_hasModerator_person.csv) is: 13751, error lines: 0
2021/04/15 21:29:52 [INFO] reader.go:180: Total lines of file(/home/ldbc_snb_datagen/social_network/dynamic/forum.csv) is: 13751, error lines: 0
2021/04/15 21:29:52 [INFO] reader.go:180: Total lines of file(/home/ldbc_snb_datagen/social_network/dynamic/person_knows_person.csv) is: 14074, error lines: 0
2021/04/15 21:29:52 [INFO] statsmgr.go:61: Done(/home/ldbc_snb_datagen/social_network/dynamic/forum_hasModerator_person.csv): Time(24.85s), Finished(317655), Failed(200), Latency AVG(2886us), Batches Req AVG(3377us), Rows AVG(12781.23/s)
2021/04/15 21:29:52 [INFO] statsmgr.go:61: Done(/home/ldbc_snb_datagen/social_network/dynamic/forum.csv): Time(24.90s), Finished(318955), Failed(200), Latency AVG(2886us), Batches Req AVG(3378us), Rows AVG(12809.63/s)
2021/04/15 21:29:52 [INFO] statsmgr.go:61: Tick: Time(25.00s), Finished(321855), Failed(200), Latency AVG(2886us), Batches Req AVG(3378us), Rows AVG(12874.14/s)
2021/04/15 21:29:52 [INFO] statsmgr.go:61: Done(/home/ldbc_snb_datagen/social_network/dynamic/person_knows_person.csv): Time(25.20s), Finished(327829), Failed(200), Latency AVG(2886us), Batches Req AVG(3377us), Rows AVG(13010.11/s)
2021/04/15 21:29:53 [INFO] reader.go:180: Total lines of file(/home/ldbc_snb_datagen/social_network/static/tag_hasType_tagclass.csv) is: 16081, error lines: 0
2021/04/15 21:29:53 [INFO] reader.go:180: Total lines of file(/home/ldbc_snb_datagen/social_network/static/tag.csv) is: 16081, error lines: 0
2021/04/15 21:29:53 [INFO] statsmgr.go:61: Done(/home/ldbc_snb_datagen/social_network/static/tag_hasType_tagclass.csv): Time(26.06s), Finished(356110), Failed(200), Latency AVG(2864us), Batches Req AVG(3350us), Rows AVG(13664.50/s)
2021/04/15 21:29:53 [INFO] statsmgr.go:61: Done(/home/ldbc_snb_datagen/social_network/static/tag.csv): Time(26.25s), Finished(361691), Failed(200), Latency AVG(2863us), Batches Req AVG(3350us), Rows AVG(13779.68/s)
2021/04/15 21:29:57 [INFO] statsmgr.go:61: Tick: Time(30.00s), Finished(471191), Failed(200), Latency AVG(2877us), Batches Req AVG(3366us), Rows AVG(15706.02/s)
2021/04/15 21:30:02 [INFO] statsmgr.go:61: Tick: Time(35.00s), Finished(619691), Failed(200), Latency AVG(2881us), Batches Req AVG(3364us), Rows AVG(17705.01/s)
2021/04/15 21:30:03 [INFO] reader.go:180: Total lines of file(/home/ldbc_snb_datagen/social_network/dynamic/person_hasInterest_tag.csv) is: 35476, error lines: 0
2021/04/15 21:30:04 [INFO] statsmgr.go:61: Done(/home/ldbc_snb_datagen/social_network/dynamic/person_hasInterest_tag.csv): Time(36.40s), Finished(662967), Failed(200), Latency AVG(2874us), Batches Req AVG(3355us), Rows AVG(18215.19/s)
2021/04/15 21:30:07 [INFO] statsmgr.go:61: Tick: Time(40.00s), Finished(770467), Failed(200), Latency AVG(2873us), Batches Req AVG(3353us), Rows AVG(19261.33/s)
2021/04/15 21:30:09 [INFO] reader.go:180: Total lines of file(/home/ldbc_snb_datagen/social_network/dynamic/person_likes_post.csv) is: 47216, error lines: 0
2021/04/15 21:30:09 [INFO] reader.go:180: Total lines of file(/home/ldbc_snb_datagen/social_network/dynamic/forum_hasTag_tag.csv) is: 47698, error lines: 0
2021/04/15 21:30:10 [INFO] statsmgr.go:61: Done(/home/ldbc_snb_datagen/social_network/dynamic/person_likes_post.csv): Time(42.59s), Finished(847483), Failed(200), Latency AVG(2872us), Batches Req AVG(3353us), Rows AVG(19900.41/s)
2021/04/15 21:30:10 [INFO] statsmgr.go:61: Done(/home/ldbc_snb_datagen/social_network/dynamic/forum_hasTag_tag.csv): Time(42.64s), Finished(849281), Failed(200), Latency AVG(2872us), Batches Req AVG(3353us), Rows AVG(19915.18/s)
2021/04/15 21:30:11 [INFO] reader.go:180: Total lines of file(/home/ldbc_snb_datagen/social_network/dynamic/post_hasTag_tag.csv) is: 51119, error lines: 0
2021/04/15 21:30:11 [INFO] statsmgr.go:61: Done(/home/ldbc_snb_datagen/social_network/dynamic/post_hasTag_tag.csv): Time(44.13s), Finished(894000), Failed(200), Latency AVG(2871us), Batches Req AVG(3350us), Rows AVG(20258.16/s)
2021/04/15 21:30:12 [INFO] statsmgr.go:61: Tick: Time(45.00s), Finished(919900), Failed(200), Latency AVG(2872us), Batches Req AVG(3350us), Rows AVG(20442.20/s)
2021/04/15 21:30:15 [INFO] reader.go:180: Total lines of file(/home/ldbc_snb_datagen/social_network/dynamic/person_likes_comment.csv) is: 62226, error lines: 0
2021/04/15 21:30:16 [INFO] statsmgr.go:61: Done(/home/ldbc_snb_datagen/social_network/dynamic/person_likes_comment.csv): Time(48.55s), Finished(1030726), Failed(200), Latency AVG(2860us), Batches Req AVG(3333us), Rows AVG(21232.24/s)
2021/04/15 21:30:17 [INFO] statsmgr.go:61: Tick: Time(50.00s), Finished(1075126), Failed(200), Latency AVG(2858us), Batches Req AVG(3330us), Rows AVG(21502.43/s)
2021/04/15 21:30:20 [INFO] reader.go:180: Total lines of file(/home/ldbc_snb_datagen/social_network/dynamic/comment_replyOf_post.csv) is: 74257, error lines: 0
2021/04/15 21:30:20 [INFO] statsmgr.go:61: Done(/home/ldbc_snb_datagen/social_network/dynamic/comment_replyOf_post.csv): Time(52.83s), Finished(1160083), Failed(200), Latency AVG(2857us), Batches Req AVG(3330us), Rows AVG(21959.27/s)
2021/04/15 21:30:21 [INFO] reader.go:180: Total lines of file(/home/ldbc_snb_datagen/social_network/dynamic/comment_replyOf_comment.csv) is: 76788, error lines: 0
2021/04/15 21:30:21 [INFO] statsmgr.go:61: Done(/home/ldbc_snb_datagen/social_network/dynamic/comment_replyOf_comment.csv): Time(53.74s), Finished(1187771), Failed(200), Latency AVG(2855us), Batches Req AVG(3328us), Rows AVG(22103.44/s)
2021/04/15 21:30:22 [INFO] statsmgr.go:61: Tick: Time(55.00s), Finished(1225071), Failed(200), Latency AVG(2856us), Batches Req AVG(3330us), Rows AVG(22273.78/s)
2021/04/15 21:30:27 [INFO] statsmgr.go:61: Tick: Time(60.00s), Finished(1378371), Failed(200), Latency AVG(2851us), Batches Req AVG(3321us), Rows AVG(22972.81/s)
2021/04/15 21:30:32 [INFO] statsmgr.go:61: Tick: Time(65.00s), Finished(1526471), Failed(200), Latency AVG(2853us), Batches Req AVG(3326us), Rows AVG(23484.06/s)
2021/04/15 21:30:34 [INFO] reader.go:180: Total lines of file(/home/ldbc_snb_datagen/social_network/dynamic/forum_hasMember_person.csv) is: 123269, error lines: 0
2021/04/15 21:30:35 [INFO] statsmgr.go:61: Done(/home/ldbc_snb_datagen/social_network/dynamic/forum_hasMember_person.csv): Time(67.64s), Finished(1607440), Failed(200), Latency AVG(2852us), Batches Req AVG(3322us), Rows AVG(23763.77/s)
2021/04/15 21:30:37 [INFO] statsmgr.go:61: Tick: Time(70.00s), Finished(1685440), Failed(200), Latency AVG(2846us), Batches Req AVG(3308us), Rows AVG(24077.68/s)
2021/04/15 21:30:37 [INFO] reader.go:180: Total lines of file(/home/ldbc_snb_datagen/social_network/dynamic/post_isLocatedIn_place.csv) is: 135702, error lines: 0
2021/04/15 21:30:37 [INFO] reader.go:180: Total lines of file(/home/ldbc_snb_datagen/social_network/dynamic/post.csv) is: 135702, error lines: 0
2021/04/15 21:30:37 [INFO] reader.go:180: Total lines of file(/home/ldbc_snb_datagen/social_network/dynamic/post_hasCreator_person.csv) is: 135702, error lines: 0
2021/04/15 21:30:37 [INFO] reader.go:180: Total lines of file(/home/ldbc_snb_datagen/social_network/dynamic/forum_containerOf_post.csv) is: 135702, error lines: 0
2021/04/15 21:30:38 [INFO] statsmgr.go:61: Done(/home/ldbc_snb_datagen/social_network/dynamic/post_isLocatedIn_place.csv): Time(70.60s), Finished(1703742), Failed(200), Latency AVG(2845us), Batches Req AVG(3308us), Rows AVG(24132.27/s)
2021/04/15 21:30:38 [INFO] statsmgr.go:61: Done(/home/ldbc_snb_datagen/social_network/dynamic/post.csv): Time(70.67s), Finished(1705846), Failed(200), Latency AVG(2845us), Batches Req AVG(3307us), Rows AVG(24136.65/s)
2021/04/15 21:30:38 [INFO] statsmgr.go:61: Done(/home/ldbc_snb_datagen/social_network/dynamic/post_hasCreator_person.csv): Time(70.69s), Finished(1706148), Failed(200), Latency AVG(2845us), Batches Req AVG(3307us), Rows AVG(24136.94/s)
2021/04/15 21:30:38 [INFO] statsmgr.go:61: Done(/home/ldbc_snb_datagen/social_network/dynamic/forum_containerOf_post.csv): Time(70.69s), Finished(1706348), Failed(200), Latency AVG(2845us), Batches Req AVG(3307us), Rows AVG(24137.36/s)
2021/04/15 21:30:39 [INFO] reader.go:180: Total lines of file(/home/ldbc_snb_datagen/social_network/dynamic/comment_isLocatedIn_place.csv) is: 151044, error lines: 0
2021/04/15 21:30:39 [INFO] reader.go:180: Total lines of file(/home/ldbc_snb_datagen/social_network/dynamic/comment_hasCreator_person.csv) is: 151044, error lines: 0
2021/04/15 21:30:39 [INFO] reader.go:180: Total lines of file(/home/ldbc_snb_datagen/social_network/dynamic/comment.csv) is: 151044, error lines: 0
2021/04/15 21:30:40 [INFO] statsmgr.go:61: Done(/home/ldbc_snb_datagen/social_network/dynamic/comment_isLocatedIn_place.csv): Time(72.57s), Finished(1763392), Failed(200), Latency AVG(2843us), Batches Req AVG(3306us), Rows AVG(24300.50/s)
2021/04/15 21:30:40 [INFO] statsmgr.go:61: Done(/home/ldbc_snb_datagen/social_network/dynamic/comment_hasCreator_person.csv): Time(72.64s), Finished(1765636), Failed(200), Latency AVG(2843us), Batches Req AVG(3306us), Rows AVG(24306.61/s)
2021/04/15 21:30:40 [INFO] statsmgr.go:61: Done(/home/ldbc_snb_datagen/social_network/dynamic/comment.csv): Time(72.66s), Finished(1766280), Failed(200), Latency AVG(2843us), Batches Req AVG(3306us), Rows AVG(24307.93/s)
2021/04/15 21:30:41 [INFO] reader.go:180: Total lines of file(/home/ldbc_snb_datagen/social_network/dynamic/comment_hasTag_tag.csv) is: 191304, error lines: 0
2021/04/15 21:30:41 [INFO] statsmgr.go:61: Done(/home/ldbc_snb_datagen/social_network/dynamic/comment_hasTag_tag.csv): Time(73.95s), Finished(1805584), Failed(200), Latency AVG(2842us), Batches Req AVG(3305us), Rows AVG(24416.53/s)


相应的yaml配置文件

version: v2
description: ldbc
removeTempFiles: false
clientSettings:
  retry: 3
  concurrency: 1 # number of graph clients
  channelBufferSize: 128
  space: ldbc_snb_sf100_vid_string
  connection:
    user: root
    password: password
    address: 127.0.0.1:9669
  postStart:
    commands: |
      CREATE SPACE IF NOT EXISTS ldbc_snb_sf100_vid_string(PARTITION_NUM = 1, REPLICA_FACTOR = 1, vid_type = fixed_string(200));
      USE ldbc_snb_sf100_vid_string;
      CREATE TAG IF NOT EXISTS `person`(`firstName` string, `lastName` string, `gender` string, `birthday` string, `creationDate` string, `locationIP` string, `browserUsed` string);
      CREATE TAG IF NOT EXISTS `place`(`name` string, `url` string, `type` string);
      CREATE TAG IF NOT EXISTS `organization`(`type` string, `name` string, `url` string);
      CREATE TAG IF NOT EXISTS `post`(`imageFile` string, `creationDate` string, `locationIP` string, `browserUsed` string, `language` string, `content` string, `length` int);
      CREATE TAG IF NOT EXISTS `comment`(`creationDate` string, `locationIP` string, `browserUsed` string, `content` string, `length` int);
      - path: /home/ldbc_snb_datagen/social_network/dynamic/post.csv
    failDataPath: ./err/data/post.csv
    batchSize: 100
    type: csv
    csv:
      withHeader: false
      withLabel: false
      delimiter: "|"
    schema:
      type: vertex
      vertex:
        vid:
          index: 0
          type: string
        tags:
          - name: post
            props:
              - name: imageFile
                type: string
                index: 1
              - name: creationDate
                type: string
                index: 2
              - name: locationIP
                type: string
                index: 3
              - name: browserUsed
                type: string
                index: 4
              - name: language
                type: string
                index: 5
              - name: content
                type: string
                index: 6
              - name: length
                type: int
                index: 7

  - path: /home/ldbc_snb_datagen/social_network/dynamic/comment.csv
    failDataPath: ./err/data/comment.csv
    batchSize: 100
    type: csv
    csv:
      withHeader: false
      withLabel: false
      delimiter: "|"
    schema:
      type: vertex
      vertex:
        vid:
          index: 0
          type: string
        tags:
          - name: comment
            props:
              - name: creationDate
                type: string
                index: 1
              - name: locationIP
                type: string
                index: 2
              - name: browserUsed
                type: string
                index: 3
              - name: content
                type: string
                index: 4
              - name: length
                type: int
                index: 5

length 类型改为string就可以全部顺利导入,int有部分失败,求助~

看配置文件是没什么问题,有个 path 格式不对,可能是贴错了?

  1. 你可以先看一下这个 space 下是不是已经有了 post,schema 是怎么样的。DESCRIBE TAG post;
  2. 如果 schema 是正确的,把错误的 nGQL 粘到 console 里执行一下,看看会不会报错。

是不是csv文件里那一列有无效的int?import应该有一个err目录,记录导入失败的row,把导入失败的写成一个insert语句在consol里试试呢?

(root@nebula) [ldbc_snb_sf100_vid_string]> DESCRIBE TAG post;
+----------------+----------+-------+---------+
| Field          | Type     | Null  | Default |
+----------------+----------+-------+---------+
| "imageFile"    | "string" | "YES" |         |
+----------------+----------+-------+---------+
| "creationDate" | "string" | "YES" |         |
+----------------+----------+-------+---------+
| "locationIP"   | "string" | "YES" |         |
+----------------+----------+-------+---------+
| "browserUsed"  | "string" | "YES" |         |
+----------------+----------+-------+---------+
| "language"     | "string" | "YES" |         |
+----------------+----------+-------+---------+
| "content"      | "string" | "YES" |         |
+----------------+----------+-------+---------+
| "length"       | "int64"  | "YES" |         |
+----------------+----------+-------+---------+
Got 7 rows (time spent 1337/2219 us)

Fri, 16 Apr 2021 11:29:34 CST

选择load成功的id 893353199072
893353199072|2012-04-21T15:06:19.248+0000|31.7.139.198|Chrome|yes|3
可以看到下图是成功的。

(root@nebula) [ldbc_snb_sf100_vid_string]> FETCH PROP ON * '893353199072';



+-------------------------------------------------------------------------------------------------------------------------------------------------------+
| vertices_                                                                                                                                             |
+-------------------------------------------------------------------------------------------------------------------------------------------------------+
| ("893353199072" :comment{browserUsed: "Chrome", content: "yes", creationDate: "2012-04-21T15:06:19.248+0000", length: 3, locationIP: "31.7.139.198"}) |
+-------------------------------------------------------------------------------------------------------------------------------------------------------+
Got 1 rows (time spent 6267/7068 us)

Fri, 16 Apr 2021 11:52:47 CST

在控制台执行还是会出现同样的问题。

(root@nebula) [ldbc_snb_sf100_vid_string]> INSERT VERTEX `comment`(`creationDate`,`locationIP`,`browserUsed`,`content`,`length`) VALUES "id": ("creationDate","locationIP","browserUsed","content",length), "893353199071": ("2011-08-17T14:26:59.961+0000","46.16.217.105","Chrome","yes",32333)
[ERROR (-12)]: SemanticError: Insert wrong value: `length'.

Fri, 16 Apr 2021 11:55:35 CST

你的 csv 文件是不是有 header 头,然后相当于执行了

INSERT VERTEX `Comment`(`creationDate`,`locationIP`,`browserUsed`,`content`,`length`) VALUES id:("creationDate","locationIP","browserUsed","content","length")

因为 importer 是按批导入的,有一个语句失败导致一批的数据导入失败了。

你可以去掉 csv 第一行,再试下。

withHeader: false , 这个参数改下就好了

非常感谢各位的帮助! :smiling_face_with_three_hearts:
确实是把第一行的Header作为数据插入,因为只有post 和comment 的定义中有int,所以只会有这两个csv文件导入失败。
修改withHeader: true后出现问题错误,不知道大家也出现过这个问题没,如下图。
解决方案:暂时将ldbc生成数据第一行删除。

[nebula-importer]$ ./nebula-importer --config ~/nebula-bench-master/ldbc/import/ldbc_vid_string.yaml
2021/04/16 15:42:12 --- START OF NEBULA IMPORTER ---
2021/04/16 15:42:12 [INFO] connection_pool.go:74: [nebula-clients] connection pool is initialized successfully
2021/04/16 15:42:13 [INFO] clientmgr.go:28: Create 8 Nebula Graph clients
2021/04/16 15:42:13 [INFO] reader.go:26: The delimiter of /lab505/cyf/ldbc_snb_datagen/social_network/dynamic/person.csv is U+007C '|'
2021/04/16 15:42:13 [INFO] reader.go:26: The delimiter of /lab505/cyf/ldbc_snb_datagen/social_network/static/place.csv is U+007C '|'
panic: runtime error: invalid memory address or nil pointer dereference
[signal SIGSEGV: segmentation violation code=0x1 addr=0x0 pc=0x53203d]

goroutine 16 [running]:
github.com/vesoft-inc/nebula-importer/pkg/config.(*VID).String(0xc00000f5f0, 0x7a40e6, 0x4, 0xc00063c1a0, 0xc000484c58)
	/lab505/cyf/nebula-importer/pkg/config/config.go:437 +0x9d
github.com/vesoft-inc/nebula-importer/pkg/config.(*Vertex).String(0xc0002405a0, 0x6, 0xc00063e0e8)
	/lab505/cyf/nebula-importer/pkg/config/config.go:678 +0x44d
github.com/vesoft-inc/nebula-importer/pkg/config.(*Schema).String(0xc00000f5d8, 0x3e, 0xc00001c3c0)
	/lab505/cyf/nebula-importer/pkg/config/config.go:365 +0xa5
github.com/vesoft-inc/nebula-importer/pkg/reader.(*FileReader).startLog(0xc0002397c0)
	/lab505/cyf/nebula-importer/pkg/reader/reader.go:64 +0x85
github.com/vesoft-inc/nebula-importer/pkg/reader.(*FileReader).Read(0xc0002397c0, 0x0, 0x0)
	/lab505/cyf/nebula-importer/pkg/reader/reader.go:156 +0x613
github.com/vesoft-inc/nebula-importer/pkg/cmd.(*Runner).Run.func2(0xc0002394c0, 0xc000239500, 0xc0002397c0, 0xc00001c3c0, 0x3e)
	/lab505/cyf/nebula-importer/pkg/cmd/runner.go:70 +0x45
created by github.com/vesoft-inc/nebula-importer/pkg/cmd.(*Runner).Run
	/lab505/cyf/nebula-importer/pkg/cmd/runner.go:69 +0x6b6
1 个赞

有没有测试过程和文档可以发一下哇

小白友好的无网环境 Docker 集群部署 + 测试文档

你可以看下这篇文章,了解下数据的预处理,然后就是搭配使用的数据导入工具文档了。

大佬 你这yaml文件 是重新新建了一个yaml 还是在docker-compose.yaml上面改的啊

浙ICP备20010487号