How to kill a currently long running query in Neo4j

Question

How can I kill a currently long-running query in Neo4j (without restarting the server)?

I know we can globally set a timeout for queries, but sometimes I want to execute heavy queries/creates/updates on the server that could take a while...

Thanks.

That is planned in 2.x, we are right now structuring the code for having the concept of a request through all layers, among other in order to be able to kill it. — Peter Neubauer, Apr 17 '13 at 13:34
@PeterNeubauer :When will the first stable version of 2.0 should come out? and when specifically this feature will come out ? — Gil Stal, Apr 17 '13 at 13:37
Maybe, replace long-running query by many short-running? Can you write about your task here or to my e-mail? — Evgenii, Apr 23 '13 at 09:27
@Eugeny: I know I can do that, but my question is about already running queries. I'm not the only developer so I can't control every cypher query that is being executed. besides, sometimes people make mistakes and I want to fix them without restarting the neo4j server. — Gil Stal, Apr 23 '13 at 10:39
You can to create plugin and execute each long-running query in new thread (and kill it when you want). — Evgenii, Apr 23 '13 at 11:38
@PeterNeubauer Now that 2.0 has been around for a bit, is there a way to accomplish this without writing a plugin? — Tasos Bitsios, Aug 22 '14 at 18:10
Have a look at this forum post [https://groups.google.com/forum/m/#!topic/neo4j/5ec8FThLTeo]( https://groups.google.com/forum/m/#!topic/neo4j/5ec8FThLTeo) — TechnoCrat, Mar 06 '15 at 15:48

Jerome_B · Answer 1 · 2017-05-19T13:30:20.613

11

Available in version >3.1 Enterprise with

CALL dbms.listQueries()
CALL dbms.killQuery(queryId)

Admins may "kill'em all"

There is also

 :queries

edited May 19 '17 at 13:30

answered Nov 15 '16 at 17:10

Jerome_B

1,079
8
15

I'm on 3.4.0. For some reason it doesn't cancel queries. – expert Jun 08 '18 at 11:47
@expert **Enterprise** version ? – Jerome_B Jun 08 '18 at 13:16
@Jerome_B Yep, enterprise from their docker image – expert Jun 08 '18 at 17:15
@expert in the browser, the loader keeps turning although I killed the query. I verified with the movies dataset (:play movies) and this long running query MATCH (n),(m),(o) RETURN n,m,o The icon must be clicked twice, and the second is not the cross. A bit counterintuitive imho – Jerome_B Jun 09 '18 at 13:54
@expert I verified with dbms.killQuery too. Works – Jerome_B Jun 09 '18 at 13:57

score 1 · Answer 2 · answered Feb 11 '15 at 08:29

1

Currently there is no way to abort queries in Neo4j. At least I haven't found anything when I needed and I searched the docs quite a lot of times.

answered Feb 11 '15 at 08:29

Laszlo Varga

87
6

score 1 · Answer 3 · answered Apr 01 '15 at 08:12

The 2.2 release has some functionality around this area, but still no monitoring tool that you could see, for example, the queries ran by other clients, you can only kill your own long running queries, executed through the web ui or the shell.

Neo4J 2.2 Release Notes

score 0 · Answer 4 · answered Apr 01 '15 at 10:26

I think there is no way to abort queries in Neo4j.

There is a way to kill long running queries automatically with the Guard stuff (you can pick either max number of operations or a timeout). There were some instructions sent out (couldn't find it immediately and I need to run).

score 0 · Answer 5 · answered Aug 15 '16 at 19:51

0

I found that in the shell pressing CTRL-C terminates the query (running V3.0.3)

answered Aug 15 '16 at 19:51

Albert S

2,552
1
22
28

How to kill a currently long running query in Neo4j

5 Answers5

Linked