Skip to content

Error with adding edges on the same vertex from multiple threads on a replica server #1114

@lvca

Description

@lvca

This issue was reported on the Discord channel by louisP. The problem has been identified to happen with the following conditions:

  • using a SQL script
  • add edge(s) on the same vertex
  • execute this operation from multiple threads at the same time
  • execute the script against a replica server (the issue is not reproduced when it's executed on the leader)

The result is some missing outgoing edges from the source vertex. The vertices and edges are created regularly, but not all are connected to the source vertex.

Example:

BEGIN ISOLATION REPEATABLE_READ;
LET photo = CREATE vertex Photos" + serverIndex + " SET id = uuid(), name = \"downloadX.jpg\";
LET user = SELECT * FROM Users" + serverIndex + " WHERE id = \"u1111\";
LET userEdge = Create edge HasUploaded" + serverIndex + " FROM $user to $photo set type = \"User_Photos\";
COMMIT RETRY 100;
return $photo;

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions