From: John McBride <jmcbride@ccis.com>
To: pgsql-admin@postgresql.org
Subject: Re: fedora core 2 postgresql regression tests fail
Date: Sat, 02 Oct 2004 15:30:20 -0700
Message-ID: <415F2BFC.1080303@ccis.com> (raw)
In-Reply-To: <415E8308.9080004@ccis.com>
References: <415B866D.4090203@ccis.com>
<cjh92a$18d4$1@news.hub.org>
<415E8308.9080004@ccis.com>
John McBride wrote:
> stig erikson wrote:
>
>> John McBride wrote:
>>
>>>
>>> As user postgres I try and run the tests:
>>>
>>> $ pwd
>>> /usr/lib/pgsql/test/regress
>>> $ time ./pg_regress.sh --schedule=parallel_schedule
>
> I've no idea what the others should be set to. I think the tests
> directory is setup for people who install from source, rather than
> binary installers.
>
This is most certainly the problem. It looks like the "tests" rpm
depends on the source code being present to run, and it is not there. I
downloaded/built/installed 8b3 and here is the result:
======================
All 96 tests passed.
======================
The variables for a build/install end up as:
bindir=/usr/local/pgsql/bin
libdir=/usr/local/pgsql/lib
pkglibdir=/usr/local/pgsql/lib
datadir=/usr/local/pgsql/share
VERSION=8.0.0beta3
host_tuple=
GMAKE=gmake
enable_shared=yes
GCC=yes
Next I removed 8b3 and reinstalled 7.4.2, added the following set to the
pg_regress.sh:
bindir=/usr/bin
libdir=/usr/lib/pgsql
pkglibdir=/usr/lib/pgsql
datadir=/var/lib/pgsql
VERSION=7.4.2
host_tuple=
GMAKE=gmake
enable_shared=yes
GCC=yes
Now it is down to one error:
test create_function_1 ... FAILED
=======================
1 of 93 tests failed.
=======================
$ cat ./regression.diffs
inline patch 1: ./results/create_function_1.out Sat Oct 2 15:20:50 2004 (+0/-1 lines) download inline-1.patch*** ./expected/create_function_1.out Wed Mar 10 13:36:51 2004
--- ./results/create_function_1.out Sat Oct 2 15:20:50 2004
***************
*** 70,76 ****
ERROR: could not access file "nosuchfile": No such file or directory
CREATE FUNCTION test1 (int) RETURNS int LANGUAGE c
AS '/usr/lib/pgsql/test/regress/regress.so', 'nosuchsymbol';
! ERROR: Can't find function nosuchsymbol in file
/usr/lib/pgsql/test/regress/regress.so
CREATE FUNCTION test1 (int) RETURNS int LANGUAGE internal
AS 'nosuch';
ERROR: there is no built-in function named "nosuch"
--- 70,76 ----
ERROR: could not access file "nosuchfile": No such file or directory
CREATE FUNCTION test1 (int) RETURNS int LANGUAGE c
AS '/usr/lib/pgsql/test/regress/regress.so', 'nosuchsymbol';
! ERROR: could not find function "nosuchsymbol" in file
"/usr/lib/pgsql/test/regress/regress.so"
CREATE FUNCTION test1 (int) RETURNS int LANGUAGE internal
AS 'nosuch';
ERROR: there is no built-in function named "nosuch"
======================================================================
PS sorry about the double post earlier. The first did not show up in my
sent items and the list slowed down temporarily and I did not notice in
time--I thought the first msg was lost.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: jmcbride@ccis.com
Subject: Re: fedora core 2 postgresql regression tests fail
In-Reply-To: <415F2BFC.1080303@ccis.com>
References: <415B866D.4090203@ccis.com> <cjh92a$18d4$1@news.hub.org> <415E8308.9080004@ccis.com> <415F2BFC.1080303@ccis.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox