因果集群数据库备份后,cypher查询异常
发布于 13 天前 作者 shensh 67 次浏览 来自 问答

您好, 我用企业版在配集群时,按照文档上的步骤,现在在尝试备份和恢复,恢复后集群显示正常,但是我在cypher增加点时,发生了异常,异常如图所示exception.jpg

4 回复

可以把节点的错误日志、neo4j.conf文件上传上来吗?

之前刚配好集群时,可以进行节点的增删改查操作,集群中的Core Servers也能进行数据同步。然后load了别的数据库,现在观察集群状态正常,但是进行cypher进行增加节点时,报了上面这个异常,请问大概是什么原因?

2018-02-06 10:46:42.265+0000 ERROR [o.n.b.v.r.ErrorReporter] Client triggered an unexpected error [UnknownError]: IdAllocation state is probably corrupted or out of sync with the cluster. Local highId is 703861 and allocation range is IdRange[16384-17407, defrag []], reference f9570d68-4a4b-4f0a-8269-2e004be7ea98. 2018-02-06 10:46:42.265+0000 ERROR [o.n.b.v.r.ErrorReporter] Client triggered an unexpected error [UnknownError]: IdAllocation state is probably corrupted or out of sync with the cluster. Local highId is 703861 and allocation range is IdRange[16384-17407, defrag []], reference f9570d68-4a4b-4f0a-8269-2e004be7ea98. IdAllocation state is probably corrupted or out of sync with the cluster. Local highId is 703861 and allocation range is IdRange[16384-17407, defrag []] java.lang.IllegalStateException: IdAllocation state is probably corrupted or out of sync with the cluster. Local highId is 703861 and allocation range is IdRange[16384-17407, defrag []] at org.neo4j.causalclustering.core.state.machines.id.ReplicatedIdGenerator.respectingHighId(ReplicatedIdGenerator.java:243) at org.neo4j.causalclustering.core.state.machines.id.ReplicatedIdGenerator.storeLocally(ReplicatedIdGenerator.java:228) at org.neo4j.causalclustering.core.state.machines.id.ReplicatedIdGenerator.acquireNextIdBatch(ReplicatedIdGenerator.java:138) at org.neo4j.causalclustering.core.state.machines.id.ReplicatedIdGenerator.nextIdBatch(ReplicatedIdGenerator.java:152) at org.neo4j.kernel.impl.store.id.IdGenerator$Delegate.nextIdBatch(IdGenerator.java:68) at org.neo4j.kernel.impl.store.id.IdGenerator$Delegate.nextIdBatch(IdGenerator.java:68) at org.neo4j.kernel.impl.store.CommonAbstractStore.nextIdBatch(CommonAbstractStore.java:585) at org.neo4j.kernel.impl.store.id.RenewableBatchIdSequence.nextId(RenewableBatchIdSequence.java:74) at org.neo4j.kernel.impl.store.id.RenewableBatchIdSequences.nextId(RenewableBatchIdSequences.java:55) at org.neo4j.kernel.impl.storageengine.impl.recordstorage.RecordStorageCommandCreationContext.nextId(RecordStorageCommandCreationContext.java:75) at org.neo4j.kernel.impl.storageengine.impl.recordstorage.StoreStatement.reserveNode(StoreStatement.java:274) at org.neo4j.kernel.impl.api.StateHandlingStatementOperations.nodeCreate(StateHandlingStatementOperations.java:418) at org.neo4j.kernel.impl.api.ConstraintEnforcingEntityOperations.nodeCreate(ConstraintEnforcingEntityOperations.java:452) at org.neo4j.kernel.impl.api.LockingStatementOperations.nodeCreate(LockingStatementOperations.java:284) at org.neo4j.kernel.impl.api.OperationsFacade.nodeCreate(OperationsFacade.java:839) at org.neo4j.kernel.impl.factory.GraphDatabaseFacade.createNodeId(GraphDatabaseFacade.java:280) at org.neo4j.cypher.javacompat.internal.GraphDatabaseCypherService.createNodeId(GraphDatabaseCypherService.java:64) at org.neo4j.cypher.internal.spi.v3_3.TransactionBoundQueryContext.createNodeId(TransactionBoundQueryContext.scala:103) at org.neo4j.cypher.internal.compatibility.v3_3.ExceptionTranslatingQueryContext$$anonfun$createNodeId$1.apply$mcJ$sp(ExceptionTranslatingQueryContext.scala:54) at org.neo4j.cypher.internal.compatibility.v3_3.ExceptionTranslatingQueryContext$$anonfun$createNodeId$1.apply(ExceptionTranslatingQueryContext.scala:54) at org.neo4j.cypher.internal.compatibility.v3_3.ExceptionTranslatingQueryContext$$anonfun$createNodeId$1.apply(ExceptionTranslatingQueryContext.scala:54) at org.neo4j.cypher.internal.spi.v3_3.ExceptionTranslationSupport$class.translateException(ExceptionTranslationSupport.scala:32) at org.neo4j.cypher.internal.compatibility.v3_3.ExceptionTranslatingQueryContext.translateException(ExceptionTranslatingQueryContext.scala:39) at org.neo4j.cypher.internal.compatibility.v3_3.ExceptionTranslatingQueryContext.createNodeId(ExceptionTranslatingQueryContext.scala:54) at org.neo4j.cypher.internal.spi.v3_3.UpdateCountingQueryContext.createNodeId(UpdateCountingQueryContext.scala:74) at org.neo4j.cypher.internal.compatibility.v3_3.runtime.slotted.pipes.BaseCreateNodeSlottedPipe$$anonfun$internalCreateResults$1.apply(CreateNodeSlottedPipe.scala:45) at org.neo4j.cypher.internal.compatibility.v3_3.runtime.slotted.pipes.BaseCreateNodeSlottedPipe$$anonfun$internalCreateResults$1.apply(CreateNodeSlottedPipe.scala:44) at scala.collection.Iterator$$anon$11.next(Iterator.scala:410) at scala.collection.Iterator$$anon$11.next(Iterator.scala:410) at org.neo4j.cypher.internal.compatibility.v3_3.runtime.ClosingIterator$$anonfun$next$1.apply(ResultIterator.scala:70) at org.neo4j.cypher.internal.compatibility.v3_3.runtime.ClosingIterator$$anonfun$next$1.apply(ResultIterator.scala:67) at org.neo4j.cypher.internal.compatibility.v3_3.runtime.ClosingIterator$$anonfun$failIfThrows$1.apply(ResultIterator.scala:84) at org.neo4j.cypher.internal.compatibility.v3_3.runtime.ClosingIterator.decoratedCypherException(ResultIterator.scala:93) at org.neo4j.cypher.internal.compatibility.v3_3.runtime.ClosingIterator.failIfThrows(ResultIterator.scala:82) at org.neo4j.cypher.internal.compatibility.v3_3.runtime.ClosingIterator.next(ResultIterator.scala:67) at org.neo4j.cypher.internal.compatibility.v3_3.runtime.ClosingIterator.next(ResultIterator.scala:48) at scala.collection.Iterator$class.foreach(Iterator.scala:891) at org.neo4j.cypher.internal.compatibility.v3_3.runtime.ClosingIterator.foreach(ResultIterator.scala:48) at scala.collection.generic.Growable$class.$plus$plus$eq(Growable.scala:59) at scala.collection.mutable.ListBuffer.$plus$plus$eq(ListBuffer.scala:183) at scala.collection.mutable.ListBuffer.$plus$plus$eq(ListBuffer.scala:45) at scala.collection.TraversableOnce$class.to(TraversableOnce.scala:310) at org.neo4j.cypher.internal.compatibility.v3_3.runtime.ClosingIterator.to(ResultIterator.scala:48) at scala.collection.TraversableOnce$class.toList(TraversableOnce.scala:294) at org.neo4j.cypher.internal.compatibility.v3_3.runtime.ClosingIterator.toList(ResultIterator.scala:48) at org.neo4j.cypher.internal.compatibility.v3_3.runtime.EagerResultIterator.<init>(ResultIterator.scala:34) at org.neo4j.cypher.internal.compatibility.v3_3.runtime.ClosingIterator.toEager(ResultIterator.scala:52) at org.neo4j.cypher.internal.compatibility.v3_3.runtime.executionplan.DefaultExecutionResultBuilderFactory$ExecutionWorkflowBuilder.buildResultIterator(DefaultExecutionResultBuilderFactory.scala:120) at org.neo4j.cypher.internal.compatibility.v3_3.runtime.executionplan.DefaultExecutionResultBuilderFactory$ExecutionWorkflowBuilder.createResults(DefaultExecutionResultBuilderFactory.scala:103) at org.neo4j.cypher.internal.compatibility.v3_3.runtime.executionplan.DefaultExecutionResultBuilderFactory$ExecutionWorkflowBuilder.build(DefaultExecutionResultBuilderFactory.scala:74) at org.neo4j.cypher.internal.compatibility.v3_3.runtime.BuildInterpretedExecutionPlan$$anonfun$getExecutionPlanFunction$1.apply(BuildInterpretedExecutionPlan.scala:101) at org.neo4j.cypher.internal.compatibility.v3_3.runtime.BuildInterpretedExecutionPlan$$anonfun$getExecutionPlanFunction$1.apply(BuildInterpretedExecutionPlan.scala:84) at org.neo4j.cypher.internal.BuildSlottedExecutionPlan$SlottedExecutionPlan.run(BuildSlottedExecutionPlan.scala:102) at org.neo4j.cypher.internal.compatibility.v3_3.Compatibility$ExecutionPlanWrapper$$anonfun$run$1.apply(Compatibility.scala:182) at org.neo4j.cypher.internal.compatibility.v3_3.Compatibility$ExecutionPlanWrapper$$anonfun$run$1.apply(Compatibility.scala:178) at org.neo4j.cypher.internal.compatibility.v3_3.exceptionHandler$runSafely$.apply(exceptionHandler.scala:90) at org.neo4j.cypher.internal.compatibility.v3_3.Compatibility$ExecutionPlanWrapper.run(Compatibility.scala:178) at org.neo4j.cypher.internal.PreparedPlanExecution.execute(PreparedPlanExecution.scala:29) at org.neo4j.cypher.internal.ExecutionEngine.execute(ExecutionEngine.scala:116) at org.neo4j.cypher.internal.javacompat.ExecutionEngine.executeQuery(ExecutionEngine.java:62) at org.neo4j.bolt.v1.runtime.TransactionStateMachineSPI$1.start(TransactionStateMachineSPI.java:146) at org.neo4j.bolt.v1.runtime.TransactionStateMachine$State$1.run(TransactionStateMachine.java:247) at org.neo4j.bolt.v1.runtime.TransactionStateMachine.run(TransactionStateMachine.java:82) at org.neo4j.bolt.v1.runtime.BoltStateMachine$State$2.run(BoltStateMachine.java:408) at org.neo4j.bolt.v1.runtime.BoltStateMachine.run(BoltStateMachine.java:200) at org.neo4j.bolt.v1.messaging.BoltMessageRouter.lambda$onRun$3(BoltMessageRouter.java:93) at org.neo4j.bolt.v1.runtime.concurrent.RunnableBoltWorker.execute(RunnableBoltWorker.java:139) at org.neo4j.bolt.v1.runtime.concurrent.RunnableBoltWorker.run(RunnableBoltWorker.java:92) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) at org.neo4j.helpers.NamedThreadFactory$2.run(NamedThreadFactory.java:109)

在restore之前,在每个节点上运行unbind命令就可以了:

neo4j-admin unbind [–database=<name>]

相关文档:https://neo4j.com/docs/operations-manual/current/clustering/causal-clustering/setup-new-cluster/#unbind-instance-from-cluster

回到顶部