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: us...@infra.apache.org