pkg/40592: Trouble with plperl and plpythonu

[peter%ssbg.zetnet.co.uk@localhost]

>Number:         40592
>Category:       pkg
>Synopsis:       Trouble with plperl and plpythonu
>Confidential:   no
>Severity:       serious
>Priority:       medium
>Responsible:    pkg-manager
>State:          open
>Class:          sw-bug
>Submitter-Id:   net
>Arrival-Date:   Mon Feb 09 17:40:00 +0000 2009
>Originator:     Peter Hardman
>Release:        4.0.1
>Organization:
>Environment:
NetBSD server04.acrecott.local 4.0.1 NetBSD 4.0.1 (GENERIC) #0: Tue Oct  7 
22:58:48 PDT 2008  
builds@wb30:/home/builds/ab/netbsd-4-0-1-RELEASE/i386/200810080053Z-obj/home/builds/ab/netbsd-4-0-1-RELEASE/src/sys/arch/i386/compile/GENERIC
 i386
>Description:
postgresql command 

createlang -U pgsql plpythonu template1

fails with the message
"createlang: language installation failed: server closed the connection 
unexpectedly"

Although I haven't run the kernel degugger, this seems to be a re-run of the 
problem with pkgsrc supposedly fixed in problem report #28729 and discussed at 
length in the threads 'Re Threading problems' and 'pthread + pkgsrc proposal' 
in tech-pkg archives. Somewhat confirmed by my workaround listed below.

This also fails on NetBSD 3.1.
plperl fails with the same message on both platforms.


>How-To-Repeat:
Install packages postgresql8x-server and postgresql8x-plpython from pkgsrc 
current, start the server and run

createlang -U pgsql plpythonu template1


>Fix:
If the server is built with lines 34-36 of 
pkgsrc/databases/postgresql8x-server/Makefile commented out then plpythonu can 
be installed.

Lines are:

.if ${OPSYS} == "NetBSD"
DLOPEN_REQUIRE_PTHREADS=        no
.endif
 
As far as I can make out this was added to fix a problem in 2.x which resulted 
in going to 100% cpu under certain circumstances.