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:
(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.