Star

创建索引删除后始终为"QUEUE"问题

  • nebula 版本:V2.0
  • 部署方式:分布式
  • 问题:创建一个索引后删除,后续创建所有索引状态均为"QUEUE"且无法使用;
  • 问题的具体描述:
  1. 首先创建、重构索引single_player_name_index ,查询成功,查询状态为"RUNNING"。
(root@nebula) [nba]> CREATE TAG INDEX single_player_name_index ON player(name(10));
Execution succeeded (time spent 35237/85823 us)

(root@nebula) [nba]> REBUILD TAG INDEX single_player_name_index;
+------------+
| New Job Id |
+------------+
| 17         |
+------------+
Got 1 rows (time spent 28687/82365 us)

(root@nebula) [nba]> LOOKUP ON player WHERE player.name == "Tony Parker" YIELD player.name, player.age;
+-------------+---------------+------------+
| VertexID    | player.name   | player.age |
+-------------+---------------+------------+
| "player101" | "Tony Parker" | 36         |
+-------------+---------------+------------+
Got 1 rows (time spent 5777/49438 us)

(root@nebula) [nba]> SHOW JOB 17;
+----------------+---------------------+-----------+------------+-----------+
| Job Id(TaskId) | Command(Dest)       | Status    | Start Time | Stop Time |
+----------------+---------------------+-----------+------------+-----------+
| 17             | "REBUILD_TAG_INDEX" | "RUNNING" | 1608866783 | 0         |
+----------------+---------------------+-----------+------------+-----------+
Got 1 rows (time spent 10185/53699 us)
  1. 由于无法匹配MATCH,所以认为索引错误,删除索引:
(root@nebula) [nba]> MATCH (v:player{name:"Tony Parker"})--(v2) RETURN v2.name AS Name;
Empty set (time spent 5028/47556 us)

(root@nebula) [nba]> DROP TAG INDEX single_player_name_index;
Execution succeeded (time spent 7323/57498 us)

(root@nebula) [nba]> SHOW TAG INDEXES;
Empty set (time spent 2070/51837 us)
  1. 创建新索引,运行状态始终为 “QUEUE”,且无法查询到值
(root@nebula) [nba]> CREATE TAG INDEX name ON player(name(20));
Execution succeeded (time spent 18446/64020 us)

Fri, 25 Dec 2020 11:30:32 CST

(root@nebula) [nba]> REBUILD TAG INDEX name;
+------------+
| New Job Id |
+------------+
| 19         |
+------------+
Got 1 rows (time spent 8328/57543 us)

Fri, 25 Dec 2020 11:30:40 CST

(root@nebula) [nba]> SHOW JOB 19
+----------------+---------------------+---------+------------+-----------+
| Job Id(TaskId) | Command(Dest)       | Status  | Start Time | Stop Time |
+----------------+---------------------+---------+------------+-----------+
| 19             | "REBUILD_TAG_INDEX" | "QUEUE" | 0          | 0         |
+----------------+---------------------+---------+------------+-----------+
Got 1 rows (time spent 4420/46945 us)

(root@nebula) [nba]> LOOKUP ON player WHERE player.name == "Tony Parker" YIELD player.name, player.age;
Empty set (time spent 1852/60902 us)

(root@nebula) [nba]> SHOW TAG INDEX STATUS;
+----------------------------+--------------+
| Name                       | Index Status |
+----------------------------+--------------+
| "player_index_0"           | "FINISHED"   |
+----------------------------+--------------+
| "single_player_name_index" | "RUNNING"    |
+----------------------------+--------------+
| "name"                     | "QUEUE"      |
+----------------------------+--------------+
Got 3 rows (time spent 1712/73511 us)

更新:
重启服务之后状态均变更为"FAILED":

(root@nebula) [nba]> SHOW TAG INDEX STATUS;
+----------------------------+--------------+
| Name                       | Index Status |
+----------------------------+--------------+
| "player_index_0"           | "FINISHED"   |
+----------------------------+--------------+
| "single_player_name_index" | "FAILED"     |
+----------------------------+--------------+
| "name"                     | "FAILED"     |
+----------------------------+--------------+
Got 3 rows (time spent 2277/59110 us)

这些状态如何删除掉呢?

mark,多谢你的反馈,这两天修复。

这些状态过一段时间会自动删除

好的,谢谢

浙ICP备20010487号