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 11:45:46 -0700
Message-ID: <415EF75A.5000404@ccis.com> (raw)
In-Reply-To: <cjh92a$18d4$1@news.hub.org>
References: <415B866D.4090203@ccis.com>
<cjh92a$18d4$1@news.hub.org>
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
>> ....
>> ====================================================
>> 6 of 93 tests failed, 1 of these failures ignored.
>> ====================================================
>
> might or might not help for your test, there is a 7.4.5 version for
> fedora core 2.
>
> you can find it on any of the mirrors, for example:
> ftp://ftp7.de.postgresql.org/pub/ftp.postgresql.org/binary/v7.4.5/rpms/fedora/fedora-core-2
>
I forgot to mention something. It looks like the tests are setup for
people who install from source, not rpm.
The README file says to run "gmake check" to run the regression tests;
if I do that I get:
$ gmake check
GNUmakefile:16: ../../../src/Makefile.global: No such file or directory
gmake: *** No rule to make target `../../../src/Makefile.global'. Stop.
So I look at the makefile and try to run the command myself (I have seen
from google that some other people do this, too) :
$ time ./pg_regress.sh --schedule=parallel_schedule
-bash: ./pg_regress.sh: Permission denied
real 0m0.006s
user 0m0.000s
sys 0m0.002s
$ chmod +x ./pg_regress.sh
$ time ./pg_regress.sh --schedule=parallel_schedule(using postmaster on
Unix socket, default port)
============== dropping database "regression" ==============
./pg_regress.sh: line 450: @bindir@/dropdb: No such file or directory
============== creating database "regression" ==============
./pg_regress.sh: line 490: @bindir@/createdb: No such file or directory
pg_regress.sh: createdb failed
real 0m1.404s
user 0m0.093s
sys 0m0.195s
Now I change the variable @bindir@ in the script to /usr/bin and try
again, getting the results of my previous email:
====================================================
6 of 93 tests failed, 1 of these failures ignored.
====================================================
(random sometimes fails too but I know about that from the docs).
It is now obvious to me that these failures are probably caused by the
remaining uninitialized variables in pg_regress.sh (if this was a source
build/install "gmake check" would successfully run and "sed" the
variables in the script for me).
I don't know how to set these:
pg_regress: pg_regress.sh GNUmakefile
sed -e 's,@bindir@,$(bindir),g' \
-e 's,@libdir@,$(libdir),g' \
-e 's,@pkglibdir@,$(pkglibdir),g' \
-e 's,@datadir@,$(datadir),g' \
-e 's/@VERSION@/$(VERSION)/g' \
-e 's/@host_tuple@/$(host_tuple)/g' \
-e 's,@GMAKE@,$(MAKE),g' \
-e 's/@enable_shared@/$(enable_shared)/g' \
-e 's/@GCC@/$(GCC)/g' \
$< >$@
chmod a+x $@
---
John
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: <415EF75A.5000404@ccis.com>
References: <415B866D.4090203@ccis.com> <cjh92a$18d4$1@news.hub.org> <415EF75A.5000404@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