avowkind opened a new issue, #1627:
URL: https://github.com/apache/age/issues/1627
I need some help understanding this error message:
{"message":"create failed","error":"error: vertex assigned to variable o1
was deleted"}
I have a LARGE create statement that is posting in a batch of environmental
observations. It looks up vertices of PropertyType, FeatureOfInterest and
Dataset and then creates Observations linked to those vertices. example below.
This creates 128 observations in each request. After running some count of
requests successfully I get the above error.
This seems to imply that either:
- during execution of the query the vertex o1 that is created is lost or
deleted by the time we are adding the edges.
- or perhaps an o1 vertex previously created and/or deleted at some point in
the past is being found and used again - giving the error.
I'm getting the error while running an Extract/Transform/Load using Apache
Airflow. This is moving data from an operational system to the graph database.
It is possible that we might try to load the same dataset twice.
This is what I see in the Postgresql logs
2024-02-26 10:37:58.955 NZDT [31201] ERROR: vertex assigned to variable o1
was deleted
2024-02-26 10:37:58.955 NZDT [31201] STATEMENT:
body is > 64K so I will post in a file
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
