On 16/06/2023 08:32, ft wrote:
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 messagesI get an error, (1). when I create 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"Thank you very much for the report. The symbol you mention only appears in the curl sources -- there's no reference from pg_citus. So I feel this may be more a problem in curl than to do with pg_citus. Can I as what version of curl you have installed, and what options you used to build that port?Hello your first question: version of curl pkg info curl curl-8.1.1
[...]curl-8.1.2 is current, but being one patchlevel behind should not be a problem. Looks fine.
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 => /usr/local/lib/libnghttp2.so.14 (0x80153d000)
Also fine.I've tried to reproduce the problem, but without success so far. I note that was using the default options settings for pg_citus which does have ANONSTATS disabled. Given that enabling ANONSTATS is the only reason for pg_citus to have anything at all to do with libcurl, I see I need to test with that option enabled.
If you're desperate for a workaround though, try ensuring ANONSTATS is off and rebuild pg_citus.
Cheers, Matthew
OpenPGP_signature
Description: OpenPGP digital signature