JunKK7 opened a new issue #39:
URL: https://github.com/apache/incubator-age/issues/39
Hello
I'm trying to analyze AGE source for using create vertex on pl/pgsql.
I tried this script
`
LOAD 'age';
SET search_path = ag_catalog, age, public;
select create_graph('test');
SELECT * from cypher('test', $$
CREATE (a:Part {id: '123',value: '1234'})
$$) as (a agtype);
SELECT * from cypher('test', $$
MATCH (a:Part)
RETURN a.value
$$) as (a agtype);
CREATE OR REPLACE FUNCTION public.create_graph4(
)
RETURNS void
LANGUAGE 'plpgsql'
AS $BODY$
begin
LOAD 'age';
SET search_path = ag_catalog, age, public;
SELECT * from cypher('test', $$ create(:Part{id:'1234',value:'12345'})
$$) as (a agtype);
end
$BODY$;
select public.create_graph4();
`
error
`2021-03-09 12:48:38.560 KST [24113] LOG: server process (PID 26455) was
terminated by signal 11: segmentation error
2021-03-09 12:48:38.560 KST [24113] DETAIL: Failed process was running:
select public.create_graph4();
2021-03-09 12:48:38.560 KST [24113] LOG: terminating any other active
server processes
2021-03-09 12:48:38.561 KST [26449] WARNING: terminating connection because
of crash of another server process
2021-03-09 12:48:38.561 KST [26449] DETAIL: The postmaster has commanded
this server process to roll back the current transaction and exit, because
another server process exited abnormally and possibly corrupted shared memory.
2021-03-09 12:48:38.561 KST [26449] HINT: In a moment you should be able to
reconnect to the database and repeat your command.
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: 2021-03-09
12:48:38.563 KST [26452] WARNING: terminating connection because of crash of
another server process
2021-03-09 12:48:38.563 KST [26452] DETAIL: The postmaster has commanded
this server process to roll back the current transaction and exit, because
another server process exited abnormally and possibly corrupted shared memory.
2021-03-09 12:48:38.563 KST [26452] HINT: In a moment you should be able to
reconnect to the database and repeat your command.
2021-03-09 12:48:38.564 KST [26457] FATAL: the database system is in
recovery mode
Failed.
!> 2021-03-09 12:48:38.565 KST [24113] LOG: all server processes
terminated; reinitializing
2021-03-09 12:48:38.578 KST [26458] LOG: database system was interrupted;
last known up at 2021-03-09 12:46:40 KST
2021-03-09 12:48:38.772 KST [26458] LOG: database system was not properly
shut down; automatic recovery in progress
2021-03-09 12:48:38.774 KST [26458] LOG: redo starts at 0/31CF228
2021-03-09 12:48:38.791 KST [26458] LOG: invalid record length at
0/337ADC8: wanted 24, got 0
2021-03-09 12:48:38.791 KST [26458] LOG: redo done at 0/337AD60
2021-03-09 12:48:38.791 KST [26458] LOG: last completed transaction was at
log time 2021-03-09 12:48:37.494032+09
2021-03-09 12:48:38.835 KST [24113] LOG: database system is ready to accept
connections
`
first start "select public.create_graph4();" -> disconnect
second start "select public.create_graph4();" -> not disconnect
third start "select public.create_graph4();" -> not disconnect
why first time start "select public.create_graph4()" disconnected ?
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
[email protected]
