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

[BUG] Using collections.remove_all stops the docker container #475

Open
ca-ryanjohn-velasco opened this issue May 26, 2024 · 3 comments
Open
Assignees
Labels
bug bug community community Effort - Unknown Effort - Unknown Frequency - EveryTime Frequency - EveryTime Reach - Some Reach - Some Severity - S1 Severity - S1

Comments

@ca-ryanjohn-velasco
Copy link

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:

  1. 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 ;
  2. Click on 'run query'
    network-db-export.zip
    keys.json
@antejavor
Copy link

Hi @ca-ryanjohn-velasco, thanks for opening the issue, we will look into this.

@antejavor antejavor added community community Severity - S1 Severity - S1 Effort - Unknown Effort - Unknown Frequency - EveryTime Frequency - EveryTime Reach - Some Reach - Some labels May 27, 2024
@katarinasupe
Copy link
Contributor

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?

@ca-ryanjohn-velasco
Copy link
Author

ca-ryanjohn-velasco commented May 27, 2024

I am using 2.17.
Attached is the config, log and video.
memgraph.zip
memgraph_2024-05-27.log

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug bug community community Effort - Unknown Effort - Unknown Frequency - EveryTime Frequency - EveryTime Reach - Some Reach - Some Severity - S1 Severity - S1
Projects
Development

No branches or pull requests

4 participants