From: Tom Lane <tgl@sss.pgh.pa.us>
To: Tomas Vondra <tomas.vondra@enterprisedb.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Subject: Re: dikkop seems unhappy because of openssl stuff (FreeBSD 14-BETA1)
Date: Tue, 19 Sep 2023 19:24:50 -0400
Message-ID: <425660.1695165890@sss.pgh.pa.us> (raw)
In-Reply-To: <20f76b64-c572-7320-64cc-2f6fb3548552@enterprisedb.com>
References: <316d304a-1dcd-cea1-3d6c-27f794727a06@enterprisedb.com>
<220198.1695063151@sss.pgh.pa.us>
<595acc76-6b9c-1445-67e4-00c84cb1a4d8@enterprisedb.com>
<380389.1695141908@sss.pgh.pa.us>
<20f76b64-c572-7320-64cc-2f6fb3548552@enterprisedb.com>
Tomas Vondra <tomas.vondra@enterprisedb.com> writes:
> bsd@freebsd:~ $ tclsh8.6
> % clock scan "1/26/2010"
> time value too large/small to represent
In hopes of replicating this, I tried installing FreeBSD 14-BETA2
aarch64 on my Pi 3B. This test case works fine:
$ tclsh8.6
% clock scan "1/26/2010"
1264482000
$ tclsh8.7
% clock scan "1/26/2010"
1264482000
and unsurprisingly, pltcl's regression tests pass. I surmise
that something is broken in BETA1 that they fixed in BETA2.
plpython works too, with the python 3.9 package (and no older
python).
However, all is not peachy, because plperl doesn't work.
Trying to CREATE EXTENSION either plperl or plperlu leads
to a libperl panic:
pl_regression=# create extension plperl;
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.
with this in the postmaster log:
panic: pthread_key_create failed
That message is certainly not ours, so it must be coming out of libperl.
Another thing that seemed strange is that ecpg's preproc.o takes
O(forever) to compile. I killed the build after observing that the
compiler had gotten to 40 minutes of CPU time, and redid that step
with PROFILE=-O0, which allowed it to compile in 20 seconds or so.
(I also tried -O1, but gave up after a few minutes.) This machine
can compile the main backend grammar in a minute or two, so there is
something very odd there.
I'm coming to the conclusion that 14-BETA is, well, beta grade.
I'll be interested to see if you get the same results when you
update to BETA2.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: tgl@sss.pgh.pa.us, tomas.vondra@enterprisedb.com, pgsql-hackers@lists.postgresql.org
Subject: Re: dikkop seems unhappy because of openssl stuff (FreeBSD 14-BETA1)
In-Reply-To: <425660.1695165890@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox