Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 16 Jun 2023 06:47:25 +0200
From:      ft <ml@ft-c.de>
To:        stable@FreeBSD.org
Subject:   pg_citus extension error
Message-ID:  <bd000b5954f72688dad5d4e08d88eff15a3712b2.camel@ft-c.de>

next in thread | raw e-mail | index | archive | help
Hello,=20

A postgresql database v14 is running in a jail.
I installed pg_citus with portupgrade: no error messages

I get an error,=C2=A0
(1). when I=C2=A0create extension citus; or
(2). when I change shared_preload_libraries and restart the database

(1)
errormessage:
SQL Error [58P01]: ERROR: could not load library
"/usr/local/lib/postgresql/citus.so": /usr/local/lib/libcurl.so.4:
Undefined symbol
"nghttp2_option_set_no_rfc9113_leading_and_trailing_ws_validation"

(2)
when I set the value in postgresql.conf
shared_preload_libraries =3D 'citus'
and restart, then I get the error-message
service postgresql restart
2023-06-16 06:26:19.909 CEST [31451] FATAL:=C2=A0 could not load library
"/usr/local/lib/postgresql/citus.so": /usr/local/lib/libcurl.so.4:
=C2=A0Undefined symbol
"nghttp2_option_set_no_rfc9113_leading_and_trailing_ws_validation"

Here some information:
ls -l /usr/local/lib/libcurl*
-rw-r--r-- 1 1509404 May 25 03:14 libcurl.a
lrwxr-xr-x 1 16 May 25 03:14 libcurl.so -> libcurl.so.4.8.0
lrwxr-xr-x 1 16 May 25 03:14 libcurl.so.4 -> libcurl.so.4.8.0
-rwxr-xr-x 1 706112 May 25 03:14 libcurl.so.4.8.0

ls -l /usr/local/lib/postgresql/citus.so
-rwxr-xr-x 1 1711040 Jun 15 22:52 citus.so
(all with root wheel)

portversion 11.3.0

Do you need more information?

Franz





Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bd000b5954f72688dad5d4e08d88eff15a3712b2.camel>