Cypher error : Negative ids are not supported (expected format: <databasename>-query-<id>)

Hello, long time relational database user, relative new neo4j / graph database user. I'm running into a weird issue with a system I'm developing and googling / searching here doesn't turn up anything substantive.

I'm noticing some lingering queries after my import scripts have finished running that I can't seem to kill. Why the queries themselves remain is confusing but for the time being I'd be happy if I could terminate them so that I can safely shutdown the process and make config changes.

neo4j@system> CALL dbms.listQueries();
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| queryId                 | username | metaData | query                                                    | parameters | planner          | runtime     | indexes                                                                                                                     | startTime                  | protocol | clientAddress     | requestUri                                         | status    | resourceInformation | activeLockCount | elapsedTimeMillis | cpuTimeMillis | waitTimeMillis | idleTimeMillis | allocatedBytes | pageHits | pageFaults | connectionId | database |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| "system-query-35668420" | "neo4j"  | {}       | "CALL dbms.listQueries();"                               | {}         | "administration" | "system"    | []                                                                                                                          | "2020-05-02T12:12:52.565Z" | "bolt"   | "127.0.0.1:59816" | "127.0.0.1:7687"                                   | "running" | {}                  | 0               | 22                | NULL          | 0              | NULL           | NULL           | 1        | 0          | "bolt-373"   | "system" |
| "neo4j-query-22282676"  | "neo4j"  | {}       | "MATCH(l:Ledger { processed : false }) RETURN l LIMIT 5" | {}         | "idp"            | "pipelined" | [{propertyKey: "processed", identifier: "l", indexType: "SCHEMA INDEX", labelId: "0", entityType: "NODE", label: "Ledger"}] | "2020-05-01T06:42:03.369Z" | "http"   | "127.0.0.1:36172" | "http://127.0.0.1:7474/db/data/transaction/commit" | "running" | {}                  | 0               | 106249219         | NULL          | 0              | NULL           | NULL           | 12       | 0          | "http-354"   | "neo4j"  |
| "neo4j-query-16564368"  | "neo4j"  | {}       | "MATCH(l:Ledger { processed : false }) RETURN l LIMIT 5" | {}         | "idp"            | "pipelined" | [{propertyKey: "processed", identifier: "l", indexType: "SCHEMA INDEX", labelId: "0", entityType: "NODE", label: "Ledger"}] | "2020-04-30T18:01:52.203Z" | "http"   | "127.0.0.1:35862" | "http://127.0.0.1:7474/db/data/transaction/commit" | "running" | {}                  | 1               | 151860385         | NULL          | 0              | NULL           | NULL           | 19       | 0          | "http-339"   | "neo4j"  |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

Attempting to kill either of the long running queries results in:

neo4j@system> call dbms.killQuery("neo4j-query-16564368");
Negative ids are not supported (expected format: <databasename>-query-<id>)

I was able to successfully terminate the connections owning those queries but for some reason these queries cannot be killed. Could anyone offer any insights? Many thanks

OK spent a while debugging this tonight. Weird thing is is that these queries are still persisting after I added transaction timeouts to neo4j.conf

dbms.transaction.timeout=10s
dbms.lock.acquisition.timeout=10s

From what I understand this config should kill the queries after 10 seconds but even after restarting neo4j the problem re-manifests after a while. Inspecting the transaction log it is apparent that the transactions encapsulating these MATCH queries (they are the only ones in the transaction) are timing out but the transactions / queries are failing to be removed. Any insights into why this is would be much appreciated.

+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| transactionId               | username | metaData | startTime                  | protocol | clientAddress     | requestUri                                         | currentQueryId        | currentQuery                                             | activeLockCount | status                                                                                 | resourceInformation | elapsedTimeMillis | cpuTimeMillis | waitTimeMillis | idleTimeMillis | allocatedBytes | allocatedDirectBytes | pageHits | pageFaults | connectionId | initializationStackTrace | database |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| "neo4j-transaction-3364817" | "neo4j"  | {}       | "2020-05-05T23:10:49.473Z" | "http"   | "127.0.0.1:60990" | "http://127.0.0.1:7474/db/data/transaction/commit" | "neo4j-query-3364822" | "MATCH(l:Ledger { processed : false }) RETURN l LIMIT 5" | 0               | "Terminated with reason: Status.Code[Neo.ClientError.Transaction.TransactionTimedOut]" | {}                  | 22609522          | 0             | 0              | 22609522       | 0              | 0                    | 21       | 0          | "http-18"    | ""                       | "neo4j"  |
| "neo4j-transaction-1269815" | "neo4j"  | {}       | "2020-05-05T20:50:33.893Z" | "http"   | "127.0.0.1:60374" | "http://127.0.0.1:7474/db/data/transaction/commit" | ""                    | ""                                                       | 0               | "Terminated with reason: Status.Code[Neo.ClientError.Transaction.TransactionTimedOut]" | {}                  | 31025102          | 0             | 0              | 31025102       | 0              | 0                    | 14       | 0          | "http-8"     | ""                       | "neo4j"  |
| "neo4j-transaction-3364610" | "neo4j"  | {}       | "2020-05-05T23:10:48.467Z" | "http"   | "127.0.0.1:60364" | "http://127.0.0.1:7474/db/data/transaction/commit" | "neo4j-query-3364615" | "MATCH(l:Ledger { processed : false }) RETURN l LIMIT 5" | 0               | "Terminated with reason: Status.Code[Neo.ClientError.Transaction.TransactionTimedOut]" | {}                  | 22610528          | 0             | 0              | 22610528       | 0              | 0                    | 23       | 0          | "http-7"     | ""                       | "neo4j"  |
| "neo4j-transaction-4517045" | "neo4j"  | {}       | "2020-05-06T00:38:23.191Z" | "http"   | "127.0.0.1:60720" | "http://127.0.0.1:7474/db/data/transaction/commit" | ""                    | ""                                                       | 0               | "Terminated with reason: Status.Code[Neo.ClientError.Transaction.TransactionTimedOut]" | {}                  | 17355804          | 0             | 0              | 17355804       | 0              | 0                    | 0        | 0          | "http-14"    | ""                       | "neo4j"  |
| "neo4j-transaction-7123820" | "neo4j"  | {}       | "2020-05-06T04:29:36.141Z" | "http"   | "127.0.0.1:33208" | "http://127.0.0.1:7474/db/data/transaction/commit" | "neo4j-query-7123825" | "MATCH(l:Ledger { processed : false }) RETURN l LIMIT 5" | 0               | "Terminated with reason: Status.Code[Neo.ClientError.Transaction.TransactionTimedOut]" | {}                  | 3482854           | 0             | 0              | 3482854        | 0              | 0                    | 20       | 0          | "http-21"    | ""                       | "neo4j"  |
| "neo4j-transaction-7603038" | "neo4j"  | {}       | "2020-05-06T05:27:38.976Z" | "bolt"   | "127.0.0.1:49436" | "127.0.0.1:7687"                                   | "neo4j-query-7603044" | "
call dbms.listTransactions();"                         | 0               | "Running"                                                                              | {}                  | 19                | 0             | 0              | 19             | 0              | 0                    | 0        | 0          | "bolt-22"    | ""                       | "neo4j"  |
| "neo4j-transaction-1577687" | "neo4j"  | {}       | "2020-05-05T21:11:22.009Z" | "http"   | "127.0.0.1:60378" | "http://127.0.0.1:7474/db/data/transaction/commit" | ""                    | ""                                                       | 0               | "Terminated with reason: Status.Code[Neo.ClientError.Transaction.TransactionTimedOut]" | {}                  | 29776986          | 0             | 0              | 29776986       | 0              | 0                    | 20       | 0          | "http-10"    | ""                       | "neo4j"  |
| "neo4j-transaction-2424439" | "neo4j"  | {}       | "2020-05-05T22:08:46.701Z" | "http"   | "127.0.0.1:60366" | "http://127.0.0.1:7474/db/data/transaction/commit" | ""                    | ""                                                       | 0               | "Terminated with reason: Status.Code[Neo.ClientError.Transaction.TransactionTimedOut]" | {}                  | 26332294          | 0             | 0              | 26332294       | 0              | 0                    | 0        | 0          | "http-9"     | ""                       | "neo4j"  |
<truncated for brevity>
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

Now as far as the "Negative IDs" error which occurs when I try to manually kill the queries. Adding -debug and -format verbose to cypher shell yields more output:

org.neo4j.driver.exceptions.ClientException: Negative ids are not supported (expected format: <databasename>-query-<id>)
        at org.neo4j.driver.internal.util.Futures.blockingGet(Futures.java:143)
        at org.neo4j.driver.internal.InternalResult.blockingGet(InternalResult.java:128)
        at org.neo4j.driver.internal.InternalResult.keys(InternalResult.java:55)
        at org.neo4j.shell.state.StatementBoltResult.getKeys(StatementBoltResult.java:25)
        at org.neo4j.shell.prettyprint.TableOutputFormatter.formatAndCount(TableOutputFormatter.java:35)
        at org.neo4j.shell.prettyprint.PrettyPrinter.format(PrettyPrinter.java:28)
        at org.neo4j.shell.CypherShell.lambda$executeCypher$0(CypherShell.java:99)
        at java.base/java.util.Optional.ifPresent(Optional.java:183)
        at org.neo4j.shell.CypherShell.executeCypher(CypherShell.java:98)
        at org.neo4j.shell.CypherShell.execute(CypherShell.java:81)
        at org.neo4j.shell.cli.InteractiveShellRunner.runUntilEnd(InteractiveShellRunner.java:107)
        at org.neo4j.shell.Main.runShell(Main.java:120)
        at org.neo4j.shell.Main.startShell(Main.java:86)
        at org.neo4j.shell.Main.main(Main.java:44)
        Suppressed: org.neo4j.driver.internal.util.ErrorUtil$InternalExceptionCause
                at org.neo4j.driver.internal.util.ErrorUtil.newNeo4jError(ErrorUtil.java:79)
                at org.neo4j.driver.internal.async.inbound.InboundMessageDispatcher.handleFailureMessage(InboundMessageDispatcher.java:105)
                at org.neo4j.driver.internal.messaging.v1.MessageReaderV1.unpackFailureMessage(MessageReaderV1.java:83)
                at org.neo4j.driver.internal.messaging.v1.MessageReaderV1.read(MessageReaderV1.java:59)
                at org.neo4j.driver.internal.async.inbound.InboundMessageHandler.channelRead0(InboundMessageHandler.java:83)
                at org.neo4j.driver.internal.async.inbound.InboundMessageHandler.channelRead0(InboundMessageHandler.java:35)
                at org.neo4j.driver.internal.shaded.io.netty.channel.SimpleChannelInboundHandler.channelRead(SimpleChannelInboundHandler.java:105)
                at org.neo4j.driver.internal.shaded.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:374)
                at org.neo4j.driver.internal.shaded.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:360)
                at org.neo4j.driver.internal.shaded.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:352)
                at org.neo4j.driver.internal.shaded.io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:328)
                at org.neo4j.driver.internal.shaded.io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:302)
                at org.neo4j.driver.internal.async.inbound.MessageDecoder.channelRead(MessageDecoder.java:47)
                at org.neo4j.driver.internal.shaded.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:374)
                at org.neo4j.driver.internal.shaded.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:360)
                at org.neo4j.driver.internal.shaded.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:352)
                at org.neo4j.driver.internal.shaded.io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:328)
                at org.neo4j.driver.internal.shaded.io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:302)
                at org.neo4j.driver.internal.shaded.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:374)
                at org.neo4j.driver.internal.shaded.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:360)
                at org.neo4j.driver.internal.shaded.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:352)
                at org.neo4j.driver.internal.shaded.io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1422)
                at org.neo4j.driver.internal.shaded.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:374)
                at org.neo4j.driver.internal.shaded.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:360)
                at org.neo4j.driver.internal.shaded.io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:931)
                at org.neo4j.driver.internal.shaded.io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:163)
                at org.neo4j.driver.internal.shaded.io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:700)
                at org.neo4j.driver.internal.shaded.io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:635)
                at org.neo4j.driver.internal.shaded.io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:552)
                at org.neo4j.driver.internal.shaded.io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:514)
                at org.neo4j.driver.internal.shaded.io.netty.util.concurrent.SingleThreadEventExecutor$6.run(SingleThreadEventExecutor.java:1044)
                at org.neo4j.driver.internal.shaded.io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74)
                at org.neo4j.driver.internal.shaded.io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
                at java.base/java.lang.Thread.run(Thread.java:834)

Unfortunately this isn't too helpful. Inspecting debug.log does yield more promising results:


2020-05-06 06:44:23.398+0000 ERROR id:7603066 - 2 ms: bolt-session      bolt    neo4j-java/dev          client/127.0.0.1:49750  server/127.0.0.1:7687>  neo4j - neo4j - call dbms.killQuery('neo4j-query-3364822'); - {} - {} Negative ids are not supported (expected format: <databasename>-query-<id>)
org.neo4j.exceptions.CypherExecutionException: Negative ids are not supported (expected format: <databasename>-query-<id>)
        at org.neo4j.cypher.internal.planning.ExceptionTranslationSupport.translateException(ExceptionTranslationSupport.scala:41)
        at org.neo4j.cypher.internal.planning.ExceptionTranslationSupport.translateException$(ExceptionTranslationSupport.scala:32)
        at org.neo4j.cypher.internal.planning.ExceptionTranslatingQueryContext.translateException(ExceptionTranslatingQueryContext.scala:40)
        at org.neo4j.cypher.internal.planning.ExceptionTranslationSupport.translateIterator(ExceptionTranslationSupport.scala:48)
        at org.neo4j.cypher.internal.planning.ExceptionTranslationSupport.translateIterator$(ExceptionTranslationSupport.scala:47)
        at org.neo4j.cypher.internal.planning.ExceptionTranslatingQueryContext.translateIterator(ExceptionTranslatingQueryContext.scala:40)
        at org.neo4j.cypher.internal.planning.ExceptionTranslatingQueryContext.callDbmsProcedure(ExceptionTranslatingQueryContext.scala:189)
        at org.neo4j.cypher.internal.runtime.DbmsCallMode.callProcedure(ProcedureCallMode.scala:85)
        at org.neo4j.cypher.internal.runtime.interpreted.pipes.ProcedureCallPipe.call(ProcedureCallPipe.scala:87)
        at org.neo4j.cypher.internal.runtime.interpreted.pipes.ProcedureCallPipe.$anonfun$internalCreateResultsByAppending$1(ProcedureCallPipe.scala:73)
        at scala.collection.Iterator$$anon$11.nextCur(Iterator.scala:480)
        at scala.collection.Iterator$$anon$11.hasNext(Iterator.scala:486)
        at org.neo4j.cypher.internal.runtime.pipelined.operators.SlottedPipeHeadOperator$OTask.operate(SlottedPipeOperator.scala:111)
        at org.neo4j.cypher.internal.runtime.pipelined.operators.OperatorWithInterpretedDBHitsProfiling.operateWithProfile(SlottedPipeOperator.scala:51)
        at org.neo4j.cypher.internal.runtime.pipelined.operators.OperatorWithInterpretedDBHitsProfiling.operateWithProfile$(SlottedPipeOperator.scala:43)
        at org.neo4j.cypher.internal.runtime.pipelined.operators.SlottedPipeHeadOperator$OTask.operateWithProfile(SlottedPipeOperator.scala:93)
        at org.neo4j.cypher.internal.runtime.pipelined.PipelineTask.executeOperators(PipelineTask.scala:58)
        at org.neo4j.cypher.internal.runtime.pipelined.PipelineTask.executeWorkUnit(PipelineTask.scala:48)
        at org.neo4j.cypher.internal.runtime.pipelined.Worker.executeTask(Worker.scala:128)
        at org.neo4j.cypher.internal.runtime.pipelined.Worker.workOnQuery(Worker.scala:84)
        at org.neo4j.cypher.internal.runtime.pipelined.execution.CallingThreadExecutingQuery.request(CallingThreadExecutingQuery.scala:30)
        at org.neo4j.cypher.internal.PipelinedRuntime$PipelinedRuntimeResult.request(PipelinedRuntime.scala:326)
        at org.neo4j.cypher.internal.result.StandardInternalExecutionResult.request(StandardInternalExecutionResult.scala:88)
        at org.neo4j.cypher.internal.result.ClosingExecutionResult.request(ClosingExecutionResult.scala:135)
        at org.neo4j.bolt.runtime.AbstractCypherAdapterStream.handleRecords(AbstractCypherAdapterStream.java:105)
        at org.neo4j.bolt.v3.messaging.ResultHandler.onPullRecords(ResultHandler.java:41)
        at org.neo4j.bolt.v4.messaging.PullResultConsumer.consume(PullResultConsumer.java:42)
        at org.neo4j.bolt.runtime.statemachine.impl.TransactionStateMachine$State.consumeResult(TransactionStateMachine.java:511)
        at org.neo4j.bolt.runtime.statemachine.impl.TransactionStateMachine$State$1.streamResult(TransactionStateMachine.java:264)
        at org.neo4j.bolt.runtime.statemachine.impl.TransactionStateMachine.streamResult(TransactionStateMachine.java:92)
        at org.neo4j.bolt.v4.runtime.AutoCommitState.processStreamResultMessage(AutoCommitState.java:41)
        at org.neo4j.bolt.v4.runtime.AbstractStreamingState.processUnsafe(AbstractStreamingState.java:49)
        at org.neo4j.bolt.v3.runtime.FailSafeBoltStateMachineState.process(FailSafeBoltStateMachineState.java:48)
        at org.neo4j.bolt.runtime.statemachine.impl.AbstractBoltStateMachine.nextState(AbstractBoltStateMachine.java:143)
        at org.neo4j.bolt.runtime.statemachine.impl.AbstractBoltStateMachine.process(AbstractBoltStateMachine.java:91)
        at org.neo4j.bolt.messaging.BoltRequestMessageReader.lambda$doRead$1(BoltRequestMessageReader.java:90)
        at org.neo4j.bolt.runtime.DefaultBoltConnection.lambda$enqueue$0(DefaultBoltConnection.java:151)
        at org.neo4j.bolt.runtime.DefaultBoltConnection.processNextBatchInternal(DefaultBoltConnection.java:240)
        at org.neo4j.bolt.runtime.DefaultBoltConnection.processNextBatch(DefaultBoltConnection.java:175)
        at org.neo4j.bolt.runtime.DefaultBoltConnection.processNextBatch(DefaultBoltConnection.java:165)
        at org.neo4j.bolt.runtime.scheduling.ExecutorBoltScheduler.executeBatch(ExecutorBoltScheduler.java:212)
        at org.neo4j.bolt.runtime.scheduling.ExecutorBoltScheduler.lambda$scheduleBatchOrHandleError$2(ExecutorBoltScheduler.java:195)
        at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1700)
        at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
        at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
        at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
        at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: org.neo4j.internal.kernel.api.exceptions.ProcedureException: Negative ids are not supported (expected format: <databasename>-query-<id>)
        at org.neo4j.procedure.impl.ProcedureCompilation.rethrowProcedureException(ProcedureCompilation.java:529)
        at org.neo4j.kernel.impl.proc.GeneratedProcedure_killQuery3636528884879488.apply(Unknown Source)
       at org.neo4j.procedure.impl.ProcedureRegistry.callProcedure(ProcedureRegistry.java:208)
        at org.neo4j.procedure.impl.GlobalProceduresRegistry.callProcedure(GlobalProceduresRegistry.java:323)
        at org.neo4j.kernel.impl.api.dbms.TransactionalDbmsOperations.procedureCallDbms(TransactionalDbmsOperations.java:51)
        at org.neo4j.cypher.internal.runtime.interpreted.CallSupport$.$anonfun$callDbmsProcedure$1(CallSupport.scala:84)
        at org.neo4j.cypher.internal.runtime.interpreted.CallSupport$.callProcedure(CallSupport.scala:97)
        at org.neo4j.cypher.internal.runtime.interpreted.CallSupport$.callDbmsProcedure(CallSupport.scala:78)
        at org.neo4j.cypher.internal.runtime.interpreted.TransactionBoundQueryContext.callDbmsProcedure(TransactionBoundQueryContext.scala:834)
        at org.neo4j.cypher.internal.planning.ExceptionTranslatingQueryContext.$anonfun$callDbmsProcedure$1(ExceptionTranslatingQueryContext.scala:189)
        at org.neo4j.cypher.internal.planning.ExceptionTranslationSupport.translateException(ExceptionTranslationSupport.scala:33)
        ... 46 more
Caused by: org.neo4j.kernel.api.exceptions.InvalidArgumentsException: Negative ids are not supported (expected format: <databasename>-query-<id>)
        at com.neo4j.procedure.enterprise.builtin.DbmsId.<init>(DbmsId.java:56)
        at com.neo4j.procedure.enterprise.builtin.DbmsQueryId.<init>(DbmsQueryId.java:16)
        at com.neo4j.procedure.enterprise.builtin.EnterpriseBuiltInDbmsProcedures.killQueries(EnterpriseBuiltInDbmsProcedures.java:516)
        at com.neo4j.procedure.enterprise.builtin.EnterpriseBuiltInDbmsProcedures.killQuery(EnterpriseBuiltInDbmsProcedures.java:482)
        ... 56 more

Scrolling to the very bottom we see:

com.neo4j.procedure.enterprise.builtin.DbmsId.(DbmsId.java:56)

Unfortunately this is in the enterprise jar which only offers limited insight but inspecting with a hex editor we see the static string:

"Negative ids are not supported (expected format: )"

This is about as far as we can go, we'd need access to this source code to debug further. Why neo4j is intepreting the queryId as a negative id confounds us.

Any insights? Worth filing an issue on the neo4j github? Many thanks

Goodevening,
Could it be that the the query id your trying to stop with current syntax double quotes "query-xyz-123" should be with single quotes: 'query-xyz-123'?
https://neo4j.com/docs/operations-manual/current/monitoring/query-management/index.html#query-management-list-queries
I am not sure do.

Yours kindly,
Omer

Hello Omer, it does not matter if I use single or double quotes. The result is the same.


neo4j@neo4j> call dbms.killQuery('neo4j-query-7954010');
Negative ids are not supported (expected format: <databasename>-query-<id>)
neo4j@neo4j> call dbms.killQuery("neo4j-query-7954010");
Negative ids are not supported (expected format: <databasename>-query-<id>)

Thank you for your response

Same problem here, did you figure this out?

No not yet, just figured out a workaround for the problematic query above so that it didn't have to be killed. Would be nice to have a solution for this issue though. Good luck!