cancel
Showing results for 
Search instead for 
Did you mean: 

Join the community at Nodes 2022, our free virtual event on November 16 - 17.

Neo4j Tried to read a field larger than buffer size 2097152

skmn_88
Node Link

neo4j Tried to read a field larger than buffer size 2097152. A common cause of this is that a field has an unterminated quote and so will try to seek until the next quote, which ever line it may be on. This should not happen if multi-line fields are disabled, given that the fields contains no new-line characters

4 REPLIES 4

abk
Neo4j
Neo4j

Hi @skmn.88 ,

Could you provide some more context about what you are trying to do?

Best,
ABK

skmn_88
Node Link

I am trying to import the data from csv file and im facing the above error.

I increased the dbms.import.csv.buffer_size to 209715200. But error still keeps on coming

moi_yhchen
Node

Hi,

I got the same error like the following when i tried to import csv as node through py2neo.

py2neo.errors.DatabaseError: [Statement.ExecutionFailed] Tried to read a field larger than buffer size 2097152. A common cause of this is that a field has an unterminated quote and so will try to seek until the next quote, which ever line it may be on. This should not happen if multi-line fields are disabled, given that the fields contains no new-line characters. 

The cypher that i used is ¨

USING PERIODIC COMMIT
LOAD CSV WITH HEADERS FROM 'file:///file.csv' AS row
CREATE (: labelName{ id: toInteger(row.id), ....});

Regards,
yhchen

skmn_88
Node Link

The csv file was too huge and i was getting the above error. I splitted the csv file into 3 and import was successful without any issues... Hope that will work for that for u is well

Nodes 2022
Nodes
NODES 2022, Neo4j Online Education Summit - November 16 - 17, 2022.


Free NODES Training Series


October 19th -

Intro to Neo4j


October 20th -

Healthcare Analytics Using Neo4j


October 25th -

Handling Neo4j data with Apache Hop


October 26th -

Blazing Fast Graphs: Hands-on with Apache Arrow and Neo4j


November 2nd -

Graph EDA Using the Neo4j GDS Client