Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

When LOOKUP ON Tag by geo index the storaged service will crash #5919

Closed
k1995 opened this issue Aug 9, 2024 · 0 comments · Fixed by #5922
Closed

When LOOKUP ON Tag by geo index the storaged service will crash #5919

k1995 opened this issue Aug 9, 2024 · 0 comments · Fixed by #5922
Assignees
Labels
affects/none PR/issue: this bug affects none version. process/fixed Process of bug severity/blocker Severity of bug type/bug Type: something is unexpected

Comments

@k1995
Copy link

k1995 commented Aug 9, 2024

社区论坛原链接 https://discuss.nebula-graph.com.cn/t/topic/15886

It's works well when there is only one geo index in the tag, but there will be problems when adding other indexes

  • OS: Linux 5.15.153.1-microsoft-standard-WSL2 #1 SMP Fri Mar 29 23:14:13 UTC 2024 x86_64 x86_64 x86_64 GNU/Linux
  • nebula version 3.8

Steps to reproduce the behavior:

  1. Create Empty Space
CREATE SPACE `test` (partition_num = 10, replica_factor = 1, charset = utf8, collate = utf8_bin, vid_type = FIXED_STRING(32));
  1. Create Tag
CREATE TAG `event` ( `gps` geography(point) NULL, `background_id` int64 NULL) ttl_duration = 0, ttl_col = "";
  1. Create Index
CREATE TAG INDEX `event_bg_idx` ON `event` ( `background_id`);
CREATE TAG INDEX `event_gps_idx` ON `event` ( `gps`);
  1. Insert Data
INSERT VERTEX event (gps) VALUES "1":(ST_GeogFromText("POINT(107.09271891276 34.356034884983)"));
  1. Search by gps
LOOKUP ON event
WHERE ST_DWithin(event.gps, ST_GeogFromText("POINT(107.09271891271 54.356034884983)"), 10)
YIELD id(VERTEX) as node

Storage Error: RPC failure, probably timeout

@k1995 k1995 added the type/bug Type: something is unexpected label Aug 9, 2024
@github-actions github-actions bot added affects/none PR/issue: this bug affects none version. severity/none Severity of bug labels Aug 9, 2024
@MuYiYong MuYiYong assigned jievince and unassigned MuYiYong Aug 12, 2024
@MuYiYong MuYiYong added the severity/blocker Severity of bug label Aug 12, 2024
@github-actions github-actions bot removed the severity/none Severity of bug label Aug 12, 2024
@github-actions github-actions bot added the process/fixed Process of bug label Aug 14, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
affects/none PR/issue: this bug affects none version. process/fixed Process of bug severity/blocker Severity of bug type/bug Type: something is unexpected
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants