From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | kamalvarun2004(at)gmail(dot)com |
Subject: | BUG #17007: server process (PID XXXX) was terminated by signal 11: Segmentation fault |
Date: | 2021-05-13 14:08:36 |
Message-ID: | 17007-7b2eddada8ea1bd6@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 17007
Logged by: varun kamal
Email address: kamalvarun2004(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2021-05-13 14:41:03 | Re: BUG #17007: server process (PID XXXX) was terminated by signal 11: Segmentation fault |
Previous Message | Eugen Konkov | 2021-05-13 13:35:13 | Re: BUG #16968: Planner does not recognize optimization |