Bugzilla Bug 135187

postgresql-7.3.15 failed to compile. The error messages are long, so I'll make
an attachment.

# emerge --info
Portage 2.1_rc1-r2 (default-linux/alpha/2006.0, gcc-3.4.6, glibc-2.3.6-r4,
2.6.14.2 alpha)
=================================================================
System uname: 2.6.14.2 alpha EV56
Gentoo Base System version 1.12.0_pre19
distcc 2.18.3 alpha-unknown-linux-gnu (protocols 1 and 2) (default port 3632)
[enabled]
ccache version 2.4 [enabled]
dev-lang/python:     2.3.5, 2.4.3-r1
dev-python/pycrypto: 2.0.1-r5
dev-util/ccache:     2.4-r1
dev-util/confcache:  [Not Present]
sys-apps/sandbox:    1.2.17
sys-devel/autoconf:  2.13, 2.59-r7
sys-devel/automake:  1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2
sys-devel/binutils:  2.16.1-r2
sys-devel/libtool:   1.5.22
virtual/os-headers:  2.6.11-r4
ACCEPT_KEYWORDS="alpha ~alpha"
AUTOCLEAN="yes"
CBUILD="alpha-unknown-linux-gnu"
CFLAGS="-mieee -pipe -O2 -mcpu=ev56"
CHOST="alpha-unknown-linux-gnu"
CONFIG_PROTECT="/etc /usr/share/X11/xkb /usr/share/config /var/bind"
CONFIG_PROTECT_MASK="/etc/gconf /etc/revdep-rebuild /etc/terminfo /etc/env.d"
CXXFLAGS="-mieee -pipe -O2 -mcpu=ev56"
DISTDIR="/usr/portage/distfiles"
FEATURES="autoconfig ccache distcc distlocks metadata-transfer sfperms strict"
GENTOO_MIRRORS="http://distfiles.gentoo.org
http://distro.ibiblio.org/pub/linux/distributions/gentoo"
MAKEOPTS="-j10"
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'"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
PORTDIR_OVERLAY="/usr/local/portage"
SYNC="rsync://rsync.gentoo.org/gentoo-portage"
USE="alpha X alsa apache2 arts berkdb bitmap-fonts cli crypt cups dri eds
encode esd foomaticdb fortran gdbm gif gnome gpm gstreamer gtk gtk2 imlib
isdnlog jpeg kde libg++ libwww mad mikmod motif mp3 mpeg ncurses nptl nptlonly
ogg opengl oss pam pcre pdflib perl png pppd python qt quicktime readline
reflection sdl session spell spl ssl tcpd truetype truetype-fonts type1-fonts
udev vorbis xml xmms xorg xv zlib elibc_glibc kernel_linux userland_GNU"
Unset:  CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LANG, LC_ALL, LDFLAGS,
LINGUAS, PORTAGE_RSYNC_EXTRA_OPTS

Created an attachment (id=88120) [edit]
error messages

uhh.

it's probably need <flex-2.5.30.

please, try it with =flex-2.5.4a-r6

Also fails on ppc, same error messages.

Downgrading flex isn't an option from my pov, as flex isn't slotted.

same for sparc.

Stable on hppa

As comment #2 suggests, postgres-7.3.15 builds fine with flex-2.5.4a-r6 on
SPARC

Same problem on x86, as well. I concur that the older version of flex is not a
solution that we should go down as a true fix. Especially considering what
version we have stable on most arches now.

Is this still a problem?  Because newer versions like 7.4.13 and 8.0.8 are
stable.

Created an attachment (id=91025) [edit]
lex sources patch

The attached patch fixes compilation on x86 with flex-2.5.33-r1 and USE="java
libg++ nls pam perl python readline ssl zlib -doc -tcltk -threads".

emerge --info follows:

Portage 2.1-r1 (default-linux/x86/2006.0, gcc-3.4.6, glibc-2.3.6-r4,
2.6.16-gentoo-r9 i686)
=================================================================
System uname: 2.6.16-gentoo-r9 i686 Intel(R) Pentium(R) M processor 1000MHz
Gentoo Base System version 1.6.15
dev-lang/python:     2.4.3-r1
dev-python/pycrypto: 2.0.1-r5
dev-util/ccache:     [Not Present]
dev-util/confcache:  [Not Present]
sys-apps/sandbox:    1.2.17
sys-devel/autoconf:  2.13, 2.59-r7
sys-devel/automake:  1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2
sys-devel/binutils:  2.16.1-r3
sys-devel/gcc-config: 1.3.13-r2
sys-devel/libtool:   1.5.22
virtual/os-headers:  2.6.11-r2
ACCEPT_KEYWORDS="x86"
AUTOCLEAN="yes"
CBUILD="i686-pc-linux-gnu"
CFLAGS="-mtune=pentium4 -O3 -pipe"
CHOST="i686-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/kde/3.5/env /usr/kde/3.5/share/config
/usr/kde/3.5/shutdown /usr/share/X11/xkb /usr/share/config"
CONFIG_PROTECT_MASK="/etc/env.d /etc/gconf /etc/revdep-rebuild /etc/terminfo"
CXXFLAGS="-mtune=pentium4 -O3 -pipe"
DISTDIR="/usr/portage/distfiles"
FEATURES="autoconfig collision-protect distlocks metadata-transfer sandbox
sfperms strict"
GENTOO_MIRRORS="http://www.die.unipd.it/pub/Linux/distributions/gentoo-sources
http://distfiles.gentoo.org
http://www.ibiblio.org/pub/Linux/distributions/gentoo"
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'"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
SYNC="rsync://rsync.gentoo.org/gentoo-portage"
USE="x86 X alsa apache2 apm arts avi berkdb bitmap-fonts cli crypt cups
dlloader dri eds emboss encode esd foomaticdb fortran gdbm gif gnome gpm
gstreamer gtk gtk2 imlib ipv6 isdnlog java jpeg kde libg++ libwww mad
mailwrapper mikmod motif mp3 mpeg ncurses nls nptl ogg opengl oss pam pcre
pdflib perl png pppd python qt qt3 qt4 quicktime readline reflection sdl
session spell spl ssl tcpd truetype truetype-fonts type1-fonts udev vorbis xml
xmms xorg xv zlib elibc_glibc input_devices_keyboard input_devices_mouse
input_devices_evdev kernel_linux userland_GNU"
Unset:  CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LANG, LC_ALL, LDFLAGS,
LINGUAS, MAKEOPTS, PORTAGE_RSYNC_EXTRA_OPTS, PORTDIR_OVERLAY

Created an attachment (id=91027) [edit]
lex sources patch

The attached patch fixes compilation on x86 with flex-2.5.33-r1 and USE="java
libg++ nls pam perl python readline ssl zlib -doc -tcltk -threads".

emerge --info follows:

Portage 2.1-r1 (default-linux/x86/2006.0, gcc-3.4.6, glibc-2.3.6-r4,
2.6.16-gentoo-r9 i686)
=================================================================
System uname: 2.6.16-gentoo-r9 i686 Intel(R) Pentium(R) M processor 1000MHz
Gentoo Base System version 1.6.15
dev-lang/python:     2.4.3-r1
dev-python/pycrypto: 2.0.1-r5
dev-util/ccache:     [Not Present]
dev-util/confcache:  [Not Present]
sys-apps/sandbox:    1.2.17
sys-devel/autoconf:  2.13, 2.59-r7
sys-devel/automake:  1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2
sys-devel/binutils:  2.16.1-r3
sys-devel/gcc-config: 1.3.13-r2
sys-devel/libtool:   1.5.22
virtual/os-headers:  2.6.11-r2
ACCEPT_KEYWORDS="x86"
AUTOCLEAN="yes"
CBUILD="i686-pc-linux-gnu"
CFLAGS="-mtune=pentium4 -O3 -pipe"
CHOST="i686-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/kde/3.5/env /usr/kde/3.5/share/config
/usr/kde/3.5/shutdown /usr/share/X11/xkb /usr/share/config"
CONFIG_PROTECT_MASK="/etc/env.d /etc/gconf /etc/revdep-rebuild /etc/terminfo"
CXXFLAGS="-mtune=pentium4 -O3 -pipe"
DISTDIR="/usr/portage/distfiles"
FEATURES="autoconfig collision-protect distlocks metadata-transfer sandbox
sfperms strict"
GENTOO_MIRRORS="http://www.die.unipd.it/pub/Linux/distributions/gentoo-sources
http://distfiles.gentoo.org
http://www.ibiblio.org/pub/Linux/distributions/gentoo"
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'"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
SYNC="rsync://rsync.gentoo.org/gentoo-portage"
USE="x86 X alsa apache2 apm arts avi berkdb bitmap-fonts cli crypt cups
dlloader dri eds emboss encode esd foomaticdb fortran gdbm gif gnome gpm
gstreamer gtk gtk2 imlib ipv6 isdnlog java jpeg kde libg++ libwww mad
mailwrapper mikmod motif mp3 mpeg ncurses nls nptl ogg opengl oss pam pcre
pdflib perl png pppd python qt qt3 qt4 quicktime readline reflection sdl
session spell spl ssl tcpd truetype truetype-fonts type1-fonts udev vorbis xml
xmms xorg xv zlib elibc_glibc input_devices_keyboard input_devices_mouse
input_devices_evdev kernel_linux userland_GNU"
Unset:  CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LANG, LC_ALL, LDFLAGS,
LINGUAS, MAKEOPTS, PORTAGE_RSYNC_EXTRA_OPTS, PORTDIR_OVERLAY

Created an attachment (id=91030) [edit]
lex sources patch

The attached patch fixes compilation on x86 with flex-2.5.33-r1 and USE="java
libg++ nls pam perl python readline ssl zlib -doc -tcltk -threads".

emerge --info follows:

Portage 2.1-r1 (default-linux/x86/2006.0, gcc-3.4.6, glibc-2.3.6-r4,
2.6.16-gentoo-r9 i686)
=================================================================
System uname: 2.6.16-gentoo-r9 i686 Intel(R) Pentium(R) M processor 1000MHz
Gentoo Base System version 1.6.15
dev-lang/python:     2.4.3-r1
dev-python/pycrypto: 2.0.1-r5
dev-util/ccache:     [Not Present]
dev-util/confcache:  [Not Present]
sys-apps/sandbox:    1.2.17
sys-devel/autoconf:  2.13, 2.59-r7
sys-devel/automake:  1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2
sys-devel/binutils:  2.16.1-r3
sys-devel/gcc-config: 1.3.13-r2
sys-devel/libtool:   1.5.22
virtual/os-headers:  2.6.11-r2
ACCEPT_KEYWORDS="x86"
AUTOCLEAN="yes"
CBUILD="i686-pc-linux-gnu"
CFLAGS="-mtune=pentium4 -O3 -pipe"
CHOST="i686-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/kde/3.5/env /usr/kde/3.5/share/config
/usr/kde/3.5/shutdown /usr/share/X11/xkb /usr/share/config"
CONFIG_PROTECT_MASK="/etc/env.d /etc/gconf /etc/revdep-rebuild /etc/terminfo"
CXXFLAGS="-mtune=pentium4 -O3 -pipe"
DISTDIR="/usr/portage/distfiles"
FEATURES="autoconfig collision-protect distlocks metadata-transfer sandbox
sfperms strict"
GENTOO_MIRRORS="http://www.die.unipd.it/pub/Linux/distributions/gentoo-sources
http://distfiles.gentoo.org
http://www.ibiblio.org/pub/Linux/distributions/gentoo"
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'"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
SYNC="rsync://rsync.gentoo.org/gentoo-portage"
USE="x86 X alsa apache2 apm arts avi berkdb bitmap-fonts cli crypt cups
dlloader dri eds emboss encode esd foomaticdb fortran gdbm gif gnome gpm
gstreamer gtk gtk2 imlib ipv6 isdnlog java jpeg kde libg++ libwww mad
mailwrapper mikmod motif mp3 mpeg ncurses nls nptl ogg opengl oss pam pcre
pdflib perl png pppd python qt qt3 qt4 quicktime readline reflection sdl
session spell spl ssl tcpd truetype truetype-fonts type1-fonts udev vorbis xml
xmms xorg xv zlib elibc_glibc input_devices_keyboard input_devices_mouse
input_devices_evdev kernel_linux userland_GNU"
Unset:  CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LANG, LC_ALL, LDFLAGS,
LINGUAS, MAKEOPTS, PORTAGE_RSYNC_EXTRA_OPTS, PORTDIR_OVERLAY

Actually, it looks like gentoo bugzilla is buggy and returns Internal Server
Error 500, but infact accepts the post.

7.3.15-r1 with patch from Giacomo Cariello committed in portage.

ppc stable

Reminder to all CCed arches: please stable dev-db/libpq-7.3.15 and
dev-db/postgresql-7.3.15-r1 ASAP wrt bug #134168 (security bug with exploits et
all running around). The compile failure was now fixed and I can confirm
compilation is ok on x86, and ppc/mips already marked it stable, so please test
and mark stable, tnx!
Best regards, CHTEKK.

(In reply to comment #15)
> Reminder to all CCed arches: please stable dev-db/libpq-7.3.15 and
> dev-db/postgresql-7.3.15-r1 ASAP wrt bug #134168 (security bug with exploits
> et all running around). The compile failure was now fixed and I can confirm
> compilation is ok on x86, and ppc/mips already marked it stable, so please
> test and mark stable, tnx!
> Best regards, CHTEKK.

alpha and amd64 stable.

A note on testing...

emerge --config failed. I had to add "kernel.sem = 512 32000 100 512" to
/etc/sysctl.conf and run `sysctl -p`. It was failing with the following message
"IpcSemaphoreCreate: semget(key=129, num=17, 03600) failed: No space left on
device"

`/etc/init.d/postgresql start` also failed. I had to lower the values for -N
and -B in /etc/conf.d/postgresql. It was failing with the following message:
"IpcMemoryCreate: shmget(key=5432001, size=38461440, 03600) failed: Invalid
argument"

Stable on SPARC

on x86:

[ebuild  N    ] dev-db/libpq-7.3.15  USE="nls readline ssl zlib -kerberos -pam"
[ebuild  N    ] dev-db/postgresql-7.3.15-r1  USE="nls readline ssl zlib -doc
-java -libg++ -pam -perl -python -tcl -threads -tk"


libpq went fine.

postgresql compiled without any serious issues.
Setting up the initial database caused no errors after which I started the
daemon, created a database and played around a bit. Everything worked fine.


emerge --info
------------------------------------------------------------------

Portage 2.1-r2 (default-linux/x86/2006.0, gcc-3.4.6, glibc-2.3.6-r4,
2.6.17-gentoo-r5 i686)
=================================================================
System uname: 2.6.17-gentoo-r5 i686 AMD Athlon(tm) 64 Processor 3200+
Gentoo Base System version 1.12.4
app-admin/eselect-compiler: [Not Present]
dev-lang/python:     2.4.3-r1
dev-python/pycrypto: 2.0.1-r5
dev-util/ccache:     [Not Present]
dev-util/confcache:  [Not Present]
sys-apps/sandbox:    1.2.17
sys-devel/autoconf:  2.13, 2.59-r7
sys-devel/automake:  1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2
sys-devel/binutils:  2.16.1-r3
sys-devel/gcc-config: 1.3.13-r3
sys-devel/libtool:   1.5.22
virtual/os-headers:  2.6.11-r2
ACCEPT_KEYWORDS="x86"
AUTOCLEAN="yes"
CBUILD="i686-pc-linux-gnu"
CFLAGS="-march=k8 -O2 -fomit-frame-pointer -pipe"
CHOST="i686-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/kde/3.5/env /usr/kde/3.5/share/config
/usr/kde/3.5/shutdown /usr/lib/X11/xkb /usr/share/config"
CONFIG_PROTECT_MASK="/etc/env.d /etc/gconf /etc/revdep-rebuild /etc/terminfo"
CXXFLAGS="-march=k8 -O2 -fomit-frame-pointer -pipe"
DISTDIR="/usr/portage/distfiles"
FEATURES="autoconfig collision-protect distlocks metadata-transfer sandbox
sfperms strict test"
GENTOO_MIRRORS="http://gentoo.nedlinux.nl
ftp://ftp.snt.utwente.nl/pub/os/linux/gentoo/"
LINGUAS="en nl"
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'"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
SYNC="rsync://rsync.nl.gentoo.org/gentoo-portage"
USE="x86 3dnow 3dnowext X aac acpi alsa avi bitmap-fonts bzip2 cairo cdparanoia
cli crypt ctype cups dlloader dri dvd dvdread firefox foomaticdb ftp gd gdbm
gif gtk2 iconv icu idn jpeg jpeg2k kde kdeenablefinal libwww mad mmx mmxext
mozsvg mp3 mpeg mplayer msn ncurses network nls nomotif nptl nptlonly nsplugin
ogg opengl pcre pdflib php png posix ppds pppd qt3 qt4 quicktime rdesktop
readline reflection rtc session sharedmem sockets spl sse sse2 ssl svg tcpd
tetex tiff truetype truetype-fonts type1-fonts udev unicode userlocales vorbis
win32codecs xml xorg xpm xv zlib elibc_glibc input_devices_keyboard
input_devices_mouse kernel_linux linguas_en linguas_nl userland_GNU
video_cards_radeon"
Unset:  CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LANG, LC_ALL, LDFLAGS,
MAKEOPTS, PORTAGE_RSYNC_EXTRA_OPTS, PORTDIR_OVERLAY

glad to see this working, I'm just going to say x86 stable ^.^

~arm ~hppa ~ia64 ~s390 ~sh: please keyword this ASAP to fix the compile
failures and the security issue (bug #134168). Thanks!
Best regards, CHTEKK.

HPPA done.

This is long fixed... Closing.
Best regards, CHTEKK.