Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 166290 - dev-db/postgresql-8.1.5-r1: test fails
Summary: dev-db/postgresql-8.1.5-r1: test fails
Status: RESOLVED FIXED
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: Current packages (show other bugs)
Hardware: All Linux
: High normal (vote)
Assignee: PgSQL Bugs
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: 183764
  Show dependency tree
 
Reported: 2007-02-11 01:45 UTC by Miroslav Šulc
Modified: 2010-07-11 11:17 UTC (History)
3 users (show)

See Also:
Package list:
Runtime testing required: ---


Attachments
emerge --info (emerge_info.txt,11.30 KB, text/plain)
2007-02-11 01:46 UTC, Miroslav Šulc
Details
postgresql-8.2.4-r1/temp/build.log (build.log,361.91 KB, text/plain)
2007-10-22 13:05 UTC, Marijn Schouten (RETIRED)
Details
patch to make testsuite use /tmp for socket instead of /var/run/postgresql (pg.test,557 bytes, patch)
2008-06-21 15:00 UTC, Olivier Huber
Details | Diff

Note You need to log in before you can comment on or make changes to this bug.
Description Miroslav Šulc gentoo-dev 2007-02-11 01:45:37 UTC
USE="doc nls pam perl python readline ssl test* xml zlib -kerberos -pg-intdatetime (-selinux) -tcl"

i686-pc-linux-gnu-gcc -O2 -march=pentium4m -pipe -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fpic -DREFINT_VERBOSE -I. -I../../src/include -D_GNU_SOURCE   -c -o refint.o refint.c -MMD
i686-pc-linux-gnu-gcc -shared -o refint.so refint.o
i686-pc-linux-gnu-gcc -O2 -march=pentium4m -pipe -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fpic -DREFINT_VERBOSE -I. -I../../src/include -D_GNU_SOURCE   -c -o autoinc.o autoinc.c -MMD
i686-pc-linux-gnu-gcc -shared -o autoinc.so autoinc.o
make[3]: Leaving directory `/var/tmp/portage/dev-db/postgresql-8.1.5-r1/work/postgresql-8.1.5/contrib/spi'
rm -rf ./testtablespace
mkdir ./testtablespace
/bin/sh ./pg_regress --temp-install --top-builddir=../../.. --temp-port=55432 --schedule=./parallel_schedule --multibyte=SQL_ASCII --load-language=plpgsql
============== removing existing temp installation    ==============
============== creating temporary installation        ==============
============== initializing database system           ==============

pg_regress: initdb failed
Examine /var/tmp/portage/dev-db/postgresql-8.1.5-r1/work/postgresql-8.1.5/src/test/regress/log/initdb.log for the reason.

make[2]: *** [check] Error 2
make[2]: Leaving directory `/var/tmp/portage/dev-db/postgresql-8.1.5-r1/work/postgresql-8.1.5/src/test/regress'
make[1]: *** [check] Error 2
make[1]: Leaving directory `/var/tmp/portage/dev-db/postgresql-8.1.5-r1/work/postgresql-8.1.5/src/test'
make: *** [check] Error 2

!!! ERROR: dev-db/postgresql-8.1.5-r1 failed.
Call stack:
  ebuild.sh, line 1614:   Called dyn_test
  ebuild.sh, line 1026:   Called qa_call 'src_test'
  environment, line 3620:   Called src_test
  postgresql-8.1.5-r1.ebuild, line 238:   Called die

!!! Make check failed. See above for details.
!!! If you need support, post the topmost build error, and the call stack if relevant.
!!! A complete build log is located at '/var/tmp/portage/dev-db/postgresql-8.1.5-r1/temp/build.log'.

Here is content of /var/tmp/portage/dev-db/postgresql-8.1.5-r1/work/postgresql-8.1.5/src/test/regress/log/initdb.log:
su: Authentication service cannot retrieve authentication info
(Ignored)
/bin/sh: /var/tmp/portage/dev-db/postgresql-8.1.5-r1/work/postgresql-8.1.5/src/test/regress/./tmp_check/install//usr/bin/initdb: Permission denied
Comment 1 Miroslav Šulc gentoo-dev 2007-02-11 01:46:06 UTC
Created attachment 109817 [details]
emerge --info
Comment 2 Miroslav Šulc gentoo-dev 2007-02-12 20:20:44 UTC
The same applies to postgresql-8.1.8.
Comment 3 Marijn Schouten (RETIRED) gentoo-dev 2007-10-22 13:04:44 UTC
dev-db/postgresql-8.2.4-r1 fails test on amd64:

Portage 2.1.3.15 (default-linux/amd64/2006.1/desktop, gcc-4.2.2, glibc-2.6.1-r0, 2.6.22-gentoo-r8 x86_64)
=================================================================
System uname: 2.6.22-gentoo-r8 x86_64 Intel(R) Core(TM)2 CPU 6600 @ 2.40GHz
Timestamp of tree: Fri, 19 Oct 2007 13:30:01 +0000
app-shells/bash:     3.2_p17-r1
dev-java/java-config: 1.3.7, 2.1.2-r1
dev-lang/python:     2.4.4-r4, 2.5.1-r2
dev-python/pycrypto: 2.0.1-r6
sys-apps/baselayout: 1.12.10-r5
sys-apps/sandbox:    1.2.18.1-r1
sys-devel/autoconf:  2.13, 2.61-r1
sys-devel/automake:  1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2, 1.10
sys-devel/binutils:  2.18-r1
sys-devel/gcc-config: 1.4.0-r4
sys-devel/libtool:   1.5.24
virtual/os-headers:  2.6.23
ACCEPT_KEYWORDS="amd64 ~amd64"
CBUILD="x86_64-pc-linux-gnu"
CFLAGS="-O2 -pipe -ggdb"
CHOST="x86_64-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/kde/3.5/env /usr/kde/3.5/share/config /usr/kde/3.5/shutdown /usr/share/config"
CONFIG_PROTECT_MASK="/etc/env.d /etc/env.d/java/ /etc/fonts/fonts.conf /etc/gconf /etc/php/apache2-php5/ext-active/ /etc/php/cgi-php5/ext-active/ /etc/php/cli-php5/ext-active/ /etc/revdep-rebuild /etc/terminfo /etc/texmf/web2c /etc/udev/rules.d"
CXXFLAGS="-O2 -pipe -ggdb"
DISTDIR="/usr/portage/distfiles"
FEATURES="collision-protect cvs distlocks metadata-transfer parallel-fetch sandbox sfperms splitdebug strict unmerge-orphans userfetch"
GENTOO_MIRRORS="http://distfiles.gentoo.org http://distro.ibiblio.org/pub/linux/distributions/gentoo"
LANG="en_US.UTF-8"
LINGUAS="en nl"
MAKEOPTS="-j4"
PKGDIR="/usr/portage/packages"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --delete-after --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages --filter=H_**/files/digest-*"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
PORTDIR_OVERLAY="/usr/portage/local/layman/nouveau /home/marijn/git/gentoo-lisp-overlay /home/marijn/overlay"
SYNC="rsync://rsync.gentoo.org/gentoo-portage"
USE="X a52 aac acpi alsa amd64 berkdb bitmap-fonts cairo cdr cli cracklib crypt cups dbus dri dts dvd dvdr dvdread eds emacs emboss encode esd fam firefox fortran gdbm gif gmp gnome gpm gstreamer gtk gtk2 hal iconv ipv6 isdnlog jpeg kde kdeenablefinal ldap lm_sensors mad midi mikmod mng mp3 mpeg mudflap ncurses nls nptl nptlonly nvidia offensive ogg opengl openmp pam pcre pdf perl png ppds pppd python qt3 qt4 quicktime readline reflection sdl session smp spell spl ssl svg tcpd theora threads tiff truetype truetype-fonts type1-fonts unicode vorbis xinerama xml xorg xpm xv zlib" ALSA_CARDS="hda-intel" ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat linear meter mulaw multi null plug rate route share shm softvol" ELIBC="glibc" INPUT_DEVICES="keyboard mouse evdev" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LINGUAS="en nl" USERLAND="GNU" VIDEO_CARDS="fbdev nouveau nv nvidia"
Unset:  CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LC_ALL, LDFLAGS, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS
Comment 4 Marijn Schouten (RETIRED) gentoo-dev 2007-10-22 13:05:26 UTC
Created attachment 134116 [details]
postgresql-8.2.4-r1/temp/build.log
Comment 5 Ryan Hill (RETIRED) gentoo-dev 2008-03-15 19:19:12 UTC
slightly different w/ 8.2.6 on mips:

mkdir ./testtablespace
chown portage testtablespace .
su -s /bin/sh portage -c "./pg_regress --psqldir=`pwd`/../../bin/psql --temp-install=./tmp_check --top-builddir=../../.. --temp-port=55432 --schedule=./parallel_schedule --multibyte=SQL_ASCII --load-language=plpgsql  "
invalid binary "/var/tmp/portage/dev-db/postgresql-8.2.6/work/postgresql-8.2.6/src/test/regress/pg_regress"
============== creating temporary installation        ==============
pg_regress: could not create directory "/var/tmp/portage/dev-db/postgresql-8.2.6/work/postgresql-8.2.6/src/test/regress/./tmp_check": Permission denied
make[2]: *** [check] Error 2
make[2]: Leaving directory `/var/tmp/portage/dev-db/postgresql-8.2.6/work/postgresql-8.2.6/src/test/regress'
make[1]: *** [check] Error 2
make[1]: Leaving directory `/var/tmp/portage/dev-db/postgresql-8.2.6/work/postgresql-8.2.6/src/test'
make: *** [check] Error 2
Comment 6 Olivier Huber 2008-06-21 14:59:06 UTC
Here is a little update :

I try to make tests succeed with dev-db/postgresql-server.

First I encounter this error in initdb.log : 

 Running in noclean mode.  Mistakes will not be cleaned up.
initdb: cannot be run as root
Please log in (using, e.g., "su") as the (unprivileged) user that will
own the server process.

So I have emerged it with FEATURES=userpriv

After that, here is the second error :
# cat postmaster.log
FATAL:  could not create lock file "/var/run/postgresql/.s.PGSQL.55432.lock": No such file or directory

I had to create /var/run/postgresql/ and portage user has to be able to write in this directory.
I don't know if this is really safe, but I add portage in postgres group. And everything was fine.

But I don't think this is the right way to solve this issue. So I try to add this "-k /tmp" so the location of the socket is /tmp, but I don't know why it fails.

./pg_regress --temp-install=./tmp_check --top-builddir=../../.. --srcdir=/var/tmp/portage/dev-db/postgresql-server-8.3.3/work/postgresql-8.3.3/src/test/regress --temp-port=55432 --schedule=./parallel_schedule --multibyte=SQL_ASCII --load-language=plpgsql    --psqldir=/usr/lib/postgresql-8.3/bin/
============== creating temporary installation        ==============
============== initializing database system           ==============
============== starting postmaster                    ==============

pg_regress: postmaster did not respond within 60 seconds
Examine ./log/postmaster.log for the reason
make[2]: *** [check] Erreur 2
make[2]: quittant le répertoire « /var/tmp/portage/dev-db/postgresql-server-8.3.3/work/postgresql-8.3.3/src/test/regress »
make[1]: *** [check] Erreur 2
make[1]: quittant le répertoire « /var/tmp/portage/dev-db/postgresql-server-8.3.3/work/postgresql-8.3.3/src/test »
make: *** [check] Erreur 2

cat /var/tmp/portage/dev-db/postgresql-server-8.3.3/work/postgresql-8.3.3/src/test/regress/log/postmaster.log
LOG:  database system was shut down at 2008-06-21 16:49:50 CEST
LOG:  autovacuum launcher started
LOG:  database system is ready to accept connections

 
Comment 7 Olivier Huber 2008-06-21 15:00:20 UTC
Created attachment 157937 [details, diff]
patch to make testsuite use /tmp for socket instead of /var/run/postgresql
Comment 8 Patrick Lauer gentoo-dev 2010-07-11 11:17:55 UTC
Package gone.