nebula 版本:3.2.0
-
部署方式:单机
-
安装方式:RPM
-
是否为线上版本:Y
-
硬件信息
- 磁盘 SSD
- CPU 8核 内存信息 64G
-
问题的具体描述
执行一条nGQL导致计算节点挂死
语句:LOOKUP ON tb2
yield id(vertex) as test_id3
|GO FROM $-.test_id3 OVER tb1
where (tb1.test_id == 38 or tb1.test_id == 73) and tb1.time_format_date == ‘2022-08-18’
YIELD tb1.test_id as test_id,tb1.test_id2 as test_id2,
case when tb1.test_id == 38 then tb1.test_id3 else tb1.test_id4 end as test_id3,
case when tb1.test_id == 38 then tb1.test_id4 else tb1.test_id3 end as test_id4,
tb1.time_format_date as time_region,tb1.time_format_date as time_format_date
|GROUP BY $-.test_id2,$-.time_format_date,$-.time_region,$-.test_id3,$-.test_id4
YIELD $-.test_id2 as test_id2,$-.time_format_date as time_format_date,$-.time_region as time_region,$-.test_id3 as test_id3,$-.test_id4 as test_id4,
sum(case when tb1.test_id == 38 then 1 else 0 end)/25 as first_num,sum(case when tb1.test_id == 38 then 0 else 1 end)/15 as second_num
|YIELD $-.test_id2 as test_id2,$-.time_format_date as time_format_date,$-.time_region as time_region,$-.test_id3 as test_id3, $-.test_id4 as test_id4,$-.first_num as first_num,$-.second_num as second_num,
case when $-.first_num > $-.second_num then $-.second_num else $-.first_num end as num
WHERE $-.first_num >= 1 and $-.second_num >= 1
|GROUP BY $-.time_format_date,$-.time_region,$-.test_id3,$-.test_id4
YIELD $-.time_format_date as time_format_date,$-.time_region as time_region,$-.test_id3 as test_id3,$-.test_id4 as test_id4,sum($-.num) as num
|YIELD $-.time_format_date as time_format_date,$-.time_region as time_region,$-.test_id3 as test_id3,$-.test_id4 as test_id4,$-.num as num,CASE WHEN $-.num >= 1 and $-.num < 3 THEN 0 WHEN $-.num >= 3 and $-.num < 5 THEN 1 WHEN $-.num >= 5 and $-.num < 10 THEN 2 ELSE 3 END AS count_rank -
相关的graph info 日志信息
F20220905 15:17:26.964362 26317 LabelAttributeExpression.h:37] LabelAttributeExpression has to be rewritten
dmp见附件
52618be0-f25b-43fa-bac32b9c-6c1afe31.dmp (1.4 MB)