pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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.

view thread (7+ messages)  latest in thread

Message-ID: <415F2BFC.1080303@ccis.com>
Permalink:  ../415F2BFC.1080303@ccis.com/
Also on:    postgresql.org/message-id/415F2BFC.1080303@ccis.com

 ·  · 

reply

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