Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!

Bug 138155

Summary: glibc 2.3.6-r4 update breaks postgresql locales
Product: Gentoo Linux Reporter: k_berbach
Component: New packagesAssignee: PgSQL Bugs <pgsql-bugs>
Status: VERIFIED INVALID    
Severity: major CC: esigra
Priority: High    
Version: 2006.0   
Hardware: x86   
OS: Linux   
Whiteboard:
Package list:
Runtime testing required: ---

Description k_berbach 2006-06-27 00:08:45 UTC
After updateing from glibc-2.3.6-r3 to glibc 2.3.6-r4 postgresql-8.1.3 fails to start. The postgres error messages are:

FATAL:  invalid value for parameter "lc_messages": "de_DE.utf8"
FATAL:  invalid value for parameter "lc_messages": "de_DE.utf8"
FATAL:  invalid value for parameter "lc_monetary": "de_DE.utf8"

Commenting out these values in postgresql.conf produces an error upon starting postgres stating the database is incompatible with the system.
Which is ok, as you cannot change the lc_messages value once initdb has run. The postgres cluster has been initialized with UTF8 and a german unicode locale, so people using a "C" locale for postgres may most likely not be affected.

Putting:
de_DE.UTF8 UTF8
en_US.UTF8 UTF8

into /etc/locale.gen after upgrading glibc and running locale-gen did not help, postgres still fails to start with above error messages. 

Downgrading to glibc-2.3.6-r3 and all is fine again. I have been using "-userlocales" in my USE flags all the time so far. 
This behaviour is reproducable, as an second upgrade to 2.3.6-r4 broke postgresql again, while downgrading made it work. A second machine shows the same behaviour.

Currently I am using a 2006.0 profile and portage 2.1-r1 on a 2.6.16.x kernel, hardly any CFLAG options. Will post the output emerge --info later, as I cannot access my machine right now.
Comment 1 k_berbach 2006-06-27 22:52:10 UTC
emerge --info:

Gentoo Base System version 1.6.15
Portage 2.1-r1 (default-linux/x86/2006.0, gcc-3.4.6, glibc-2.3.6-r3, 2.6.16.16 i686) =================================================================
System uname: 2.6.16.16 i686 Pentium II (Deschutes)
dev-lang/python:     2.4.2
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-r1
sys-devel/binutils:  2.16.1-r2
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="-march=pentium2 -O2 -pipe"
CHOST="i686-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/lib/X11/xkb /var/bind" CONFIG_PROTECT_MASK="/etc/env.d /etc/gconf /etc/revdep-rebuild /etc/terminfo" CXXFLAGS="-march=pentium2 -O2 -pipe" DISTDIR="/usr/src/gentoo/distfiles"
FEATURES="autoconfig distlocks metadata-transfer sandbox sfperms strict" GENTOO_MIRRORS="http://distfiles.gentoo.org http://distro.ibiblio.org/pub/linux/distributions/gentoo"
LANG="de_DE.utf8"
LC_ALL="de_DE.utf8"
LINGUAS="de en_GB"
MAKEOPTS="-j1"
PKGDIR="/usr/src/gentoo/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="/usr/src/gentoo/tmp"
PORTDIR="/usr/src/gentoo/portage" PORTDIR_OVERLAY="/usr/src/gentoo/local"
SYNC="rsync://rsync.gentoo.org/gentoo-portage"
USE="x86 aalib acl acpi apache2 berkdb bzlib caps cdr cli crypt cups dri dvd dvdr eds emboss encode exif fam flac fortran ftp gd gpm imagemagick isdnlog ithreads kerberos ldap mcal mmap mmx nls no_wxgtk1 nptl nptlonly offensive ogg pdflib pic postgres ppds pppd readline reflection rtc samba sasl scanner session smartcard snmp spell ssl threads truetype truetype-fonts udev unicode usb xml2 xorg xrandr zlib elibc_glibc kernel_linux linguas_de linguas_en_GB userland_GNU"
Unset:  CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LDFLAGS, PORTAGE_RSYNC_EXTRA_OPTS
Comment 2 Jakub Moc (RETIRED) gentoo-dev 2006-06-28 11:11:09 UTC
> Putting
> de_DE.UTF8 UTF8
> en_US.UTF8 UTF8
> into /etc/locale.gen after upgrading glibc and running locale-gen did not help

Invalid, needs to be:

de_DE.UTF-8 UTF8
en_US.UTF-8 UTF8
Comment 3 Jakub Moc (RETIRED) gentoo-dev 2006-06-28 11:11:57 UTC
(In reply to comment #2)
> Invalid, needs to be:

Errr...
 
de_DE.UTF-8 UTF-8
en_US.UTF-8 UTF-8

actually.