cancel
Showing results for 
Search instead for 
Did you mean: 

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

Unable to start database after bulk import

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

2 REPLIES 2

did you then seed each of the cluster members with the database produced from neo4j-admin import and as described at https://neo4j.com/docs/operations-manual/4.0/clustering/seed/#causal-clustering-seed-import ???

Hi @dana.canzano,

This doc talks about creating seeding system dumps. I understand how to stop the database and create a dump from an db offline. However, how do we create a dump for the system database?

Also, a quick question regarding the enterprise release docker image? How do we start a trial version of the image for testing? I have already signed up a for trial.

Thanks.