Neo4j

inersha · 12-29-2021

I've recently upgraded from 4.3.3 to 4.4.2. On 4.3.3 I used the neo4j-admin import tool to import some data on a fresh database. However, since upgrading to 4.4.2 and using the same tool on the same CSV files I am getting incorrect data being inserte...

inersha · 11-23-2021

I'm regularly making cypher queries to insert data in to Neo4j. Every now and then Neo4j will hang for around 3-5 minutes, and I'm not able to run any queries against the database. What usually causes this? I've checked debug.log and I haven't found ...

inersha · 11-19-2021

Hello there, I have a script that runs a few hundred thousand individual transactions to insert data in to Neo4j. Each of these Cypher queries uses the exact same format -- it's just the parameters that change from one query to the next. However, at ...

inersha · 10-26-2021

Neo4j Version: 4.3.6 I'm using neo4j-admin import to import some data in to a fresh database. I'm using a text index for one of the types of nodes, and whilst almost all of the :IDs are in the region of 50-100 bytes in length, there is the odd one th...

inersha · 01-30-2019

I have a database that is roughly 1200GB. I am running it on a server with 128GB of RAM, and 32GB of swap memory. These are my neo4j.conf settings: dbms.memory.heap.initial_size=16g dbms.memory.heap.max_size=16g dbms.memory.pagecache.size=64g Over t...

inersha · 12-31-2021

It appears that this is a known issue: neo4j-admin import generated duplicate id's after upgrade to 4.4 · Issue #12793 · neo4j/neo4j · GitHub "I found the issue and a fix for it. It should be included in the next 4.4.x release."

inersha · 12-30-2021

I think the problem is to do with the values of the :ID nodes. My CSV file looks like this: hash:ID,height:INT,version:INT,prevblock:STRING 000000000019d6689c085ae165831e934ff763ae46a2a6c172b3f1b60a8ce26f,0,1,00000000000000000000000000000000000000000...

inersha · 11-21-2021

Thanks for the suggestion. I've been running this query after every 2000 transactions, but it hasn't stopped Neo4j from hanging for about 5 minutes every now and then. What has helped however is increasing the maximum heap size. Whereas before a tran...

inersha · 11-19-2021

I've modified the script to wait 5 minutes after a failed transaction and to try again. During this time I got these errors in debug.log: 2021-11-19 20:07:18.064+0000 INFO [o.n.c.i.ExecutionEngine] [neo4j/c7a51d5e] Discarded stale query from the que...

inersha · 10-26-2021

I've done some more testing, and it seems the maximum length I can use for an :ID is 46341 characters in length. For example, this import works: name:ID <46341 character string> But this fails: name:ID <46342 character string> Is this a specific li...

Neo4j

User Statistics

User Activity

Has the neo4j-admin import tool changed in recent versions?

What can cause Neo4j to hang for around 3-5 minutes?

Stale Queries - Neo4j transactions stalling during import

What's the maximum length for an :ID during import?

Is it possible to reduce the amount of swap space that Neo4j uses?

Re: Has the neo4j-admin import tool changed in recent versions?

Re: Has the neo4j-admin import tool changed in recent versions?

Re: Stale Queries - Neo4j transactions stalling during import

Re: Stale Queries - Neo4j transactions stalling during import

Re: What's the maximum length for an :ID during import?