Re: DSM robustness failure (was Re: Peripatus/failures)

Larry Rosenman <ler(at)lerctr(dot)org> writes:
> On Wed, Oct 17, 2018 at 08:10:28PM -0400, Tom Lane wrote:
>> However, I'm still slightly interested in how it
>> was that that broke DSM so thoroughly ... I pulled down your version of
>> python2.7 and will see if that reproduces it.

> It was built on a previous alpha, so who knows what the differing
> compiler/libs/kernel/etc did. The options used did *NOT* change, just
> the userland used to compile it. (I.E. that package, running on
> ALPHA10 is what broke).

Hm. I forcibly installed your package over the regular one using
pkg add -f python27-2.7.15.txz
and rebuilt PG, and what I get is a failure in the plpython regression
test, but no crash. So I'm still confused.

*** /usr/home/tgl/pgsql/src/pl/plpython/expected/plpython_import.out Wed Oct 17 19:48:19 2018
--- /usr/home/tgl/pgsql/src/pl/plpython/results/plpython_import.out Wed Oct 17 20:50:22 2018
***************
*** 64,79 ****
-- test import and simple argument handling
--
SELECT import_test_one('sha hash of this string');
! import_test_one
! ------------------------------------------
! a04e23cb9b1a09cd1051a04a7c571aae0f90346c
! (1 row)
!
-- test import and tuple argument handling
--
select import_test_two(users) from users where fname = 'willem';
! import_test_two
! -------------------------------------------------------------------
! sha hash of willemdoe is 3cde6b574953b0ca937b4d76ebc40d534d910759
! (1 row)
!
--- 64,79 ----
-- test import and simple argument handling
--
SELECT import_test_one('sha hash of this string');
! ERROR: AttributeError: 'module' object has no attribute 'sha1'
! CONTEXT: Traceback (most recent call last):
! PL/Python function "import_test_one", line 3, in <module>
! digest = hashlib.sha1(p.encode("ascii"))
! PL/Python function "import_test_one"
-- test import and tuple argument handling
--
select import_test_two(users) from users where fname = 'willem';
! ERROR: AttributeError: 'module' object has no attribute 'sha1'
! CONTEXT: Traceback (most recent call last):
! PL/Python function "import_test_two", line 4, in <module>
! digest = hashlib.sha1(plain.encode("ascii"))
! PL/Python function "import_test_two"

======================================================================

regards, tom lane