Bug 359713 – dev-db/postgresql-9.0 won't start due to left over @GENTOO_POTAGE_EPREFIX@ in server.patch

• Status: RESOLVED FIXED
• Product: Gentoo Linux

[Description Attila Jecs 2011-03-21 08:45:31 UTC]

after upgrading to 9.0.3-r1 postgres wont start, the error from the log is:

FATAL:  could not create lock file "@GENTOO_POTAGE_EPREFIX@/var/run/postgresql/.s.PGSQL.5432.lock": No such file or directory.

Reproducible: Always

Steps to Reproduce:
1. eselect rc start postgresql-9.0
2. tail /var/lib/postgresql/9.0/data/postmaster.log
Actual Results:  
FATAL:  could not create lock file "@GENTOO_POTAGE_EPREFIX@/var/run/postgresql/.s.PGSQL.5432.lock": No such file or directory.


this is two ~amd64 install, i dont have any prefix stuff

[Comment 1 Cănărău Constantin 2011-03-21 09:24:42 UTC]

I can confirm this.
Portage 2.2.0_alpha28 (default/linux/amd64/10.0/desktop/gnome, gcc-4.5.2, glibc-2.13-r2, 2.6.38-gentoo x86_64)
=================================================================
System uname: Linux-2.6.38-gentoo-x86_64-Intel-R-_Core-TM-_i7_CPU_860_@_2.80GHz-with-gentoo-2.0.2
Timestamp of tree: Mon, 21 Mar 2011 08:00:01 +0000
app-shells/bash:     4.2_p8
dev-java/java-config: 2.1.11-r3
dev-lang/python:     2.7.1-r1, 3.1.3-r1
dev-util/cmake:      2.8.4
sys-apps/baselayout: 2.0.2
sys-apps/openrc:     0.7.0
sys-apps/sandbox:    2.5
sys-devel/autoconf:  2.13, 2.68
sys-devel/automake:  1.9.6-r3, 1.10.3, 1.11.1
sys-devel/binutils:  2.21.51.0.7
sys-devel/gcc:       4.5.2
sys-devel/gcc-config: 1.4.1
sys-devel/libtool:   2.4-r1
sys-devel/make:      3.82
virtual/os-headers:  2.6.38 (sys-kernel/linux-headers)
Repositories: gentoo added systemd mozilla
Installed sets: 
ACCEPT_KEYWORDS="amd64 ~amd64"
ACCEPT_LICENSE="*"
CBUILD="x86_64-pc-linux-gnu"
CFLAGS="-O2 -pipe -march=native -mtune=native -ftree-vectorize -w -floop-block -floop-interchange -floop-strip-mine"
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 /usr/share/gnupg/qualified.txt /var/bind /var/lib/citadel /var/lib/hsqldb"
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.3/ext-active/ /etc/php/cgi-php5.3/ext-active/ /etc/php/cli-php5.3/ext-active/ /etc/revdep-rebuild /etc/sandbox.d /etc/splash /etc/terminfo"
CXXFLAGS="-O2 -pipe -march=native -mtune=native -ftree-vectorize -w -floop-block -floop-interchange -floop-strip-mine"
DISTDIR="/usr/portage/distfiles"
EMERGE_DEFAULT_OPTS="--jobs=3 --load-average=7.9 --keep-going --with-bdeps=y --complete-graph"
FEATURES="assume-digests binpkg-logs candy collision-protect distlocks fail-clean fixlafiles fixpackages news nodoc noinfo parallel-fetch preserve-libs protect-owned sfperms strict unknown-features-warn unmerge-logs unmerge-orphans userfetch"
FFLAGS=""
GENTOO_MIRRORS="http://localhost http://mirrors.xservers.ro/gentoo/ http://ftp.roedu.net/pub/mirrors/gentoo.org/ http://mirrors.evolva.ro/gentoo/ http://distfiles.gentoo.org/ http://distfiles.gentoo.org"
LANG="ro_RO.UTF-8"
LC_ALL="ro_RO.UTF-8"
LDFLAGS="-Wl,-O1,--sort-common,--warn-once,--hash-style=gnu,--as-needed"
LINGUAS="ro en"
MAKEOPTS="-j8 --load-average=9"
PKGDIR="/usr/portage/packages"
PORTAGE_COMPRESS="bzip2"
PORTAGE_COMPRESS_FLAGS="-9"
PORTAGE_CONFIGROOT="/"
PORTAGE_RSYNC_EXTRA_OPTS="--delete-before --human-readable --progress"
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/portage/local/added /usr/portage/local/systemd /usr/portage/local/mozilla"
SYNC="rsync://rsync.gentoo.org/gentoo-portage"
USE="X a52 aac acl acpi alsa amd64 apache2 bzip2 cairo cdr cli consolekit cracklib crypt cups cxx dbus dri dts dvd dvdr encode exif fam ffmpeg firefox flac gdbm gdu gif gmp gnome gnome-keyring gpm graphviz gstreamer gtk hddtemp iconv imagemagick java jpeg kde kdehiddenvisibility lame lcms libnotify lm_sensors logrotate mad matroska mikmod mmx mng modules mp3 mp4 mpeg mpg123 mudflap multilib mysql mysqli nautilus ncurses nls nptl nptlonly nsplugin ogg opengl openmp optimized-qmake pam pango pch pcre pdf perl png policykit postgres python qt3support qt4 readline samba sasl sdl semantic-desktop session spell sse sse2 sse3 ssl ssse3 startup-notification svg sysfs system-sqlite systemd tcpd threads tiff truetype twolame udev unicode usb v4l v4l2 vdpau vhosts vorbis x264 xcb xcomposite xml xorg xulrunner xv xvid 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 mmap_emul mulaw multi null plug rate route share shm softvol" APACHE2_MODULES="actions alias asis auth_basic auth_digest authn_alias authn_anon authn_dbd authn_dbm authn_default authn_file authz_dbm authz_default authz_groupfile authz_host authz_owner authz_user autoindex cache cern_meta cgi cgid charset_lite dav dav_fs dav_lock dbd deflate dir disk_cache dumpio env expires ext_filter file_cache filter headers ident imagemap include info log_config log_forensic logio mem_cache mime mime_magic negotiation proxy proxy_ajp proxy_balancer proxy_connect proxy_ftp proxy_http rewrite setenvif so speling status substitute unique_id userdir usertrack version vhost_alias" APACHE2_MPMS="worker" CAMERAS="ptp2" COLLECTD_PLUGINS="apache apcups ascent bind conntrack contextswitch cpu csv curl curl_xml dbi df disk dns email entropy exec filecount fscache gmond hddtemp interface iptables irq load logfile match_empty_counter match_hashed match_regex match_timediff match_value mbmon memcachec memcached memory multimeter mysql network nginx notify_desktop notify_email ntpd olsrd onewire openvpn postgresql powerdns processes protocols python rrdcached rrdtool sensors serial snmp swap syslog table tail target_notification target_replace target_scale target_set tcpconns ted thermal unixsock uptime users uuid vmem write_http" ELIBC="glibc" GPSD_PROTOCOLS="ashtech aivdm earthmate evermore fv18 garmin garmintxt gpsclock itrax mtk3301 nmea ntrip navcom oceanserver oldstyle oncore rtcm104v2 rtcm104v3 sirf superstar2 timing tsip tripmate tnt ubx" INPUT_DEVICES="evdev keyboard mouse" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LINGUAS="ro en" LIRC_DEVICES="hauppauge" NETBEANS_MODULES="apisupport harness ide java nb websvccommon php mobility ergonomics enterprise profiler cnd dlight groovy identity" NGINX_MODULES_HTTP="access addition auth_basic autoindex browser cache_purge charset dav empty_gif fastcgi flv geo geoip gzip headers_more image_filter limit_req limit_zone map memcached perl proxy random_index realip referer rewrite scgi secure_link split_clients ssi stub_status sub upstream_ip_hash userid uwsgi xslt" NGINX_MODULES_MAIL="imap pop3 smtp" PHP_TARGETS="php5-3" RUBY_TARGETS="ruby18" USERLAND="GNU" VIDEO_CARDS="nv nvidia" XTABLES_ADDONS="quota2 psd pknock lscan length2 ipv4options ipset ipp2p iface geoip fuzzy condition tee tarpit sysrq steal rawnat logmark ipmark dhcpmac delude chaos account" 
Unset:  CPPFLAGS, CTARGET, INSTALL_MASK, PORTAGE_BUNZIP2_COMMAND

The GENTOO_POTAGE variable it's hardcoded in /usr/lib64/postgresql-9.0/bin/postgres from /var/tmp/portage/dev-db/postgresql-server-9.0.3-r1/work/server.patch. The patch it's from postgresql-patches-9.0.tbz2.
Manually runnig through ebuild ... unpack, repair the patch, compile, install and qmerge phases solved the problem.

[Comment 2 Guillaume Castagnino 2011-03-21 10:28:11 UTC]

There is a typo in server.patch :

# grep -nr POTAGE /var/tmp/portage/dev-db/postgresql-server-9.0.3-r1/work/server.patch
144:+#define DEFAULT_PGSOCKET_DIR  "@GENTOO_POTAGE_EPREFIX@/var/run/postgresql"

[Comment 3 Leif Biberg Kristensen 2011-03-21 12:37:26 UTC]

Quick fix if you already have installed it. Luckily, postgresql-9.0.3 is already in stable, so you only have to comment out postgresql-base and postgresql-server in /etc/portage/package.keywords, run emerge -C postgresql-base postgresql-server, and reemerge.

[Comment 4 Christer Ekholm 2011-03-21 18:37:33 UTC]

Until a fixed -r2 is out it's also possible to override the compiled
in value by adding a PGOPTS="-k /var/run/postgresql" to
/etc/conf.d/postgresql-9.0

[Comment 5 Aaron W. Swenson 2011-03-21 20:46:38 UTC]

(In reply to comment #4)
> Until a fixed -r2 is out it's also possible to override the compiled
> in value by adding a PGOPTS="-k /var/run/postgresql" to
> /etc/conf.d/postgresql-9.0

Yes, and don't forget to specify the path in psql.

I'll fix this bug in an hour, though, so you won't have to wait to terribly long.

[Comment 6 Aaron W. Swenson 2011-03-21 23:16:21 UTC]

  21 Mar 2011; Aaron W. Swenson <[e-mail]>
  -postgresql-server-9.0.3-r1.ebuild, +postgresql-server-9.0.3-r2.ebuild:
  Fixes bug 359713