Re: Vers. 8.3.0: "make check" fails dismally

From: imacat <imacat(at)mail(dot)imacat(dot)idv(dot)tw>
To: PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Vers. 8.3.0: "make check" fails dismally
Date: 2008-02-11 18:27:21
Message-ID: 20080212022711.5ECF.8909D663@mail.imacat.idv.tw
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Wed, 06 Feb 2008 11:26:16 -0500
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> > Am Mittwoch, 6. Februar 2008 schrieb Mike Dowling:
> >> Naively checking the build using "make check" (yes, gnu make, and as an
> >> unprivaleged user) fails all tests. The apparent reason is that
> >> postgres cannot find its shared libraries.
> > Which platform?
> An idea that comes to mind is that you had an older PG version already
> installed and for some reason the dynamic loader tried to resolve
> libpq.so as the older version instead of the newer one. If that's the
> problem then a temporary workaround such as LD_LIBRARY_PATH is often the
> best answer for running "make check", since the issue will disappear
> after you "make install" anyway.

No. Setting LD_LIBRARY_PATH does not work for me. The test system
is looking for libpq.so.5, but not libpq.so. If I move the old
/usr/lib/libpq.so.5 to somewhere else, everything works.

My platforms are Debian GNU/Linux 4.0 Etch r2, kernel 2.6.22.10, GCC
4.1.2, GLIBC 2.3.6, i386 and x86_64. My configuration is:

./configure --prefix=/usr

The result is below. I would be very appreciated if someone can
tell me where I did wrong.

imacat(at)rinse src/postgresql-8.3.0 % pwd
/usr/local/src/postgresql-8.3.0
imacat(at)rinse src/postgresql-8.3.0 % export LD_LIBRARY_PATH=/usr/local/src/postgresql-8.3.0/src/test/regress/tmp_check/install/usr/lib
imacat(at)rinse src/postgresql-8.3.0 % make check
All of PostgreSQL successfully made. Ready to install.
============== removing existing temp installation ==============
============== creating temporary installation ==============
============== initializing database system ==============
============== starting postmaster ==============
running on port 55432 with pid 20391
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
============== installing plpgsql ==============
CREATE LANGUAGE
============== running regression test queries ==============
parallel group (17 tests): boolean char name varchar text int2 int4 int8 float4 bit oid float8 numeric txid uuid enum money
boolean ... FAILED
char ... FAILED
name ... FAILED
varchar ... FAILED
text ... FAILED
int2 ... FAILED
int4 ... FAILED
int8 ... FAILED
oid ... FAILED
float4 ... FAILED
float8 ... FAILED
bit ... FAILED
numeric ... FAILED
txid ... FAILED
uuid ... FAILED
enum ... FAILED
money ... FAILED
test strings ... FAILED
test numerology ... FAILED
parallel group (18 tests): point lseg box path polygon circle date time timetz timestamp timestamptz interval tinterval tstypes abstime reltime comments inet
point ... FAILED
lseg ... FAILED
box ... FAILED
path ... FAILED
polygon ... FAILED
circle ... FAILED
date ... FAILED
time ... FAILED
timetz ... FAILED
timestamp ... FAILED
timestamptz ... FAILED
interval ... FAILED
abstime ... FAILED
reltime ... FAILED
tinterval ... FAILED
inet ... FAILED
tstypes ... FAILED
comments ... FAILED
parallel group (5 tests): geometry horology type_sanity opr_sanity oidjoins
geometry ... FAILED
horology ... FAILED
oidjoins ... FAILED
type_sanity ... FAILED
opr_sanity ... FAILED
test insert ... FAILED
test create_function_1 ... FAILED
test create_type ... FAILED
test create_table ... FAILED
test create_function_2 ... FAILED
parallel group (2 tests): copy copyselect
copy ... FAILED
copyselect ... FAILED
parallel group (8 tests): constraints triggers create_misc create_operator inherit vacuum drop_if_exists create_aggregate
constraints ... FAILED
triggers ... FAILED
create_misc ... FAILED
create_aggregate ... FAILED
create_operator ... FAILED
inherit ... FAILED
vacuum ... FAILED
drop_if_exists ... FAILED
parallel group (2 tests): create_index create_view
create_index ... FAILED
create_view ... FAILED
test sanity_check ... FAILED
test errors ... FAILED
test select ... FAILED
parallel group (20 tests): select_into select_distinct select_distinct_on select_implicit select_having subselect union case join aggregates transactions random portals arrays btree_index hash_index update prepared_xacts delete namespace
select_into ... FAILED
select_distinct ... FAILED
select_distinct_on ... FAILED
select_implicit ... FAILED
select_having ... FAILED
subselect ... FAILED
union ... FAILED
case ... FAILED
join ... FAILED
aggregates ... FAILED
transactions ... FAILED
random ... failed (ignored)
portals ... FAILED
arrays ... FAILED
btree_index ... FAILED
hash_index ... FAILED
update ... FAILED
namespace ... FAILED
prepared_xacts ... FAILED
delete ... FAILED
test privileges ... FAILED
test misc ... FAILED
parallel group (10 tests): select_views portals_p2 rules cluster guc foreign_key dependency combocid tsearch tsdicts
select_views ... FAILED
portals_p2 ... FAILED
rules ... FAILED
foreign_key ... FAILED
cluster ... FAILED
dependency ... FAILED
guc ... FAILED
combocid ... FAILED
tsearch ... FAILED
tsdicts ... FAILED
parallel group (18 tests): plancache limit plpgsql copy2 temp domain rangefuncs prepare without_oid conversion truncate alter_table sequence polymorphism rowtypes returning largeobject xml
plancache ... FAILED
limit ... FAILED
plpgsql ... FAILED
copy2 ... FAILED
temp ... FAILED
domain ... FAILED
rangefuncs ... FAILED
prepare ... FAILED
without_oid ... FAILED
conversion ... FAILED
truncate ... FAILED
alter_table ... FAILED
sequence ... FAILED
polymorphism ... FAILED
rowtypes ... FAILED
returning ... FAILED
largeobject ... FAILED
xml ... FAILED
test stats ... FAILED
test tablespace ... FAILED
============== shutting down postmaster ==============
server stopped

=======================================================
114 of 114 tests failed, 1 of these failures ignored.
=======================================================

The differences that caused some tests to fail can be viewed in the
file "./regression.diffs". A copy of the test summary that you see
above is saved in the file "./regression.out".

make[2]: *** [check] Error 1
make[1]: *** [check] Error 2
make: *** [check] Error 2
imacat(at)rinse src/postgresql-8.3.0 % ls /usr/local/src/postgresql-8.3.0/src/test/regress/tmp_check/install/usr/lib
libecpg.a libecpg.so libpgtypes.so libpq.so.5
libecpg_compat.a libecpg.so.6 libpgtypes.so.3 libpq.so.5.1
libecpg_compat.so libecpg.so.6.0 libpgtypes.so.3.0 postgresql
libecpg_compat.so.3 libpgport.a libpq.a
libecpg_compat.so.3.0 libpgtypes.a libpq.so
imacat(at)rinse src/postgresql-8.3.0 %

--
Best regards,
imacat ^_*' <imacat(at)mail(dot)imacat(dot)idv(dot)tw>
PGP Key: http://www.imacat.idv.tw/me/pgpkey.asc

<<Woman's Voice>> News: http://www.wov.idv.tw/
Tavern IMACAT's: http://www.imacat.idv.tw/
TLUG List Manager: http://lists.linux.org.tw/cgi-bin/mailman/listinfo/tlug

Browse pgsql-bugs by date

  From Date Subject
Next Message Magnus Hagander 2008-02-11 19:55:27 Re: BUG #3948: date/time functions returning wrong value
Previous Message Dave Page 2008-02-11 16:40:48 Re: BUG #3947: Unable to Initialize Data Cluster