Date: Fri, 11 Jul 2025 21:55:51 +0000 (UTC)
From: abrahim abrahao <a_abrahao@yahoo.com.br>
Reply-To: abrahim abrahao <a_abrahao@yahoo.com.br>
To: "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>, 
	'Shlok Kyal' <shlok.kyal.oss@gmail.com>
Message-ID: <214578394.658903.1752270951070@mail.yahoo.com>
In-Reply-To: <OSCPR01MB14966052872EC78BE7E6C7FBBF54BA@OSCPR01MB14966.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> <714296734.237495.1752168801905@mail.yahoo.com> <OSCPR01MB14966052872EC78BE7E6C7FBBF54BA@OSCPR01MB14966.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_658902_1754717837.1752270951068"
Content-Length: 5751
Archived-At: <https://www.postgresql.org/message-id/214578394.658903.1752270951070%40mail.yahoo.com>
Precedence: bulk

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

 Hi Hayato and Shlok, I confirmed that it is related of Citus, everytrhing =
worked after remove the Citus instalation from the docker image.
I did not added=C2=A0stack trace=C2=A0yet on the new instalation. It seems =
that the present Citus installation was done in an unusual way. I will work=
 to figure out a better way to install it.

 Thanks for your help, I appreciate it.


    On Thursday, July 10, 2025 at 08:10:18 p.m. MDT, Hayato Kuroda (Fujitsu=
) <kuroda.hayato@fujitsu.com> wrote: =20
=20
 Dear Abrahim

> The Citus extension package is installed, but it is not preload on shared=
_preload_libraries
> and citus extesion is not created.

It is possible that a shared library is loaded even if shared_preload is no=
t set
and CREATE EXTENSION is not executed. Per my understanding the specified pl=
ugin
name would be searched by the same rule as other libraries. See [1].

Another example is 'test_decoding'. It is a sample plugin which postgres-co=
re
includes. Anyone can use the plugin via SQL function. CREATE EXTENSION is n=
ot needed.

```
postgres=3D# SELECT pg_create_logical_replication_slot('slot', 'test_decodi=
ng');
 pg_create_logical_replication_slot=20
------------------------------------
 (slot,0/1829CE0)
(1 row)
```

> I will create a new container without Citus extension package ...

Yeah, it is quite helpful to understand the issue correctly. Thanks for wor=
king on it.

[1]: https://www.postgresql.org/docs/devel/xfunc-c.html#XFUNC-C-DYNLOAD

Best regards,
Hayato Kuroda
FUJITSU LIMITED

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

<html><head></head><body><div class=3D"ydpe1fc543eyahoo-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"><div dir=3D"ltr" data-setdir=
=3D"false">Hi Hayato and Shlok, I confirmed that it is related of Citus, ev=
erytrhing worked after remove the Citus instalation from the docker image.<=
/div><div dir=3D"ltr" data-setdir=3D"false"><br></div><div dir=3D"ltr" data=
-setdir=3D"false"><span>I did not <span>added<span><span style=3D"font-fami=
ly: Helvetica Neue, Helvetica, Arial, sans-serif; font-size: 16px;">&nbsp;<=
/span><span style=3D"font-family: Helvetica Neue, Helvetica, Arial, sans-se=
rif; font-size: 16px;"><a shape=3D"rect" href=3D"https://wiki.postgresql.or=
g/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Linux/BSD" =
class=3D"ydpcbf7f5c9yiv4913605085" style=3D"color: rgb(51, 143, 233); text-=
decoration-line: underline;" rel=3D"nofollow" target=3D"_blank">stack trace=
</a>&nbsp;yet on the new instalation.</span></span></span></span></div><div=
 dir=3D"ltr" data-setdir=3D"false"> <span>It seems that the present Citus i=
nstallation was done in an unusual way. I will work to figure out a better =
way to install it.</span><br></div><div dir=3D"ltr" data-setdir=3D"false"><=
span><br></span></div><div dir=3D"ltr" data-setdir=3D"false"> <span>Thanks =
for your help, I appreciate it.</span><br></div></div><div dir=3D"ltr" data=
-setdir=3D"false"><br></div><div><br></div>
       =20
        </div><div id=3D"yahoo_quoted_2586325344" class=3D"yahoo_quoted">
            <div style=3D"font-family:'Helvetica Neue', Helvetica, Arial, s=
ans-serif;font-size:13px;color:#26282a;">
               =20
                <div>
                        On Thursday, July 10, 2025 at 08:10:18 p.m. MDT, 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 Abrahim<br clear=3D"none"><br cl=
ear=3D"none">&gt; The Citus extension package is installed, but it is not p=
reload on shared_preload_libraries<br clear=3D"none">&gt; and citus extesio=
n is not created.<br clear=3D"none"><br clear=3D"none">It is possible that =
a shared library is loaded even if shared_preload is not set<br clear=3D"no=
ne">and CREATE EXTENSION is not executed. Per my understanding the specifie=
d plugin<br clear=3D"none">name would be searched by the same rule as other=
 libraries. See [1].<br clear=3D"none"><br clear=3D"none">Another example i=
s 'test_decoding'. It is a sample plugin which postgres-core<br clear=3D"no=
ne">includes. Anyone can use the plugin via SQL function. CREATE EXTENSION =
is not needed.<br clear=3D"none"><br clear=3D"none">```<br clear=3D"none">p=
ostgres=3D# SELECT pg_create_logical_replication_slot('slot', 'test_decodin=
g');<br clear=3D"none"> pg_create_logical_replication_slot <br clear=3D"non=
e">------------------------------------<br clear=3D"none"> (slot,0/1829CE0)=
<br clear=3D"none">(1 row)<br clear=3D"none">```<br clear=3D"none"><br clea=
r=3D"none">&gt; I will create a new container without Citus extension packa=
ge ...<br clear=3D"none"><br clear=3D"none">Yeah, it is quite helpful to un=
derstand the issue correctly. Thanks for working on it.<br clear=3D"none"><=
br clear=3D"none">[1]: <a shape=3D"rect" href=3D"https://www.postgresql.org=
/docs/devel/xfunc-c.html#XFUNC-C-DYNLOAD" target=3D"_blank">https://www.pos=
tgresql.org/docs/devel/xfunc-c.html#XFUNC-C-DYNLOAD</a><div class=3D"yqt781=
8821901" id=3D"yqtfd36702"><br clear=3D"none"><br clear=3D"none">Best regar=
ds,<br clear=3D"none">Hayato Kuroda<br clear=3D"none">FUJITSU LIMITED<br cl=
ear=3D"none"><br clear=3D"none"></div></div></div>
            </div>
        </div></body></html>
------=_Part_658902_1754717837.1752270951068--