8000 Query with MIN on collected variable crashes Db · Issue #14807 · arangodb/arangodb · GitHub
[go: up one dir, main page]

Skip to content
Query with MIN on collected variable crashes Db #14807
Closed
@JosipVuckovic

Description

@JosipVuckovic

My Environment

  • ArangoDB Version: 3.8.1
  • Storage Engine: RocksDB
  • Deployment Mode: Single Server
  • Deployment Strategy: ArangoDB Starter
  • Configuration:
  • Infrastructure: own
  • Operating System: Windows 10
  • Total RAM in your machine:
  • Disks in use: SSD
  • Used Package: other

Component, Query & Data

Affected feature:
ArangoDb instance

AQL query (if applicable):

for u in union([],[])
                collect test = u.v into g
                return Distinct {
                    Test: test,
                    Prop1: MIN(g[*].u.someProp),
                    Prop2: MAX(g[*].u.someProp)
                }

AQL explain and/or profile (if applicable):

Execution plan:
 Id   NodeType            Est.   Comment
  1   SingletonNode          1   * ROOT
  2   CalculationNode        1     - LET #7 = [ ]   /* json expression */   /* const assignment */
  3   EnumerateListNode      0     - FOR u IN #7   /* list iteration */
  4   CalculationNode        0       - LET #9 = u.`v`   /* attribute expression */
  9   SortNode               0       - SORT #9 ASC   /* sorting strategy: standard */
  5   CollectNode            0       - COLLECT test = #9 INTO g KEEP u   /* sorted */
  6   CalculationNode        0       - LET #11 = { "Test" : test, "Prop1" : MIN(g[*].`u`.`someProp`), "Prop2" : MAX(g[*].`u`.`someProp`) }   /* simple expression */
  7   CollectNode            0       - COLLECT #13 = #11   /* distinct */
  8   ReturnNode             0       - RETURN #13
Indexes used:
 none
Functions used:
 Name   Deterministic   Cacheable   Uses V8
 MIN    true            true        false
 MAX    true            true        false
Optimization rules applied:
 Id   RuleName
  1   remove-collect-variables
Optimization rules with highest execution times:
 RuleName                                    Duration [s]
 remove-collect-variables                         0.00002
 specialize-collect                               0.00002
 remove-redundant-calculations                    0.00001
 use-indexes                                      0.00001
 optimize-count                                   0.00000
41 rule(s) executed, 1 plan(s) created

Dataset:
N/A

Size of your Dataset on disk:
minimal

Replication Factor & Number of Shards (Cluster only):
N/A

Steps to reproduce

  1. Just run the AQL query

Problem:
Whole ArangoDb instance crashes, i.e. I need to manually restart the ArangoDb service.

Expected result:
Load data

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions

      0