ERROR importing dump from Aura: Database 'neo4j' is unavailable

Neo4j Graph Platform
, , , ,
1

Hello together,

I have tried searching for the issue and haven't found something that could help me.

After exporting a dump file from Aurda DB, I wanted to import the dump into a local DB, so that I can analyze my graph with SemSpect (>119 k relationships). However, when importing to an existing project or creating a new project from the dump, the created databse is offline and cannot be accessed. I get following error:

Database 'neo4j' is unavailable. Run :sysinfo for more info.

Sorry if this posst is redundant, I ave a little time pressure :confused:

Kind regards,

(Showing last 100 lines...)
2022-11-28 11:19:04.031+0000 WARN [o.n.k.d.Database] [neo4j/3bb86def] Exception occurred while starting the database. Trying to stop already started components.
java.lang.IllegalArgumentException: The read version string length 99 is not proper.
at org.neo4j.kernel.impl.store.MetaDataStore.versionLongToString(MetaDataStore.java:910) ~[neo4j-record-storage-engine-4.4.0.jar:4.4.0]
at org.neo4j.kernel.impl.store.format.RecordFormatSelector.selectForStore(RecordFormatSelector.java:159) ~[neo4j-record-storage-engine-4.4.0.jar:4.4.0]
at org.neo4j.kernel.impl.store.format.RecordFormatSelector.selectNewestFormat(RecordFormatSelector.java:280) ~[neo4j-record-storage-engine-4.4.0.jar:4.4.0]
at org.neo4j.kernel.impl.storemigration.RecordStoreVersionCheck.configuredVersion(RecordStoreVersionCheck.java:169) ~[neo4j-record-storage-engine-4.4.0.jar:4.4.0]
at org.neo4j.kernel.impl.storemigration.RecordStoreVersionCheck.(RecordStoreVersionCheck.java:56) ~[neo4j-record-storage-engine-4.4.0.jar:4.4.0]
at org.neo4j.internal.recordstorage.RecordStorageEngineFactory.versionCheck(RecordStorageEngineFactory.java:128) ~[neo4j-record-storage-engine-4.4.0.jar:4.4.0]
at org.neo4j.kernel.impl.storemigration.DatabaseMigrator.migrate(DatabaseMigrator.java:90) ~[neo4j-kernel-4.4.0.jar:4.4.0]
at org.neo4j.kernel.database.Database.upgradeStore(Database.java:681) ~[neo4j-kernel-4.4.0.jar:4.4.0]
at org.neo4j.kernel.database.Database.start(Database.java:411) ~[neo4j-kernel-4.4.0.jar:4.4.0]
at org.neo4j.kernel.lifecycle.LifeSupport$LifecycleInstance.start(LifeSupport.java:442) ~[neo4j-common-4.4.0.jar:4.4.0]
at org.neo4j.kernel.lifecycle.LifeSupport.start(LifeSupport.java:110) ~[neo4j-common-4.4.0.jar:4.4.0]
at com.neo4j.dbms.database.EnterpriseDatabase.start(EnterpriseDatabase.java:40) ~[neo4j-dbms-enterprise-4.4.0.jar:4.4.0]
at com.neo4j.dbms.database.MultiDatabaseManager.startDatabase0(MultiDatabaseManager.java:204) ~[neo4j-dbms-enterprise-4.4.0.jar:4.4.0]
at com.neo4j.dbms.database.MultiDatabaseManager.startDatabase(MultiDatabaseManager.java:183) ~[neo4j-dbms-enterprise-4.4.0.jar:4.4.0]
at com.neo4j.dbms.database.MultiDatabaseManager.forSingleDatabase(MultiDatabaseManager.java:147) ~[neo4j-dbms-enterprise-4.4.0.jar:4.4.0]
at com.neo4j.dbms.database.MultiDatabaseManager.startDatabase(MultiDatabaseManager.java:125) ~[neo4j-dbms-enterprise-4.4.0.jar:4.4.0]
at com.neo4j.dbms.Transition$Prepared.doTransitionAction(Transition.java:101) ~[neo4j-dbms-enterprise-4.4.0.jar:4.4.0]
at com.neo4j.dbms.Transition$Prepared.doTransition(Transition.java:88) ~[neo4j-dbms-enterprise-4.4.0.jar:4.4.0]
at com.neo4j.dbms.DbmsReconciler.doTransitionStep(DbmsReconciler.java:245) ~[neo4j-dbms-enterprise-4.4.0.jar:4.4.0]
at com.neo4j.dbms.DbmsReconciler.doTransitionStep(DbmsReconciler.java:246) ~[neo4j-dbms-enterprise-4.4.0.jar:4.4.0]
at com.neo4j.dbms.DbmsReconciler.doTransitionStep(DbmsReconciler.java:246) ~[neo4j-dbms-enterprise-4.4.0.jar:4.4.0]
at com.neo4j.dbms.DbmsReconciler.doTransitionSteps(DbmsReconciler.java:230) ~[neo4j-dbms-enterprise-4.4.0.jar:4.4.0]
at com.neo4j.dbms.DbmsReconciler.executeJob(DbmsReconciler.java:183) ~[neo4j-dbms-enterprise-4.4.0.jar:4.4.0]
at com.neo4j.dbms.DbmsReconciler.lambda$scheduleReconciliationJob$2(DbmsReconciler.java:166) ~[neo4j-dbms-enterprise-4.4.0.jar:4.4.0]
at com.neo4j.dbms.ReconcilerJob.executeJob(ReconcilerJob.java:52) ~[neo4j-dbms-enterprise-4.4.0.jar:4.4.0]
at com.neo4j.dbms.ReconcilerJobManager$ReconciliationWorker.run(ReconcilerJobManager.java:240) ~[neo4j-dbms-enterprise-4.4.0.jar:4.4.0]
at org.neo4j.kernel.impl.scheduler.ThreadPool.lambda$asCallable$1(ThreadPool.java:151) ~[neo4j-kernel-4.4.0.jar:4.4.0]
at org.neo4j.kernel.impl.scheduler.ThreadPool.lambda$submit$0(ThreadPool.java:115) ~[neo4j-kernel-4.4.0.jar:4.4.0]
at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
at java.lang.Thread.run(Thread.java:834) [?:?]
2022-11-28 11:19:04.039+0000 ERROR [c.n.d.DbmsReconciler] Encountered error when attempting to reconcile database neo4j (request by Startup:1) to state 'online', database remains in state 'offline'
org.neo4j.dbms.api.DatabaseManagementException: Unable to start database `DatabaseId{3bb86def[neo4j]}`
at com.neo4j.dbms.database.MultiDatabaseManager.unableToStartDatabase(MultiDatabaseManager.java:198) ~[neo4j-dbms-enterprise-4.4.0.jar:4.4.0]
at com.neo4j.dbms.database.MultiDatabaseManager.startDatabase(MultiDatabaseManager.java:187) ~[neo4j-dbms-enterprise-4.4.0.jar:4.4.0]
at com.neo4j.dbms.database.MultiDatabaseManager.forSingleDatabase(MultiDatabaseManager.java:147) ~[neo4j-dbms-enterprise-4.4.0.jar:4.4.0]
at com.neo4j.dbms.database.MultiDatabaseManager.startDatabase(MultiDatabaseManager.java:125) ~[neo4j-dbms-enterprise-4.4.0.jar:4.4.0]
at com.neo4j.dbms.Transition$Prepared.doTransitionAction(Transition.java:101) ~[neo4j-dbms-enterprise-4.4.0.jar:4.4.0]
at com.neo4j.dbms.Transition$Prepared.doTransition(Transition.java:88) ~[neo4j-dbms-enterprise-4.4.0.jar:4.4.0]
at com.neo4j.dbms.DbmsReconciler.doTransitionStep(DbmsReconciler.java:245) ~[neo4j-dbms-enterprise-4.4.0.jar:4.4.0]
at com.neo4j.dbms.DbmsReconciler.doTransitionStep(DbmsReconciler.java:246) ~[neo4j-dbms-enterprise-4.4.0.jar:4.4.0]
at com.neo4j.dbms.DbmsReconciler.doTransitionStep(DbmsReconciler.java:246) ~[neo4j-dbms-enterprise-4.4.0.jar:4.4.0]
at com.neo4j.dbms.DbmsReconciler.doTransitionSteps(DbmsReconciler.java:230) ~[neo4j-dbms-enterprise-4.4.0.jar:4.4.0]
at com.neo4j.dbms.DbmsReconciler.executeJob(DbmsReconciler.java:183) ~[neo4j-dbms-enterprise-4.4.0.jar:4.4.0]
at com.neo4j.dbms.DbmsReconciler.lambda$scheduleReconciliationJob$2(DbmsReconciler.java:166) ~[neo4j-dbms-enterprise-4.4.0.jar:4.4.0]
at com.neo4j.dbms.ReconcilerJob.executeJob(ReconcilerJob.java:52) ~[neo4j-dbms-enterprise-4.4.0.jar:4.4.0]
at com.neo4j.dbms.ReconcilerJobManager$ReconciliationWorker.run(ReconcilerJobManager.java:240) ~[neo4j-dbms-enterprise-4.4.0.jar:4.4.0]
at org.neo4j.kernel.impl.scheduler.ThreadPool.lambda$asCallable$1(ThreadPool.java:151) ~[neo4j-kernel-4.4.0.jar:4.4.0]
at org.neo4j.kernel.impl.scheduler.ThreadPool.lambda$submit$0(ThreadPool.java:115) ~[neo4j-kernel-4.4.0.jar:4.4.0]
at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
at java.lang.Thread.run(Thread.java:834) [?:?]
Caused by: org.neo4j.kernel.lifecycle.LifecycleException: Component 'org.neo4j.kernel.database.Database@3356f1f6' was successfully initialized, but failed to start. Please see the attached cause exception "The read version string length 99 is not proper.".
at org.neo4j.kernel.lifecycle.LifeSupport$LifecycleInstance.start(LifeSupport.java:463) ~[neo4j-common-4.4.0.jar:4.4.0]
at org.neo4j.kernel.lifecycle.LifeSupport.start(LifeSupport.java:110) ~[neo4j-common-4.4.0.jar:4.4.0]
at com.neo4j.dbms.database.EnterpriseDatabase.start(EnterpriseDatabase.java:40) ~[neo4j-dbms-enterprise-4.4.0.jar:4.4.0]
at com.neo4j.dbms.database.MultiDatabaseManager.startDatabase0(MultiDatabaseManager.java:204) ~[neo4j-dbms-enterprise-4.4.0.jar:4.4.0]
at com.neo4j.dbms.database.MultiDatabaseManager.startDatabase(MultiDatabaseManager.java:183) ~[neo4j-dbms-enterprise-4.4.0.jar:4.4.0]
... 18 more
Caused by: java.lang.RuntimeException: java.lang.IllegalArgumentException: The read version string length 99 is not proper.
at org.neo4j.kernel.database.Database.handleStartupFailure(Database.java:638) ~[neo4j-kernel-4.4.0.jar:4.4.0]
at org.neo4j.kernel.database.Database.start(Database.java:532) ~[neo4j-kernel-4.4.0.jar:4.4.0]
at org.neo4j.kernel.lifecycle.LifeSupport$LifecycleInstance.start(LifeSupport.java:442) ~[neo4j-common-4.4.0.jar:4.4.0]
at org.neo4j.kernel.lifecycle.LifeSupport.start(LifeSupport.java:110) ~[neo4j-common-4.4.0.jar:4.4.0]
at com.neo4j.dbms.database.EnterpriseDatabase.start(EnterpriseDatabase.java:40) ~[neo4j-dbms-enterprise-4.4.0.jar:4.4.0]
at com.neo4j.dbms.database.MultiDatabaseManager.startDatabase0(MultiDatabaseManager.java:204) ~[neo4j-dbms-enterprise-4.4.0.jar:4.4.0]
at com.neo4j.dbms.database.MultiDatabaseManager.startDatabase(MultiDatabaseManager.java:183) ~[neo4j-dbms-enterprise-4.4.0.jar:4.4.0]
... 18 more
Caused by: java.lang.IllegalArgumentException: The read version string length 99 is not proper.
at org.neo4j.kernel.impl.store.MetaDataStore.versionLongToString(MetaDataStore.java:910) ~[neo4j-record-storage-engine-4.4.0.jar:4.4.0]
at org.neo4j.kernel.impl.store.format.RecordFormatSelector.selectForStore(RecordFormatSelector.java:159) ~[neo4j-record-storage-engine-4.4.0.jar:4.4.0]
at org.neo4j.kernel.impl.store.format.RecordFormatSelector.selectNewestFormat(RecordFormatSelector.java:280) ~[neo4j-record-storage-engine-4.4.0.jar:4.4.0]
at org.neo4j.kernel.impl.storemigration.RecordStoreVersionCheck.configuredVersion(RecordStoreVersionCheck.java:169) ~[neo4j-record-storage-engine-4.4.0.jar:4.4.0]
at org.neo4j.kernel.impl.storemigration.RecordStoreVersionCheck.(RecordStoreVersionCheck.java:56) ~[neo4j-record-storage-engine-4.4.0.jar:4.4.0]
at org.neo4j.internal.recordstorage.RecordStorageEngineFactory.versionCheck(RecordStorageEngineFactory.java:128) ~[neo4j-record-storage-engine-4.4.0.jar:4.4.0]
at org.neo4j.kernel.impl.storemigration.DatabaseMigrator.migrate(DatabaseMigrator.java:90) ~[neo4j-kernel-4.4.0.jar:4.4.0]
at org.neo4j.kernel.database.Database.upgradeStore(Database.java:681) ~[neo4j-kernel-4.4.0.jar:4.4.0]
at org.neo4j.kernel.database.Database.start(Database.java:411) ~[neo4j-kernel-4.4.0.jar:4.4.0]
at org.neo4j.kernel.lifecycle.LifeSupport$LifecycleInstance.start(LifeSupport.java:442) ~[neo4j-common-4.4.0.jar:4.4.0]
at org.neo4j.kernel.lifecycle.LifeSupport.start(LifeSupport.java:110) ~[neo4j-common-4.4.0.jar:4.4.0]
at com.neo4j.dbms.database.EnterpriseDatabase.start(EnterpriseDatabase.java:40) ~[neo4j-dbms-enterprise-4.4.0.jar:4.4.0]
at com.neo4j.dbms.database.MultiDatabaseManager.startDatabase0(MultiDatabaseManager.java:204) ~[neo4j-dbms-enterprise-4.4.0.jar:4.4.0]
at com.neo4j.dbms.database.MultiDatabaseManager.startDatabase(MultiDatabaseManager.java:183) ~[neo4j-dbms-enterprise-4.4.0.jar:4.4.0]
... 18 more
2022-11-28 11:19:04.040+0000 INFO [c.n.d.DbmsReconciler] Database 'neo4j' transition is complete from INITIAL{db=neo4j/3bb86def} to FAILED/STOPPED{db=neo4j/3bb86def} (request by Startup:1)
2022-11-28 11:19:04.040+0000 INFO [c.n.d.StartupOperator] All databases were reconciled at startup
2022-11-28 11:19:04.040+0000 INFO [o.n.b.t.DefaultReconciledTransactionTracker] Enabling with transaction ID 73
2022-11-28 11:19:05.083+0000 INFO [c.n.c.n.Server] [backup-server] bound to '127.0.0.1:6362' with transport 'NioServerSocketChannel'
2022-11-28 11:19:06.337+0000 INFO [c.n.m.g.GlobalMetricsExtension] Sending metrics to CSV file at C:\Users\~\.Neo4jDesktop\relate-data\dbmss\dbms-a71147f4-9115-456e-b10e-8270a5f5d3a4\metrics
2022-11-28 11:19:06.358+0000 INFO [o.n.b.BoltServer] Bolt enabled on 127.0.0.1:7687.
2022-11-28 11:19:06.358+0000 INFO [o.n.s.AbstractNeoWebServer$ServerComponentsLifecycleAdapter] Starting web server
2022-11-28 11:19:07.103+0000 INFO [c.n.s.e.EnterpriseNeoWebServer] Remote interface available at http://localhost:7474/
2022-11-28 11:19:07.103+0000 INFO [o.n.s.AbstractNeoWebServer$ServerComponentsLifecycleAdapter] Web server started.
2022-11-28 11:19:07.106+0000 INFO [o.n.g.f.DatabaseManagementServiceFactory] id: 160A1C682F455BB99C28DA7013A7FC765231B535EF7044678E512CA187530B78
2022-11-28 11:19:07.106+0000 INFO [o.n.g.f.DatabaseManagementServiceFactory] name: system
2022-11-28 11:19:07.107+0000 INFO [o.n.g.f.DatabaseManagementServiceFactory] creationDate: 2022-11-28T11:16:52.288Z

2

Hi,

it is really hard to provide an answer without knowing anything about the database you created and downloaded from Aura. The error is about the DBMS failing to read and understand the metadata from the store. I can see from the stack trace that you are running Neo4j 4.4.0 locally. I would assume that the database in Aura was created as version 5 and that is why 4.4 failed to read the metadata, because the format changed between 4.x and 5.

I would recommend downloading Neo4j 5 and trying with that one.

3

@Jonnyfoka

given the stack trace it appears there is some mismatch for the record store format of the graph. Is your Aura instance on the same version of Neo4j as your local instance in Neo4j Desktop?

4

Hi,

thank you very much for the quick responses. It seems it has to do with the different versions of the database my local instance was at 4.4.0 while aura at 5.

Following the suggestion of I installed the newest version of desktop. However, I was not able to create a 5.x database, as it does not fetch the database when starting it.

Am I missing something in the installation? I thought installing Neo4j Desktop 5.x will automatically install the necessary database versions.

Kind regards,

Jonnyfoka_0-1669799926954.png