NetBSD Problem Report #25473

Received: (qmail 9695 invoked by uid 605); 5 May 2004 16:24:52 -0000
Message-Id: <20040505162450.70D9C68@mail.pacang.com>
Date: Wed,  5 May 2004 09:24:50 -0700 (PDT)
From: bservies@pacang.com
Sender: gnats-bugs-owner@NetBSD.org
Reply-To: bservies@pacang.com
To: gnats-bugs@gnats.netbsd.org
Subject: Postgresql-7.3.2 fails to load languages on netbsd-1.6/cobalt
X-Send-Pr-Version: 3.95

>Number:         25473
>Category:       pkg
>Synopsis:       Postgresql-7.3.2 fails to load languages on netbsd-1.6/cobalt
>Confidential:   no
>Severity:       serious
>Priority:       medium
>Responsible:    pkg-manager
>State:          closed
>Class:          sw-bug
>Submitter-Id:   net
>Arrival-Date:   Wed May 05 16:25:00 +0000 2004
>Closed-Date:    Sun Oct 10 17:31:22 +0000 2004
>Last-Modified:  Mon Nov 08 16:44:01 +0000 2004
>Originator:     Byron Servies
>Release:        NetBSD 1.6.2
>Organization:
	Self
>Environment:
System: NetBSD piglet.central 1.6.2 NetBSD 1.6.2 (BYRON) #1: Mon Mar 1 21:23:26 PST 2004 root@piglet.central:/usr/src/sys/arch/cobalt/compile/BYRON cobalt
Architecture: mipsel
Machine: cobalt
>Description:
	After building postgresql-7.3.2 from pkgsrc I attempted to add
	the plpgsql scripting language to the database using the command:

	$ createlang plpgsql template1
	ERROR:  Load of file /usr/pkg/lib/postgresql/plpgsql.so failed: dlopen (/usr/pkg/lib/postgresql/plpgsql.so) not supported
	createlang: language installation failed

	Investigating this problem, I found that the dynaloader.c file (which
	abstracts dlopen, etc., calls) contained blocks of "if defined(__mips__)"
	that print the 'not supported' error and return a fault instead of
	calling dlopen.

>How-To-Repeat:
	Build postgresql and attempt to load the language as shown above.
	Note that I am running a kernel with the following settings for
	semaphores so that postgres will start:
	options       SEMMNI=2000     # number of semaphore identifiers
	options       SEMMNS=12000    # number of semaphores in system
	options       SEMUME=2000     # max number of undo entries per process
	options       SEMMNU=6000     # number of undo structures in system
>Fix:
	I replaced these with "ifndef HAVE_DLOPEN" and rebuilt.  The database
	now loads languages and passes nearly all the provided regression
	tests (which would not run before because they required the plpgsql
	language).
>Release-Note:
>Audit-Trail:

From: Jaromir Dolecek <jdolecek@netbsd.org>
To: gnats-bugs@gnats.NetBSD.org
Cc:  
Subject: pr/25473 CVS commit: pkgsrc/databases/postgresql74
Date: Sun, 10 Oct 2004 16:44:39 +0000 (UTC)

 Module Name:	pkgsrc
 Committed By:	jdolecek
 Date:		Sun Oct 10 16:44:39 UTC 2004

 Modified Files:
 	pkgsrc/databases/postgresql74: Makefile.common
 Added Files:
 	pkgsrc/databases/postgresql74/files: netbsd.c netbsd.h

 Log Message:
 Update the NetBSD dynloader wrapper code to use straigh dl*() calls on all
 archs. This fixes support for dynamic loading on mips, and adresses
 PR pkg/25473 by Byron Servies.


 To generate a diff of this commit:
 cvs rdiff -r1.12 -r1.13 pkgsrc/databases/postgresql74/Makefile.common
 cvs rdiff -r0 -r1.1 pkgsrc/databases/postgresql74/files/netbsd.c \
     pkgsrc/databases/postgresql74/files/netbsd.h

 Please note that diffs are not public domain; they are subject to the
 copyright notices on the relevant files.


From: Jaromir Dolecek <jdolecek@netbsd.org>
To: gnats-bugs@gnats.NetBSD.org
Cc:  
Subject: pr/25473 CVS commit: pkgsrc/databases/postgresql73
Date: Sun, 10 Oct 2004 17:27:43 +0000 (UTC)

 Module Name:	pkgsrc
 Committed By:	jdolecek
 Date:		Sun Oct 10 17:27:43 UTC 2004

 Modified Files:
 	pkgsrc/databases/postgresql73: Makefile.common
 Added Files:
 	pkgsrc/databases/postgresql73/files: netbsd.c netbsd.h

 Log Message:
 Update the NetBSD dynloader wrapper code to use straigh dl*() calls on all
 archs. This fixes support for dynamic loading on mips and also improves
 error reporting.

 Fixes PR pkg/25473 by Byron Servies.

 PKGREVISION not bumped, will ride update to 7.3.7


 To generate a diff of this commit:
 cvs rdiff -r1.2 -r1.3 pkgsrc/databases/postgresql73/Makefile.common
 cvs rdiff -r0 -r1.1 pkgsrc/databases/postgresql73/files/netbsd.c \
     pkgsrc/databases/postgresql73/files/netbsd.h

 Please note that diffs are not public domain; they are subject to the
 copyright notices on the relevant files.

State-Changed-From-To: open->closed 
State-Changed-By: jdolecek 
State-Changed-When: Sun Oct 10 17:30:51 UTC 2004 
State-Changed-Why:  
Fix for this (similar to what you suggested) was committed to pkgsrc. 
Thanks for report. 

From: Lubomir Sedlacik <salo@netbsd.org>
To: gnats-bugs@gnats.NetBSD.org
Cc:  
Subject: pr/25473 CVS commit: [pkgsrc-2004Q3] pkgsrc/databases
Date: Mon,  8 Nov 2004 16:43:30 +0000 (UTC)

 Module Name:	pkgsrc
 Committed By:	salo
 Date:		Mon Nov  8 16:43:29 UTC 2004

 Modified Files:
 	pkgsrc/databases/jdbc-postgresql [pkgsrc-2004Q3]: Makefile distinfo
 	pkgsrc/databases/postgresql73 [pkgsrc-2004Q3]: Makefile.common distinfo
 	pkgsrc/databases/postgresql73-client [pkgsrc-2004Q3]: Makefile
 	pkgsrc/databases/postgresql73-docs [pkgsrc-2004Q3]: Makefile PLIST
 	pkgsrc/databases/postgresql73/patches [pkgsrc-2004Q3]: patch-ad
 Added Files:
 	pkgsrc/databases/postgresql73/files [pkgsrc-2004Q3]: netbsd.c netbsd.h
 	pkgsrc/databases/postgresql73/patches [pkgsrc-2004Q3]: patch-aj

 Log Message:
 Pullup ticket 126 - requested by Havard Eidnes
 security and bug fixes for postgresql73

         Module Name:    pkgsrc
         Committed By:   jdolecek
         Date:           Sun Oct 10 15:58:03 UTC 2004

         Modified Files:
                 pkgsrc/databases/postgresql73-client: Makefile

         Log Message:
         kill -O pax argument - it's not portable, and it's not needed here
         in first place

         fixes PR pkg/23829 by Michal Pasternak
 ---
         Module Name:    pkgsrc
         Committed By:   jdolecek
         Date:           Sun Oct 10 17:27:43 UTC 2004

         Modified Files:
                 pkgsrc/databases/postgresql73: Makefile.common
         Added Files:
                 pkgsrc/databases/postgresql73/files: netbsd.c netbsd.h

         Log Message:
         Update the NetBSD dynloader wrapper code to use straigh dl*() calls on all
         archs. This fixes support for dynamic loading on mips and also improves
         error reporting.

         Fixes PR pkg/25473 by Byron Servies.

         PKGREVISION not bumped, will ride update to 7.3.7
 ---
         Module Name:    pkgsrc
         Committed By:   jdolecek
         Date:           Sun Oct 10 17:46:07 UTC 2004

         Modified Files:
                 pkgsrc/databases/postgresql73: Makefile.common distinfo
                 pkgsrc/databases/postgresql73-client: Makefile
                 pkgsrc/databases/postgresql73-lib: Makefile
                 pkgsrc/databases/postgresql73-pltcl: Makefile
                 pkgsrc/databases/postgresql73-server: Makefile
                 pkgsrc/doc: CHANGES

         Log Message:
         Update to PostgreSQL 7.3.7.

         Changes:
              * Prevent possible loss of committed transactions during crash
                Due to insufficient interlocking between transaction commit and
                checkpointing, it was possible for transactions committed just
                before the most recent checkpoint to be lost, in whole or in part,
                following a database crash and restart. This is a serious bug that
                has existed since PostgreSQL 7.1.
              * Remove asymmetrical word processing in tsearch (Teodor)
              * Properly schema-qualify function names when pg_dump'ing a CAST
 ---
         Module Name:    pkgsrc
         Committed By:   jdolecek
         Date:           Sun Oct 10 17:48:34 UTC 2004

         Modified Files:
                 pkgsrc/databases/jdbc-postgresql: Makefile distinfo
                 pkgsrc/doc: CHANGES

         Log Message:
         Update to JDBC driver included with PostgreSQL 7.3.7.

         Notable change in 7.3.5:
              * Remove  ability  to bind a list of values to a single parameter in
                JDBC (prevents possible SQL-injection attacks)
 ---
         Module Name:    pkgsrc
         Committed By:   kristerw
         Date:           Thu Oct 14 17:58:43 UTC 2004

         Modified Files:
                 pkgsrc/databases/postgresql73-docs: Makefile PLIST

         Log Message:
         Correct PLIST.
         Bump PKGREVISION.
 ---
         Module Name:    pkgsrc
         Committed By:   jdolecek
         Date:           Sun Oct 10 18:26:00 UTC 2004

         Modified Files:
                 pkgsrc/databases/postgresql73: distinfo
                 pkgsrc/databases/postgresql73/patches: patch-ad
         Added Files:
                 pkgsrc/databases/postgresql73/patches: patch-aj

         Log Message:
         add patches to make it possible to compile PL/Python
 ---
         Module Name:    pkgsrc
         Committed By:   jdolecek
         Date:           Mon Oct 25 17:40:01 UTC 2004

         Modified Files:
                 pkgsrc/databases/jdbc-postgresql: Makefile distinfo
                 pkgsrc/databases/postgresql73: Makefile.common distinfo
                 pkgsrc/databases/postgresql73-docs: Makefile
                 pkgsrc/doc: CHANGES

         Log Message:
         Update all postgresql73 packages to 7.3.8. This fixes following two issues:

         * A vulnerability exists due to the insecure creation of temporary files,
           which could possibly let a malicious user overwrite arbitrary files

         * Repair possible failure to update hint bits on disk
           Under rare circumstances this oversight could lead to "could not access
           transaction status" failures, which qualifies it as a potential-data-loss bug.
 ---
         Module Name:    pkgsrc
         Committed By:   he
         Date:           Mon Nov  1 22:32:26 UTC 2004

         Modified Files:
                 pkgsrc/databases/postgresql73-docs: PLIST

         Log Message:
         Correct PLIST after upgrade to postgresql 7.3.8.


 To generate a diff of this commit:
 cvs rdiff -r1.23 -r1.23.6.1 pkgsrc/databases/jdbc-postgresql/Makefile
 cvs rdiff -r1.9 -r1.9.8.1 pkgsrc/databases/jdbc-postgresql/distinfo
 cvs rdiff -r1.2 -r1.2.2.1 pkgsrc/databases/postgresql73/Makefile.common
 cvs rdiff -r1.1.1.1 -r1.1.1.1.2.1 pkgsrc/databases/postgresql73/distinfo
 cvs rdiff -r1.1.1.1 -r1.1.1.1.2.1 \
     pkgsrc/databases/postgresql73-client/Makefile
 cvs rdiff -r1.1.1.1 -r1.1.1.1.2.1 pkgsrc/databases/postgresql73-docs/Makefile \
     pkgsrc/databases/postgresql73-docs/PLIST
 cvs rdiff -r0 -r1.1.2.1 pkgsrc/databases/postgresql73/files/netbsd.c \
     pkgsrc/databases/postgresql73/files/netbsd.h
 cvs rdiff -r1.1.1.1 -r1.1.1.1.2.1 \
     pkgsrc/databases/postgresql73/patches/patch-ad
 cvs rdiff -r0 -r1.1.2.1 pkgsrc/databases/postgresql73/patches/patch-aj

 Please note that diffs are not public domain; they are subject to the
 copyright notices on the relevant files.

>Unformatted:
 >Quarter:
 >Keywords:
 >Date-Required:

NetBSD Home
NetBSD PR Database Search

(Contact us) $NetBSD: query-full-pr,v 1.51 2026/08/10 02:28:17 riastradh Exp $
$NetBSD: gnats_config.sh,v 1.10 2026/05/13 22:00:09 riastradh Exp $
Copyright © 1994-2026 The NetBSD Foundation, Inc. ALL RIGHTS RESERVED.