Package: postgresql-9.1 Version: 9.1.22-0+deb7u1 Severity: important Dear Maintainer,
* What led up to the situation? I'm running unattended-upgrade which recently upgraded the locales package. That triggered running locale-gen, and the problem also appears when running locale-gen alone. * What exactly did you do (or not do) that was effective (or ineffective)? I tried to connect using psql to a local postgresql server installation. * What was the outcome of this action? psql: FATAL: Datenbank-Locale ist inkompatibel mit Betriebssystem DETAIL: Die Datenbank wurde mit LC_COLLATE >>en_US.UTF-8<< initialisiert, was von setlocale() nicht erkannt wird. TIP: Erzeugen Sie die Datenbank neu mit einer anderen Locale oder installieren Sie die fehlende Locale. * What outcome did you expect instead? A normal prompt letting me access the database. * Debug strace says 25055 munmap(0xb7256000, 4096) = 0 25055 open("/usr/lib/locale/locale-archive", O_RDONLY|O_LARGEFILE) = 7 25055 fstat64(7, {st_mode=S_IFREG|0644, st_size=3926944, ...}) = 0 25055 close(7) = 0 25055 open("/usr/lib/locale/en_US.UTF-8/LC_COLLATE", O_RDONLY) = -1 ENOENT (No such file or directory) 25055 open("/usr/lib/locale/en_US.utf8/LC_COLLATE", O_RDONLY) = -1 ENOENT (No such file or directory) 25055 open("/usr/lib/locale/en_US/LC_COLLATE", O_RDONLY) = -1 ENOENT (No such file or directory) 25055 open("/usr/lib/locale/en.UTF-8/LC_COLLATE", O_RDONLY) = -1 ENOENT (No such file or directory) 25055 open("/usr/lib/locale/en.utf8/LC_COLLATE", O_RDONLY) = -1 ENOENT (No such file or directory) 25055 open("/usr/lib/locale/en/LC_COLLATE", O_RDONLY) = -1 ENOENT (No such file or directory) 25055 time(NULL) = 1464599678 25055 time(NULL) = 1464599678 25055 time(NULL) = 1464599678 25055 write(2, "2016-05-30 11:14:38 CEST FATAL: Datenbank-Locale ist inkompatibel mit Betriebssystem\n2016-05-30 11:14:38 CEST DETAIL: Die Datenbank wurde mit LC_COLLATE >>en_US.UTF-8<< initialisiert, was von setlocale() nicht erkannt wird.\n2016-05-30 11:14:38 CEST TIPP: Erzeugen Sie die Datenbank neu mit einer anderen Locale oder installieren Sie die fehlende Locale.\n", 357) = 357 25055 send(9, "R\0\0\0\10\0\0\0\0E\0\0\1:SFATAL\0CXX000\0MDatenbank-Locale ist inkompatibel mit Betriebssystem\0DDie Datenbank wurde mit LC_COLLATE >>en_US.UTF-8<< initialisiert, was von setlocale() nicht erkannt wird.\0HErzeugen Sie die Datenbank neu mit einer anderen Locale oder installieren Sie die fehlende Locale.\0Fpostinit.c\0L338\0RCheckMyDatabase\0\0", 324, 0) = 324 25055 gettimeofday({1464599678, 833943}, NULL) = 0 so locale-archive is not read. lsof says postgres 13643 postgres DEL REG 9,126 415433 /usr/lib/locale/locale-archive Manually restarting postgresql "fixes" the issue for me. Currently I'm trying to workaround using $ localedef --no-archive -f UTF-8 -i en_US en_US.UTF-8 But this really should not be needed as I guess it will not become updated automatically. Regards, M. Braun -- System Information: Debian Release: 7.10 APT prefers oldstable-updates APT policy: (500, 'oldstable-updates'), (500, 'oldstable') Architecture: i386 (i686) Kernel: Linux 3.16-0.bpo.2-686-pae (SMP w/1 CPU core) Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8) (ignored: LC_ALL set to de_DE.utf8) Shell: /bin/sh linked to /bin/dash Versions of packages postgresql-9.1 depends on: ii libc6 2.13-38+deb7u11 ii libcomerr2 1.42.5-1.1+deb7u1 ii libgssapi-krb5-2 1.10.1+dfsg-5+deb7u7 ii libkrb5-3 1.10.1+dfsg-5+deb7u7 ii libldap-2.4-2 2.4.31-2+deb7u1 ii libpam0g 1.1.3-7.1 ii libpq5 9.1.22-0+deb7u1 ii libssl1.0.0 1.0.1e-2+deb7u21 ii libxml2 2.8.0+dfsg1-7+wheezy5 ii locales 2.13-38+deb7u11 ii postgresql-client-9.1 9.1.22-0+deb7u1 ii postgresql-common 134wheezy4 ii ssl-cert 1.0.32+deb7u1 ii tzdata 2016d-0+deb7u1 postgresql-9.1 recommends no packages. Versions of packages postgresql-9.1 suggests: pn locales-all <none> pn oidentd | ident-server <none> -- no debconf information _______________________________________________ Pkg-postgresql-public mailing list Pkg-postgresql-public@lists.alioth.debian.org http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public