X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 592B4329D7F for ; Sat, 2 Oct 2004 23:16:45 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 90293-10 for ; Sat, 2 Oct 2004 22:16:38 +0000 (GMT) Received: from mail.ccis.com (mail.ccis.com [204.118.241.3]) by svr1.postgresql.org (Postfix) with ESMTP id A6774329E7D for ; Sat, 2 Oct 2004 23:16:40 +0100 (BST) Received: from [10.0.0.1] (unverified [4.46.202.191]) by mail.ccis.com (SurgeMail 2.0g2) with ESMTP id 13259112 for ; Sat, 02 Oct 2004 15:06:57 -0700 Message-ID: <415F2BFC.1080303@ccis.com> Date: Sat, 02 Oct 2004 15:30:20 -0700 From: John McBride User-Agent: Mozilla Thunderbird 0.6 (X11/20040519) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: fedora core 2 postgresql regression tests fail References: <415B866D.4090203@ccis.com> <415E8308.9080004@ccis.com> In-Reply-To: <415E8308.9080004@ccis.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Server: High Performance Mail Server - http://surgemail.com X-Authenticated-User: jmcbride Domain mail.ccis.com X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_RFCI X-Spam-Level: X-Archive-Number: 200410/54 X-Sequence-Number: 15047 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 *** ./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.