This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Help

Head's Up! These forums are read-only. All users and content have migrated. Please join us at community.neo4j.com.

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

mo1
Node Link

‎05-02-2020 05:24 AM

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

Labels:
Reply
5 REPLIES 5

mo1
Node Link

‎05-05-2020 11:56 PM

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

0 Kudos
Reply

omerule
Graph Buddy

‎05-06-2020 08:22 AM

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-manage...
I am not sure do.

Yours kindly,
Omer

0 Kudos
Reply

mo1
Node Link
In response to omerule

‎05-06-2020 10:11 AM

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

0 Kudos
Reply

luanne
Node Clone

‎05-10-2020 10:59 PM

Same problem here, did you figure this out?

0 Kudos
Reply

mo1
Node Link
In response to luanne

‎05-11-2020 10:24 AM

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!

0 Kudos
Reply
Nodes 2022
Nodes
NODES 2022, Neo4j Online Education Summit

All the sessions of the conference are now available online

Watch replays