已针对tag属性创建索引,但match匹配不到数据

**[quote=“yee, post:13, topic:4242, full:true”]
看起来是索引没有生效,具体原因还是要请 @bright-starry-sky 来给定位一下。

PS: 建议你把执行结果使用代码格式显示,这个显示太乱了。
[/quote]

斜体示例*** 1. 列表条目[quote=“yee, post:13, topic:4242, full:true”]
看起来是索引没有生效,具体原因还是要请 @bright-starry-sky 来给定位一下。

PS: 建议你把执行结果使用代码格式显示,这个显示太乱了。
[/quote]

我这边上传图片格式的会报失败,上传不了,上传文字版的提交后就格式边了,实在不好意思哦

大概已经猜到问题了,lookup语句本身没问题,可否尝试手动insert一个vertex,然后再lookup试一下?

(root@nebula) [basketballplayer]> insert vertex player(name,age) values “player151”:(“T Mac”, 45);
Execution succeeded (time spent 1143/2445 us)

Thu, 03 Jun 2021 11:59:44 CST

(root@nebula) [basketballplayer]>
(root@nebula) [basketballplayer]> lookup on player where player.name = ‘T Mac’;
[ERROR (-7)]: SyntaxError: syntax error near `= ‘T Mac’

Thu, 03 Jun 2021 12:00:04 CST

(root@nebula) [basketballplayer]> lookup on player where player.name == ‘T Mac’;
±------------+
| VertexID |
±------------+
| “player151” |
±------------+
Got 1 rows (time spent 1117/2195 us)

Thu, 03 Jun 2021 12:00:08 CST

(root@nebula) [basketballplayer]>
(root@nebula) [basketballplayer]> MATCH (a:player {name: “T Mac”}) return a;
±----------------------------------------------+
| a |
±----------------------------------------------+
| (“player151” :player{age: 45, name: “T Mac”}) |
±----------------------------------------------+
Got 1 rows (time spent 1985/3110 us)

Thu, 03 Jun 2021 12:00:56 CST

(root@nebula) [basketballplayer]>

按您的方式再插入一条记录,使用loopup和match就都可以查下出来,多谢专家!!
是什么原因呢,还请指导

可否把rebuild那个时间段的 meta和storage的log贴出来看下?

meta的日志如下:

root@dggprunner00015:/usr/local/nebula/logs# cat nebula-metad.dggprunner00015.root.log.INFO.20210526-114113.12438
Log file created at: 2021/05/26 11:41:13
Running on machine: dggprunner00015
Log line format: [IWEF]mmdd hh:mm:ss.uuuuuu threadid file:line] msg
I0526 11:41:13.828116 12438 MetaDaemon.cpp:246] identify myself as “10.116.148.15”:9559
I0526 11:41:13.832821 12438 NebulaStore.cpp:47] Start the raft service…
I0526 11:41:13.833160 12438 RaftexService.cpp:65] Init thrift server for raft service, port: 9560
I0526 11:41:13.833230 12483 RaftexService.cpp:98] Starting the Raftex Service
I0526 11:41:13.869204 12483 RaftexService.cpp:86] Starting the Raftex Service on 9560
I0526 11:41:13.869232 12483 RaftexService.cpp:110] Start the Raftex Service successfully
I0526 11:41:13.869275 12438 NebulaStore.cpp:75] Scan the local path, and init the spaces_
I0526 11:41:13.869344 12438 NebulaStore.cpp:81] Scan path “/data/meta/nebula/0”
W0526 11:41:14.049207 12476 RaftexService.cpp:181] Cannot find the part 0 in the graph space 0
I0526 11:41:14.051648 12501 EventListner.h:18] Rocksdb start compaction column family: default because of LevelL0FilesNum, status: OK, compacted 5 files into 0, base level is 0, output level is 1
I0526 11:41:14.051774 12438 RocksEngine.cpp:119] open rocksdb on /data/meta/nebula/0/data
I0526 11:41:14.051787 12438 NebulaStore.cpp:111] Load space 0 from disk
I0526 11:41:14.051800 12438 NebulaStore.cpp:146] Need to open 1 parts of space 0
I0526 11:41:14.055378 12501 EventListner.h:30] Rocksdb compaction completed column family: default because of LevelL0FilesNum, status: OK, compacted 5 files into 1, base level is 0, output level is 1
I0526 11:41:14.260120 12479 FileBasedWal.cpp:65] [Port: 9560, Space: 0, Part: 0] lastLogId in wal is 963279, lastLogTerm is 149, path is /data/meta/nebula/0/wal/0/0000000000000804105.wal
I0526 11:41:14.260219 12479 RaftPart.cpp:295] [Port: 9560, Space: 0, Part: 0] There are 2 peer hosts, and total 3 copies. The quorum is 2, as learner 0, lastLogId 963279, lastLogTerm 149, committedLogId 963278, term 149
I0526 11:41:14.260226 12479 RaftPart.cpp:308] [Port: 9560, Space: 0, Part: 0] Add peer “10.116.148.22”:9560
I0526 11:41:14.260243 12479 RaftPart.cpp:308] [Port: 9560, Space: 0, Part: 0] Add peer “10.116.148.114”:9560
I0526 11:41:14.260335 12479 NebulaStore.cpp:177] Load part 0, 0 from disk
I0526 11:41:14.260370 12438 NebulaStore.cpp:192] Load space 0 complete
I0526 11:41:14.260396 12438 NebulaStore.cpp:201] Init data from partManager for “10.116.148.15”:9559
I0526 11:41:14.260406 12438 NebulaStore.cpp:291] Data space 0 has existed!
I0526 11:41:14.260408 12438 NebulaStore.cpp:330] [Space: 0, Part: 0] has existed!
I0526 11:41:14.260429 12438 NebulaStore.cpp:68] Register handler…
I0526 11:41:14.260433 12438 MetaDaemon.cpp:99] Waiting for the leader elected…
I0526 11:41:14.260437 12438 MetaDaemon.cpp:112] Leader has not been elected, sleep 1s
I0526 11:41:14.419728 12480 RaftPart.cpp:1043] [Port: 9560, Space: 0, Part: 0] Start leader election, reason: lastMsgDur 358, term 149
I0526 11:41:14.419766 12480 RaftPart.cpp:1193] [Port: 9560, Space: 0, Part: 0] Sending out an election request (space = 0, part = 0, term = 150, lastLogId = 963279, lastLogTerm = 149, candidateIP = 10.116.148.15, candidatePort = 9560)
I0526 11:41:14.421394 12480 RaftPart.cpp:1138] [Port: 9560, Space: 0, Part: 0] My last log id is less than “10.116.148.22”:9560, double my election interval.
I0526 11:41:14.421418 12480 RaftPart.cpp:1138] [Port: 9560, Space: 0, Part: 0] My last log id is less than “10.116.148.114”:9560, double my election interval.
I0526 11:41:14.421422 12480 RaftPart.cpp:1275] [Port: 9560, Space: 0, Part: 0] No one is elected, continue the election
I0526 11:41:15.260560 12438 MetaDaemon.cpp:112] Leader has not been elected, sleep 1s
I0526 11:41:16.260728 12438 MetaDaemon.cpp:112] Leader has not been elected, sleep 1s
I0526 11:41:16.812916 12476 RaftPart.cpp:1739] [Port: 9560, Space: 0, Part: 0] I dont know who is leader for current term 149, so accept the candidate “10.116.148.114”:9560
I0526 11:41:16.812948 12476 RaftPart.cpp:1761] [Port: 9560, Space: 0, Part: 0] The current role is Candidate. Will follow the new leader 10.116.148.114:9560 [Term: 149]
I0526 11:41:16.813099 12479 Part.cpp:191] [Port: 9560, Space: 0, Part: 0] Find the new leader “10.116.148.114”:9560
I0526 11:41:17.260926 12438 MetaDaemon.cpp:141] Get meta version is 2
I0526 11:41:17.261050 12438 MetaDaemon.cpp:168] Nebula store init succeeded, clusterId 7356165955248333383
I0526 11:41:17.261062 12438 MetaDaemon.cpp:259] Start http service
I0526 11:41:17.275574 12438 MetaDaemon.cpp:176] Starting Meta HTTP Service
I0526 11:41:17.277329 12525 WebService.cpp:131] Web service started on HTTP[19559], HTTP2[19560]
I0526 11:41:17.277454 12438 JobManager.cpp:52] JobManager initialized
I0526 11:41:17.277473 12531 JobManager.cpp:75] JobManager::runJobBackground() enter
I0526 11:41:17.277585 12438 MetaDaemon.cpp:316] The meta deamon start on “10.116.148.15”:9559
I0527 11:05:45.291472 12545 HBProcessor.cpp:47] Set clusterId for new host “10.116.148.15”:9779!
E0527 11:05:45.291528 12545 RaftPart.cpp:367] [Port: 9560, Space: 0, Part: 0] The partition is not a leader
E0527 11:05:45.291689 12545 RaftPart.cpp:687] [Port: 9560, Space: 0, Part: 0] Cannot append logs, clean the buffer
I0527 15:41:14.644043 12480 FileBasedWal.cpp:738] [Port: 9560, Space: 0, Part: 0] Clean wals number 1
I0529 22:31:15.338212 12480 FileBasedWal.cpp:738] [Port: 9560, Space: 0, Part: 0] Clean wals number 1
I0601 05:01:16.131122 12479 FileBasedWal.cpp:738] [Port: 9560, Space: 0, Part: 0] Clean wals number 1
I0603 07:41:16.806901 12480 FileBasedWal.cpp:738] [Port: 9560, Space: 0, Part: 0] Clean wals number 1

storage的日志如下,一直在报错:

E0603 14:08:20.272584 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:08:22.275190 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:08:24.276310 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:08:26.278750 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:08:28.279893 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:08:30.281077 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:08:32.282223 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:08:34.283336 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:08:36.284452 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:08:38.285564 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:08:40.286654 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:08:42.287860 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:08:44.289024 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:08:46.290134 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:08:48.291317 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:08:50.292543 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:08:52.293669 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:08:54.294780 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:08:56.295998 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:08:58.297252 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:09:00.298393 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:09:02.299533 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:09:04.301789 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:09:06.302997 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:09:08.304123 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:09:10.305310 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:09:12.306397 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:09:14.307649 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:09:16.308820 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:09:18.310058 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:09:20.311206 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:09:22.312373 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:09:24.314402 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:09:26.315605 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:09:28.316761 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:09:30.317986 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:09:32.319106 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:09:34.320446 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:09:36.321676 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:09:38.322857 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:09:40.323988 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:09:42.325078 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:09:44.326175 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:09:46.327457 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:09:48.328677 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:09:50.329957 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:09:52.331074 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:09:54.332238 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:09:56.333376 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:09:58.334610 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:10:00.335773 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:10:02.336931 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:10:04.338275 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:10:06.339584 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:10:08.340726 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:10:10.341894 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!
E0603 14:10:12.343076 3371 MetaClient.cpp:63] Heartbeat failed, status:Wrong cluster!

storage和meta配置对不上 cluster.id删掉 重启 重新rebuild

1、cluster.id删掉是什么意思,不太懂
2、集群重启是将metad,graphd和storaged所有服务都重启吗

集群有个storaged实例的问题重启恢复了,cluster.id也删掉后重启的,但rebuild tag index 后还是loopup不到,
但我把之前插入的点和边都重新插了一遍,现在都能查了,可以继续技术验证了
多谢支持

1 个赞

好的,meta的问题看日志可能是因为初始安装时改过配置文件IP或port导致meta中的数据和实际的环境不匹配导致,一般删掉安装目录下的cluster.id文件后再重启就能解决,稍后可以再关注一下meta和storage中的LOG。

1 个赞

您好,@bright-starry-sky
昨天我重新创建了一个图空间,创建了一个tag,然后对一个属性加了索引,然后重建了索引,最后我插入记录,然后使用fetch可以搜到记录,通过match和lookup还是搜不出记录,也就是索引还是不生效,
再请教下,我的测试集群是否有问题没有彻底解决?

可能还是环境问题,打开vlog,贴一下log中的异常信息?

Log file created at: 2021/06/07 11:00:35
Running on machine: dggprunner00022
Log line format: [IWEF]mmdd hh:mm:ss.uuuuuu threadid file:line] msg
E0607 11:00:35.435747 22535 RaftPart.cpp:367] [Port: 9560, Space: 0, Part: 0] The partition is not a leader
E0607 11:00:35.436029 22535 RaftPart.cpp:687] [Port: 9560, Space: 0, Part: 0] Cannot append logs, clean the buffer

日志文件名:nebula-metad.hostname.root.log.ERROR.20210607-110035.22428

meta有问题了,看log是meta没有leader了。可以这样尝试一下,只留一个metad进程。
从根本上解决的话,还得检查一下graphd和storaged中meta的配置信息。配置信息没问题的话,只留一个metad,没问题后再对metad扩容到初始数目。
猜测是meta很乱了,这个meta的ip:port一开始配置错了,然后启动集群后,又进行了重启和修改。

Log file created at: 2021/06/08 16:44:18
Running on machine: dggprunner00022
Log line format: [IWEF]mmdd hh:mm:ss.uuuuuu threadid file:line] msg
E0608 16:44:18.302009 18847 RebuildIndexTask.cpp:36] Index not found: 3
E0608 16:44:18.302155 18847 AdminTaskManager.cpp:115] job 4, genSubTask failed, err=-37
E0608 16:44:18.302173 18847 AdminTaskProcessor.cpp:24] unsupported conversion of code E_INDEX_NOT_FOUND

专家您好:我们这边按您说的搞了一次,发现还是不行,然后我们干脆把库都删除了,安装包也卸载了然后重新安装这个测试环境,然后重新验证还是match不到数据,报错日志如上面这些,您看这个版本是否有bug?

这是个新问题了,原因是index创建后,还没同步到metaClient中,应该等一下就可以了。
或者把配置参数中的heartbeat_interval_secs设置的小点,设置为1.

metad, storaged, graphd 需要把heartbeat_interval_secs设置为一样的值。

专家您好,但这个设置后,不意味着match匹配的问题就能解决吧?这个问题只能说明我的动作快了,没有间隔默认的20s就操作了

对,先解决rebuild的问题。只有rebuild成功了,match才能查出结果。