The following bug has been logged on the website:
Bug reference: 17007
Logged by: varun kamal
Email address: kamalvarun2004@gmail.com
PostgreSQL version: 12.2
Operating system: RHEL 7.5
Description:
Dear Team,
We are facing an issue once in 2 days that Postgres instance crashes with
following error
"server process (PID XXXX) was terminated by signal 11: Segmentation fault"
with following query.
DETAIL: Failed process was running: SELECT NULL AS TABLE_CAT, n.nspname AS
TABLE_SCHEM, ct.relname AS TABLE_NAME, a.attname AS COLUMN_NAME,
(i.keys).n AS KEY_SEQ, ci.relname AS PK_NAME FROM pg_catalog.pg_class ct
JOIN pg_catalog.pg_attribute a ON (ct.oid = a.attrelid) JOIN
pg_catalog.pg_namespace n ON (ct.relnamespace = n.oid) JOIN (SELECT
i.indexrelid, i.indrelid, i.indisprimary,
information_schema._pg_expandarray(i.indkey) AS keys FROM
pg_catalog.pg_index i) i ON (a.attnum = (i.keys).x AND a.attrelid =
i.indrelid) JOIN pg_catalog.pg_class ci ON (ci.oid = i.indexrelid) WHERE
true AND ct.relname = '<REL_NAME>' AND i.indisprimary ORDER BY table_name,
pk_name, key_seq
Regards,
Varun