I've been trying out the new "Superfast Batch Importer": https://github.com/neo4j-contrib/superfast-batch-importer
It looks very promising, but I'm having a few problems. Help? Background My real files will be enormous (eg, 100M rels), so I'm using moderate-sized test files: $ wc -l tmp/[nr]* 128299 tmp/nodes.csv 92661 tmp/rels.csv 220960 total Here is my batch.properties file, set up for a 32GB, 8-core Mac Pro, running OSX 10.7.5: cache_type=none use_memory_mapped_buffers=true # 14 bytes per node neostore.nodestore.db.mapped_memory=2G # 33 bytes per relationship neostore.relationshipstore.db.mapped_memory=20G # 38 bytes per property neostore.propertystore.db.mapped_memory=1G # 60 bytes per long-string block neostore.propertystore.db.strings.mapped_memory=1G neostore.propertystore.db.index.keys.mapped_memory=50M neostore.propertystore.db.index.mapped_memory=50M # set up indexing batch_import.node_index.Xhas_airport_code=exact batch_import.node_index.XhasArea=exact batch_import.node_index.Xhas_family_name=exact batch_import.node_index.Xhas_GeoNames_Class_ID=exact batch_import.node_index.Xhas_GeoNames_Entity_ID=exact batch_import.node_index.Xhas_given_name=exact batch_import.node_index.Xhas_gloss=exact batch_import.node_index.Xhas_ISBN=exact batch_import.node_index.Xhas_IMDB=exact batch_import.node_index.Xhas_language_code=exact batch_import.node_index.Xhas_motto=exact batch_import.node_index.Xhas_official_language=exact batch_import.node_index.Xhas_Synset_ID=exact batch_import.node_index.Xhas_top-level_domain=exact batch_import.node_index.Xhas_three-letter_language_code=exact batch_import.node_index.Xis_preferred_meaning_of=exact batch_import.node_index.Xlabel=exact batch_import.node_index.Xns_name=exact batch_import.node_index.Xpreferred_label=exact Behavior My Terminal output looks rather messy; perhaps some output buffering tweaks or newlines are needed: $ time import.sh test.db -nodes ../nodes.csv -rels ../rels.csv Neo4j Data Importer Importer -db-directory <graph.db> -nodes <nodes.csv> -rels <rels.csv> -debug <debug config> Using Existing Configuration File [Current time:2014-05-31 15:11:32.258][Compile Time:Importer $ batch-import-2.1.0 $ 31/05/2014 04:12:24] Node Import: [5] Property[292048] Node[128298] Relationship[0] Label[0] Disk[13 mb, 0 mb/sec] FreeMem[3173 mb] [2014-05-31 15:11:41.02] Node file [nodes.csv] imported in 8 secs - [Property[292048] Node[128298] Relationship[0] Label[0]] [2014-05-31 15:11:41.02]Node Import complete in 8 secs - [Property[292048] Node[128298] Relationship[0] Label[0]]java.lang.NumberFormatException: For input string: "owl_Thing" at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65) at java.lang.Long.parseLong(Long.java:441) at java.lang.Long.parseLong(Long.java:483) at org.neo4j.batchimport.importer.structs.AbstractDataBuffer.getLong(AbstractDataBuffer.java:159) at org.neo4j.unsafe.batchinsert.BatchInserterImplNew.accumulateNodeCount(BatchInserterImplNew.java:743) at org.neo4j.batchimport.importer.stages.NodeStatsAccumulatorStage$2.execute(NodeStatsAccumulatorStage.java:24) at org.neo4j.batchimport.importer.stages.ImportWorker.processData(ImportWorker.java:144) at org.neo4j.batchimport.importer.stages.ImportWorker.run(ImportWorker.java:196) Invoke stage method failed:ImportNode_Stage1:[Error in accumulateNodeCount - For input string: "owl_Thing"]:1 org.neo4j.kernel.api.Exceptions.BatchImportException: [Error in accumulateNodeCount - For input string: "owl_Thing"] at org.neo4j.batchimport.importer.stages.ImportWorker.processData(ImportWorker.java:152) at org.neo4j.batchimport.importer.stages.ImportWorker.run(ImportWorker.java:196) Import worker:ImportNode_Stage1:[Error in accumulateNodeCount - For input string: "owl_Thing"] Uncaught exception: java.lang.RuntimeException: [Error in accumulateNodeCount - For input string: "owl_Thing"] java.lang.InterruptedException at java.util.concurrent.locks.AbstractQueuedSynchronizer.acquireInterruptibly(AbstractQueuedSynchronizer.java:1219) at java.util.concurrent.locks.ReentrantLock.lockInterruptibly(ReentrantLock.java:340) at java.util.concurrent.ArrayBlockingQueue.put(ArrayBlockingQueue.java:321) at org.neo4j.batchimport.importer.structs.DataBufferBlockingQ.putBuffer(DataBufferBlockingQ.java:243) at org.neo4j.batchimport.importer.stages.ImportWorker.writeData(ImportWorker.java:160) at org.neo4j.batchimport.importer.stages.ImportWorker.run(ImportWorker.java:198) java.lang.InterruptedException: sleep interruptedImport worker:ImportNode_Stage0:null at java.lang.Thread.sleep(Native Method)Uncaught exception: java.lang.RuntimeException at org.neo4j.batchimport.importer.stages.ImportWorker.readData(ImportWorker.java:131) at org.neo4j.batchimport.importer.stages.ImportWorker.run(ImportWorker.java:194) Import worker:ImportNode_Stage4:sleep interrupted java.lang.InterruptedException: sleep interruptedUncaught exception: java.lang.RuntimeException: sleep interrupted ... Aside from the fact that the SBI doesn't like "owl_Thing", I have no clue about what the problem is. Also, the Relationship Prescan counter (827, below) is only changing once a second: [827] Property[292048] Node[128298] Relationship[0] Label[0] Disk[13 mb, 0 mb/sec] FreeMem[3088 mb] If this is counting relationships, this load is gonna take a loooong time... -- You received this message because you are subscribed to the Google Groups "Neo4j" group. To unsubscribe from this group and stop receiving emails from it, send an email to neo4j+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.