Your message dated Fri, 12 Aug 2016 21:22:00 +0200 with message-id <[email protected]> and subject line Re: Bug#825814: postgresql-9.1: postgresql refuses connection with setlocale error after localgen is run has caused the Debian Bug report #825814, regarding postgresql-9.1: postgresql refuses connection with setlocale error after localgen is run to be marked as done.
This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the Bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what this message is talking about, this may indicate a serious mail system misconfiguration somewhere. Please contact [email protected] immediately.) -- 825814: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=825814 Debian Bug Tracking System Contact [email protected] with problems
--- Begin Message ---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
--- End Message ---
--- Begin Message ---No reply from submitter, closing. Christoph
--- End Message ---
_______________________________________________ Pkg-postgresql-public mailing list [email protected] http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public
