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

Neo4j Graph Platform Cypher
1

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

2

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

3

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'?

I am not sure do.

Yours kindly,
Omer

4

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

5

Same problem here, did you figure this out?

6

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!