Skip to content

Edge creation fails with 'Target node does not exist' despite loading nodes.csv #3766

Description

@jturkar

Describe the bug
While importing relationships (edges) from a CSV file, ArcadeDB throws the error:
"Target node does not exist in DB", even though the nodes were previously loaded successfully.

Steps to reproduce

  1. Load nodes using nodes.csv:
    LOAD CSV WITH HEADERS FROM 'file:///nodes.csv' AS row
    CREATE (:Node {NodeID: row.NodeID})

  2. Verify nodes:
    MATCH (n:Node) RETURN n LIMIT 10

  3. Load edges using edges.csv:
    LOAD CSV WITH HEADERS FROM 'file:///edges.csv' AS row
    MATCH (a:Node {NodeID: row.Source})
    MATCH (b:Node {NodeID: row.Target})
    CREATE (a)-[:RELATION]->(b)

Expected behavior
Edges should be created successfully between existing nodes.

Actual behavior
Edge creation fails with error:
"Target node does not exist in DB"

Environment

  • ArcadeDB Version: 1.7.0
  • OS: Windows (WSL/Ubuntu)
  • Deployment: Docker

Additional context

  • Nodes are loaded from CSV before edges
  • NodeID values in nodes.csv and edges.csv are expected to match
  • Sample failing records:
    ba-llb-h → nluj
    bba-llb-h → nluj

Metadata

Metadata

Assignees

Type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions