Re: pg_citus extension error

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 messages
>>>
>>> I 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