Re: error “server process was terminated by signal 11: Segmentation fault” running pg_create_logical_replication_slot using pgoutput plugin

From: abrahim abrahao <a_abrahao(at)yahoo(dot)com(dot)br>
To: "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>, 'Shlok Kyal' <shlok(dot)kyal(dot)oss(at)gmail(dot)com>
Subject: Re: error “server process was terminated by signal 11: Segmentation fault” running pg_create_logical_replication_slot using pgoutput plugin
Date: 2025-07-11 21:55:51
Message-ID: 214578394.658903.1752270951070@mail.yahoo.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 stack trace yet 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(dot)hayato(at)fujitsu(dot)com> wrote:

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 not set
and CREATE EXTENSION is not executed. Per my understanding the specified plugin
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-core
includes. Anyone can use the plugin via SQL function. CREATE EXTENSION is not needed.

```
postgres=# SELECT pg_create_logical_replication_slot('slot', 'test_decoding');
pg_create_logical_replication_slot
------------------------------------
(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 working on it.

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

Best regards,
Hayato Kuroda
FUJITSU LIMITED

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2025-07-11 22:57:11 Re: Aggregate versions of hashing functions (md5, sha1, etc...)
Previous Message Adrian Klaver 2025-07-11 21:00:59 Re: Aggregate versions of hashing functions (md5, sha1, etc...)