public inbox for [email protected]
help / color / mirror / Atom feed RE: error “server process was terminated by signal 11: Segmentation fault” running pg_create_logical_replication_slot using pgoutput plugin
3+ messages / 2 participants
[nested] [flat]
* RE: error “server process was terminated by signal 11: Segmentation fault” running pg_create_logical_replication_slot using pgoutput plugin
@ 2025-07-11 02:09 Hayato Kuroda (Fujitsu) <[email protected]>
0 siblings, 1 reply; 3+ messages in thread
From: Hayato Kuroda (Fujitsu) @ 2025-07-11 02:09 UTC (permalink / raw)
To: 'abrahim abrahao' <[email protected]>; +Cc: [email protected] <[email protected]>; 'Shlok Kyal' <[email protected]>
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: error “server process was terminated by signal 11: Segmentation fault” running pg_create_logical_replication_slot using pgoutput plugin
@ 2025-07-11 21:55 abrahim abrahao <[email protected]>
parent: Hayato Kuroda (Fujitsu) <[email protected]>
0 siblings, 1 reply; 3+ messages in thread
From: abrahim abrahao @ 2025-07-11 21:55 UTC (permalink / raw)
To: Hayato Kuroda (Fujitsu) <[email protected]>; +Cc: [email protected] <[email protected]>; 'Shlok Kyal' <[email protected]>
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) <[email protected]> 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* RE: error “server process was terminated by signal 11: Segmentation fault” running pg_create_logical_replication_slot using pgoutput plugin
@ 2025-07-15 03:09 Hayato Kuroda (Fujitsu) <[email protected]>
parent: abrahim abrahao <[email protected]>
0 siblings, 0 replies; 3+ messages in thread
From: Hayato Kuroda (Fujitsu) @ 2025-07-15 03:09 UTC (permalink / raw)
To: 'abrahim abrahao' <[email protected]>; +Cc: [email protected] <[email protected]>; 'Shlok Kyal' <[email protected]>
Dear Abrahim,
> Hi Hayato and Shlok, I confirmed that it is related of Citus, everytrhing worked
> after remove the Citus instalation from the docker image.
Thanks for the confirmation. I also feel that the issue is related with Citus. I recommend
to report the Citus's community [1] to solve the issue.
[1]: https://github.com/citusdata/citus
Best regards,
Hayato Kuroda
FUJITSU LIMITED
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2025-07-15 03:09 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-07-11 02:09 RE: error “server process was terminated by signal 11: Segmentation fault” running pg_create_logical_replication_slot using pgoutput plugin Hayato Kuroda (Fujitsu) <[email protected]>
2025-07-11 21:55 ` abrahim abrahao <[email protected]>
2025-07-15 03:09 ` Hayato Kuroda (Fujitsu) <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox