CREATE DATABASE causes errors in neo4j-enterprise v4.4.6

Neo4j Graph Platform
,
1

When I run CREATE DATABASE ... for a db that has been recently dropped, I see multiple errors in debug.log (see below).

I'm running neo4j-enterprise v4.4.6 on a reasonably well-provisioned AWS EC2 instance.

UPDATE: I've searched my old versions of debug.log and found that this complaint first appeared on '2021-06-06 14:29:39.522+0000'. So whether or not this is an issue, it is apparently not new.

My three databases and the python code that populates each have been running reliably for nearly two years. Since upgrading, I see a variety of unexpected hangs, errors, and similar issues.

I hope that someone can provide insight into whether or not this is a real issue and what if anything I can do to work around it.

Here are the contents of debug.log in response to CREATE DATABASE in the Neo4J Browser:

2022-05-18 14:09:10.512+0000 ERROR [o.n.b.r.s.i.ErrorReporter] Client triggered an unexpected error [Neo.DatabaseError.General.UnknownError]: Lexical error at line 1, column 18.  Encountered: <EOF> after : "", reference 29b027af-d76d-47f8-b341-ae0b26b0764c.
2022-05-18 14:09:10.512+0000 ERROR [o.n.b.r.s.i.ErrorReporter] Client triggered an unexpected error [Neo.DatabaseError.General.UnknownError]: Lexical error at line 1, column 18.  Encountered: <EOF> after : "", reference 29b027af-d76d-47f8-b341-ae0b26b0764c.
org.neo4j.cypher.internal.parser.javacc.TokenMgrException: Lexical error at line 1, column 18.  Encountered: <EOF> after : ""
	at org.neo4j.cypher.internal.parser.javacc.CypherTokenManager.getNextToken(CypherTokenManager.java:7616) ~[neo4j-cypher-javacc-parser-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.parser.javacc.Cypher.jj_ntk_f(Cypher.java:23635) ~[neo4j-cypher-javacc-parser-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.parser.javacc.Cypher.SymbolicDatabaseNameStringOrParameter(Cypher.java:18004) ~[neo4j-cypher-javacc-parser-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.parser.javacc.Cypher.CreateDatabase(Cypher.java:17135) ~[neo4j-cypher-javacc-parser-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.parser.javacc.Cypher.CreateCommand(Cypher.java:7263) ~[neo4j-cypher-javacc-parser-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.parser.javacc.Cypher.SingleQueryOrCommand(Cypher.java:288) ~[neo4j-cypher-javacc-parser-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.parser.javacc.Cypher.Statement(Cypher.java:262) ~[neo4j-cypher-javacc-parser-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.parser.javacc.Cypher.Statements(Cypher.java:188) ~[neo4j-cypher-javacc-parser-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.ast.factory.neo4j.JavaCCParser$.parse(JavaCCParser.scala:54) ~[neo4j-cypher-ast-factory-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.compiler.helpers.Neo4jJavaCCParserWithFallback$.parse(Neo4jJavaCCParserWithFallback.scala:48) ~[neo4j-cypher-planner-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.compiler.phases.JavaccParsing$.process(JavaccParsing.scala:40) ~[neo4j-cypher-planner-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.compiler.phases.JavaccParsing$.process(JavaccParsing.scala:36) ~[neo4j-cypher-planner-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.phases.Phase.$anonfun$transform$1(Phase.scala:36) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.helpers.package$.$anonfun$closing$1(package.scala:24) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.helpers.package$.using(package.scala:32) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.helpers.package$.closing(package.scala:24) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.phases.Phase.transform(Phase.scala:35) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.phases.Phase.transform$(Phase.scala:33) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.compiler.phases.JavaccParsing$.transform(JavaccParsing.scala:36) ~[neo4j-cypher-planner-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.phases.PipeLine.transform(Transformer.scala:78) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.phases.PipeLine.transform(Transformer.scala:78) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.phases.PipeLine.transform(Transformer.scala:78) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.phases.PipeLine.transform(Transformer.scala:78) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.phases.PipeLine.transform(Transformer.scala:78) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.phases.PipeLine.transform(Transformer.scala:78) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.phases.PipeLine.transform(Transformer.scala:78) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.phases.PipeLine.transform(Transformer.scala:78) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.phases.PipeLine.transform(Transformer.scala:78) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.phases.PipeLine.transform(Transformer.scala:78) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.fabric.pipeline.FabricFrontEnd$Pipeline$parseAndPrepare$.process(FabricFrontEnd.scala:139) ~[neo4j-fabric-4.4.6.jar:4.4.6]
	at org.neo4j.fabric.planning.FabricPlanner$PlannerInstance.$anonfun$computePlan$1(FabricPlanner.scala:87) ~[neo4j-fabric-4.4.6.jar:4.4.6]
	at org.neo4j.fabric.planning.FabricPlanner$PlannerInstance.trace(FabricPlanner.scala:127) ~[neo4j-fabric-4.4.6.jar:4.4.6]
	at org.neo4j.fabric.planning.FabricPlanner$PlannerInstance.computePlan(FabricPlanner.scala:86) ~[neo4j-fabric-4.4.6.jar:4.4.6]
	at org.neo4j.fabric.planning.FabricPlanner$PlannerInstance.$anonfun$plan$1(FabricPlanner.scala:79) ~[neo4j-fabric-4.4.6.jar:4.4.6]
	at org.neo4j.fabric.cache.FabricQueryCache.computeIfAbsent(FabricQueryCache.scala:52) ~[neo4j-fabric-4.4.6.jar:4.4.6]
	at org.neo4j.fabric.planning.FabricPlanner$PlannerInstance.plan$lzycompute(FabricPlanner.scala:80) ~[neo4j-fabric-4.4.6.jar:4.4.6]
	at org.neo4j.fabric.planning.FabricPlanner$PlannerInstance.plan(FabricPlanner.scala:76) ~[neo4j-fabric-4.4.6.jar:4.4.6]
	at org.neo4j.fabric.executor.FabricExecutor.run(FabricExecutor.java:123) ~[neo4j-fabric-4.4.6.jar:4.4.6]
	at org.neo4j.fabric.bolt.BoltFabricDatabaseService$BoltTransactionImpl.executeQuery(BoltFabricDatabaseService.java:186) ~[neo4j-fabric-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.runtime.statemachine.impl.AbstractTransactionStateMachineSPI$AbstractBoltResultHandle.start(AbstractTransactionStateMachineSPI.java:128) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.runtime.statemachine.impl.TransactionStateMachine$State.startExecution(TransactionStateMachine.java:530) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.runtime.statemachine.impl.TransactionStateMachine$State$2.run(TransactionStateMachine.java:326) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.runtime.statemachine.impl.TransactionStateMachine.run(TransactionStateMachine.java:89) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.runtime.statemachine.impl.TransactionStateMachine.run(TransactionStateMachine.java:82) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.transaction.StatementProcessorTxManager.runQuery(StatementProcessorTxManager.java:92) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.v4.runtime.InTransactionState.processRunMessage(InTransactionState.java:95) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.v4.runtime.InTransactionState.processUnsafe(InTransactionState.java:52) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.v3.runtime.FailSafeBoltStateMachineState.process(FailSafeBoltStateMachineState.java:48) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.runtime.statemachine.impl.AbstractBoltStateMachine.nextState(AbstractBoltStateMachine.java:154) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.runtime.statemachine.impl.AbstractBoltStateMachine.process(AbstractBoltStateMachine.java:102) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.messaging.BoltRequestMessageReader.lambda$doRead$1(BoltRequestMessageReader.java:93) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.runtime.DefaultBoltConnection.lambda$enqueue$0(DefaultBoltConnection.java:156) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.runtime.DefaultBoltConnection.processNextBatchInternal(DefaultBoltConnection.java:252) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.runtime.DefaultBoltConnection.processNextBatch(DefaultBoltConnection.java:187) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.runtime.DefaultBoltConnection.processNextBatch(DefaultBoltConnection.java:177) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.runtime.scheduling.ExecutorBoltScheduler.executeBatch(ExecutorBoltScheduler.java:257) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.runtime.scheduling.ExecutorBoltScheduler.lambda$scheduleBatchOrHandleError$3(ExecutorBoltScheduler.java:240) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1700) [?:?]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
	at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) [apoc-4.4.0.3-core.jar:4.4.0.3]
	at java.lang.Thread.run(Thread.java:829) [?:?]
2022-05-18 14:09:11.819+0000 ERROR [o.n.b.r.s.i.ErrorReporter] Client triggered an unexpected error [Neo.DatabaseError.General.UnknownError]: Lexical error at line 1, column 24.  Encountered: <EOF> after : "", reference 74a5de80-0910-495b-a202-15d242d5cb97.
2022-05-18 14:09:11.820+0000 ERROR [o.n.b.r.s.i.ErrorReporter] Client triggered an unexpected error [Neo.DatabaseError.General.UnknownError]: Lexical error at line 1, column 24.  Encountered: <EOF> after : "", reference 74a5de80-0910-495b-a202-15d242d5cb97.
org.neo4j.cypher.internal.parser.javacc.TokenMgrException: Lexical error at line 1, column 24.  Encountered: <EOF> after : ""
	at org.neo4j.cypher.internal.parser.javacc.CypherTokenManager.getNextToken(CypherTokenManager.java:7616) ~[neo4j-cypher-javacc-parser-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.parser.javacc.Cypher.jj_ntk_f(Cypher.java:23635) ~[neo4j-cypher-javacc-parser-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.parser.javacc.Cypher.SymbolicDatabaseNameStringOrParameter(Cypher.java:18004) ~[neo4j-cypher-javacc-parser-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.parser.javacc.Cypher.CreateDatabase(Cypher.java:17135) ~[neo4j-cypher-javacc-parser-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.parser.javacc.Cypher.CreateCommand(Cypher.java:7263) ~[neo4j-cypher-javacc-parser-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.parser.javacc.Cypher.SingleQueryOrCommand(Cypher.java:288) ~[neo4j-cypher-javacc-parser-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.parser.javacc.Cypher.Statement(Cypher.java:262) ~[neo4j-cypher-javacc-parser-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.parser.javacc.Cypher.Statements(Cypher.java:188) ~[neo4j-cypher-javacc-parser-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.ast.factory.neo4j.JavaCCParser$.parse(JavaCCParser.scala:54) ~[neo4j-cypher-ast-factory-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.compiler.helpers.Neo4jJavaCCParserWithFallback$.parse(Neo4jJavaCCParserWithFallback.scala:48) ~[neo4j-cypher-planner-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.compiler.phases.JavaccParsing$.process(JavaccParsing.scala:40) ~[neo4j-cypher-planner-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.compiler.phases.JavaccParsing$.process(JavaccParsing.scala:36) ~[neo4j-cypher-planner-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.phases.Phase.$anonfun$transform$1(Phase.scala:36) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.helpers.package$.$anonfun$closing$1(package.scala:24) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.helpers.package$.using(package.scala:32) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.helpers.package$.closing(package.scala:24) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.phases.Phase.transform(Phase.scala:35) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.phases.Phase.transform$(Phase.scala:33) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.compiler.phases.JavaccParsing$.transform(JavaccParsing.scala:36) ~[neo4j-cypher-planner-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.phases.PipeLine.transform(Transformer.scala:78) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.phases.PipeLine.transform(Transformer.scala:78) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.phases.PipeLine.transform(Transformer.scala:78) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.phases.PipeLine.transform(Transformer.scala:78) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.phases.PipeLine.transform(Transformer.scala:78) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.phases.PipeLine.transform(Transformer.scala:78) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.phases.PipeLine.transform(Transformer.scala:78) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.phases.PipeLine.transform(Transformer.scala:78) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.phases.PipeLine.transform(Transformer.scala:78) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.phases.PipeLine.transform(Transformer.scala:78) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.fabric.pipeline.FabricFrontEnd$Pipeline$parseAndPrepare$.process(FabricFrontEnd.scala:139) ~[neo4j-fabric-4.4.6.jar:4.4.6]
	at org.neo4j.fabric.planning.FabricPlanner$PlannerInstance.$anonfun$computePlan$1(FabricPlanner.scala:87) ~[neo4j-fabric-4.4.6.jar:4.4.6]
	at org.neo4j.fabric.planning.FabricPlanner$PlannerInstance.trace(FabricPlanner.scala:127) ~[neo4j-fabric-4.4.6.jar:4.4.6]
	at org.neo4j.fabric.planning.FabricPlanner$PlannerInstance.computePlan(FabricPlanner.scala:86) ~[neo4j-fabric-4.4.6.jar:4.4.6]
	at org.neo4j.fabric.planning.FabricPlanner$PlannerInstance.$anonfun$plan$1(FabricPlanner.scala:79) ~[neo4j-fabric-4.4.6.jar:4.4.6]
	at org.neo4j.fabric.cache.FabricQueryCache.computeIfAbsent(FabricQueryCache.scala:52) ~[neo4j-fabric-4.4.6.jar:4.4.6]
	at org.neo4j.fabric.planning.FabricPlanner$PlannerInstance.plan$lzycompute(FabricPlanner.scala:80) ~[neo4j-fabric-4.4.6.jar:4.4.6]
	at org.neo4j.fabric.planning.FabricPlanner$PlannerInstance.plan(FabricPlanner.scala:76) ~[neo4j-fabric-4.4.6.jar:4.4.6]
	at org.neo4j.fabric.executor.FabricExecutor.run(FabricExecutor.java:123) ~[neo4j-fabric-4.4.6.jar:4.4.6]
	at org.neo4j.fabric.bolt.BoltFabricDatabaseService$BoltTransactionImpl.executeQuery(BoltFabricDatabaseService.java:186) ~[neo4j-fabric-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.runtime.statemachine.impl.AbstractTransactionStateMachineSPI$AbstractBoltResultHandle.start(AbstractTransactionStateMachineSPI.java:128) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.runtime.statemachine.impl.TransactionStateMachine$State.startExecution(TransactionStateMachine.java:530) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.runtime.statemachine.impl.TransactionStateMachine$State$2.run(TransactionStateMachine.java:326) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.runtime.statemachine.impl.TransactionStateMachine.run(TransactionStateMachine.java:89) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.runtime.statemachine.impl.TransactionStateMachine.run(TransactionStateMachine.java:82) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.transaction.StatementProcessorTxManager.runQuery(StatementProcessorTxManager.java:92) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.v4.runtime.InTransactionState.processRunMessage(InTransactionState.java:95) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.v4.runtime.InTransactionState.processUnsafe(InTransactionState.java:52) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.v3.runtime.FailSafeBoltStateMachineState.process(FailSafeBoltStateMachineState.java:48) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.runtime.statemachine.impl.AbstractBoltStateMachine.nextState(AbstractBoltStateMachine.java:154) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.runtime.statemachine.impl.AbstractBoltStateMachine.process(AbstractBoltStateMachine.java:102) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.messaging.BoltRequestMessageReader.lambda$doRead$1(BoltRequestMessageReader.java:93) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.runtime.DefaultBoltConnection.lambda$enqueue$0(DefaultBoltConnection.java:156) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.runtime.DefaultBoltConnection.processNextBatchInternal(DefaultBoltConnection.java:252) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.runtime.DefaultBoltConnection.processNextBatch(DefaultBoltConnection.java:187) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.runtime.DefaultBoltConnection.processNextBatch(DefaultBoltConnection.java:177) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.runtime.scheduling.ExecutorBoltScheduler.executeBatch(ExecutorBoltScheduler.java:257) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.runtime.scheduling.ExecutorBoltScheduler.lambda$scheduleBatchOrHandleError$3(ExecutorBoltScheduler.java:240) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1700) [?:?]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
	at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) [apoc-4.4.0.3-core.jar:4.4.0.3]
	at java.lang.Thread.run(Thread.java:829) [?:?]
2022-05-18 14:09:12.136+0000 ERROR [o.n.b.r.s.i.ErrorReporter] Client triggered an unexpected error [Neo.DatabaseError.General.UnknownError]: Lexical error at line 1, column 25.  Encountered: <EOF> after : "", reference b610d83e-23eb-4c4b-bd99-b753edb9e936.
2022-05-18 14:09:12.136+0000 ERROR [o.n.b.r.s.i.ErrorReporter] Client triggered an unexpected error [Neo.DatabaseError.General.UnknownError]: Lexical error at line 1, column 25.  Encountered: <EOF> after : "", reference b610d83e-23eb-4c4b-bd99-b753edb9e936.
org.neo4j.cypher.internal.parser.javacc.TokenMgrException: Lexical error at line 1, column 25.  Encountered: <EOF> after : ""
	at org.neo4j.cypher.internal.parser.javacc.CypherTokenManager.getNextToken(CypherTokenManager.java:7616) ~[neo4j-cypher-javacc-parser-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.parser.javacc.Cypher.jj_ntk_f(Cypher.java:23635) ~[neo4j-cypher-javacc-parser-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.parser.javacc.Cypher.SymbolicDatabaseNameStringOrParameter(Cypher.java:18004) ~[neo4j-cypher-javacc-parser-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.parser.javacc.Cypher.CreateDatabase(Cypher.java:17135) ~[neo4j-cypher-javacc-parser-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.parser.javacc.Cypher.CreateCommand(Cypher.java:7263) ~[neo4j-cypher-javacc-parser-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.parser.javacc.Cypher.SingleQueryOrCommand(Cypher.java:288) ~[neo4j-cypher-javacc-parser-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.parser.javacc.Cypher.Statement(Cypher.java:262) ~[neo4j-cypher-javacc-parser-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.parser.javacc.Cypher.Statements(Cypher.java:188) ~[neo4j-cypher-javacc-parser-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.ast.factory.neo4j.JavaCCParser$.parse(JavaCCParser.scala:54) ~[neo4j-cypher-ast-factory-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.compiler.helpers.Neo4jJavaCCParserWithFallback$.parse(Neo4jJavaCCParserWithFallback.scala:48) ~[neo4j-cypher-planner-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.compiler.phases.JavaccParsing$.process(JavaccParsing.scala:40) ~[neo4j-cypher-planner-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.compiler.phases.JavaccParsing$.process(JavaccParsing.scala:36) ~[neo4j-cypher-planner-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.phases.Phase.$anonfun$transform$1(Phase.scala:36) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.helpers.package$.$anonfun$closing$1(package.scala:24) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.helpers.package$.using(package.scala:32) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.helpers.package$.closing(package.scala:24) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.phases.Phase.transform(Phase.scala:35) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.phases.Phase.transform$(Phase.scala:33) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.compiler.phases.JavaccParsing$.transform(JavaccParsing.scala:36) ~[neo4j-cypher-planner-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.phases.PipeLine.transform(Transformer.scala:78) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.phases.PipeLine.transform(Transformer.scala:78) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.phases.PipeLine.transform(Transformer.scala:78) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.phases.PipeLine.transform(Transformer.scala:78) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.phases.PipeLine.transform(Transformer.scala:78) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.phases.PipeLine.transform(Transformer.scala:78) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.phases.PipeLine.transform(Transformer.scala:78) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.phases.PipeLine.transform(Transformer.scala:78) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.phases.PipeLine.transform(Transformer.scala:78) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.frontend.phases.PipeLine.transform(Transformer.scala:78) ~[neo4j-front-end-4.4.6.jar:4.4.6]
	at org.neo4j.fabric.pipeline.FabricFrontEnd$Pipeline$parseAndPrepare$.process(FabricFrontEnd.scala:139) ~[neo4j-fabric-4.4.6.jar:4.4.6]
	at org.neo4j.fabric.planning.FabricPlanner$PlannerInstance.$anonfun$computePlan$1(FabricPlanner.scala:87) ~[neo4j-fabric-4.4.6.jar:4.4.6]
	at org.neo4j.fabric.planning.FabricPlanner$PlannerInstance.trace(FabricPlanner.scala:127) ~[neo4j-fabric-4.4.6.jar:4.4.6]
	at org.neo4j.fabric.planning.FabricPlanner$PlannerInstance.computePlan(FabricPlanner.scala:86) ~[neo4j-fabric-4.4.6.jar:4.4.6]
	at org.neo4j.fabric.planning.FabricPlanner$PlannerInstance.$anonfun$plan$1(FabricPlanner.scala:79) ~[neo4j-fabric-4.4.6.jar:4.4.6]
	at org.neo4j.fabric.cache.FabricQueryCache.computeIfAbsent(FabricQueryCache.scala:52) ~[neo4j-fabric-4.4.6.jar:4.4.6]
	at org.neo4j.fabric.planning.FabricPlanner$PlannerInstance.plan$lzycompute(FabricPlanner.scala:80) ~[neo4j-fabric-4.4.6.jar:4.4.6]
	at org.neo4j.fabric.planning.FabricPlanner$PlannerInstance.plan(FabricPlanner.scala:76) ~[neo4j-fabric-4.4.6.jar:4.4.6]
	at org.neo4j.fabric.executor.FabricExecutor.run(FabricExecutor.java:123) ~[neo4j-fabric-4.4.6.jar:4.4.6]
	at org.neo4j.fabric.bolt.BoltFabricDatabaseService$BoltTransactionImpl.executeQuery(BoltFabricDatabaseService.java:186) ~[neo4j-fabric-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.runtime.statemachine.impl.AbstractTransactionStateMachineSPI$AbstractBoltResultHandle.start(AbstractTransactionStateMachineSPI.java:128) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.runtime.statemachine.impl.TransactionStateMachine$State.startExecution(TransactionStateMachine.java:530) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.runtime.statemachine.impl.TransactionStateMachine$State$2.run(TransactionStateMachine.java:326) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.runtime.statemachine.impl.TransactionStateMachine.run(TransactionStateMachine.java:89) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.runtime.statemachine.impl.TransactionStateMachine.run(TransactionStateMachine.java:82) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.transaction.StatementProcessorTxManager.runQuery(StatementProcessorTxManager.java:92) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.v4.runtime.InTransactionState.processRunMessage(InTransactionState.java:95) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.v4.runtime.InTransactionState.processUnsafe(InTransactionState.java:52) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.v3.runtime.FailSafeBoltStateMachineState.process(FailSafeBoltStateMachineState.java:48) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.runtime.statemachine.impl.AbstractBoltStateMachine.nextState(AbstractBoltStateMachine.java:154) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.runtime.statemachine.impl.AbstractBoltStateMachine.process(AbstractBoltStateMachine.java:102) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.messaging.BoltRequestMessageReader.lambda$doRead$1(BoltRequestMessageReader.java:93) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.runtime.DefaultBoltConnection.lambda$enqueue$0(DefaultBoltConnection.java:156) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.runtime.DefaultBoltConnection.processNextBatchInternal(DefaultBoltConnection.java:252) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.runtime.DefaultBoltConnection.processNextBatch(DefaultBoltConnection.java:187) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.runtime.DefaultBoltConnection.processNextBatch(DefaultBoltConnection.java:177) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.runtime.scheduling.ExecutorBoltScheduler.executeBatch(ExecutorBoltScheduler.java:257) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at org.neo4j.bolt.runtime.scheduling.ExecutorBoltScheduler.lambda$scheduleBatchOrHandleError$3(ExecutorBoltScheduler.java:240) ~[neo4j-bolt-4.4.6.jar:4.4.6]
	at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1700) [?:?]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
	at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) [apoc-4.4.0.3-core.jar:4.4.0.3]
	at java.lang.Thread.run(Thread.java:829) [?:?]
2

@tms quote="tms, post:1, topic:56498"]

2022-05-18 14:09:10.512+0000 ERROR [o.n.b.r.s.i.ErrorReporter] Client triggered an unexpected error [Neo.DatabaseError.General.UnknownError]: Lexical error at line 1, column 18.  Encountered: <EOF> after : "", reference 29b027af-d76d-47f8-b341-ae0b26b0764c.
org.neo4j.cypher.internal.parser.javacc.TokenMgrException: Lexical error at line 1, column 18.  Encountered: <EOF> after : ""
	at org.neo4j.cypher.internal.parser.javacc.CypherTokenManager.getNextToken(CypherTokenManager.java:7616) ~[neo4j-cypher-javacc-parser-4.4.6.jar:4.4.6]
	at org.neo4j.cypher.internal.parser.javacc.Cypher.jj_ntk_f(Cypher.java:23635) ~[neo4j-cypher-javacc-parser-4.4.6.jar:4.4.6]

[/quote]

would appear to indicate the cypher statement sent is somehow syntactically incorrect. Do you have the complete cypher statement? does the database name have any non alpha numeric characters in it, which would thus require enclosing the name in backticks?

3

The complete cypher statement was (and is):

CREATE DATABASE `covid-b`

Note the back-ticks. There is no complaint in the browser, and it apparently runs fine (aside from the errors reported in debug.log.

If it's helpful, I can forward more of debug.log, if it provides additional helpful context.

Here is the sequence that I generally follow:

  1. Drop the database ("DROP DATABASE covid-b")
  2. Create the database ("CREATE DATABASE covid-b")
  3. Stop the database ("STOP DATABASE covid-b")
  4. Load from a snapshot (using neo4j-admin, into covid-b)
  5. Start the database ("START DATABASE covid-b")

My daily ingestor script (in Python) automates this using a combination of shell commands and calls to the Python driver of Neo4J

Each snapshot is created from a related Python script that performs a backup. It's sequence is (all done from within the script):

  1. Stop the database ("STOP DATABASE covid-b")
  2. Use neo4j-admin to dump the database into a snapshot (mumble/covid-b.dump)
  3. Start the database ("START DATABASE covid-b")

I use two databases, covid-a and covid-b. One is always the current DATABASE_TO_QUERY (kept as an environment variable). The ingestor adds data to whichever database is not DATABASE_TO_QUERY. This allows me to do a daily increment each day, and each increment handles the most recent 2 days (typically) of data.

4

@tms

is the statement terminated by a ; ?

5

The statements done from the shell are terminated by a semi, yes.

The forum markup rules are stripping the back-ticks from the above. But yes, when these are run from Python scripts then each shell command is semi-colon terminated, and every reference to covid-a or covid-b is delimited by back-ticks.

I'm happy to take this a different media if it's more convenient. This may not be of interest to the larger audience. :)

One of the exercises I've been tempted to try is to completely remove Neo4J from the system, remove all of its files (/var/lib/neo4j, /var/log/neo4j, etc), re-install it, and then use neo4j-admin to load it from snapshots. I use just three databases, covid-a, covid-b, and covid-baseline (or covid-c).

I notice that the "metrics" directory (/var/lib/neo4j/metrics) is large (20G). I'm also nervous about detritus accumulating in /var/lib/neo4j/data/transactions.

In other production sites I've supported in the past, there have been mechanisms for periodically purging the files used by the database (such as MySQL or MongoDB). I'm not aware of any comparable mechanism for Neo4J.

6

@tms

purging...

so although we dont offer a direct command to purge if you set the parameters accordingly and at next checkpoint, i.e. defaults to every 15 minutes you should see the files managed per the parameters