Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 16 Jun 2023 09:32:29 +0200
From:      ft <ml@ft-c.de>
To:        Matthew Seaman <matthew@FreeBSD.org>, stable@FreeBSD.org
Subject:   Re: pg_citus extension error
Message-ID:  <a09fdcacf0676e9f534db5983457a36277b96c65.camel@ft-c.de>
In-Reply-To: <ec0f3a62-66ac-5e11-20b5-662c9b468ee1@FreeBSD.org>
References:  <a36ddbd5fd354e202d3328ba2462467ec71a86ab.camel@ft-c.de> <ec0f3a62-66ac-5e11-20b5-662c9b468ee1@FreeBSD.org>

next in thread | previous in thread | raw e-mail | index | archive | help
On Fri, 2023-06-16 at 07:21 +0100, Matthew Seaman wrote:
> On 16/06/2023 05:45, ft wrote:
> > A postgresql database v14 is running in a jail.
> > I installed pg_citus with portupgrade: no error messages
> >=20
> > I get an error,
> > (1). when I=C2=A0create extension citus; or
> > (2). when I change shared_preload_libraries and restart the
> > database
> >=20
> > (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"
> >=20
>=20
> Thank you very much for the report.=C2=A0 The symbol you mention only
> appears=20
> in the curl sources -- there's no reference from pg_citus.=C2=A0 So I fee=
l
> this may be more a problem in curl than to do with pg_citus.
>=20
> Can I as what version of curl you have installed, and what options
> you=20
> used to build that port?
>=20
Hello

your first question: version of curl

pkg info curl
curl-8.1.1
Name           : curl
Version        : 8.1.1
Installed on   : Mon Jun 12 10:28:00 2023 CEST
Origin         : ftp/curl
Architecture   : FreeBSD:13:amd64
Prefix         : /usr/local
Categories     : www net ftp
Maintainer     : sunpoet@FreeBSD.org
WWW            : https://curl.se/
Options        :
        ALTSVC         : on
        BROTLI         : off
        CARES          : off
        CA_BUNDLE      : on
        COOKIES        : on
        CURL_DEBUG     : off
        DEBUG          : off
        DICT           : on
        DOCS           : on
        EXAMPLES       : on
        FTP            : on
        GNUTLS         : off
        GOPHER         : on
        GSSAPI_BASE    : on
        GSSAPI_HEIMDAL : off
        GSSAPI_MIT     : off
        GSSAPI_NONE    : off
        HTTP           : on
        HTTP2          : on
        IDN            : off
        IMAP           : on
        IPV6           : on
        LDAP           : off
        LDAPS          : off
        LIBSSH2        : on
        MQTT           : off
        NTLM           : on
        OPENSSL        : on
        POP3           : on
        PROXY          : on
        PSL            : on
        RTMP           : off
        RTSP           : on
        SMB            : off
        SMTP           : on
        STATIC         : on
        TELNET         : on
        TFTP           : on
        THREADED_RESOLVER: on
        TLS_SRP        : on
        WOLFSSL        : off
        ZSTD           : off
Shared Libs required:
        libssh2.so.1
        libpsl.so.5
        libnghttp2.so.14
Shared Libs provided:
        libcurl.so.4
Annotations    :
        FreeBSD_version: 1301000
        cpe            : cpe:2.3:a:haxx:curl:8.1.1:::::freebsd13:x64


the second question: ldd ...

[ft@jail_pg01 ~]$  ldd /usr/local/lib/libcurl.so.4.*
/usr/local/lib/libcurl.so.4.8.0:
  libnghttp2.so.14 =3D> /usr/local/lib/libnghttp2.so.14 (0x80153d000)
  libssh2.so.1 =3D> /usr/local/lib/libssh2.so.1 (0x80156f000)
  libpsl.so.5 =3D> /usr/local/lib/libpsl.so.5 (0x8015ae000)
  libssl.so.111 =3D> /usr/lib/libssl.so.111 (0x801e00000)
  libheimntlm.so.11 =3D> /usr/lib/libheimntlm.so.11 (0x8015c2000)
  libhx509.so.11 =3D> /usr/lib/libhx509.so.11 (0x801e98000)
  libcom_err.so.5 =3D> /usr/lib/libcom_err.so.5 (0x8015cc000)
  libcrypto.so.111 =3D> /lib/libcrypto.so.111 (0x801ee9000)
  libasn1.so.11 =3D> /usr/lib/libasn1.so.11 (0x8021dc000)
  libwind.so.11 =3D> /usr/lib/libwind.so.11 (0x8015d1000)
  libheimbase.so.11 =3D> /usr/lib/libheimbase.so.11 (0x80227f000)
  libroken.so.11 =3D> /usr/lib/libroken.so.11 (0x802286000)
  libcrypt.so.5 =3D> /lib/libcrypt.so.5 (0x80229b000)
  libz.so.6 =3D> /lib/libz.so.6 (0x8022bc000)
  libkrb5.so.11 =3D> /usr/lib/libkrb5.so.11 (0x8022d9000)
  libgssapi.so.10 =3D> /usr/lib/libgssapi.so.10 (0x80235b000)
  libgssapi_krb5.so.10 =3D> /usr/lib/libgssapi_krb5.so.10 (0x802367000)
  libthr.so.3 =3D> /lib/libthr.so.3 (0x802389000)
  libc.so.7 =3D> /lib/libc.so.7 (0x801083000)
  libintl.so.8 =3D> /usr/local/lib/libintl.so.8 (0x8023b7000)
  libunistring.so.2 =3D> /usr/local/lib/libunistring.so.2 (0x8023c5000)
  libidn2.so.0 =3D> /usr/local/lib/libidn2.so.0 (0x8025c1000)
  libprivateheimipcc.so.11 =3D> /usr/lib/libprivateheimipcc.so.11
(0x8025f5000)






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