Re: dikkop seems unhappy because of openssl stuff (FreeBSD 14-BETA1) - Mailing list pgsql-hackers

From Thomas Munro
Subject Re: dikkop seems unhappy because of openssl stuff (FreeBSD 14-BETA1)
Date
Msg-id CA+hUKGLSBemXaDRsFexkpMPMmabPmT+weWBUREumOt2uPTtiqg@mail.gmail.com
Whole thread Raw
In response to Re: dikkop seems unhappy because of openssl stuff (FreeBSD 14-BETA1)  (Michael Paquier <michael@paquier.xyz>)
Responses Re: dikkop seems unhappy because of openssl stuff (FreeBSD 14-BETA1)
List pgsql-hackers
On Tue, Sep 19, 2023 at 2:04 PM Michael Paquier <michael@paquier.xyz> wrote:
> On Mon, Sep 18, 2023 at 03:11:27PM +0200, Tomas Vondra wrote:
> > Both 11 and 12 failed with a weird openssl segfaults in plpython tests,
> > see [2] and [3]. And 13 is stuck in some openssl stuff in plpython
> > tests, with 100% CPU usage (for ~30h now):
> >
> > #0  0x00000000850e86c0 in OPENSSL_sk_insert ()
> >     from /usr/local/lib/libcrypto.so.11
> > #1  0x00000000850a5848 in CRYPTO_set_ex_data ()
> >     from /usr/local/lib/libcrypto.so.11
> > ...
> >
> > Full backtrace attached. I'm not sure what could possibly be causing
> > this, except maybe something in FreeBSD? Or maybe there's some confusion
> > about libraries? No idea.
>
> FWIW, I've seen such corrupted and time-sensitive stacks in the past
> in the plpython tests in builds when python linked to a SSL library
> different than what's linked with the backend.  So that smells like a
> packaging issue to me.

Could it be confusion due to the presence of OpenSSL 3.0 in the
FreeBSD base system (/usr/include, /usr/lib) combined with the
presence of OpenSSL 1.1.1 installed with "pkg install openssl"
(/usr/local/include, /usr/local/lib)?  Tomas, does it help if you "pkg
remove openssl"?



pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Improving btree performance through specializing by key shape, take 2
Next
From: "Hayato Kuroda (Fujitsu)"
Date:
Subject: RE: pg_ctl start may return 0 even if the postmaster has been already started on Windows