BUG #17007: server process (PID XXXX) was terminated by signal 11: Segmentation fault

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

Responses

Browse pgsql-bugs by date

  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