Re: Vers. 8.3.0: "make check" fails dismally - Mailing list pgsql-bugs

On Wed, 06 Feb 2008 11:26:16 -0500
Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Peter Eisentraut <peter_e@gmx.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=3D/usr

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

imacat@rinse src/postgresql-8.3.0 % pwd
/usr/local/src/postgresql-8.3.0
imacat@rinse src/postgresql-8.3.0 % export LD_LIBRARY_PATH=3D/usr/local/src=
/postgresql-8.3.0/src/test/regress/tmp_check/install/usr/lib
imacat@rinse src/postgresql-8.3.0 % make check
All of PostgreSQL successfully made. Ready to install.
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D removing existing temp installat=
ion    =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D creating temporary installation =
       =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D initializing database system    =
       =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D starting postmaster             =
       =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
running on port 55432 with pid 20391
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D creating database "regression"  =
       =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
CREATE DATABASE
ALTER DATABASE
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D installing plpgsql              =
       =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
CREATE LANGUAGE
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D running regression test queries =
       =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
parallel group (17 tests):  boolean char name varchar text int2 int4 int8 f=
loat4 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 ti=
metz timestamp timestamptz interval tinterval tstypes abstime reltime comme=
nts 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 transact=
ions random portals arrays btree_index hash_index update prepared_xacts del=
ete 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 forei=
gn_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 range=
funcs prepare without_oid conversion truncate alter_table sequence polymorp=
hism 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
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D shutting down postmaster        =
       =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
server stopped

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

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@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@rinse src/postgresql-8.3.0 %

--
Best regards,
imacat ^_*' <imacat@mail.imacat.idv.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