mage
mage copied to clipboard
[BUG] Using collections.remove_all stops the docker container
Running a query using collections.remove_all with more than 500 keys will cause the server to stop
To Reproduce Steps to reproduce the behavior:
- Run the following query on memgraph lab UNWIND $keys as item WITH collect(DISTINCT item[0]['uuid']) AS inuuid, collect(DISTINCT item[1]['uuid']) AS outuuid MATCH (in:Interface)-[rel:EXPOSES]->(out:Port) WHERE in.uuid IN inuuid AND out.uuid IN outuuid WITH in, rel, out, LABELS(in) AS nodeInLabels, LABELS(out) AS nodeOutLabels WHERE size(collections.remove_all(nodeInLabels, ["Bloom_Perspective","FunctionalId","RefactorVersion"])) = 1 AND collections.remove_all(nodeInLabels, ["Bloom_Perspective","FunctionalId","RefactorVersion","Interface"]) = [] AND size(collections.remove_all(nodeOutLabels, ["Bloom_Perspective","FunctionalId","RefactorVersion"])) = 1 AND collections.remove_all(nodeOutLabels, ["Bloom_Perspective","FunctionalId","RefactorVersion","Port"]) = [] AND [ in{.uuid}, out{.uuid} ] in $keys RETURN rel{IN: in{.uuid}, REL: rel{ElementID: id(rel)}, OUT:out{.uuid}} as key ;
- Click on 'run query' network-db-export.zip keys.json
Hi @ca-ryanjohn-velasco, thanks for opening the issue, we will look into this.
This is Memgraph 2.14. @ca-ryanjohn-velasco can you share your whole config, logs and if there is anything else specific to your database setup and how you're running this query?
I am using 2.17. Attached is the config, log and video. memgraph.zip memgraph_2024-05-27.log