[ubuntu/saucy-proposed] postgresql-9.1 9.1.11-0ubuntu0.13.10 (Accepted)
Martin Pitt
martin.pitt at ubuntu.com
Fri Dec 6 06:00:29 UTC 2013
postgresql-9.1 (9.1.11-0ubuntu0.13.10) saucy-proposed; urgency=low
* New upstream bug fix release. (LP: #1257211)
- Fix "VACUUM"'s tests to see whether it can update relfrozenxid.
In some cases "VACUUM" (either manual or autovacuum) could
incorrectly advance a table's relfrozenxid value, allowing tuples
to escape freezing, causing those rows to become invisible once
2^31 transactions have elapsed. The probability of data loss is
fairly low since multiple incorrect advancements would need to
happen before actual loss occurs, but it's not zero. Users
upgrading from releases 9.0.4 or 8.4.8 or earlier are not affected,
but all later versions contain the bug.
The issue can be ameliorated by, after upgrading, vacuuming all
tables in all databases while having vacuum_freeze_table_age set to
zero. This will fix any latent corruption but will not be able to
fix all pre-existing data errors. However, an installation can be
presumed safe after performing this vacuuming if it has executed
fewer than 2^31 update transactions in its lifetime (check this
with SELECT txid_current() < 2^31).
- Fix initialization of "pg_clog" and "pg_subtrans" during hot
standby startup.
This bug can cause data loss on standby servers at the moment they
start to accept hot-standby queries, by marking committed
transactions as uncommitted. The likelihood of such corruption is
small unless, at the time of standby startup, the primary server
has executed many updating transactions since its last checkpoint.
Symptoms include missing rows, rows that should have been deleted
being still visible, and obsolete versions of updated rows being
still visible alongside their newer versions.
This bug was introduced in versions 9.3.0, 9.2.5, 9.1.10, and
9.0.14. Standby servers that have only been running earlier
releases are not at risk. It's recommended that standby servers
that have ever run any of the buggy releases be re-cloned from the
primary (e.g., with a new base backup) after upgrading.
- See HISTORY/changelog.gz for details about other bug fixes.
Date: Tue, 03 Dec 2013 10:16:56 +0100
Changed-By: Martin Pitt <martin.pitt at ubuntu.com>
Maintainer: Ubuntu Developers <ubuntu-devel-discuss at lists.ubuntu.com>
https://launchpad.net/ubuntu/saucy/+source/postgresql-9.1/9.1.11-0ubuntu0.13.10
-------------- next part --------------
Format: 1.8
Date: Tue, 03 Dec 2013 10:16:56 +0100
Source: postgresql-9.1
Binary: libpq-dev libpq5 libecpg6 libecpg-dev libecpg-compat3 libpgtypes3 postgresql-9.1 postgresql-9.1-dbg postgresql-client-9.1 postgresql-server-dev-9.1 postgresql-doc-9.1 postgresql-contrib-9.1 postgresql-plperl-9.1 postgresql-plpython-9.1 postgresql-plpython3-9.1 postgresql-pltcl-9.1
Architecture: source
Version: 9.1.11-0ubuntu0.13.10
Distribution: saucy-proposed
Urgency: low
Maintainer: Ubuntu Developers <ubuntu-devel-discuss at lists.ubuntu.com>
Changed-By: Martin Pitt <martin.pitt at ubuntu.com>
Description:
libecpg-compat3 - older version of run-time library for ECPG programs
libecpg-dev - development files for ECPG (Embedded PostgreSQL for C)
libecpg6 - run-time library for ECPG programs
libpgtypes3 - shared library libpgtypes for PostgreSQL 9.1
libpq-dev - header files for libpq5 (PostgreSQL library)
libpq5 - PostgreSQL C client library
postgresql-9.1 - object-relational SQL database, version 9.1 server
postgresql-9.1-dbg - debug symbols for postgresql-9.1
postgresql-client-9.1 - front-end programs for PostgreSQL 9.1
postgresql-contrib-9.1 - additional facilities for PostgreSQL
postgresql-doc-9.1 - documentation for the PostgreSQL database management system
postgresql-plperl-9.1 - PL/Perl procedural language for PostgreSQL 9.1
postgresql-plpython-9.1 - PL/Python procedural language for PostgreSQL 9.1
postgresql-plpython3-9.1 - PL/Python 3 procedural language for PostgreSQL 9.1
postgresql-pltcl-9.1 - PL/Tcl procedural language for PostgreSQL 9.1
postgresql-server-dev-9.1 - development files for PostgreSQL 9.1 server-side programming
Launchpad-Bugs-Fixed: 1257211
Changes:
postgresql-9.1 (9.1.11-0ubuntu0.13.10) saucy-proposed; urgency=low
.
* New upstream bug fix release. (LP: #1257211)
- Fix "VACUUM"'s tests to see whether it can update relfrozenxid.
In some cases "VACUUM" (either manual or autovacuum) could
incorrectly advance a table's relfrozenxid value, allowing tuples
to escape freezing, causing those rows to become invisible once
2^31 transactions have elapsed. The probability of data loss is
fairly low since multiple incorrect advancements would need to
happen before actual loss occurs, but it's not zero. Users
upgrading from releases 9.0.4 or 8.4.8 or earlier are not affected,
but all later versions contain the bug.
The issue can be ameliorated by, after upgrading, vacuuming all
tables in all databases while having vacuum_freeze_table_age set to
zero. This will fix any latent corruption but will not be able to
fix all pre-existing data errors. However, an installation can be
presumed safe after performing this vacuuming if it has executed
fewer than 2^31 update transactions in its lifetime (check this
with SELECT txid_current() < 2^31).
- Fix initialization of "pg_clog" and "pg_subtrans" during hot
standby startup.
This bug can cause data loss on standby servers at the moment they
start to accept hot-standby queries, by marking committed
transactions as uncommitted. The likelihood of such corruption is
small unless, at the time of standby startup, the primary server
has executed many updating transactions since its last checkpoint.
Symptoms include missing rows, rows that should have been deleted
being still visible, and obsolete versions of updated rows being
still visible alongside their newer versions.
This bug was introduced in versions 9.3.0, 9.2.5, 9.1.10, and
9.0.14. Standby servers that have only been running earlier
releases are not at risk. It's recommended that standby servers
that have ever run any of the buggy releases be re-cloned from the
primary (e.g., with a new base backup) after upgrading.
- See HISTORY/changelog.gz for details about other bug fixes.
Checksums-Sha1:
dd803d36afd63058dbfef5031645d8ee5bfb6212 3457 postgresql-9.1_9.1.11-0ubuntu0.13.10.dsc
b9ee975498705647aae77dae91869bfc6bb079ff 15861805 postgresql-9.1_9.1.11.orig.tar.bz2
537aabdb2ef02eaa547b3a39ec657e8d43087460 48953 postgresql-9.1_9.1.11-0ubuntu0.13.10.debian.tar.gz
Checksums-Sha256:
3b0334aba8acd1f1efa9e57052c5b8d3269d78caf790837436da3cdec2cb2ad0 3457 postgresql-9.1_9.1.11-0ubuntu0.13.10.dsc
ccbc35aae1490ee5878b97a6aea48dad7465cdad296b380542e4303b68cc6f74 15861805 postgresql-9.1_9.1.11.orig.tar.bz2
595582eed230ef3d5bc01179902600eca55d12a2c43702388e06ec07890d1050 48953 postgresql-9.1_9.1.11-0ubuntu0.13.10.debian.tar.gz
Files:
74ab060bb3c7011837a0b92eee012fcc 3457 database optional postgresql-9.1_9.1.11-0ubuntu0.13.10.dsc
863caa3d9f57ab3cd031fd06f497e1b6 15861805 database optional postgresql-9.1_9.1.11.orig.tar.bz2
5f57e2d220fc5b06bf877907cab2d1ae 48953 database optional postgresql-9.1_9.1.11-0ubuntu0.13.10.debian.tar.gz
Original-Maintainer: Debian PostgreSQL Maintainers <pkg-postgresql-public at lists.alioth.debian.org>
More information about the Saucy-changes
mailing list