From ml@ft-c.de Fri Jun 16 04:47:25 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 4Qj68d0KLSz4dmyL
for <stable@mlmmj.nyi.freebsd.org>; Fri, 16 Jun 2023 04:47:29 +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 4Qj68c0sHXz3MDS
for <stable@FreeBSD.org>; Fri, 16 Jun 2023 04:47:28 +0000 (UTC)
(envelope-from ml@ft-c.de)
Authentication-Results: mx1.freebsd.org;
dkim=none;
spf=pass (mx1.freebsd.org: domain of ml@ft-c.de designates 192.109.42.8 as permitted sender) smtp.mailfrom=ml@ft-c.de;
dmarc=none
X-Envelope-From: ml@ft-c.de
X-Envelope-To: <stable@FreeBSD.org>
Received: from authenticated.user (localhost [127.0.0.1]) by einhorn.in-berlin.de with ESMTPSA id 35G4lQKA909040
(version=TLSv1.3 cipher=TLS_AES_256_GCM_SHA384 bits=256 verify=NOT)
for <stable@FreeBSD.org>; Fri, 16 Jun 2023 06:47:26 +0200
Message-ID: <bd000b5954f72688dad5d4e08d88eff15a3712b2.camel@ft-c.de>
Subject: pg_citus extension error
From: ft <ml@ft-c.de>
Reply-To: ml@ft-c.de
To: stable@FreeBSD.org
Date: Fri, 16 Jun 2023 06:47:25 +0200
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 <freebsd-stable.freebsd.org>
List-Archive: https://lists.freebsd.org/archives/freebsd-stable
List-Help: <mailto:stable+help@freebsd.org>
List-Post: <mailto:stable@freebsd.org>
List-Subscribe: <mailto:stable+subscribe@freebsd.org>
List-Unsubscribe: <mailto:stable+unsubscribe@freebsd.org>
Sender: owner-freebsd-stable@freebsd.org
X-BeenThere: freebsd-stable@freebsd.org
MIME-Version: 1.0
X-Spamd-Result: default: False [-3.40 / 15.00];
NEURAL_HAM_LONG(-1.00)[-1.000];
NEURAL_HAM_MEDIUM(-1.00)[-1.000];
NEURAL_HAM_SHORT(-0.90)[-0.899];
R_SPF_ALLOW(-0.20)[+ip4:192.109.42.0/24:c];
RCVD_IN_DNSWL_LOW(-0.10)[192.109.42.8:from];
MIME_GOOD(-0.10)[text/plain];
RWL_MAILSPIKE_GOOD(-0.10)[192.109.42.8:from];
RCVD_COUNT_TWO(0.00)[2];
DMARC_NA(0.00)[ft-c.de];
R_DKIM_NA(0.00)[];
ASN(0.00)[asn:29670, ipnet:192.109.42.0/24, country:DE];
FROM_EQ_ENVFROM(0.00)[];
MLMMJ_DEST(0.00)[stable@FreeBSD.org];
MIME_TRACE(0.00)[0:+];
MID_RHS_MATCH_FROM(0.00)[];
TO_DN_NONE(0.00)[];
RCPT_COUNT_ONE(0.00)[1];
RCVD_VIA_SMTP_AUTH(0.00)[];
HAS_REPLYTO(0.00)[ml@ft-c.de];
RCVD_TLS_ALL(0.00)[];
FROM_HAS_DN(0.00)[];
REPLYTO_ADDR_EQ_FROM(0.00)[];
TO_MATCH_ENVRCPT_ALL(0.00)[];
PREVIOUSLY_DELIVERED(0.00)[stable@freebsd.org];
ARC_NA(0.00)[]
X-Rspamd-Queue-Id: 4Qj68c0sHXz3MDS
X-Spamd-Bar: ---
X-ThisMailContainsUnwantedMimeParts: N
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