Your message dated Mon, 03 Apr 2006 00:47:07 -0700
with message-id <[EMAIL PROTECTED]>
and subject line Bug#343057: fixed in postgresql-common 49
has caused the attached Bug report 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 I am
talking about this indicates a serious mail system misconfiguration
somewhere. Please contact me immediately.)
Debian bug tracking system administrator
(administrator, Debian Bugs database)
--- Begin Message ---
Package: postgresql-common
Version: 36
Severity: normal
After upgrade postgresql-common from 30 to 36 start test failed, but
postgresql is started.
postgresql-common 36
postgresql 7.5.13
postgresql-7.4 1:7.4.9-2
/etc/init.d/postgresql-7.4 start &>postgresql.log
postgresql.log attached
shell locale ru_RU.UTF-8 or POSIX, result the same
from postgresql.conf:
client_encoding = utf-8 # actually, defaults to database encoding
# These settings are initialized by initdb -- they may be changed
lc_messages = 'POSIX' # locale for system error message strings
lc_monetary = 'ru_RU.ISO8859-5' # locale for monetary formatting
lc_numeric = 'ru_RU.ISO8859-5' # locale for number formatting
lc_time = 'ru_RU.ISO8859-5' # locale for time formatting
-- System Information:
Debian Release: testing/unstable
APT prefers testing
APT policy: (990, 'testing'), (500, 'unstable')
Architecture: amd64 (x86_64)
Shell: /bin/sh linked to /bin/bash
Kernel: Linux 2.6.14-2-amd64-k8-smp
Locale: LANG=ru_RU.UTF-8, LC_CTYPE=ru_RU.UTF-8 (charmap=UTF-8)
Versions of packages postgresql-common depends on:
ii adduser 3.80 Add and remove users and groups
ii debconf [debconf-2.0] 1.4.59 Debian configuration management sy
ii lsb-base 3.0-11 Linux Standard Base 3.0 init scrip
Versions of packages postgresql-common recommends:
ii openssl 0.9.8a-3 Secure Socket Layer (SSL) binary a
-- debconf information:
postgresql-common/obsolete-major:
Starting PostgreSQL 7.4 database server: mainThe PostgreSQL server failed to
start. Please check the log output:
2005-12-12 11:31:28 [18990] LOG: database system was shut down at 2005-12-12
11:31:15 MSK
2005-12-12 11:31:28 [18990] LOG: checkpoint record is at 1/DFADAFA8
2005-12-12 11:31:28 [18990] LOG: redo record is at 1/DFADAFA8; undo record is
at 0/0; shutdown TRUE
2005-12-12 11:31:28 [18990] LOG: next transaction ID: 164644; next OID: 187651
2005-12-12 11:31:29 [18990] LOG: database system is ready
2005-12-12 11:31:29 [18993] LOG: connection received: host=[local] port=
2005-12-12 11:31:29 [18993] LOG: incomplete startup packet
2005-12-12 11:31:30 [18997] LOG: connection received: host=[local] port=
2005-12-12 11:31:30 [18997] LOG: connection authorized: user=postgres
database=template1
2005-12-12 11:31:30 [18997] WARNING: ignoring unconvertible UTF-8 character
0xdcef
2005-12-12 11:31:30 [18997] WARNING: ignoring unconvertible UTF-8 character
0xdbd0
2005-12-12 11:31:30 [18997] WARNING: ignoring unconvertible UTF-8 character
0xd4d5
2005-12-12 11:31:30 [18997] WARNING: ignoring unconvertible UTF-8 character
0xdbd5
2005-12-12 11:31:30 [18997] WARNING: ignoring unconvertible UTF-8 character
0xe6222c
2005-12-12 11:31:30 [18997] WARNING: ignoring unconvertible UTF-8 character
0xded4
2005-12-12 11:31:30 [18997] WARNING: ignoring unconvertible UTF-8 character
0xd8e0
2005-12-12 11:31:30 [18997] WARNING: ignoring unconvertible UTF-8 character
0xded2
2005-12-12 11:31:30 [18997] WARNING: ignoring unconvertible UTF-8 character
0xdad0
2005-12-12 11:31:30 [18997] LOG: statement: SELECT d.datname as "¸",
u.usename as "²
pg_catalog.pg_encoding_to_char(d.encoding) as "º"
FROM pg_catalog.pg_database d
LEFT JOIN pg_catalog.pg_user u ON d.datdba = u.usesysid
ORDER BY 1;
2005-12-12 11:31:30 [18997] ERROR: syntax error at or near "º" at character 103
2005-12-12 11:31:30 [19000] LOG: connection received: host=[local] port=
2005-12-12 11:31:30 [19000] LOG: connection authorized: user=postgres
database=template1
2005-12-12 11:31:30 [19000] WARNING: ignoring unconvertible UTF-8 character
0xdcef
2005-12-12 11:31:30 [19000] WARNING: ignoring unconvertible UTF-8 character
0xdbd0
2005-12-12 11:31:30 [19000] WARNING: ignoring unconvertible UTF-8 character
0xd4d5
2005-12-12 11:31:30 [19000] WARNING: ignoring unconvertible UTF-8 character
0xdbd5
2005-12-12 11:31:30 [19000] WARNING: ignoring unconvertible UTF-8 character
0xe6222c
2005-12-12 11:31:30 [19000] WARNING: ignoring unconvertible UTF-8 character
0xded4
2005-12-12 11:31:30 [19000] WARNING: ignoring unconvertible UTF-8 character
0xd8e0
2005-12-12 11:31:30 [19000] WARNING: ignoring unconvertible UTF-8 character
0xded2
2005-12-12 11:31:30 [19000] WARNING: ignoring unconvertible UTF-8 character
0xdad0
2005-12-12 11:31:30 [19000] LOG: statement: SELECT d.datname as "¸",
u.usename as "²
pg_catalog.pg_encoding_to_char(d.encoding) as "º"
FROM pg_catalog.pg_database d
LEFT JOIN pg_catalog.pg_user u ON d.datdba = u.usesysid
ORDER BY 1;
2005-12-12 11:31:30 [19000] ERROR: syntax error at or near "º" at character 103
2005-12-12 11:31:31 [19011] LOG: connection received: host=[local] port=
2005-12-12 11:31:31 [19011] LOG: connection authorized: user=postgres
database=template1
2005-12-12 11:31:31 [19011] WARNING: ignoring unconvertible UTF-8 character
0xdcef
2005-12-12 11:31:31 [19011] WARNING: ignoring unconvertible UTF-8 character
0xdbd0
2005-12-12 11:31:31 [19011] WARNING: ignoring unconvertible UTF-8 character
0xd4d5
2005-12-12 11:31:31 [19011] WARNING: ignoring unconvertible UTF-8 character
0xdbd5
2005-12-12 11:31:31 [19011] WARNING: ignoring unconvertible UTF-8 character
0xe6222c
2005-12-12 11:31:31 [19011] WARNING: ignoring unconvertible UTF-8 character
0xded4
2005-12-12 11:31:31 [19011] WARNING: ignoring unconvertible UTF-8 character
0xd8e0
2005-12-12 11:31:31 [19011] WARNING: ignoring unconvertible UTF-8 character
0xded2
2005-12-12 11:31:31 [19011] WARNING: ignoring unconvertible UTF-8 character
0xdad0
2005-12-12 11:31:31 [19011] LOG: statement: SELECT d.datname as "¸",
u.usename as "²
pg_catalog.pg_encoding_to_char(d.encoding) as "º"
FROM pg_catalog.pg_database d
LEFT JOIN pg_catalog.pg_user u ON d.datdba = u.usesysid
ORDER BY 1;
2005-12-12 11:31:31 [19011] ERROR: syntax error at or near "º" at character 103
2005-12-12 11:31:31 [19014] LOG: connection received: host=[local] port=
2005-12-12 11:31:31 [19014] LOG: connection authorized: user=postgres
database=template1
2005-12-12 11:31:31 [19014] WARNING: ignoring unconvertible UTF-8 character
0xdcef
2005-12-12 11:31:31 [19014] WARNING: ignoring unconvertible UTF-8 character
0xdbd0
2005-12-12 11:31:31 [19014] WARNING: ignoring unconvertible UTF-8 character
0xd4d5
2005-12-12 11:31:31 [19014] WARNING: ignoring unconvertible UTF-8 character
0xdbd5
2005-12-12 11:31:31 [19014] WARNING: ignoring unconvertible UTF-8 character
0xe6222c
2005-12-12 11:31:31 [19014] WARNING: ignoring unconvertible UTF-8 character
0xded4
2005-12-12 11:31:31 [19014] WARNING: ignoring unconvertible UTF-8 character
0xd8e0
2005-12-12 11:31:31 [19014] WARNING: ignoring unconvertible UTF-8 character
0xded2
2005-12-12 11:31:31 [19014] WARNING: ignoring unconvertible UTF-8 character
0xdad0
2005-12-12 11:31:31 [19014] LOG: statement: SELECT d.datname as "¸",
u.usename as "²
pg_catalog.pg_encoding_to_char(d.encoding) as "º"
FROM pg_catalog.pg_database d
LEFT JOIN pg_catalog.pg_user u ON d.datdba = u.usesysid
ORDER BY 1;
2005-12-12 11:31:31 [19014] ERROR: syntax error at or near "º" at character 103
2005-12-12 11:31:32 [19017] LOG: connection received: host=[local] port=
2005-12-12 11:31:32 [19017] LOG: connection authorized: user=postgres
database=template1
2005-12-12 11:31:32 [19017] WARNING: ignoring unconvertible UTF-8 character
0xdcef
2005-12-12 11:31:32 [19017] WARNING: ignoring unconvertible UTF-8 character
0xdbd0
2005-12-12 11:31:32 [19017] WARNING: ignoring unconvertible UTF-8 character
0xd4d5
2005-12-12 11:31:32 [19017] WARNING: ignoring unconvertible UTF-8 character
0xdbd5
2005-12-12 11:31:32 [19017] WARNING: ignoring unconvertible UTF-8 character
0xe6222c
2005-12-12 11:31:32 [19017] WARNING: ignoring unconvertible UTF-8 character
0xded4
2005-12-12 11:31:32 [19017] WARNING: ignoring unconvertible UTF-8 character
0xd8e0
2005-12-12 11:31:32 [19017] WARNING: ignoring unconvertible UTF-8 character
0xded2
2005-12-12 11:31:32 [19017] WARNING: ignoring unconvertible UTF-8 character
0xdad0
2005-12-12 11:31:32 [19017] LOG: statement: SELECT d.datname as "¸",
u.usename as "²
pg_catalog.pg_encoding_to_char(d.encoding) as "º"
FROM pg_catalog.pg_database d
LEFT JOIN pg_catalog.pg_user u ON d.datdba = u.usesysid
ORDER BY 1;
2005-12-12 11:31:32 [19017] ERROR: syntax error at or near "º" at character 103
2005-12-12 11:31:32 [19020] LOG: connection received: host=[local] port=
2005-12-12 11:31:32 [19020] LOG: connection authorized: user=postgres
database=template1
2005-12-12 11:31:32 [19020] WARNING: ignoring unconvertible UTF-8 character
0xdcef
2005-12-12 11:31:32 [19020] WARNING: ignoring unconvertible UTF-8 character
0xdbd0
2005-12-12 11:31:32 [19020] WARNING: ignoring unconvertible UTF-8 character
0xd4d5
2005-12-12 11:31:32 [19020] WARNING: ignoring unconvertible UTF-8 character
0xdbd5
2005-12-12 11:31:32 [19020] WARNING: ignoring unconvertible UTF-8 character
0xe6222c
2005-12-12 11:31:32 [19020] WARNING: ignoring unconvertible UTF-8 character
0xded4
2005-12-12 11:31:32 [19020] WARNING: ignoring unconvertible UTF-8 character
0xd8e0
2005-12-12 11:31:32 [19020] WARNING: ignoring unconvertible UTF-8 character
0xded2
2005-12-12 11:31:32 [19020] WARNING: ignoring unconvertible UTF-8 character
0xdad0
2005-12-12 11:31:32 [19020] LOG: statement: SELECT d.datname as "¸",
u.usename as "²
pg_catalog.pg_encoding_to_char(d.encoding) as "º"
FROM pg_catalog.pg_database d
LEFT JOIN pg_catalog.pg_user u ON d.datdba = u.usesysid
ORDER BY 1;
2005-12-12 11:31:32 [19020] ERROR: syntax error at or near "º" at character 103
2005-12-12 11:31:33 [19023] LOG: connection received: host=[local] port=
2005-12-12 11:31:33 [19023] LOG: connection authorized: user=postgres
database=template1
2005-12-12 11:31:33 [19023] WARNING: ignoring unconvertible UTF-8 character
0xdcef
2005-12-12 11:31:33 [19023] WARNING: ignoring unconvertible UTF-8 character
0xdbd0
2005-12-12 11:31:33 [19023] WARNING: ignoring unconvertible UTF-8 character
0xd4d5
2005-12-12 11:31:33 [19023] WARNING: ignoring unconvertible UTF-8 character
0xdbd5
2005-12-12 11:31:33 [19023] WARNING: ignoring unconvertible UTF-8 character
0xe6222c
2005-12-12 11:31:33 [19023] WARNING: ignoring unconvertible UTF-8 character
0xded4
2005-12-12 11:31:33 [19023] WARNING: ignoring unconvertible UTF-8 character
0xd8e0
2005-12-12 11:31:33 [19023] WARNING: ignoring unconvertible UTF-8 character
0xded2
2005-12-12 11:31:33 [19023] WARNING: ignoring unconvertible UTF-8 character
0xdad0
2005-12-12 11:31:33 [19023] LOG: statement: SELECT d.datname as "¸",
u.usename as "²
pg_catalog.pg_encoding_to_char(d.encoding) as "º"
FROM pg_catalog.pg_database d
LEFT JOIN pg_catalog.pg_user u ON d.datdba = u.usesysid
ORDER BY 1;
2005-12-12 11:31:33 [19023] ERROR: syntax error at or near "º" at character 103
2005-12-12 11:31:33 [19026] LOG: connection received: host=[local] port=
2005-12-12 11:31:33 [19026] LOG: connection authorized: user=postgres
database=template1
2005-12-12 11:31:33 [19026] WARNING: ignoring unconvertible UTF-8 character
0xdcef
2005-12-12 11:31:33 [19026] WARNING: ignoring unconvertible UTF-8 character
0xdbd0
2005-12-12 11:31:33 [19026] WARNING: ignoring unconvertible UTF-8 character
0xd4d5
2005-12-12 11:31:33 [19026] WARNING: ignoring unconvertible UTF-8 character
0xdbd5
2005-12-12 11:31:33 [19026] WARNING: ignoring unconvertible UTF-8 character
0xe6222c
2005-12-12 11:31:33 [19026] WARNING: ignoring unconvertible UTF-8 character
0xded4
2005-12-12 11:31:33 [19026] WARNING: ignoring unconvertible UTF-8 character
0xd8e0
2005-12-12 11:31:33 [19026] WARNING: ignoring unconvertible UTF-8 character
0xded2
2005-12-12 11:31:33 [19026] WARNING: ignoring unconvertible UTF-8 character
0xdad0
2005-12-12 11:31:33 [19026] LOG: statement: SELECT d.datname as "¸",
u.usename as "²
pg_catalog.pg_encoding_to_char(d.encoding) as "º"
FROM pg_catalog.pg_database d
LEFT JOIN pg_catalog.pg_user u ON d.datdba = u.usesysid
ORDER BY 1;
2005-12-12 11:31:33 [19026] ERROR: syntax error at or near "º" at character 103
2005-12-12 11:31:34 [19032] LOG: connection received: host=[local] port=
2005-12-12 11:31:34 [19032] LOG: connection authorized: user=postgres
database=template1
2005-12-12 11:31:34 [19032] WARNING: ignoring unconvertible UTF-8 character
0xdcef
2005-12-12 11:31:34 [19032] WARNING: ignoring unconvertible UTF-8 character
0xdbd0
2005-12-12 11:31:34 [19032] WARNING: ignoring unconvertible UTF-8 character
0xd4d5
2005-12-12 11:31:34 [19032] WARNING: ignoring unconvertible UTF-8 character
0xdbd5
2005-12-12 11:31:34 [19032] WARNING: ignoring unconvertible UTF-8 character
0xe6222c
2005-12-12 11:31:34 [19032] WARNING: ignoring unconvertible UTF-8 character
0xded4
2005-12-12 11:31:34 [19032] WARNING: ignoring unconvertible UTF-8 character
0xd8e0
2005-12-12 11:31:34 [19032] WARNING: ignoring unconvertible UTF-8 character
0xded2
2005-12-12 11:31:34 [19032] WARNING: ignoring unconvertible UTF-8 character
0xdad0
2005-12-12 11:31:34 [19032] LOG: statement: SELECT d.datname as "¸",
u.usename as "²
pg_catalog.pg_encoding_to_char(d.encoding) as "º"
FROM pg_catalog.pg_database d
LEFT JOIN pg_catalog.pg_user u ON d.datdba = u.usesysid
ORDER BY 1;
2005-12-12 11:31:34 [19032] ERROR: syntax error at or near "º" at character 103
2005-12-12 11:31:34 [19035] LOG: connection received: host=[local] port=
2005-12-12 11:31:34 [19035] LOG: connection authorized: user=postgres
database=template1
2005-12-12 11:31:34 [19035] WARNING: ignoring unconvertible UTF-8 character
0xdcef
2005-12-12 11:31:34 [19035] WARNING: ignoring unconvertible UTF-8 character
0xdbd0
2005-12-12 11:31:34 [19035] WARNING: ignoring unconvertible UTF-8 character
0xd4d5
2005-12-12 11:31:34 [19035] WARNING: ignoring unconvertible UTF-8 character
0xdbd5
2005-12-12 11:31:34 [19035] WARNING: ignoring unconvertible UTF-8 character
0xe6222c
2005-12-12 11:31:34 [19035] WARNING: ignoring unconvertible UTF-8 character
0xded4
2005-12-12 11:31:34 [19035] WARNING: ignoring unconvertible UTF-8 character
0xd8e0
2005-12-12 11:31:34 [19035] WARNING: ignoring unconvertible UTF-8 character
0xded2
2005-12-12 11:31:34 [19035] WARNING: ignoring unconvertible UTF-8 character
0xdad0
2005-12-12 11:31:34 [19035] LOG: statement: SELECT d.datname as "¸",
u.usename as "²
pg_catalog.pg_encoding_to_char(d.encoding) as "º"
FROM pg_catalog.pg_database d
LEFT JOIN pg_catalog.pg_user u ON d.datdba = u.usesysid
ORDER BY 1;
2005-12-12 11:31:34 [19035] ERROR: syntax error at or near "º" at character 103
2005-12-12 11:31:35 [19038] LOG: connection received: host=[local] port=
2005-12-12 11:31:35 [19038] LOG: connection authorized: user=postgres
database=template1
2005-12-12 11:31:35 [19038] WARNING: ignoring unconvertible UTF-8 character
0xdcef
2005-12-12 11:31:35 [19038] WARNING: ignoring unconvertible UTF-8 character
0xdbd0
2005-12-12 11:31:35 [19038] WARNING: ignoring unconvertible UTF-8 character
0xd4d5
2005-12-12 11:31:35 [19038] WARNING: ignoring unconvertible UTF-8 character
0xdbd5
2005-12-12 11:31:35 [19038] WARNING: ignoring unconvertible UTF-8 character
0xe6222c
2005-12-12 11:31:35 [19038] WARNING: ignoring unconvertible UTF-8 character
0xded4
2005-12-12 11:31:35 [19038] WARNING: ignoring unconvertible UTF-8 character
0xd8e0
2005-12-12 11:31:35 [19038] WARNING: ignoring unconvertible UTF-8 character
0xded2
2005-12-12 11:31:35 [19038] WARNING: ignoring unconvertible UTF-8 character
0xdad0
2005-12-12 11:31:35 [19038] LOG: statement: SELECT d.datname as "¸",
u.usename as "²
pg_catalog.pg_encoding_to_char(d.encoding) as "º"
FROM pg_catalog.pg_database d
LEFT JOIN pg_catalog.pg_user u ON d.datdba = u.usesysid
ORDER BY 1;
2005-12-12 11:31:35 [19038] ERROR: syntax error at or near "º" at character 103
[31mfailed![39;49m
--- End Message ---
--- Begin Message ---
Source: postgresql-common
Source-Version: 49
We believe that the bug you reported is fixed in the latest version of
postgresql-common, which is due to be installed in the Debian FTP archive:
postgresql-client-common_49_all.deb
to pool/main/p/postgresql-common/postgresql-client-common_49_all.deb
postgresql-common_49.dsc
to pool/main/p/postgresql-common/postgresql-common_49.dsc
postgresql-common_49.tar.gz
to pool/main/p/postgresql-common/postgresql-common_49.tar.gz
postgresql-common_49_all.deb
to pool/main/p/postgresql-common/postgresql-common_49_all.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 [EMAIL PROTECTED],
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Martin Pitt <[EMAIL PROTECTED]> (supplier of updated postgresql-common 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 [EMAIL PROTECTED])
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Format: 1.7
Date: Mon, 3 Apr 2006 09:03:15 +0200
Source: postgresql-common
Binary: postgresql-client-common postgresql-common
Architecture: source all
Version: 49
Distribution: unstable
Urgency: low
Maintainer: Martin Pitt <[EMAIL PROTECTED]>
Changed-By: Martin Pitt <[EMAIL PROTECTED]>
Description:
postgresql-client-common - manager for multiple PostgreSQL client versions
postgresql-common - manager for PostgreSQL database clusters
Closes: 343057 359249
Changes:
postgresql-common (49) unstable; urgency=low
.
* debian/supported-versions:
- Do not fail the package installation if an unknown LSB release is
encountered; merely print a warning and assume just the latest
PostgreSQL version is supported.
- Fix Ubuntu Dapper release version (6.04 -> 6.06).
(https://launchpad.net/bugs/36921)
* pg_createcluster: Add option -p/--port to set the cluster port.
Closes: #359249
* t/030_errors.t: Check that pg_createcluster's --port option validates the
port number (invalid number, already used port).
* t/090_multicluster.t: Check that pg_createcluster's --port option works.
* t/050_encodings.t: Check correct input/output with Latin-1 and UTF-8
client encodings in all server locale/encoding combinations.
* pg_ctlcluster: Do not set LC_ALL and LANG environment variables for the
postmaster; it handles locales by itself, and explicitly setting them
breaks sometimes. Thanks to Olleg Samoylov for analyzing this.
Closes: #343057
* t/TestLib.pm: Sort list of major versions, since we rely on a sorted list.
* debian/init.d-functions, do_ctl_all(): Fix 'return' statements to
explicitlly return 0 to not break with dash.
* pg_lsclusters: Sort output by version, then by cluster name.
Files:
e965d1054a31a8149445073fd6b9a094 604 misc optional postgresql-common_49.dsc
be756d06fd28761b68c00c88c1d44ea1 71937 misc optional
postgresql-common_49.tar.gz
913a61a7e7fc3bd6ccfc3816ba959159 79598 misc optional
postgresql-common_49_all.deb
dd06838279ceed7677cc638997a2cfe6 31826 misc optional
postgresql-client-common_49_all.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
iD8DBQFEMM+6DecnbV4Fd/IRAvKvAKCPfDRNDHo/TJa9ssNFlz9ADqwC+ACfWRma
1a72SJiNFYUDZpTsh6u9K30=
=ZKuL
-----END PGP SIGNATURE-----
--- End Message ---
