public inbox for [email protected]
help / color / mirror / Atom feedFrom: milist ujang <[email protected]>
To: [email protected]
Subject: signal 11: Segmentation fault ; query constraint list; pg16.3
Date: Mon, 20 May 2024 17:31:45 +0700
Message-ID: <CACG9ogyCjz6yBKBuTX=686CypkgQj+RjrtAw2Skj1Q=0AxxG3Q@mail.gmail.com> (raw)
postgres 16.1; rocky 9.3
when connect to database postgres this query is OK, but run on user
database, got segmentation fault.
2024-05-20 17:16:54.942 WIB,,,134291,,6648420a.20c93,165,,2024-05-18
12:52:10 WIB,,0,LOG,00000,"server process (PID 487952) was terminated by
signal 11: Segmentation fault","Failed process was running: select
ct.conname as constraint_name,
a.attname as column_name,
fc.relname as foreign_table_name,
fns.nspname as foreign_table_schema,
fa.attname as foreign_column_name
from
(SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype,
ct.confkey, generate_subscripts(ct.conkey, 1) AS s
FROM pg_constraint ct
) AS ct
inner join pg_class c on c.oid=ct.conrelid
inner join pg_namespace ns on c.relnamespace=ns.oid
inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum =
ct.conkey[ct.s]
left join pg_class fc on fc.oid=ct.confrelid
left join pg_namespace fns on fc.relnamespace=fns.oid
left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum =
ct.confkey[ct.s]
where
ct.contype='f'
and c.relname='table1'
and ns.nspname='schemauser'
order by
fns.nspname, fc.relname, a.attnum
;",,,,,,,,"","postmaster",,0
2024-05-20 17:16:54.942 WIB,,,134291,,6648420a.20c93,166,,2024-05-18
12:52:10 WIB,,0,LOG,00000,"terminating any other active server
processes",,,,,,,,,"","postmaster",,0
--
regards
ujang jaenudin | Self-Employed, DBA Consultant
http://id.linkedin.com/pub/ujang-jaenudin/12/64/bab
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected]
Subject: Re: signal 11: Segmentation fault ; query constraint list; pg16.3
In-Reply-To: <CACG9ogyCjz6yBKBuTX=686CypkgQj+RjrtAw2Skj1Q=0AxxG3Q@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox