路径查询异常

huotu · 2021 年4 月 9 日 08:04

nebula 版本：2.0 rc1
部署方式（分布式 / 单机 / Docker / DBaaS）：分布式

(root@nebula) [mygraph]> 
(root@nebula) [mygraph]> FIND ALL PATH FROM "DHHM_13540000009" TO "DHHM_13540000010" OVER dhhm_dhhm;
2021/04/09 15:43:55 Loop error, *graph.ExecutionResponse error reading struct: *nebula.DataSet error reading struct: *nebula.Row error reading struct: *nebula.Value error reading struct: *nebula.Path error reading struct: *nebula.Vertex error reading struct: error reading field 1: read tcp 10.210.141.9:32846->10.210.141.9:9669: i/o timeout
[root@node01 nebulagraph]# [root@node01 nebulagraph]# logout

在查找两点之间的路径的时候报错

jmq2020 · 2021 年4 月 9 日 09:04

帮忙把 stderr.log 贴一下

huotu · 2021 年4 月 9 日 09:21

我在执行这条语句的时候，graphd-stderr.log日志文件并没有输出内容，日志最后部分内容：

E0409 09:47:24.154103 464372 QueryInstance.cpp:120] SyntaxError: syntax error near INEDX' E0409 14:23:17.555428 464372 Iterator.cpp:53] Value type is not list, type: DATASET E0409 14:23:18.335935 464372 Iterator.cpp:53] Value type is not list, type: DATASET E0409 14:23:26.125321 464364 Iterator.cpp:53] Value type is not list, type: DATASET E0409 14:23:26.128062 464364 Iterator.cpp:53] Value type is not list, type: DATASET E0409 14:29:48.812036 464371 QueryInstance.cpp:120] SyntaxError: syntax error near LIMIT’
E0409 16:23:59.852576 464364 MutateValidator.cpp:108] Insert wrong value: LOU'. E0409 16:23:59.852857 464364 QueryInstance.cpp:120] SemanticError: Insert wrong value: LOU’.
E0409 16:25:05.072635 464364 QueryInstance.cpp:120] SyntaxError: syntax error near ";' E0409 16:25:51.940487 464364 QueryInstance.cpp:120] TagName shzh’ is nonexistent
E0409 16:32:30.578673 464353 QueryInstance.cpp:120] SyntaxError: syntax error near EXIT' E0409 16:38:22.942895 464371 QueryInstance.cpp:120] SyntaxError: syntax error near _dst’
E0409 16:38:33.070427 464371 QueryInstance.cpp:120] TagName dhhm_dhhm' is nonexistent E0409 16:42:21.459141 464353 QueryInstance.cpp:120] SyntaxError: syntax error near $-’
E0409 17:09:26.435406 464353 QueryInstance.cpp:120] SyntaxError: syntax error near `OVER’

huotu · 2021 年4 月 9 日 09:22

只有一个 stderr.log 文件，就是 graphd-stderr.log

jmq2020 · 2021 年4 月 9 日 09:26

这个日志应该不是报错时候的日志，你看一下是哪个服务进程挂了，帮忙把nebula-graph.ERROR这个日志也贴一下把

huotu · 2021 年4 月 9 日 09:39

所有服务器进程都没有挂
[root@node01 nebulagraph]# nebula.service status all
[WARN] The maximum files allowed to open might be too few: 1024
[INFO] nebula-metad: Running as 463908, Listening on 9559
[INFO] nebula-graphd: Running as 463999, Listening on 9669
[INFO] nebula-storaged: Running as 464020, Listening on 9779

有一个警告
会不会是因为系统能打开的文件句柄 open-file 太小了
[WARN] The maximum files allowed to open might be too few: 1024

nebula-graph.ERROR日志如下：
[root@node01 logs]# ll | grep ERROR
lrwxrwxrwx 1 root root -rw-r–r-- 1 root root -rw-r–r-- 1 root root -rw-r–r-- 1 root root -rw-r–r-- 1 root root -rw-r–r-- 1 root root -rw-r–r-- 1 root root lrwxrwxrwx 1 root root -rw-r–r-- 1 root root -rw-r–r-- 1 root root -rw-r–r-- 1 root root -rw-r–r-- 1 root root -rw-r–r-- 1 root root lrwxrwxrwx 1 root root -rw-r–r-- 1 root root -rw-r–r-- 1 root root -rw-r–r-- 1 root root -rw-r–r-- 1 root root -rw-r–r-- 1 root root -rw-r–r-- 1 root root 58 Apr 8 17:08 nebula-graphd.ERROR → nebula-graphd.node01.root.log.ERROR.20210408-170859.463999
767 Apr 6 09:20 nebula-graphd.node01.root.log.ERROR.20210402-180522.33366
506 Apr 6 14:47 nebula-graphd.node01.root.log.ERROR.20210406-144725.141657
1322 Apr 7 12:48 nebula-graphd.node01.root.log.ERROR.20210406-153315.189081
1224 Apr 8 14:21 nebula-graphd.node01.root.log.ERROR.20210408-095124.417439
963 Apr 8 15:17 nebula-graphd.node01.root.log.ERROR.20210408-145120.441859
3799 Apr 9 17:09 nebula-graphd.node01.root.log.ERROR.20210408-170859.463999
57 Apr 8 14:51 nebula-metad.ERROR → nebula-metad.node01.root.log.ERROR.20210408-145126.441784
771 Apr 6 14:27 nebula-metad.node01.root.log.ERROR.20210402-180519.33328
313 Apr 6 15:32 nebula-metad.node01.root.log.ERROR.20210406-153212.141567
277 Apr 7 12:48 nebula-metad.node01.root.log.ERROR.20210407-124823.189002
1070 Apr 8 14:51 nebula-metad.node01.root.log.ERROR.20210408-095121.417368
538 Apr 8 15:26 nebula-metad.node01.root.log.ERROR.20210408-145126.441784
60 Apr 8 17:08 nebula-storaged.ERROR → nebula-storaged.node01.root.log.ERROR.20210408-170859.464020
633 Apr 2 18:05 nebula-storaged.node01.root.log.ERROR.20210402-180522.33407
1007 Apr 6 15:32 nebula-storaged.node01.root.log.ERROR.20210406-144725.141675
4096 Apr 7 12:53 nebula-storaged.node01.root.log.ERROR.20210406-153315.189113
877 Apr 8 09:51 nebula-storaged.node01.root.log.ERROR.20210408-095125.417479
1671 Apr 8 15:26 nebula-storaged.node01.root.log.ERROR.20210408-145120.441892
1299 Apr 8 17:09 nebula-storaged.node01.root.log.ERROR.20210408-170859.464020

[root@node01 logs]# vim nebula-graphd.node01.root.log.ERROR.20210408-170859.463999

Log file created at: 2021/04/08 17:08:59
Running on machine: node01
Log line format: [IWEF]mmdd hh:mm:ss.uuuuuu threadid file:line] msg
E0408 17:08:59.814239 464015 MetaClient.cpp:581] Send request to [10.210.141.135:9559], exceed retry limit
E0408 17:08:59.814976 463999 MetaClient.cpp:60] Heartbeat failed, status:RPC failure in MetaClient: N6apache6thrift9transport19TTransportExceptionE: AsyncSocketException: connect failed, type = Socket not open, errno = 111 (Connection refused): Connection refused
E0408 17:24:22.158116 464350 UseValidator.cpp:24] Unknown space: mygraph
E0408 17:24:22.158293 464350 QueryInstance.cpp:120] SpaceNotFound:
E0408 17:24:22.158824 464350 QueryInstance.cpp:120] SemanticError: Space was not chosen.
E0408 17:24:22.159322 464350 QueryInstance.cpp:120] SemanticError: Space was not chosen.
E0408 17:24:22.159801 464350 QueryInstance.cpp:120] SemanticError: Space was not chosen.
E0408 17:24:22.160260 464350 QueryInstance.cpp:120] SemanticError: Space was not chosen.
E0408 17:26:32.221779 464368 QueryInstance.cpp:120] SyntaxError: syntax error near SPACE' E0408 17:54:34.159598 464363 QueryInstance.cpp:120] SyntaxError: syntax error near count’
E0408 17:54:56.689733 464349 QueryInstance.cpp:120] SyntaxError: syntax error near count' E0408 17:55:25.030092 464348 QueryInstance.cpp:120] SyntaxError: syntax error near | count(’
E0408 17:55:29.654790 464372 QueryInstance.cpp:120] SyntaxError: syntax error near | count(' E0408 17:55:45.554129 464348 QueryInstance.cpp:120] SyntaxError: syntax error near count’
E0408 17:58:45.369784 464355 QueryInstance.cpp:120] SyntaxError: syntax error near count' E0408 17:58:52.500830 464368 QueryInstance.cpp:120] SyntaxError: syntax error near | count(’
E0409 09:09:58.652961 464364 QueryInstance.cpp:120] SyntaxError: syntax error near RETURN' E0409 09:17:47.667063 464372 QueryInstance.cpp:120] SemanticError: $$.dhhm.id’, not found the property id'. E0409 09:22:16.409152 464364 QueryInstance.cpp:120] SyntaxError: syntax error near limit’
E0409 09:23:50.795096 464364 QueryInstance.cpp:120] SyntaxError: syntax error near limit' E0409 09:24:01.160209 464364 QueryInstance.cpp:120] SyntaxError: syntax error near LIMIT’
E0409 09:24:05.719451 464364 QueryInstance.cpp:120] SyntaxError: syntax error near LIMIT' E0409 09:45:47.879379 464372 QueryInstance.cpp:120] SyntaxError: syntax error near INEDX’
E0409 09:46:18.463981 464372 QueryInstance.cpp:120] SyntaxError: syntax error near INEDX' E0409 09:47:24.154103 464372 QueryInstance.cpp:120] SyntaxError: syntax error near INEDX’
E0409 14:23:17.555428 464372 Iterator.cpp:53] Value type is not list, type: DATASET
E0409 14:23:18.335935 464372 Iterator.cpp:53] Value type is not list, type: DATASET
E0409 14:23:26.125321 464364 Iterator.cpp:53] Value type is not list, type: DATASET
E0409 14:23:26.128062 464364 Iterator.cpp:53] Value type is not list, type: DATASET
E0409 14:29:48.812036 464371 QueryInstance.cpp:120] SyntaxError: syntax error near LIMIT' E0409 16:23:59.852576 464364 MutateValidator.cpp:108] Insert wrong value: LOU’.
E0409 16:23:59.852857 464364 QueryInstance.cpp:120] SemanticError: Insert wrong value: LOU'. E0409 16:25:05.072635 464364 QueryInstance.cpp:120] SyntaxError: syntax error near ";’
E0409 16:25:51.940487 464364 QueryInstance.cpp:120] TagName shzh' is nonexistent E0409 16:32:30.578673 464353 QueryInstance.cpp:120] SyntaxError: syntax error near EXIT’
E0409 16:38:22.942895 464371 QueryInstance.cpp:120] SyntaxError: syntax error near _dst' E0409 16:38:33.070427 464371 QueryInstance.cpp:120] TagName dhhm_dhhm’ is nonexistent
E0409 16:42:21.459141 464353 QueryInstance.cpp:120] SyntaxError: syntax error near $-' E0409 17:09:26.435406 464353 QueryInstance.cpp:120] SyntaxError: syntax error near OVER’

huotu · 2021 年4 月 9 日 09:43

因为最初报错提示：
2021/04/09 15:43:55 Loop error, *graph.ExecutionResponse error reading struct: *nebula.DataSet error reading struct: *nebula.Row error reading struct: *nebula.Value error reading struct: *nebula.Path error reading struct: *nebula.Vertex error reading struct: error reading field 1: read tcp 10.210.141.9:32846->10.210.141.9:9669: i/o timeout

有一个 i/o 超时

jmq2020 · 2021 年4 月 12 日 03:32

您好，您可以更新到最新到版本试一下，最近path 有修改

huotu · 2021 年4 月 17 日 02:30

经过测试，小数据量是可以的，2.0 rc1 版本和 2.0.1 版都OK
但我录入完20亿数据以后，查询时 2.0 rc1 就会报这个错

jmq2020 · 2021 年4 月 19 日 02:32

2.0rc1 的时候还没有开始优化，到2.0.1这个版本对很多算子已经做了优化，是不是2.0rc1 的速度会比2.0.1的速度慢了很多

huotu · 2021 年4 月 19 日 03:35

2.0 rc1 的查不出结果，我试一下2.0.1版本大数据量情况

huotu · 2021 年4 月 28 日 01:14

2.0-rc1版本最短路径&全路径查询会出现该异常，升级到2.0-ga版本即可解决