Date: Thu, 10 Jul 2025 17:33:21 +0000 (UTC)
From: abrahim abrahao <a_abrahao@yahoo.com.br>
Reply-To: abrahim abrahao <a_abrahao@yahoo.com.br>
To: 'Shlok Kyal' <shlok.kyal.oss@gmail.com>, 
	"Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Message-ID: <714296734.237495.1752168801905@mail.yahoo.com>
In-Reply-To: <OS7PR01MB14968C27D3E6D1EE9E5F5AB97F548A@OS7PR01MB14968.jpnprd01.prod.outlook.com>
References: <2138039822.1224213.1751997247151.ref@mail.yahoo.com> <2138039822.1224213.1751997247151@mail.yahoo.com> <CANhcyEXh+fbxcfcSatDzFp=PWLW00_Ug35RvunGhHh7epvpdFg@mail.gmail.com> <CANhcyEXU4qyFZzKB3ByGqdMrM_v7RpowzLhcRVry6WhxBZaeAA@mail.gmail.com> <OS7PR01MB14968C27D3E6D1EE9E5F5AB97F548A@OS7PR01MB14968.jpnprd01.prod.outlook.com>
Subject: =?UTF-8?Q?Re:_error_=E2=80=9Cserver_process_was_term?=
 =?UTF-8?Q?inated_by_signal_11:_Segmentation_f?=
 =?UTF-8?Q?ault=E2=80=9D_running_pg=5Fcreate=5Flogical=5Frep?=
 =?UTF-8?Q?lication=5Fslot_using_pgoutput_plugin?=
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="----=_Part_237494_619607406.1752168801903"
Content-Length: 12246
Archived-At: <https://www.postgresql.org/message-id/714296734.237495.1752168801905%40mail.yahoo.com>
Precedence: bulk

------=_Part_237494_619607406.1752168801903
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

 Thanks=C2=A0=C2=A0Hayato and=C2=A0Shlok,=C2=A0The Citus extension package =
is installed, but it is not preload on=C2=A0shared_preload_libraries and ci=
tus extesion is not created.I will create a new container without=C2=A0Citu=
s extension package and adding=C2=A0stack trace ( I think this is the one y=
ou're talking about) as soon as possible and I will update here as soon I c=
omplete the test.
See information below.
show shared_preload_libraries;=C2=A0 =C2=A0shared_preload_libraries--------=
-----------------------=C2=A0pg_stat_statements, pg_repack(1 row)
\dx=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 List of installed extensions=C2=A0 =C2=A0 =C2=A0 =C2=A0 Name=C2=
=A0 =C2=A0 =C2=A0 =C2=A0 | Version |=C2=A0 =C2=A0Schema=C2=A0 =C2=A0|=C2=A0=
 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 Description--------------------+---------+--------=
----+----------------------------------------------------------------------=
--=C2=A0btree_gist=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| 1.7=C2=A0 =C2=A0 =C2=
=A0| public=C2=A0 =C2=A0 =C2=A0| support for indexing common datatypes in G=
iST=C2=A0ltree=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | 1.2=C2=A0 =
=C2=A0 =C2=A0| public=C2=A0 =C2=A0 =C2=A0| data type for hierarchical tree-=
like structures=C2=A0pg_stat_statements | 1.10=C2=A0 =C2=A0 | public=C2=A0 =
=C2=A0 =C2=A0| track planning and execution statistics of all SQL statement=
s executed=C2=A0pg_trgm=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | 1.5=C2=
=A0 =C2=A0 =C2=A0| public=C2=A0 =C2=A0 =C2=A0| text similarity measurement =
and index searching based on trigrams=C2=A0pgcrypto=C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0| 1.3=C2=A0 =C2=A0 =C2=A0| public=C2=A0 =C2=A0 =C2=A0| cry=
ptographic functions=C2=A0plpgsql=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
| 1.0=C2=A0 =C2=A0 =C2=A0| pg_catalog | PL/pgSQL procedural language=C2=A0p=
ostgis=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | 3.5.1=C2=A0 =C2=A0| publi=
c=C2=A0 =C2=A0 =C2=A0| PostGIS geometry and geography spatial types and fun=
ctions=C2=A0uuid-ossp=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | 1.1=C2=A0 =C2=A0 =
=C2=A0| public=C2=A0 =C2=A0 =C2=A0| generate universally unique identifiers=
 (UUIDs)(8 rows)

Steps done until=C2=A0pg_create_logical_replication_slot command (just the =
steps, does not include the full command)
set=C2=A0wal_level,=C2=A0max_replication_slots,=C2=A0max_wal_senders and=C2=
=A0listen_addresses=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0name=C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 | setting-----------------------+---------=C2=A0listen_ad=
dresses=C2=A0 =C2=A0 =C2=A0 | *=C2=A0max_replication_slots | 10=C2=A0max_wa=
l_senders=C2=A0 =C2=A0 =C2=A0 =C2=A0| 20=C2=A0wal_level=C2=A0 =C2=A0 =C2=A0=
 =C2=A0 =C2=A0 =C2=A0 =C2=A0| logical
Changed pg_hba filerestart databasepg_ctl restart -D $POSTGRESQL_DATA
create a user "CREATE USER user_rep WITH REPLICATION ENCRYPTED PASSWORD"ALT=
ER DEFAULT PRIVILEGES FOR ROLE postgres IN SCHEMA myg GRANT SELECT ON TABLE=
S TO user_rep;CREATE PUBLICATION myg_pub FOR TABLES IN SCHEMA myg;ALTER PUB=
LICATION myg_pub ADD TABLE myg
SELECT snapshot_name FROM pg_create_logical_replication_slot

    On Wednesday, July 9, 2025 at 10:19:07 p.m. EDT, Hayato Kuroda (Fujitsu=
) <kuroda.hayato@fujitsu.com> wrote: =20
=20
 Dear Shlok, Abrahim,

> Also, I was going to the logs on found:
> > > < 2025-07-08 14:57:08.653 UTC psql postgres postgres 172.18.0.94(5341=
4)
> SELECT 00000 2025-07-08 14:57:07 UTC 1096 686d31c3.448 2025-07-08
> 14:57:08.653 UTC > LOG:=C2=A0 Initializing CDC decoder
>=20
> This log is not present in Postgres source code. Why is this log appearin=
g here?

I found the output in Citus source code [1]. So, I'm afraid that you may lo=
ad the
shared library provided by Citus when you created the replication slot.

If so, Citus community may be the better place to discuss the bug.
We can help if you can reproduce the bug by the PostgreSQL core codes.

[1]: https://github.com/citusdata/citus/blob/5deaf9a61673e10c183b6d4f13593f=
168e1c2c10/src/backend/distributed/cdc/cdc_decoder.c#L85

Best regards,
Hayato Kuroda
FUJITSU LIMITED

 =20
------=_Part_237494_619607406.1752168801903
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<html><head></head><body><div class=3D"ydpa60bacyahoo-style-wrap" style=3D"=
font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;"><=
div></div>
        <div dir=3D"ltr" data-setdir=3D"false">Thanks&nbsp;&nbsp;<span>Haya=
to and&nbsp;<span>Shlok,&nbsp;</span></span></div><div dir=3D"ltr" data-set=
dir=3D"false"><span><span>The <span>Citus extension package is installed, b=
ut it is not preload on&nbsp;<span>shared_preload_libraries and citus extes=
ion is not created.</span></span></span></span></div><div dir=3D"ltr" data-=
setdir=3D"false"><span><span><span><span>I will create a new container with=
out&nbsp;<span>Citus extension package and adding&nbsp;<span><a href=3D"htt=
ps://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL=
_backend_on_Linux/BSD" class=3D"">stack trace</a> (  <span>I think this is =
the one you're talking about</span>) as soon as possible and I will update =
here as soon I complete the test.</span></span></span></span></span></span>=
</div><div dir=3D"ltr" data-setdir=3D"false"><br></div><div dir=3D"ltr" dat=
a-setdir=3D"false">See information below.</div><div dir=3D"ltr" data-setdir=
=3D"false"><br></div><div dir=3D"ltr" data-setdir=3D"false"><div><div>show =
shared_preload_libraries;</div><div>&nbsp; &nbsp;shared_preload_libraries</=
div><div>-------------------------------</div><div>&nbsp;pg_stat_statements=
, pg_repack</div><div>(1 row)</div><div><br></div><div>\dx</div><div>&nbsp;=
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbs=
p; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Li=
st of installed extensions</div><div>&nbsp; &nbsp; &nbsp; &nbsp; Name&nbsp;=
 &nbsp; &nbsp; &nbsp; | Version |&nbsp; &nbsp;Schema&nbsp; &nbsp;|&nbsp; &n=
bsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; =
&nbsp; &nbsp; &nbsp; Description</div><div>--------------------+---------+-=
-----------+---------------------------------------------------------------=
---------</div><div>&nbsp;btree_gist&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| 1.7=
&nbsp; &nbsp; &nbsp;| public&nbsp; &nbsp; &nbsp;| support for indexing comm=
on datatypes in GiST</div><div>&nbsp;ltree&nbsp; &nbsp; &nbsp; &nbsp; &nbsp=
; &nbsp; &nbsp; | 1.2&nbsp; &nbsp; &nbsp;| public&nbsp; &nbsp; &nbsp;| data=
 type for hierarchical tree-like structures</div><div>&nbsp;pg_stat_stateme=
nts | 1.10&nbsp; &nbsp; | public&nbsp; &nbsp; &nbsp;| track planning and ex=
ecution statistics of all SQL statements executed</div><div>&nbsp;pg_trgm&n=
bsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; | 1.5&nbsp; &nbsp; &nbsp;| public&n=
bsp; &nbsp; &nbsp;| text similarity measurement and index searching based o=
n trigrams</div><div>&nbsp;pgcrypto&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp=
;| 1.3&nbsp; &nbsp; &nbsp;| public&nbsp; &nbsp; &nbsp;| cryptographic funct=
ions</div><div>&nbsp;plpgsql&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; | 1.0=
&nbsp; &nbsp; &nbsp;| pg_catalog | PL/pgSQL procedural language</div><div>&=
nbsp;postgis&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; | 3.5.1&nbsp; &nbsp;|=
 public&nbsp; &nbsp; &nbsp;| PostGIS geometry and geography spatial types a=
nd functions</div><div>&nbsp;uuid-ossp&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; | =
1.1&nbsp; &nbsp; &nbsp;| public&nbsp; &nbsp; &nbsp;| generate universally u=
nique identifiers (UUIDs)</div><div>(8 rows)</div></div><br><span><span><sp=
an><span><span><div><br></div><div dir=3D"ltr" data-setdir=3D"false">Steps =
done until&nbsp;<span>pg_create_logical_replication_slot command (<span>jus=
t the steps, does not include the full command</span>)</span></div><div><br=
></div></span></span></span></span></span></div><div dir=3D"ltr" data-setdi=
r=3D"false"><span><span><span><span><span><span>set&nbsp;<span>wal_level,&n=
bsp;<span>max_replication_slots,&nbsp;<span>max_wal_senders and&nbsp;<span>=
listen_addresses</span></span></span></span></span></span></span></span></s=
pan></span></div><div dir=3D"ltr" data-setdir=3D"false"><span><span><span><=
div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;name&nbsp; &nbsp; &nbsp; &nbsp; =
&nbsp; | setting</div><div>-----------------------+---------</div><div>&nbs=
p;listen_addresses&nbsp; &nbsp; &nbsp; | *</div><div>&nbsp;max_replication_=
slots | 10</div><div>&nbsp;max_wal_senders&nbsp; &nbsp; &nbsp; &nbsp;| 20</=
div><div>&nbsp;wal_level&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| l=
ogical</div></div><div><br></div></span></span></span></div><div dir=3D"ltr=
" data-setdir=3D"false">Changed pg_hba file</div><div dir=3D"ltr" data-setd=
ir=3D"false">restart database</div><div dir=3D"ltr" data-setdir=3D"false"><=
span>pg_ctl restart -D $POSTGRESQL_DATA</span><br></div><div dir=3D"ltr" da=
ta-setdir=3D"false"><span>create a user "<span>CREATE USER user_rep WITH RE=
PLICATION ENCRYPTED PASSWORD"</span></span></div><div dir=3D"ltr" data-setd=
ir=3D"false"><span><div><div dir=3D"ltr" data-setdir=3D"false">ALTER DEFAUL=
T PRIVILEGES FOR ROLE postgres IN SCHEMA myg GRANT SELECT ON TABLES TO  <sp=
an><span style=3D"color: rgb(0, 0, 0); font-family: Helvetica Neue, Helveti=
ca, Arial, sans-serif; font-size: 16px;">user_rep</span></span>;</div><div =
dir=3D"ltr" data-setdir=3D"false"><div><div>CREATE PUBLICATION myg_pub FOR =
TABLES IN SCHEMA myg;</div></div><span>ALTER PUBLICATION myg_pub ADD TABLE =
myg</span><br></div><div dir=3D"ltr" data-setdir=3D"false"><span><span>SELE=
CT snapshot_name FROM pg_create_logical_replication_slot</span><br></span><=
/div><div><br></div></div></span></div>
       =20
        </div><div id=3D"yahoo_quoted_2571840252" class=3D"yahoo_quoted">
            <div style=3D"font-family:'Helvetica Neue', Helvetica, Arial, s=
ans-serif;font-size:13px;color:#26282a;">
               =20
                <div>
                        On Wednesday, July 9, 2025 at 10:19:07 p.m. EDT, Ha=
yato Kuroda (Fujitsu) &lt;kuroda.hayato@fujitsu.com&gt; wrote:
                    </div>
                    <div><br></div>
                    <div><br></div>
               =20
               =20
                <div><div dir=3D"ltr">Dear Shlok, Abrahim,<br clear=3D"none=
"><br clear=3D"none">&gt; Also, I was going to the logs on found:<br clear=
=3D"none">&gt; &gt; &gt; &lt; 2025-07-08 14:57:08.653 UTC psql postgres pos=
tgres 172.18.0.94(53414)<br clear=3D"none">&gt; SELECT 00000 2025-07-08 14:=
57:07 UTC 1096 686d31c3.448 2025-07-08<br clear=3D"none">&gt; 14:57:08.653 =
UTC &gt; LOG:&nbsp; Initializing CDC decoder<br clear=3D"none">&gt; <br cle=
ar=3D"none">&gt; This log is not present in Postgres source code. Why is th=
is log appearing here?<br clear=3D"none"><br clear=3D"none">I found the out=
put in Citus source code [1]. So, I'm afraid that you may load the<br clear=
=3D"none">shared library provided by Citus when you created the replication=
 slot.<br clear=3D"none"><br clear=3D"none">If so, Citus community may be t=
he better place to discuss the bug.<br clear=3D"none">We can help if you ca=
n reproduce the bug by the PostgreSQL core codes.<div class=3D"yqt318276447=
7" id=3D"yqtfd03388"><br clear=3D"none"><br clear=3D"none">[1]: </div><a sh=
ape=3D"rect" href=3D"https://github.com/citusdata/citus/blob/5deaf9a61673e1=
0c183b6d4f13593f168e1c2c10/src/backend/distributed/cdc/cdc_decoder.c#L85" t=
arget=3D"_blank">https://github.com/citusdata/citus/blob/5deaf9a61673e10c18=
3b6d4f13593f168e1c2c10/src/backend/distributed/cdc/cdc_decoder.c#L85</a><br=
 clear=3D"none"><br clear=3D"none">Best regards,<br clear=3D"none">Hayato K=
uroda<br clear=3D"none">FUJITSU LIMITED<div class=3D"yqt3182764477" id=3D"y=
qtfd79543"><br clear=3D"none"><br clear=3D"none"></div></div></div>
            </div>
        </div></body></html>
------=_Part_237494_619607406.1752168801903--