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

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #17007: server process (PID XXXX) was terminated by signal 11: Segmentation fault
Дата
Msg-id 17007-7b2eddada8ea1bd6@postgresql.org
обсуждение исходный текст
Ответы Re: BUG #17007: server process (PID XXXX) was terminated by signal 11: Segmentation fault  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-bugs
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


В списке pgsql-bugs по дате отправления:

Предыдущее
От: Eugen Konkov
Дата:
Сообщение: Re: BUG #16968: Planner does not recognize optimization
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: BUG #17007: server process (PID XXXX) was terminated by signal 11: Segmentation fault