Thread: Failed regression test in postgresql-7.4

Failed regression test in postgresql-7.4

From
lanewhoy@mrcoffee.umich.edu
Date:
If PostgreSQL failed to compile on your computer or you found a bug that
is likely to be specific to one platform then please fill out this form
and e-mail it to pgsql-ports@postgresql.org.

To report any other bug, fill out the form below and e-mail it to
pgsql-bugs@postgresql.org.

If you not only found the problem but solved it and generated a patch
then e-mail it to pgsql-patches@postgresql.org instead.  Please use the
command "diff -c" to generate the patch.

You may also enter a bug report at http://www.postgresql.org/ instead of
e-mail-ing this form.

============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name        : Lane Hoy
Your email address    : lanewhoy@umich.edu


System Configuration
---------------------
  Architecture (example: Intel Pentium)      : Intel Pentium 4

  Operating System (example: Linux 2.0.26 ELF)     : Linux-2.4.23 ELF, Gentoo distribution

  PostgreSQL version (example: PostgreSQL-7.4):   PostgreSQL-7.4

  Compiler used (example:  gcc 2.95.2)        : gcc 3.3.2, glibc-2.3.2-r9


Please enter a FULL description of your problem:
------------------------------------------------
Regression test failed at the createdb stage.  Context below:

All of PostgreSQL successfully made. Ready to install.
make -C src/test check
make[1]: Entering directory `/usr/local/src/postgresql-7.4/src/test'
make -C regress check
make[2]: Entering directory `/usr/local/src/postgresql-7.4/src/test/regress'
sed -e 's,@bindir@,/usr/local/pgsql/bin,g' \
    -e 's,@libdir@,/usr/local/pgsql/lib,g' \
    -e 's,@pkglibdir@,/usr/local/pgsql/lib,g' \
    -e 's,@datadir@,/usr/local/pgsql/share,g' \
    -e 's/@VERSION@/7.4/g' \
    -e 's/@host_tuple@/i686-pc-linux-gnu/g' \
    -e 's,@GMAKE@,make,g' \
    -e 's/@enable_shared@/yes/g' \
    -e 's/@GCC@/yes/g' \
  pg_regress.sh >pg_regress
chmod a+x pg_regress
gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declarations -fpic -I../../../src/interfaces/libpq
-I../../../src/include-D_GNU_SOURCE  -I/usr/local/include -I/usr/local/ssl/include  -c -o regress.o regress.c 
gcc -shared -o regress.so regress.o
sed -e 's,@abs_srcdir@,/usr/local/src/postgresql-7.4/src/test/regress,g' -e
's,@abs_builddir@,/usr/local/src/postgresql-7.4/src/test/regress,g'-e 's/@DLSUFFIX@/.so/g' input/copy.source
>sql/copy.sql
sed -e 's,@abs_srcdir@,/usr/local/src/postgresql-7.4/src/test/regress,g' -e
's,@abs_builddir@,/usr/local/src/postgresql-7.4/src/test/regress,g'-e 's/@DLSUFFIX@/.so/g'
input/create_function_1.source>sql/create_function_1.sql 
sed -e 's,@abs_srcdir@,/usr/local/src/postgresql-7.4/src/test/regress,g' -e
's,@abs_builddir@,/usr/local/src/postgresql-7.4/src/test/regress,g'-e 's/@DLSUFFIX@/.so/g'
input/create_function_2.source>sql/create_function_2.sql 
sed -e 's,@abs_srcdir@,/usr/local/src/postgresql-7.4/src/test/regress,g' -e
's,@abs_builddir@,/usr/local/src/postgresql-7.4/src/test/regress,g'-e 's/@DLSUFFIX@/.so/g' input/misc.source
>sql/misc.sql
sed -e 's,@abs_srcdir@,/usr/local/src/postgresql-7.4/src/test/regress,g' -e
's,@abs_builddir@,/usr/local/src/postgresql-7.4/src/test/regress,g'-e 's/@DLSUFFIX@/.so/g' input/constraints.source
>sql/constraints.sql
sed -e 's,@abs_srcdir@,/usr/local/src/postgresql-7.4/src/test/regress,g' -e
's,@abs_builddir@,/usr/local/src/postgresql-7.4/src/test/regress,g'-e 's/@DLSUFFIX@/.so/g' output/copy.source
>expected/copy.out
sed -e 's,@abs_srcdir@,/usr/local/src/postgresql-7.4/src/test/regress,g' -e
's,@abs_builddir@,/usr/local/src/postgresql-7.4/src/test/regress,g'-e 's/@DLSUFFIX@/.so/g'
output/create_function_1.source>expected/create_function_1.out 
sed -e 's,@abs_srcdir@,/usr/local/src/postgresql-7.4/src/test/regress,g' -e
's,@abs_builddir@,/usr/local/src/postgresql-7.4/src/test/regress,g'-e 's/@DLSUFFIX@/.so/g'
output/create_function_2.source>expected/create_function_2.out 
sed -e 's,@abs_srcdir@,/usr/local/src/postgresql-7.4/src/test/regress,g' -e
's,@abs_builddir@,/usr/local/src/postgresql-7.4/src/test/regress,g'-e 's/@DLSUFFIX@/.so/g' output/misc.source
>expected/misc.out
sed -e 's,@abs_srcdir@,/usr/local/src/postgresql-7.4/src/test/regress,g' -e
's,@abs_builddir@,/usr/local/src/postgresql-7.4/src/test/regress,g'-e 's/@DLSUFFIX@/.so/g' output/constraints.source
>expected/constraints.out
make -C ../../../contrib/spi refint.so autoinc.so
make[3]: Entering directory `/usr/local/src/postgresql-7.4/contrib/spi'
gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declarations -fpic -DREFINT_VERBOSE -I.
-I../../src/include-D_GNU_SOURCE  -I/usr/local/include -I/usr/local/ssl/include  -c -o refint.o refint.c 
gcc -shared -o refint.so refint.o
gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declarations -fpic -DREFINT_VERBOSE -I.
-I../../src/include-D_GNU_SOURCE  -I/usr/local/include -I/usr/local/ssl/include  -c -o autoinc.o autoinc.c 
gcc -shared -o autoinc.so autoinc.o
rm refint.o autoinc.o
make[3]: Leaving directory `/usr/local/src/postgresql-7.4/contrib/spi'
/bin/sh ./pg_regress --temp-install --top-builddir=../../.. --schedule=./parallel_schedule --multibyte=SQL_ASCII
============== creating temporary installation        ==============
============== initializing database system           ==============
============== starting postmaster                    ==============
running on port 65432 with pid 7392
============== creating database "regression"         ==============
/usr/local/src/postgresql-7.4/src/test/regress/./tmp_check/install//usr/local/pgsql/bin/createdb: relocation error:
/usr/local/src/postgresql-7.4/src/test/regress/./tmp_check/install//usr/local/pgsql/bin/createdb:undefined symbol:
get_progname
pg_regress: createdb failed
make[2]: *** [check] Error 2
rm regress.o
make[2]: Leaving directory `/usr/local/src/postgresql-7.4/src/test/regress'
make[1]: *** [check] Error 2
make[1]: Leaving directory `/usr/local/src/postgresql-7.4/src/test'
make: *** [check] Error 2





Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
./configure --with-tcl --with-tclconfig=/usr/lib --with-perl --with-python \
--with-java --with-krb5=/usr/local --with-pam --with-openssl
make
make check




If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------

Re: Failed regression test in postgresql-7.4

From
Bruce Momjian
Date:
lanewhoy@mrcoffee.umich.edu wrote:
> /usr/local/src/postgresql-7.4/src/test/regress/./tmp_check/install//usr/local/pgsql/bin/createdb:
> relocation error:
> /usr/local/src/postgresql-7.4/src/test/regress/./tmp_check/install//usr/local/pgsql/bin/createdb:
> undefined symbol: get_progname > pg_regress: createdb failed > make[2]:
> *** [check] Error 2

This error means that you have an old createdb in your path or have an
old libpq lying around.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Re: Failed regression test in postgresql-7.4

From
LANE WILLIAM HOY
Date:
Thanks, Bruce.  I have a 7.3.4 install in my current path when running the
regression tests.  I will try rebuilding and retesting with a modified
path.

Lane Hoy
lanewhoy@umich.edu

On Sat, 6 Dec 2003, Bruce Momjian wrote:

> lanewhoy@mrcoffee.umich.edu wrote:
> > /usr/local/src/postgresql-7.4/src/test/regress/./tmp_check/install//usr/local/pgsql/bin/createdb:
> > relocation error:
> > /usr/local/src/postgresql-7.4/src/test/regress/./tmp_check/install//usr/local/pgsql/bin/createdb:
> > undefined symbol: get_progname > pg_regress: createdb failed > make[2]:
> > *** [check] Error 2
>
> This error means that you have an old createdb in your path or have an
> old libpq lying around.
>
> --
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman@candle.pha.pa.us               |  (610) 359-1001
>   +  If your life is a hard drive,     |  13 Roberts Road
>   +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073
>