Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 232174 - dev-db/postgresql-server-8.3.3 test failures
Summary: dev-db/postgresql-server-8.3.3 test failures
Status: RESOLVED DUPLICATE of bug 347223
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:
 
Reported: 2008-07-18 09:56 UTC by Alexis Ballier
Modified: 2011-01-06 11:52 UTC (History)
1 user (show)

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


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Alexis Ballier gentoo-dev 2008-07-18 09:56:03 UTC
mkdir ./testtablespace
./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] Error 2
make[2]: Leaving directory `/var/tmp/portage/dev-db/postgresql-server-8.3.3/work/postgresql-8.3.3/src/test/regress'
make[1]: *** [check] Error 2
make[1]: Leaving directory `/var/tmp/portage/dev-db/postgresql-server-8.3.3/work/postgresql-8.3.3/src/test'
make: *** [check] Error 2
 * 
 * ERROR: dev-db/postgresql-server-8.3.3 failed.
 * Call stack:
 *               ebuild.sh, line   49:  Called src_test
 *             environment, line 2931:  Called die

# cat postmaster.log 
FATAL:  could not create lock file "/var/run/postgresql/.s.PGSQL.55432.lock": Permission denied


# emerge --info
Portage 2.2_rc1 (default/linux/powerpc/ppc64/2008.0/64bit-userland, gcc-4.3.1, glibc-2.8_p20080602-r0, 2.6.26-rc3-00436-gb373303 ppc64)
=================================================================
System uname: Linux-2.6.26-rc3-00436-gb373303-ppc64-PPC970,_altivec_supported-with-glibc2.3
Timestamp of tree: Fri, 18 Jul 2008 08:00:02 +0000
app-shells/bash:     3.2_p39
dev-java/java-config: 1.3.7, 2.1.6-r1
dev-lang/python:     2.5.2-r5
sys-apps/baselayout: 2.0.0
sys-apps/openrc:     0.2.5
sys-apps/sandbox:    1.2.18.1-r3
sys-devel/autoconf:  2.13, 2.62-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.1-r1
sys-devel/binutils:  2.18-r3
sys-devel/gcc-config: 1.4.0-r4
sys-devel/libtool:   2.2.4
virtual/os-headers:  2.6.25-r4
ACCEPT_KEYWORDS="ppc64 ~ppc64"
CBUILD="powerpc64-unknown-linux-gnu"
CFLAGS="-O2 -pipe -mcpu=970 -mtune=970 -maltivec -mabi=altivec -ftree-vectorize -ftree-vectorizer-verbose=1 -g -ggdb"
CHOST="powerpc64-unknown-linux-gnu"
CONFIG_PROTECT="/etc"
CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/env.d/java/ /etc/eselect/postgresql /etc/fonts/fonts.conf /etc/gconf /etc/gentoo-release /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 -mcpu=970 -mtune=970 -maltivec -mabi=altivec -ftree-vectorize -ftree-vectorizer-verbose=1 -g -ggdb"
DISTDIR="/usr/portage/distfiles"
EMERGE_DEFAULT_OPTS="--with-bdeps=y"
FEATURES="buildsyspkg collision-protect distlocks fixpackages parallel-fetch preserve-libs sandbox sfperms splitdebug strict test unmerge-orphans userfetch userpriv usersandbox"
GENTOO_MIRRORS="http://mirror.ovh.net/gentoo-distfiles/ http://distfiles.gentoo.org http://www.ibiblio.org/pub/Linux/distributions/gentoo"
LANG="en_US.utf8"
LDFLAGS="-Wl,--as-needed -Wl,-O1 -Wl,--sort-common -Wl,--hash-style=gnu"
LINGUAS="en fr"
MAKEOPTS="-j4"
PKGDIR="/usr/portage/packages"
PORTAGE_COMPRESS="lzma"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
PORTDIR_OVERLAY="/usr/local/portage /share/overlay"
SYNC="rsync://rsync.gentoo.org/gentoo-portage"
USE="X a52 aac aalib acl alsa altivec audiofile bash-completion berkdb bogofilter bzip2 cairo cdda cddb cdio cdr cjk cli cpufreq cracklib crypt cups curl dbus djvu dri dts dv dvd dvdr dvdread dvi encode exif expat ffmpeg fftw firefox flac fluidsynth fontconfig fortran gdbm gif gimp glitz gnutls gpm graphviz gs gtk hal hfs icecast iconv id3tag ieee1394 imagemagick imap imlib ipv6 isdnlog ithreads jack jadetex jbig jpeg jpeg2k kdehiddenvisibility kerberos kpathsea ladspa lame latex lcms ldap libcaca libnotify libsamplerate live lyrics lzo mad matroska mbox md5sum midi mikmod mjpeg mng mod modplug mp2 mp3 mpeg mudflap musepack ncurses nls nodrm nptl nptlonly nsplugin ogg openexr opengl openmp pam pango pcre pdf perl png postgres ppc64 ppds pppd python qt3 qt3support qt4 quicktime raw readline reflection regex sdl session shout skins smp sndfile soundtouch speex spell spl sql sqlite sqlite3 ssl startup-notification svg t1lib taglib tcpd test tetex tex4ht tga theora threads tiff timidity truetype tta twolame unicode vamp vim-syntax vorbis wavpack wma wmf wxwindows x264 xcb xml xorg xulrunner xv xvid zlib" 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" APACHE2_MODULES="actions alias auth_basic authn_alias authn_anon authn_dbm authn_default authn_file authz_dbm authz_default authz_groupfile authz_host authz_owner authz_user autoindex cache dav dav_fs dav_lock deflate dir disk_cache env expires ext_filter file_cache filter headers include info log_config logio mem_cache mime mime_magic negotiation rewrite setenvif speling status unique_id userdir usertrack vhost_alias" ELIBC="glibc" INPUT_DEVICES="keyboard mouse evdev" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LINGUAS="en fr" USERLAND="GNU" VIDEO_CARDS="vga vesa nv fbdev"
Unset:  CPPFLAGS, CTARGET, INSTALL_MASK, LC_ALL, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS
Comment 1 Caleb Tennis (RETIRED) gentoo-dev 2008-09-28 23:04:48 UTC
I'm guessing this has to do with your userpriv in FEATURES.  Not sure a good fix here other than running the test as the postgres user via su.
Comment 2 Alexis Ballier gentoo-dev 2008-09-29 07:11:50 UTC
(In reply to comment #1)
> I'm guessing this has to do with your userpriv in FEATURES.  Not sure a good
> fix here other than running the test as the postgres user via su.

I think the location of the lock file can be changed; I don't remember exactly but I used this to run pgsql on boxes where I didn't have root access. If you want I can check in my old scripts how I did this.
Comment 3 Bernhard Frauendienst 2009-05-15 16:30:13 UTC
Still happens on 8.3.7

Running without userpriv is not an option, since it also can fail if the directory doesn't exist (like it did for me). If there is no previous postgresql installation, this is normally the case.

> FATAL:  could not create lock file "/var/run/postgresql/.s.PGSQL.55432.lock": No such file or directory

Changing the location for the lock file would be the cleanest solution I suppose.
Comment 4 Bernhard Frauendienst 2009-05-15 22:16:38 UTC
Also, running as root will cause the test to fail at another spot:

> initdb: cannot be run as root
> Please log in (using, e.g., "su") as the (unprivileged) user that will
> own the server process.

As far as I can tell, changing the location of the unix sockets/lock files would require patching pg_regress to pass a different directory to postgres using the -k switch.
Comment 5 Aaron W. Swenson gentoo-dev 2010-06-30 20:20:03 UTC
Does this issue persist in the latest 8.3?
Comment 6 Patrick Lauer gentoo-dev 2011-01-06 11:52:42 UTC

*** This bug has been marked as a duplicate of bug 347223 ***