I have stopped the neo4j server and then ran the neo4j-admin import command. this command loaded the data into database successfully. After loading data into database I have restarted the neo4j server and getting following error while running query on UI.
Database stop & start command
sudo service neo4j stop
sudo service neo4j start
Database version
enterprise casual cluster 4.0.4
Error on UI :-
Failed to obtain connection towards write server. Known routing table is: RoutingTable[database=graphene, expirationTime=1595537762299, currentTime=1595537462525, routers=[54.81.90.212:7687,34.205.29.59:7687], readers=[54.81.90.212:7687,34.205.29.59:7687], writers=]
Error in debug log :-
2020-07-23 20:59:11.089+0000 INFO [o.n.i.d.DiagnosticsManager] neostore.labeltokenstore.db: 2020-04-16T20:16:05+0000 - 0B
2020-07-23 20:59:11.097+0000 ERROR [c.n.c.e.PanicService] Clustering components for database 'graphene' have encountered a critical error Encountered error when attempting to reconcile database graphene from state 'EnterpriseDatabaseState{databaseId=DatabaseId{99b9a61c[graphene] }, operatorState=STOPPED, failed=false}' to state 'online'
java.lang.IllegalStateException: Encountered error when attempting to reconcile database graphene from state 'EnterpriseDatabaseState{databaseId=DatabaseId{99b9a61c[graphene] }, operatorState=STOPPED, fai
led=false}' to state 'online'
at com.neo4j.dbms.DbmsReconciler.reportErrorAndPanicDatabase(DbmsReconciler.java:435)
at com.neo4j.dbms.DbmsReconciler.handleReconciliationErrors(DbmsReconciler.java:420)
at com.neo4j.dbms.DbmsReconciler.lambda$postReconcile$14(DbmsReconciler.java:369)
at java.base/java.util.concurrent.ConcurrentHashMap.compute(ConcurrentHashMap.java:1908)
at com.neo4j.dbms.DbmsReconciler.postReconcile(DbmsReconciler.java:367)
at com.neo4j.dbms.DbmsReconciler.lambda$scheduleReconciliationJob$7(DbmsReconciler.java:234)
at java.base/java.util.concurrent.CompletableFuture.uniWhenComplete(CompletableFuture.java:859)
at java.base/java.util.concurrent.CompletableFuture$UniWhenComplete.tryFire(CompletableFuture.java:837)
at java.base/java.util.concurrent.CompletableFuture.postComplete(CompletableFuture.java:506)
at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1705)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: org.neo4j.dbms.api.DatabaseManagementException: Unable to start database DatabaseId{99b9a61c[graphene] }
at com.neo4j.dbms.database.ClusteredMultiDatabaseManager.startDatabase(ClusteredMultiDatabaseManager.java:71)
at com.neo4j.dbms.database.ClusteredMultiDatabaseManager.startDatabase(ClusteredMultiDatabaseManager.java:31)
at com.neo4j.dbms.database.MultiDatabaseManager.forSingleDatabase(MultiDatabaseManager.java:112)
at com.neo4j.dbms.database.MultiDatabaseManager.startDatabase(MultiDatabaseManager.java:98)
at com.neo4j.dbms.DbmsReconciler.start(DbmsReconciler.java:537)
at com.neo4j.dbms.Transitions$TransitionFunction.lambda$prepare$0(Transitions.java:219)
at com.neo4j.dbms.DbmsReconciler.doTransitionStep(DbmsReconciler.java:335)
at com.neo4j.dbms.DbmsReconciler.doTransitionStep(DbmsReconciler.java:336)
at com.neo4j.dbms.DbmsReconciler.doTransitions(DbmsReconciler.java:318)
at com.neo4j.dbms.DbmsReconciler.lambda$doTransitions$9(DbmsReconciler.java:308)
at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1700)
... 3 more
Caused by: org.neo4j.kernel.lifecycle.LifecycleException: Component 'org.neo4j.kernel.database.Database@e85c125' was successfully initialized, but failed to start. Please see the attached cause exception "We must have at least one transaction telling us where we are at in the consensus log.".
at org.neo4j.kernel.lifecycle.LifeSupport$LifecycleInstance.start(LifeSupport.java:465)
at org.neo4j.kernel.lifecycle.LifeSupport.start(LifeSupport.java:111)
at com.neo4j.causalclustering.common.ClusteredDatabase.start(ClusteredDatabase.java:39)
at com.neo4j.dbms.database.ClusteredMultiDatabaseManager.startDatabase(ClusteredMultiDatabaseManager.java:67)
... 13 more
Caused by: java.lang.RuntimeException: java.lang.RuntimeException: We must have at least one transaction telling us where we are at in the consensus log.
at org.neo4j.kernel.database.Database.start(Database.java:478)
at org.neo4j.kernel.lifecycle.LifeSupport$LifecycleInstance.start(LifeSupport.java:444)
... 16 more
Caused by: java.lang.RuntimeException: We must have at least one transaction telling us where we are at in the consensus log.
at com.neo4j.causalclustering.core.state.machines.tx.LastCommittedIndexFinder.getLastCommittedIndex(LastCommittedIndexFinder.java:67)
at com.neo4j.causalclustering.core.state.machines.tx.RecoverConsensusLogIndex.findLastAppliedIndex(RecoverConsensusLogIndex.java:33)
at com.neo4j.causalclustering.core.state.machines.CoreStateMachines.installCommitProcess(CoreStateMachines.java:95)
at com.neo4j.causalclustering.core.CoreCommitProcessFactory.initializeCommitProcessForStateMachines(CoreCommitProcessFactory.java:51)
at com.neo4j.causalclustering.core.CoreCommitProcessFactory.create(CoreCommitProcessFactory.java:40)
at org.neo4j.kernel.database.Database.buildKernel(Database.java:630)
at org.neo4j.kernel.database.Database.start(Database.java:421)
... 17 more
2020-07-23 20:59:11.116+0000 INFO [o.n.i.d.DiagnosticsManager] neostore.labeltokenstore.db.id: 2020-07-23T20:59:11+0000 - 40.00KiB
2020-07-23 20:59:11.116+0000 INFO [o.n.i.d.DiagnosticsManager] neostore.labeltokenstore.db.names: 2020-04-16T20:16:05+0000 - 7.979KiB
Regards,
Rambalak