Debian Bug report logs - #282502
fails to install with LATIN commands in temp file

Toggle useless messages

Message #5 received at submit@bugs.debian.org (full text, mbox, reply):

From: Joey Hess <joeyh@debian.org>

To: Debian Bug Tracking System <submit@bugs.debian.org>

Subject: fails to install with LATIN commands in temp file

Date: Mon, 22 Nov 2004 11:26:01 -0500

[Message part 1 (text/plain, inline)]

Package: postgresql
Version: 7.4.6-3
Severity: serious

Automated debian installation testing of sarge failed to install the
database-server task today. postgresql failed to install as follows:

  Setting up postgresql (7.4.6-3) ...

  Creating config file /etc/postgresql/postmaster.conf with new version
  The files belonging to this database system will be owned by user "postgres".
  This user must also own the server process.

  The database cluster will be initialized with locale C.

  fixing permissions on existing directory /var/lib/postgres/data... ok
  creating directory /var/lib/postgres/data/base... ok
  creating directory /var/lib/postgres/data/global... ok
  creating directory /var/lib/postgres/data/pg_xlog... ok
  creating directory /var/lib/postgres/data/pg_clog... ok
  selecting default max_connections... 100
  selecting default shared_buffers... 1000
  creating configuration files... ok
  creating template1 database in /var/lib/postgres/data/base/1... ok
  initializing pg_shadow... ok
  enabling unlimited row size for system tables... ok
  initializing pg_depend... ok
  creating system views... ok
  loading pg_description... ok
  creating conversions... ok
  setting privileges on built-in objects... ok
  creating information schema... ok
  vacuuming database template1... ok
  copying template1 to template0... ok

  Success. The database server should be started automatically.
  If not, you can start the database server using:

      /etc/init.d/postgresql start
  /tmp/base-config.914/pg.lSJnBc: line 8: LATIN6: command not found
  /tmp/base-config.914/pg.lSJnBc: line 9: LATIN7: command not found
  /tmp/base-config.914/pg.lSJnBc: line 10: LATIN8: command not found
  /tmp/base-config.914/pg.lSJnBc: line 11: LATIN9: command not found
  /tmp/base-config.914/pg.lSJnBc: line 12: LATIN10: command not found
  dpkg: error processing postgresql (--configure):
   subprocess post-installation script returned error exit status 127


FWIW, the temp file was put in /tmp/base-config.914/ because base-config sets
TMPDIR to there. I don't think this is related to the real problem. Postgresql
7.4.6-2 installed successfully yesterday. Looking at my old automated install
logs, postgresql -3 has been failing to install all this week in unstable,
sorry I didn't file a bug earlier to keep it out of testing.

-- 
see shy jo

[signature.asc (application/pgp-signature, inline)]

Message #10 received at 282502@bugs.debian.org (full text, mbox, reply):

From: Martin Pitt <mpitt@debian.org>

To: Joey Hess <joeyh@debian.org>, 282502@bugs.debian.org

Subject: Re: Bug#282502: fails to install with LATIN commands in temp file

Date: Tue, 23 Nov 2004 13:26:25 +0100

[Message part 1 (text/plain, inline)]

Hi Joey!

Thanks for your report.

Joey Hess [2004-11-22 11:26 -0500]:
>       /etc/init.d/postgresql start
>   /tmp/base-config.914/pg.lSJnBc: line 8: LATIN6: command not found
>   /tmp/base-config.914/pg.lSJnBc: line 9: LATIN7: command not found
>   /tmp/base-config.914/pg.lSJnBc: line 10: LATIN8: command not found
>   /tmp/base-config.914/pg.lSJnBc: line 11: LATIN9: command not found
>   /tmp/base-config.914/pg.lSJnBc: line 12: LATIN10: command not found
>   dpkg: error processing postgresql (--configure):
>    subprocess post-installation script returned error exit status 127

I am unable to reproduce this, so I'm afraid I need your help with
this. I put a debugging-enabled version on

  http://people.debian.org/~mpitt/packages/postgresql/

The only change is that I activated the shell's "-x" flag in
postgresql's postinst to enable debugging.

Can you please install the package again, using some

  ... 2>&1 | tee postgresql.log

magic and send me the output?

Also, what does /etc/environment contain on your system? What does
'locale -a' say?

Thanks a lot in advance for your help and have a nice day!

Martin

-- 
Martin Pitt                       http://www.piware.de
Ubuntu Developer            http://www.ubuntulinux.org
Debian GNU/Linux Developer       http://www.debian.org

[signature.asc (application/pgp-signature, inline)]

Message #15 received at 282502@bugs.debian.org (full text, mbox, reply):

From: Peter Eisentraut <peter_e@gmx.net>

To: Joey Hess <joeyh@debian.org>, 282502@bugs.debian.org

Subject: Re: Bug#282502: fails to install with LATIN commands in temp file

Date: Tue, 23 Nov 2004 14:06:04 +0100

[Message part 1 (text/plain, inline)]

Am Montag, 22. November 2004 17:26 schrieb Joey Hess:
>   /tmp/base-config.914/pg.lSJnBc: line 8: LATIN6: command not found
>   /tmp/base-config.914/pg.lSJnBc: line 9: LATIN7: command not found
>   /tmp/base-config.914/pg.lSJnBc: line 10: LATIN8: command not found
>   /tmp/base-config.914/pg.lSJnBc: line 11: LATIN9: command not found
>   /tmp/base-config.914/pg.lSJnBc: line 12: LATIN10: command not found
>   dpkg: error processing postgresql (--configure):
>    subprocess post-installation script returned error exit status 127

The problem is here:

initdb --encoding ${ENCODING} --pgdata ${PGDATA}

This is line 7.  The value of the shell variable ENCODING is something like 
"LATIN1
LATIN6
LATIN7
LATIN8
LATIN9
LATIN10"
with the line breaks.

The bug is in the function get_encoding().  The charset in this example was 
probably ISO-8859-1, but that also matches

LATIN6 ISO-8859-10
LATIN7 ISO-8859-13
LATIN8 ISO-8859-14
LATIN9 ISO-8859-15
LATIN10 ISO-8859-16

The matching routine needs some whitespace anchors or something.

Martin, you may also want to map

$ LC_ALL=C locale charmap
ANSI_X3.4-1968

to something, probably SQL_ASCII, but not UTF8.  In general, I don't think 
having UTF8 as a *fallback* is a good idea.

[Message part 2 (application/pgp-signature, inline)]

Message #20 received at 282502@bugs.debian.org (full text, mbox, reply):

From: Martin Pitt <mpitt@debian.org>

To: Peter Eisentraut <peter_e@gmx.net>, 282502@bugs.debian.org, Joey Hess <joeyh@debian.org>

Subject: Re: Bug#282502: fails to install with LATIN commands in temp file

Date: Tue, 23 Nov 2004 15:12:16 +0100

[Message part 1 (text/plain, inline)]

Hi Peter, hi Joey!

Peter Eisentraut [2004-11-23 14:06 +0100]:
> The bug is in the function get_encoding().  The charset in this example was 
> probably ISO-8859-1, but that also matches
> 
> LATIN6 ISO-8859-10
> LATIN7 ISO-8859-13
> LATIN8 ISO-8859-14
> LATIN9 ISO-8859-15
> LATIN10 ISO-8859-16

/me slaps his head

Right, thank you for pointing me at this. I changed the matching to

  MAP=$(grep -i "\<$CHARSET\>" <<EOF | head -1 | cut -d' '  -f 1

("head -1" just to be double-sure).

> Martin, you may also want to map
> 
> $ LC_ALL=C locale charmap
> ANSI_X3.4-1968
> 
> to something, probably SQL_ASCII, but not UTF8.  In general, I don't think 
> having UTF8 as a *fallback* is a good idea.

Instead of mapping ANSI_X3.4-1968 directly, I now use SQL_ASCII as a
fallback. This is probably a better choice anyway, thanks.

Fixed in arch head, I will upload today.

Martin

-- 
Martin Pitt                       http://www.piware.de
Ubuntu Developer            http://www.ubuntulinux.org
Debian GNU/Linux Developer       http://www.debian.org

[signature.asc (application/pgp-signature, inline)]

Message #27 received at 282502-close@bugs.debian.org (full text, mbox, reply):

From: Martin Pitt <mpitt@debian.org>

To: 282502-close@bugs.debian.org

Subject: Bug#282502: fixed in postgresql 7.4.6-4

Date: Tue, 23 Nov 2004 10:17:08 -0500

Source: postgresql
Source-Version: 7.4.6-4

We believe that the bug you reported is fixed in the latest version of
postgresql, which is due to be installed in the Debian FTP archive:

libecpg-dev_7.4.6-4_i386.deb
  to pool/main/p/postgresql/libecpg-dev_7.4.6-4_i386.deb
libecpg4_7.4.6-4_i386.deb
  to pool/main/p/postgresql/libecpg4_7.4.6-4_i386.deb
libpgtcl-dev_7.4.6-4_i386.deb
  to pool/main/p/postgresql/libpgtcl-dev_7.4.6-4_i386.deb
libpgtcl_7.4.6-4_i386.deb
  to pool/main/p/postgresql/libpgtcl_7.4.6-4_i386.deb
libpq3_7.4.6-4_i386.deb
  to pool/main/p/postgresql/libpq3_7.4.6-4_i386.deb
postgresql-client_7.4.6-4_i386.deb
  to pool/main/p/postgresql/postgresql-client_7.4.6-4_i386.deb
postgresql-contrib_7.4.6-4_i386.deb
  to pool/main/p/postgresql/postgresql-contrib_7.4.6-4_i386.deb
postgresql-dev_7.4.6-4_i386.deb
  to pool/main/p/postgresql/postgresql-dev_7.4.6-4_i386.deb
postgresql-doc_7.4.6-4_all.deb
  to pool/main/p/postgresql/postgresql-doc_7.4.6-4_all.deb
postgresql_7.4.6-4.diff.gz
  to pool/main/p/postgresql/postgresql_7.4.6-4.diff.gz
postgresql_7.4.6-4.dsc
  to pool/main/p/postgresql/postgresql_7.4.6-4.dsc
postgresql_7.4.6-4_i386.deb
  to pool/main/p/postgresql/postgresql_7.4.6-4_i386.deb



A summary of the changes between this version and the previous one is
attached.

Thank you for reporting the bug, which will now be closed.  If you
have further comments please address them to 282502@bugs.debian.org,
and the maintainer will reopen the bug report if appropriate.

Debian distribution maintenance software
pp.
Martin Pitt <mpitt@debian.org> (supplier of updated postgresql package)

(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing ftpmaster@debian.org)


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Format: 1.7
Date: Tue, 23 Nov 2004 15:29:28 +0100
Source: postgresql
Binary: postgresql-client libecpg4 libpgtcl-dev libpq3 postgresql-doc libecpg-dev postgresql-dev postgresql libpgtcl postgresql-contrib
Architecture: source i386 all
Version: 7.4.6-4
Distribution: unstable
Urgency: medium
Maintainer: Oliver Elphick <Oliver.Elphick@lfix.co.uk>
Changed-By: Martin Pitt <mpitt@debian.org>
Description: 
 libecpg-dev - development files for ECPG (Embedded PostgreSQL for C)
 libecpg4   - run-time library for ECPG programs
 libpgtcl   - Tcl procedural language, library and front-end for PostgreSQL
 libpgtcl-dev - Tcl library for PostgreSQL - development files
 libpq3     - PostgreSQL C client library
 postgresql - object-relational SQL database management system
 postgresql-client - front-end programs for PostgreSQL
 postgresql-contrib - additional facilities for PostgreSQL
 postgresql-dev - development files for libpq (PostgreSQL library)
 postgresql-doc - documentation for the PostgreSQL database management system
Closes: 282090 282431 282502
Changes: 
 postgresql (7.4.6-4) unstable; urgency=medium
 .
   * Urgency medium since this fixes an RC bug also present in Sarge.
   * Moved kernel variable checks from postgresql-startup to new script
     /usr/share/postgresql/startup-checks-root.sh and execute the latter in the
     init script. Some security enhanced kernels restrict the permissions of
     /proc/sys to root-only readability. Closes: #282431
   * postgresql-contrib.{postinst,postrm}: use the new autovac-{start,stop}
     init functions instead of restarting the complete PostgreSQL server.
     Closes: #282090
   * postgresql-startup.in: specify full path to pg_controldata to be more
     robust
   * postinst.in: fixed get_encoding function to just match against one locale
     in the list. Closes: #282502
   * postinst.in: changed fallback encoding to SQL_ASCII, which is safer than
     UTF8.
Files: 
 bcfc4a112cb2ae31965fc7cd2284dc43 973 misc optional postgresql_7.4.6-4.dsc
 aad2559bdaaeecbdb9b7dde7eaea8014 140529 misc optional postgresql_7.4.6-4.diff.gz
 c0bd3d5f1b4d55594b0826ce08f1fb4f 2384656 doc optional postgresql-doc_7.4.6-4_all.deb
 dc833f5658c28a3e1d3fa224508f9d15 3725848 misc optional postgresql_7.4.6-4_i386.deb
 9d8440425a15ad53fab7628b8bf8029f 489090 misc optional postgresql-client_7.4.6-4_i386.deb
 77823b0591365078ffaa7c1210a1d1bc 506724 libdevel optional postgresql-dev_7.4.6-4_i386.deb
 6612e873997c1670a6484b32bf139ab4 110490 libs optional libpq3_7.4.6-4_i386.deb
 1bee8348d3be783793bcca85bcdeb105 87978 libs optional libecpg4_7.4.6-4_i386.deb
 9469264355aeb0e25c44041a07f4fd26 196848 libdevel optional libecpg-dev_7.4.6-4_i386.deb
 62a10227bf65516a57e2d40f3d66bd3a 72038 libs optional libpgtcl_7.4.6-4_i386.deb
 156033311136a0a3649862e77383c02c 49314 libdevel optional libpgtcl-dev_7.4.6-4_i386.deb
 297d4c9b41bb7714f4685645bd6d58b1 598512 misc optional postgresql-contrib_7.4.6-4_i386.deb

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFBo08ODecnbV4Fd/IRAgIoAJ98WH04gqwa4zY4sZbTo4slyCxdkwCgqteQ
EJqP6kJjeC0m93J/tWr7E1o=
=s6Ea
-----END PGP SIGNATURE-----

Send a report that this bug log contains spam.