Skip to content

Return exists(path) terminates the server #693

Description

@MuhammadTahaNaveed

Describe the bug
Returning exists(path) terminates the server.

How are you accessing AGE (Command line, driver, etc.)?

  • Command Line

What data setup do we need to do?

SELECT*FROM cypher('new_issue',$$
CREATE (n:City {name:'Islamabad'}),
(m:Country {name:'Pakistan'}),
(n)-[:isin]->(m)
$$) as (a agtype);

What is the command that caused the error?

SELECT*FROM cypher('new_issue', $$
MATCH (n:City)
RETURN exists((n)-[]->())
$$) as (a agtype);
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: 2023-02-20 23:27:32.099 PKT [18622] LOG: server process (PID 18654) was terminated by signal 6: Aborted
2023-02-20 23:27:32.099 PKT [18622] DETAIL: Failed process was running: SELECT *
FROM cypher('check', $$
MATCH (n:City)
RETURN exists((n)-[]->())
$$) as (full_name agtype);
2023-02-20 23:27:32.099 PKT [18622] LOG: terminating any other active server processes
2023-02-20 23:27:32.099 PKT [18629] WARNING: terminating connection because of crash of another server process
2023-02-20 23:27:32.099 PKT [18629] 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.
2023-02-20 23:27:32.099 PKT [18629] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2023-02-20 23:27:32.100 PKT [18957] FATAL: the database system is in recovery mode
Failed.
!> 2023-02-20 23:27:32.100 PKT [18622] LOG: all server processes terminated; reinitializing
2023-02-20 23:27:32.113 PKT [18959] LOG: database system was interrupted; last known up at 2023-02-20 23:24:09 PKT
2023-02-20 23:27:32.499 PKT [18959] LOG: database system was not properly shut down; automatic recovery in progress
2023-02-20 23:27:32.505 PKT [18959] LOG: redo starts at 0/EBFA818
2023-02-20 23:27:32.505 PKT [18959] LOG: invalid record length at 0/EBFA8F8: wanted 24, got 0
2023-02-20 23:27:32.505 PKT [18959] LOG: redo done at 0/EBFA8C0
2023-02-20 23:27:32.546 PKT [18622] LOG: database system is ready to accept connections
^Z
[10]+ Stopped pgsql/bin/psql cypher

Expected behavior
expected boolean value true

Environment (please complete the following information):

  • Version : 1.2.0

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions