From nobody Fri Jun 16 07:32:29 2023 X-Original-To: stable@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 4Qj9q529yVz4fbJW for ; Fri, 16 Jun 2023 07:32:33 +0000 (UTC) (envelope-from ml@ft-c.de) Received: from einhorn-mail-out.in-berlin.de (einhorn.in-berlin.de [192.109.42.8]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "mail.in-berlin.de", Issuer "R3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4Qj9q50p6mz4Chc for ; Fri, 16 Jun 2023 07:32:33 +0000 (UTC) (envelope-from ml@ft-c.de) Authentication-Results: mx1.freebsd.org; none X-Envelope-From: ml@ft-c.de Received: from authenticated.user (localhost [127.0.0.1]) by einhorn.in-berlin.de with ESMTPSA id 35G7WTAT1154086 (version=TLSv1.3 cipher=TLS_AES_256_GCM_SHA384 bits=256 verify=NOT); Fri, 16 Jun 2023 09:32:30 +0200 Message-ID: Subject: Re: pg_citus extension error From: ft Reply-To: ml@ft-c.de To: Matthew Seaman , stable@FreeBSD.org Date: Fri, 16 Jun 2023 09:32:29 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.44.4 FreeBSD GNOME Team List-Id: Production branch of FreeBSD source code List-Archive: https://lists.freebsd.org/archives/freebsd-stable List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-stable@freebsd.org X-BeenThere: freebsd-stable@freebsd.org MIME-Version: 1.0 X-Rspamd-Queue-Id: 4Qj9q50p6mz4Chc X-Spamd-Bar: ---- X-Spamd-Result: default: False [-4.00 / 15.00]; REPLY(-4.00)[]; ASN(0.00)[asn:29670, ipnet:192.109.42.0/24, country:DE] X-Rspamd-Pre-Result: action=no action; module=replies; Message is reply to one we originated X-ThisMailContainsUnwantedMimeParts: N 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)