Re: PL/Python fails on new NetBSD/PPC 8.0 install - Mailing list pgsql-hackers

From Benjamin Scherrey
Subject Re: PL/Python fails on new NetBSD/PPC 8.0 install
Date
Msg-id CACo3ShiJQ5yGJn3s5G3X+a=qXJu3czX2B27sCtNXMxz-JaOhZA@mail.gmail.com
Whole thread Raw
In response to Re: PL/Python fails on new NetBSD/PPC 8.0 install  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: PL/Python fails on new NetBSD/PPC 8.0 install
List pgsql-hackers
None of the output provides any clue to me but I do know that Python 3.7 has some issues with a lot of versions of openssl that is based on a disagreement between devs in both projects. This was a problem for me when trying to build python 3.7 on my Kubuntu 14.04 system. I've seen this issue reported across all targets for Python including Freebsd so I expect it's likely to also happen for NetBSD. 

Perhaps this might be related to the problem? 

On Mon, Oct 28, 2019, 8:12 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Awhile back I wrote:
> I noticed that the old NetBSD 5.1.5 installation I had on my G4 Mac
> was no longer passing our regression tests, because it has a strtof()
> that is sloppy about underflow.  Rather than fight with that I decided
> to update it to something shinier (well, as shiny as you can get on
> hardware that's old enough to apply for a driver's license).  I stuck in
> NetBSD/macppc 8.0, and things seem to work, except that PL/Python
> crashes on launch.  I see something like this in the postmaster log:

> Traceback (most recent call last):
>   File "<frozen importlib._bootstrap>", line 1162, in _install_external_importers
>   File "<frozen importlib._bootstrap>", line 980, in _find_and_load
>   File "<frozen importlib._bootstrap>", line 149, in __enter__
>   File "<frozen importlib._bootstrap>", line 84, in acquire
> RuntimeError: no current thread ident
> Fatal Python error: initexternalimport: external importer setup failed
>
> Current thread 0xffffffff (most recent call first):
> 2019-06-18 17:40:59.629 EDT [20764] LOG:  server process (PID 23714) was terminated by signal 6: Abort trap
> 2019-06-18 17:40:59.629 EDT [20764] DETAIL:  Failed process was running: CREATE FUNCTION stupid() RETURNS text AS 'return "zarkon"' LANGUAGE plpython3u;

So ... I just got this identical failure on NetBSD 8.1 on a shiny
new Intel NUC box.  So that removes the excuse of old unsupported
hardware, and leaves us with the conclusion that PL/Python is
flat out broken on recent NetBSD.

This is with today's HEAD of our code and the python37-3.7.4/amd64
package from NetBSD 8.1.

BTW, the only somewhat-modern NetBSD machine in our buildfarm is
coypu, which is running NetBSD/macppc 8.0 ... but what it is testing
PL/Python against is python 2.7.15, so the fact that it doesn't
fail can probably be explained as a python 2 vs python 3 thing.

                        regards, tom lane


pgsql-hackers by date:

Previous
From: Joe Nelson
Date:
Subject: Re: Change atoi to strtol in same place
Next
From: Kyotaro Horiguchi
Date:
Subject: Re: Proposal: Add more compile-time asserts to exposeinconsistencies.