MIME-Version: 1.0
From: milist ujang <ujang.milist@gmail.com>
Date: Mon, 20 May 2024 17:31:45 +0700
Message-ID: <CACG9ogyCjz6yBKBuTX=686CypkgQj+RjrtAw2Skj1Q=0AxxG3Q@mail.gmail.com>
Subject: signal 11: Segmentation fault ; query constraint list; pg16.3
To: pgsql-general@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000e58f8b0618e03502"
Archived-At: <https://www.postgresql.org/message-id/CACG9ogyCjz6yBKBuTX%3D686CypkgQj%2BRjrtAw2Skj1Q%3D0AxxG3Q%40mail.gmail.com>
Precedence: bulk

--000000000000e58f8b0618e03502
Content-Type: text/plain; charset="UTF-8"

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

--000000000000e58f8b0618e03502
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">postgres 16.1; rocky 9.3<div><br></div><div>when connect t=
o database postgres this query is OK, but run on user database, got segment=
ation fault.</div><div><br></div><div><br></div><div>2024-05-20 17:16:54.94=
2 WIB,,,134291,,6648420a.20c93,165,,2024-05-18 12:52:10 WIB,,0,LOG,00000,&q=
uot;server process (PID 487952) was terminated by signal 11: Segmentation f=
ault&quot;,&quot;Failed process was running: select<br>=C2=A0 =C2=A0 ct.con=
name as constraint_name,<br>=C2=A0 =C2=A0 a.attname as column_name,<br>=C2=
=A0 =C2=A0 fc.relname as foreign_table_name,<br>=C2=A0 =C2=A0 fns.nspname a=
s foreign_table_schema,<br>=C2=A0 =C2=A0 fa.attname as foreign_column_name<=
br>from<br>=C2=A0 =C2=A0 (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.=
conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s<br>=
=C2=A0 =C2=A0 =C2=A0 =C2=A0FROM pg_constraint ct<br>=C2=A0 =C2=A0 ) AS ct<b=
r>=C2=A0 =C2=A0 inner join pg_class c on c.oid=3Dct.conrelid<br>=C2=A0 =C2=
=A0 inner join pg_namespace ns on c.relnamespace=3Dns.oid<br>=C2=A0 =C2=A0 =
inner join pg_attribute a on a.attrelid=3Dct.conrelid and a.attnum =3D ct.c=
onkey[ct.s]<br>=C2=A0 =C2=A0 left join pg_class fc on fc.oid=3Dct.confrelid=
<br>=C2=A0 =C2=A0 left join pg_namespace fns on fc.relnamespace=3Dfns.oid<b=
r>=C2=A0 =C2=A0 left join pg_attribute fa on fa.attrelid=3Dct.confrelid and=
 fa.attnum =3D ct.confkey[ct.s]<br>where<br>=C2=A0 =C2=A0 ct.contype=3D&#39=
;f&#39;<br>=C2=A0 =C2=A0 and c.relname=3D&#39;table1&#39;<br>=C2=A0 =C2=A0 =
and ns.nspname=3D&#39;schemauser&#39;<br>order by<br>=C2=A0 =C2=A0 fns.nspn=
ame, fc.relname, a.attnum<br>;&quot;,,,,,,,,&quot;&quot;,&quot;postmaster&q=
uot;,,0</div><div><br>2024-05-20 17:16:54.942 WIB,,,134291,,6648420a.20c93,=
166,,2024-05-18 12:52:10 WIB,,0,LOG,00000,&quot;terminating any other activ=
e server processes&quot;,,,,,,,,,&quot;&quot;,&quot;postmaster&quot;,,0<br =
clear=3D"all"><div><br></div><span class=3D"gmail_signature_prefix">-- </sp=
an><br><div dir=3D"ltr" class=3D"gmail_signature" data-smartmail=3D"gmail_s=
ignature"><div dir=3D"ltr">regards<br><br>ujang jaenudin | Self-Employed, D=
BA Consultant<br><a href=3D"http://id.linkedin.com/pub/ujang-jaenudin/12/64=
/bab" target=3D"_blank">http://id.linkedin.com/pub/ujang-jaenudin/12/64/bab=
</a><br></div></div></div></div>

--000000000000e58f8b0618e03502--