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

where statement causes storage process to exit #4097

Closed
rongjianxing opened this issue Mar 30, 2022 · 3 comments · Fixed by #4111
Closed

where statement causes storage process to exit #4097

rongjianxing opened this issue Mar 30, 2022 · 3 comments · Fixed by #4111
Assignees
Labels
community Source: who proposed the issue type/bug Type: something is unexpected
Milestone

Comments

@rongjianxing
Copy link

rongjianxing commented Mar 30, 2022

where语句导致storage进程退出

wsl ubuntu 20.04.4 lts

  • OS: Linux DESKTOP-A2N2CP3 4.4.0-19041-Microsoft #488-Microsoft Mon Sep 01 13:43:00 PST 2020 x86_64 x86_64 x86_64 GNU/Linux

**
// linux console

wget https://oss-cdn.nebula-graph.com.cn/package/3.0.1/nebula-graph-3.0.1.ubuntu2004.amd64.deb
sudo dpkg -i nebula-graph-3.0.1.ubuntu2004.amd64.deb
sudo /usr/local/nebula/scripts/nebula.service start all
./nebula-console -addr localhost -port 9669 -u root -p 123456

// nubula-console

ADD HOSTS 127.0.0.1:9779;

CREATE SPACE test (partition_num=1, replica_factor=1, vid_type=fixed_string(30));
use test;

create tag t_date_eq( \
    sts_date date,    \
    cost double,     \
);

create tag index idx_t_date_eq_sts_date on t_date_eq(sts_date);
create tag index idx_t_date_eq__cost on t_date_eq(cost);

lookup on t_date_eq                     \
    where t_date_eq.sts_date == date('2022-03-25') \
        and t_date_eq.cost > 0  \
    yield id(vertex) as vertex_id, properties(vertex).sts_date as sts_date;

**

@rongjianxing rongjianxing added the type/bug Type: something is unexpected label Mar 30, 2022
@Sophie-Xie Sophie-Xie changed the title where语句导致storage进程退出 where statement causes storage process to exit Mar 30, 2022
@Sophie-Xie Sophie-Xie added this to the v3.1.0 milestone Mar 30, 2022
@rongjianxing
Copy link
Author

可以给个回复吗。
想知道是什么原因导致的,是wsl的原因?还是单个storage的原因?还是nebula本身bug导致该语句无论如何都会有问题?

@wey-gu
Copy link
Contributor

wey-gu commented Apr 1, 2022

Thanks @rongjianxing !

I can confirm(just now with your reproduce procedure, thanks!) this query crashed stroaged, on non-wsl/non-wsl2/native Linux env.

It should be a bug, and we will look into it for the fix.

BR//Wey

@Aiee
Copy link
Contributor

Aiee commented Apr 1, 2022

Hi @rongjianxing,
Thank you for your feedback. It is caused by a bug in the constant folding of date('2022-03-25'). You may replace date('2022-03-25') with a string representation as a workaround for now, as we are fixing it.

I'll link the PR to this issue when it is available.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
community Source: who proposed the issue type/bug Type: something is unexpected
Projects
None yet
Development

Successfully merging a pull request may close this issue.

5 participants