I33Buckler commented on issue #1260:
URL: https://github.com/apache/age/issues/1260#issuecomment-1757496006
> `pg_ctrl restart`
Thank you for the suggestion.
Restarting the server did not solve the problem.
However, it introduced an additional error in the process.
Running the following code block
```
do $$
declare temprow record;
graph_name text:='transport_network';
counter integer := 123486 ;
begin
for temprow in select service_key, trip_id from trips2 order by
service_key,trip_id
loop
counter := counter+1; -- Prevent replication of row
perform
public.create_trips
(graph_name,a.service_key, a.service_id,a.trip_id,
a.trip_headsign,a.route_id, a.direction_id, a.shape_id,a.wheelchair_accessible)
from
(select * from trips2 where row_num=counter) a
;
end loop;
end; $$
```
Resulted in
```
ERROR: unhandled cypher(cstring) function call
Detail: transport_network
Where: SQL statement "select * from cypher('transport_network', $$match
(v:routes {id: "X1"})
create(v)-[:USES]->
(t:trips
{service_key: a01a724103fbb3d059b8387bf043dbc8,
service_id: "FR", id: "307", headsign: "Gungahlin Pl", route_id: "X1",
direction_id: 0, shape_id: "1002",
wheelchair_accessible: 1})$$) as (t
agtype);"
PL/pgSQL function
create_trips(text,text,text,text,text,text,integer,text,integer) line 5 at
EXECUTE
SQL statement "SELECT
public.create_trips
(graph_name,a.service_key, a.service_id,a.trip_id,
a.trip_headsign,a.route_id, a.direction_id, a.shape_id,a.wheelchair_accessible)
from
(select * from trips2 where row_num=counter) a"
PL/pgSQL function inline_code_block line 9 at PERFORM
```
I ran the process again with the following result.
```
ERROR: could not find rte for a01a724103fbb3d059b8387bf043dbc8
Where: PL/pgSQL function
create_trips(text,text,text,text,text,text,integer,text,integer) line 5 at
EXECUTE
SQL statement "SELECT
public.create_trips
(graph_name,a.service_key, a.service_id,a.trip_id,
a.trip_headsign,a.route_id, a.direction_id, a.shape_id,a.wheelchair_accessible)
from
(select * from trips2 where row_num=counter) a"
PL/pgSQL function inline_code_block line 9 at PERFORM
```
--
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]
