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

neo4j.het.io runs out of memory on random relationship query #5

Closed
dhimmel opened this issue Jun 7, 2017 · 1 comment
Closed

neo4j.het.io runs out of memory on random relationship query #5

dhimmel opened this issue Jun 7, 2017 · 1 comment

Comments

@dhimmel
Copy link
Member

dhimmel commented Jun 7, 2017

I noticed today that https://neo4j.het.io/browser/ ran out of memory while running the following query:

MATCH ()-[rel]->()
WITH type(rel) AS rel_type, collect(rel) AS rels
WITH rels[toInteger(rand() * size(rels))] AS rel
RETURN startNode(rel), rel, endNode(rel)

The error is as follows:

There is not enough memory to perform the current task. Please try increasing 'dbms.memory.heap.max_size' in the neo4j configuration (normally in 'conf/neo4j.conf' or, if you you are using Neo4j Desktop, found through the user interface) or if you are running an embedded installation increase the heap by using '-Xmx' command line flag, and then restart the database.

What's odd is that this query used to consistently not error. But today it's consistently caused a memory overflow. https://neo4j.het.io is currently running Neo4j 3.1.4 Community. See the docker image here.

@dhimmel
Copy link
Member Author

dhimmel commented Jul 17, 2019

Hoping this will be solved by #15 with an instance with more RAM.

@dhimmel dhimmel closed this as completed Jul 17, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant