[Bug 1088393] Re: New bug fix releases: 9.1.7, 8.4.15, 8.3.22
This bug was fixed in the package postgresql-9.1 - 9.1.7-0ubuntu12.04 --- postgresql-9.1 (9.1.7-0ubuntu12.04) precise-proposed; urgency=low * New upstream bug fix release: (LP: #1088393) - Fix multiple bugs associated with "CREATE INDEX CONCURRENTLY". Fix "CREATE INDEX CONCURRENTLY" to use in-place updates when changing the state of an index's pg_index row. This prevents race conditions that could cause concurrent sessions to miss updating the target index, thus resulting in corrupt concurrently-created indexes. Also, fix various other operations to ensure that they ignore invalid indexes resulting from a failed "CREATE INDEX CONCURRENTLY" command. The most important of these is "VACUUM", because an auto-vacuum could easily be launched on the table before corrective action can be taken to fix or remove the invalid index. - Fix buffer locking during WAL replay. The WAL replay code was insufficiently careful about locking buffers when replaying WAL records that affect more than one page. This could result in hot standby queries transiently seeing inconsistent states, resulting in wrong answers or unexpected failures. - See HISTORY/changelog.gz for the other bug fixes. * Drop 00git_ecpg_array_bounds.patch, fixed upstream. -- Martin PittMon, 10 Dec 2012 14:54:49 +0100 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1088393 Title: New bug fix releases: 9.1.7, 8.4.15, 8.3.22 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/postgresql-8.3/+bug/1088393/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1088393] Re: New bug fix releases: 9.1.7, 8.4.15, 8.3.22
This bug was fixed in the package postgresql-9.1 - 9.1.7-0ubuntu11.10 --- postgresql-9.1 (9.1.7-0ubuntu11.10) oneiric-proposed; urgency=low * New upstream bug fix release: (LP: #1088393) - Fix multiple bugs associated with "CREATE INDEX CONCURRENTLY". Fix "CREATE INDEX CONCURRENTLY" to use in-place updates when changing the state of an index's pg_index row. This prevents race conditions that could cause concurrent sessions to miss updating the target index, thus resulting in corrupt concurrently-created indexes. Also, fix various other operations to ensure that they ignore invalid indexes resulting from a failed "CREATE INDEX CONCURRENTLY" command. The most important of these is "VACUUM", because an auto-vacuum could easily be launched on the table before corrective action can be taken to fix or remove the invalid index. - Fix buffer locking during WAL replay. The WAL replay code was insufficiently careful about locking buffers when replaying WAL records that affect more than one page. This could result in hot standby queries transiently seeing inconsistent states, resulting in wrong answers or unexpected failures. - See HISTORY/changelog.gz for the other bug fixes. -- Martin PittMon, 10 Dec 2012 15:04:42 +0100 ** Changed in: postgresql-9.1 (Ubuntu Precise) Status: Fix Committed => Fix Released -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1088393 Title: New bug fix releases: 9.1.7, 8.4.15, 8.3.22 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/postgresql-8.3/+bug/1088393/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1088393] Re: New bug fix releases: 9.1.7, 8.4.15, 8.3.22
This bug was fixed in the package postgresql-9.1 - 9.1.7-0ubuntu12.10 --- postgresql-9.1 (9.1.7-0ubuntu12.10) quantal-proposed; urgency=low * New upstream bug fix release: (LP: #1088393) - Fix multiple bugs associated with "CREATE INDEX CONCURRENTLY". Fix "CREATE INDEX CONCURRENTLY" to use in-place updates when changing the state of an index's pg_index row. This prevents race conditions that could cause concurrent sessions to miss updating the target index, thus resulting in corrupt concurrently-created indexes. Also, fix various other operations to ensure that they ignore invalid indexes resulting from a failed "CREATE INDEX CONCURRENTLY" command. The most important of these is "VACUUM", because an auto-vacuum could easily be launched on the table before corrective action can be taken to fix or remove the invalid index. - Fix buffer locking during WAL replay. The WAL replay code was insufficiently careful about locking buffers when replaying WAL records that affect more than one page. This could result in hot standby queries transiently seeing inconsistent states, resulting in wrong answers or unexpected failures. - See HISTORY/changelog.gz for the other bug fixes. * Drop 00git_ecpg_array_bounds.patch, fixed upstream. -- Martin PittMon, 10 Dec 2012 15:00:57 +0100 ** Changed in: postgresql-9.1 (Ubuntu Oneiric) Status: Fix Committed => Fix Released -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1088393 Title: New bug fix releases: 9.1.7, 8.4.15, 8.3.22 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/postgresql-8.3/+bug/1088393/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1088393] Re: New bug fix releases: 9.1.7, 8.4.15, 8.3.22
This bug was fixed in the package postgresql-8.4 - 8.4.15-0ubuntu12.04 --- postgresql-8.4 (8.4.15-0ubuntu12.04) precise-proposed; urgency=low * New upstream bug fix release: (LP: #1088393) - Fix multiple bugs associated with "CREATE INDEX CONCURRENTLY" Fix "CREATE INDEX CONCURRENTLY" to use in-place updates when changing the state of an index's pg_index row. This prevents race conditions that could cause concurrent sessions to miss updating the target index, thus resulting in corrupt concurrently-created indexes. Also, fix various other operations to ensure that they ignore invalid indexes resulting from a failed "CREATE INDEX CONCURRENTLY" command. The most important of these is "VACUUM", because an auto-vacuum could easily be launched on the table before corrective action can be taken to fix or remove the invalid index. - See HISTORY/changelog.gz for details about other bug fixes. -- Martin PittMon, 10 Dec 2012 15:38:48 +0100 ** Changed in: postgresql-9.1 (Ubuntu Quantal) Status: Fix Committed => Fix Released -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1088393 Title: New bug fix releases: 9.1.7, 8.4.15, 8.3.22 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/postgresql-8.3/+bug/1088393/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1088393] Re: New bug fix releases: 9.1.7, 8.4.15, 8.3.22
This bug was fixed in the package postgresql-8.4 - 8.4.15-0ubuntu10.04 --- postgresql-8.4 (8.4.15-0ubuntu10.04) lucid-proposed; urgency=low * New upstream bug fix release: (LP: #1088393) - Fix multiple bugs associated with "CREATE INDEX CONCURRENTLY" Fix "CREATE INDEX CONCURRENTLY" to use in-place updates when changing the state of an index's pg_index row. This prevents race conditions that could cause concurrent sessions to miss updating the target index, thus resulting in corrupt concurrently-created indexes. Also, fix various other operations to ensure that they ignore invalid indexes resulting from a failed "CREATE INDEX CONCURRENTLY" command. The most important of these is "VACUUM", because an auto-vacuum could easily be launched on the table before corrective action can be taken to fix or remove the invalid index. - See HISTORY/changelog.gz for details about other bug fixes. -- Martin PittMon, 10 Dec 2012 15:53:42 +0100 ** Changed in: postgresql-8.4 (Ubuntu Precise) Status: Fix Committed => Fix Released -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1088393 Title: New bug fix releases: 9.1.7, 8.4.15, 8.3.22 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/postgresql-8.3/+bug/1088393/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1088393] Re: New bug fix releases: 9.1.7, 8.4.15, 8.3.22
This bug was fixed in the package postgresql-8.3 - 8.3.22-0ubuntu8.04 --- postgresql-8.3 (8.3.22-0ubuntu8.04) hardy-proposed; urgency=low * New upstream bug fix release: (LP: #1088393) - Fix multiple bugs associated with "CREATE INDEX CONCURRENTLY". Fix "CREATE INDEX CONCURRENTLY" to use in-place updates when changing the state of an index's pg_index row. This prevents race conditions that could cause concurrent sessions to miss updating the target index, thus resulting in corrupt concurrently-created indexes. Also, fix various other operations to ensure that they ignore invalid indexes resulting from a failed "CREATE INDEX CONCURRENTLY" command. The most important of these is "VACUUM", because an auto-vacuum could easily be launched on the table before corrective action can be taken to fix or remove the invalid index. - See HISTORY/changelog.gz for details about the other bug fixes. -- Martin PittMon, 10 Dec 2012 16:16:57 +0100 ** Changed in: postgresql-8.3 (Ubuntu Hardy) Status: Fix Committed => Fix Released ** Changed in: postgresql-8.4 (Ubuntu Lucid) Status: Fix Committed => Fix Released -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1088393 Title: New bug fix releases: 9.1.7, 8.4.15, 8.3.22 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/postgresql-8.3/+bug/1088393/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1088393] Re: New bug fix releases: 9.1.7, 8.4.15, 8.3.22
With hardy's glibc regression now being fixed in -security/-updates, the new postgresql update built fine on i386 and lpia. I ran the p-common regression tests successfully. ** Changed in: postgresql-8.3 (Ubuntu Hardy) Status: In Progress => Fix Committed ** Tags removed: verification-done-lucid verification-done-oneiric verification-done-precise verification-done-quantal verification-failed-hardy ** Tags added: verification-done -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1088393 Title: New bug fix releases: 9.1.7, 8.4.15, 8.3.22 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/postgresql-8.3/+bug/1088393/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1088393] Re: New bug fix releases: 9.1.7, 8.4.15, 8.3.22
(glibc issue tracked in bug #1090740) -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1088393 Title: New bug fix releases: 9.1.7, 8.4.15, 8.3.22 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/postgresql-8.3/+bug/1088393/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1088393] Re: New bug fix releases: 9.1.7, 8.4.15, 8.3.22
I've located the glibc regression and will publish an update for it on monday. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1088393 Title: New bug fix releases: 9.1.7, 8.4.15, 8.3.22 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/postgresql-8.3/+bug/1088393/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1088393] Re: New bug fix releases: 9.1.7, 8.4.15, 8.3.22
I bisected the hardy failure on i386 and lpia down to this glibc upgrade: https://launchpad.net/ubuntu/+source/glibc/2.7-10ubuntu8.2 Both postgresql 8.3.21 and 8.3.22 build fine on hardy final, and fail the same way as in comment 9 on a fully upgraded hardy. Downgrading libc6, libc6-dev, and libc6-i686 from 2.7-10ubuntu8.2 to 2.7-10ubuntu8.1 fixes the bug. For cross-checking I built 8.3.22 on current raring i386 successfully, so it's not a general i386 problem, but one with hardy specifically. Perhaps the backport of the security patches to hardy were faulty, or make assumptions that are not true on hardy? -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1088393 Title: New bug fix releases: 9.1.7, 8.4.15, 8.3.22 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/postgresql-8.3/+bug/1088393/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1088393] Re: New bug fix releases: 9.1.7, 8.4.15, 8.3.22
** Tags added: verification-done-oneiric verification-done-quantal ** Tags removed: verification-needed ** Changed in: postgresql-9.1 (Ubuntu Oneiric) Status: In Progress => Fix Committed -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1088393 Title: New bug fix releases: 9.1.7, 8.4.15, 8.3.22 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/postgresql-8.3/+bug/1088393/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1088393] Re: New bug fix releases: 9.1.7, 8.4.15, 8.3.22
precise 8.4 and 9.1 and lucid 8.4 -proposed versions verified with postgresql-common test suite. ** Tags added: verification-done-precise verification-failed-hardy ** Changed in: postgresql-9.1 (Ubuntu Precise) Status: In Progress => Fix Committed ** Changed in: postgresql-8.4 (Ubuntu Lucid) Status: In Progress => Fix Committed ** Changed in: postgresql-8.4 (Ubuntu Precise) Status: In Progress => Fix Committed ** Tags added: verification-done-lucid -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1088393 Title: New bug fix releases: 9.1.7, 8.4.15, 8.3.22 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/postgresql-8.3/+bug/1088393/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1088393] Re: New bug fix releases: 9.1.7, 8.4.15, 8.3.22
I'm chasing the test case failure on i386/lpia which caused a build failure: *** *** 432,443 select * from numeric_table where num_col in (select float_col from float_table); num_col ! - 1 - 1.1 2 3 ! (4 rows) -- -- Test case for bug #4290: bogus calculation of subplan param sets --- 432,442 select * from numeric_table where num_col in (select float_col from float_table); num_col ! - 1 2 3 ! (3 rows) The 8.3.21 -> 8.3.22 diff does not touch this part, and indeed building the current hardy-updates version 8.3.21 on current hardy now fails in exactly the same way. This happens in a hardy i386 chroot on raring amd64. So this could be a buildd change or a regression from a hardy- updates package. I'll do some bisecting to see what caused this. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1088393 Title: New bug fix releases: 9.1.7, 8.4.15, 8.3.22 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/postgresql-8.3/+bug/1088393/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1088393] Re: New bug fix releases: 9.1.7, 8.4.15, 8.3.22
** Branch unlinked: lp:ubuntu/precise-proposed/postgresql-8.4 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1088393 Title: New bug fix releases: 9.1.7, 8.4.15, 8.3.22 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/postgresql-8.3/+bug/1088393/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1088393] Re: New bug fix releases: 9.1.7, 8.4.15, 8.3.22
** Branch linked: lp:ubuntu/lucid-proposed/postgresql-8.4 ** Branch linked: lp:ubuntu/precise-proposed/postgresql-8.4 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1088393 Title: New bug fix releases: 9.1.7, 8.4.15, 8.3.22 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/postgresql-8.3/+bug/1088393/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1088393] Re: New bug fix releases: 9.1.7, 8.4.15, 8.3.22
Hello Martin, or anyone else affected, Accepted into quantal-proposed. The package will build now and be available in a few hours in the -proposed repository. Please help us by testing this new package. See https://wiki.ubuntu.com/Testing/EnableProposed for documentation how to enable and use -proposed. Your feedback will aid us getting this update out to other Ubuntu users. If this package fixes the bug for you, please change the bug tag from verification-needed to verification-done. If it does not, change the tag to verification-failed. In either case, details of your testing will help us make a better decision. Further information regarding the verification process can be found at https://wiki.ubuntu.com/QATeam/PerformingSRUVerification . Thank you in advance! ** Changed in: postgresql-9.1 (Ubuntu Quantal) Status: In Progress => Fix Committed ** Tags added: verification-needed -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1088393 Title: New bug fix releases: 9.1.7, 8.4.15, 8.3.22 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/postgresql-8.3/+bug/1088393/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1088393] Re: New bug fix releases: 9.1.7, 8.4.15, 8.3.22
8.3/hardy update uploaded to SRU review queue, too. ** Changed in: postgresql-8.4 (Ubuntu Precise) Status: New => In Progress ** Changed in: postgresql-8.3 (Ubuntu Hardy) Status: New => In Progress -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1088393 Title: New bug fix releases: 9.1.7, 8.4.15, 8.3.22 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/postgresql-8.3/+bug/1088393/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1088393] Re: New bug fix releases: 9.1.7, 8.4.15, 8.3.22
I uploaded the two 8.4 updates (lucid/precise) to the SRU review queue. ** Changed in: postgresql-8.4 (Ubuntu Lucid) Status: New => In Progress -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1088393 Title: New bug fix releases: 9.1.7, 8.4.15, 8.3.22 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/postgresql-8.3/+bug/1088393/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1088393] Re: New bug fix releases: 9.1.7, 8.4.15, 8.3.22
I uploaded the 9.1 updates to the -proposed SRU review queues. ** Changed in: postgresql-9.1 (Ubuntu Oneiric) Status: New => In Progress ** Changed in: postgresql-9.1 (Ubuntu Precise) Status: New => In Progress ** Changed in: postgresql-9.1 (Ubuntu Quantal) Status: New => In Progress -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1088393 Title: New bug fix releases: 9.1.7, 8.4.15, 8.3.22 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/postgresql-8.3/+bug/1088393/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1088393] Re: New bug fix releases: 9.1.7, 8.4.15, 8.3.22
Synced 9.1.7-1 from Debian unstable into Raring. ** Changed in: postgresql-9.1 (Ubuntu Raring) Status: New => Fix Released ** No longer affects: postgresql-8.4 (Ubuntu Hardy) ** No longer affects: postgresql-8.4 (Ubuntu Raring) ** No longer affects: postgresql-8.4 (Ubuntu Quantal) ** No longer affects: postgresql-8.4 (Ubuntu Oneiric) ** Changed in: postgresql-8.4 (Ubuntu) Status: New => Invalid -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1088393 Title: New bug fix releases: 9.1.7, 8.4.15, 8.3.22 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/postgresql-8.3/+bug/1088393/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs