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: dev-unsubscr...@age.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org