Neo4j: Neo4j 3.3.5 LOAD CSV throw Neo.DatabaseError.Statement.ExecutionFailed

Created on 2 May 2018  路  2Comments  路  Source: neo4j/neo4j

Neo4j Version: 3.3.5
Operating System: OS X 10.13.4
Driver: Cypher

Steps to reproduce

  1. Access to own Neo4j browser.
  2. Run the below cypher.
USING PERIODIC COMMIT LOAD CSV WITH HEADERS FROM 'file:///test.csv' AS row CREATE (tx:TxOut { value: row.value, n: toInt(row.n), uuid: row.uuid, created_at: timestamp() }) SET tx.script_pubkey = row.script_pubkey, tx.updated_at = timestamp()

Expect behavior

Import finishes without error.

Actual behavior

That return the error.

Neo.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. This field started at <NEO4J-HOME>/import/test.csv:1

using file here test.zip

3.3 bug cypher team-cypher

Most helpful comment

@JunOkumura Thanks for reporting. I could reproduce it and this seems like a bug to me. I will let you know when it's fixed.

Best regards
Sascha, Neo4j Cypher Team

All 2 comments

@JunOkumura Thanks for reporting. I could reproduce it and this seems like a bug to me. I will let you know when it's fixed.

Best regards
Sascha, Neo4j Cypher Team

This should now be fixed in 3.3.6

Was this page helpful?
0 / 5 - 0 ratings

Related issues

noorbakerally picture noorbakerally  路  3Comments

BrainAnnex picture BrainAnnex  路  4Comments

cybersam picture cybersam  路  3Comments

mammadalipour picture mammadalipour  路  3Comments

averza picture averza  路  3Comments