Failed regression test in postgresql-7.4

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(at)postgresql(dot)org(dot)

To report any other bug, fill out the form below and e-mail it to
pgsql-bugs(at)postgresql(dot)org(dot)

If you not only found the problem but solved it and generated a patch
then e-mail it to pgsql-patches(at)postgresql(dot)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(at)umich(dot)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:
---------------------------------------------------------------------

lanewhoy(at)mrcoffee(dot)umich(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

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(at)umich(dot)edu

On Sat, 6 Dec 2003, Bruce Momjian wrote:

> lanewhoy(at)mrcoffee(dot)umich(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
> + If your life is a hard drive, | 13 Roberts Road
> + Christ can be your backup. | Newtown Square, Pennsylvania 19073
>