avowkind commented on issue #365:
URL: https://github.com/apache/age/issues/365#issuecomment-2046163110
is it worth creating a new bug report?
**Describe the bug**
A clear and concise description of what the bug is.
It is possible to get the database into a state where a request of the form:
```pgsql
SELECT * FROM cypher('fishpond', $$
MATCH (p:PropertyType)<-[edge:typeOf*]-(node:PropertyType)
WHERE p.id = 'fish_weight_g'
RETURN node, edge
$$) as ( node agtype, edge agtype);
```
returns the error
```
ERROR,XX000,"insert_vertex_edge: failed to insert"
```
While the same request with [edge:typeOf] i.e no variable length path on the
edge succeeds
However, a second attempt in the same session will succeed.
Is is an instance of https://github.com/apache/age/issues/365 ( which was
closed with insufficient information).
**How are you accessing AGE (Command line, driver, etc.)?**
- Can be reproduced in psql, PGAdmin and nodejs driver.
**What data setup do we need to do?**
- I'm not sure I can reproduce this issue in a small example as it only
occurred after some time of use with a large dataset.
- however the same issue does appear in a db setup from a backup of the
production db. i.e. I can provide an example if required although this is
**What is the necessary configuration info needed?**
- docker image: apache/age:PG15_latest
**What is the command that caused the error?**
```pgsql
SELECT * FROM cypher('fishpond', $$
MATCH (p:PropertyType)<-[edge:typeOf*]-(node:PropertyType)
WHERE p.id = 'fish_weight_g'
RETURN node, edge
$$) as ( node agtype, edge agtype);
```
```
ERROR,XX000,"insert_vertex_edge: failed to insert"
```
**Expected behavior**
on repeating the request we get back
```
"{""id"": 844424930131972, ""label"": ""PropertyType"", ""properties"":
{""id"": ""average_fish_weight_g"", ""name"": ""Average fish weight"",
""published"": true, ""relations"": [{""id"": ""fish_weight_g"", ""relation"":
""typeOf""}], ""resultType"": ""measurement"", ""description"": ""The average
weight of the fish in the tank""}}::vertex" "{""id"": 1125899906842627,
""label"": ""typeOf"", ""end_id"": 844424930131971, ""start_id"":
844424930131972, ""properties"": {}}::edge"
"{""id"": 844424930131974, ""label"": ""PropertyType"", ""properties"":
{""id"": ""culled_fish_weight_g"", ""name"": ""Fish Weight (culled)"",
""units"": ""g"", ""published"": true, ""relations"": [{""id"":
""fish_weight_g"", ""relation"": ""typeOf""}], ""resultType"": ""measurement"",
""description"": ""Weight of fish after culling""}}::vertex" "{""id"":
1125899906842628, ""label"": ""typeOf"", ""end_id"": 844424930131971,
""start_id"": 844424930131974, ""properties"": {}}::edge"
"{""id"": 844424930131975, ""label"": ""PropertyType"", ""properties"":
{""id"": ""mortality_fish_weight_g"", ""name"": ""Fish Weight (mortality)"",
""units"": ""g"", ""published"": true, ""relations"": [{""id"":
""fish_weight_g"", ""relation"": ""typeOf""}], ""resultType"": ""measurement"",
""description"": ""Weight of dead fish""}}::vertex" "{""id"":
1125899906842629, ""label"": ""typeOf"", ""end_id"": 844424930131971,
""start_id"": 844424930131975, ""properties"": {}}::edge"
"{""id"": 844424930131976, ""label"": ""PropertyType"", ""properties"":
{""id"": ""sampled_live_fish_weight_g"", ""name"": ""Fish Weight (sampled)"",
""units"": ""g"", ""published"": true, ""relations"": [{""id"":
""fish_weight_g"", ""relation"": ""typeOf""}], ""resultType"": ""measurement"",
""description"": ""Weight of live sampled fish""}}::vertex" "{""id"":
1125899906842630, ""label"": ""typeOf"", ""end_id"": 844424930131971,
""start_id"": 844424930131976, ""properties"": {}}::edge"
"{""id"": 844424930131977, ""label"": ""PropertyType"", ""properties"":
{""id"": ""morphometric_fish_weight_g"", ""name"": ""Fish Weight
(morphometric)"", ""units"": ""g"", ""published"": true, ""relations"":
[{""id"": ""fish_weight_g"", ""relation"": ""typeOf""}], ""resultType"":
""measurement"", ""description"": ""Weight of live fish in tank calculated from
morphometric imaging""}}::vertex" "{""id"": 1125899906842631, ""label"":
""typeOf"", ""end_id"": 844424930131971, ""start_id"": 844424930131977,
""properties"": {}}::edge"
```
--
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: dev-unsubscr...@age.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
