New upstream microreleases 10.23, 12.13 and 14.6

Bug #1996770 reported by Athos Ribeiro
14
This bug affects 1 person
Affects Status Importance Assigned to Milestone
postgresql-10 (Ubuntu)
Bionic
Fix Released
High
Sergio Durigan Junior
postgresql-12 (Ubuntu)
Invalid
Undecided
Unassigned
Focal
Fix Released
High
Sergio Durigan Junior
postgresql-14 (Ubuntu)
Invalid
High
Athos Ribeiro
Jammy
Fix Released
High
Athos Ribeiro
Kinetic
Fix Released
High
Athos Ribeiro
Lunar
Won't Fix
High
Athos Ribeiro

Bug Description

[Impact]

 * MRE for latest stable fixes of Postgres 10, 12 and 14 released on November 2022.

[Test Case]

 * The Postgres MREs traditionally rely on the large set of autopkgtests
   to run for verification. In a PPA those are all already pre-checked to
   be good for this upload.

[Regression Potential]

 * Upstreams tests are usually great and in additon in the Archive there
   are plenty of autopkgtests that in the past caught issues before being
   released.
   But nevertheless there always is a risk for something to break. Since
   these are general stable releases I can't pinpoint them to a most-likely area.
   - usually this works smoothly except a few test hickups (flaky) that need to be clarified to be sure. Pre-checks will catch those to be discussed upfront (as last time)

[Other Info]

 * This is a reoccurring MRE, see below and all the references
 * No CVEs are being addressed this time. Therefore, this should go through the updates pockets.

Current versions in supported releases that got updates:
 postgresql-10 | 10.22-0ubuntu0.18.04.1 | bionic-updates | source, amd64, arm64, armhf, i386, ppc64el, s390x
 postgresql-12 | 12.12-0ubuntu0.20.04.1 | focal-updates | source, amd64, arm64, armhf, i386, ppc64el, riscv64, s390x
 postgresql-14 | 14.5-0ubuntu0.22.04.1 | jammy-updates | source, amd64, arm64, armhf, i386, ppc64el, riscv64, s390x
 postgresql-14 | 14.5-1ubuntu1 | kinetic | source, amd64, arm64, armhf, i386, ppc64el, riscv64, s390x
 postgresql-14 | 14.5-1ubuntu2 | lunar-proposed | source, amd64, arm64, armhf, i386, ppc64el, riscv64, s390x

Special cases:
- Lunar will be upgraded to 15.1. It currently has 14.6 and 15.1 in lunar-proposed, but we will only want 15.1 there.
- 10.23 is being announced as the final postgresql-10 release. After this, Bionic will no longer be part of the recurrent postgresql MREs (but will still be maintained as needed while bionic is under standard support).

Standing MRE - Consider last updates as template:
- pad.lv/1637236
- pad.lv/1664478
- pad.lv/1690730
- pad.lv/1713979
- pad.lv/1730661
- pad.lv/1747676
- pad.lv/1752271
- pad.lv/1786938
- pad.lv/1815665
- pad.lv/1828012
- pad.lv/1833211
- pad.lv/1839058
- pad.lv/1863108
- pad.lv/1892335
- pad.lv/1915254
- pad.lv/1928773
- pad.lv/1939396
- pad.lv/1950268
- pad.lv/1961127
- pad.lv/1973627
- pad.lv/1978249
- pad.lv/1984012

As usual we test and prep from the PPA and then push through SRU/Security as applicable.

Related branches

Changed in postgresql-10 (Ubuntu Bionic):
importance: Undecided → High
Changed in postgresql-12 (Ubuntu Focal):
importance: Undecided → High
Changed in postgresql-14 (Ubuntu Jammy):
importance: Undecided → High
Changed in postgresql-14 (Ubuntu Kinetic):
importance: Undecided → High
Changed in postgresql-14 (Ubuntu Lunar):
importance: Undecided → High
assignee: nobody → Athos Ribeiro (athos-ribeiro)
Changed in postgresql-14 (Ubuntu Kinetic):
assignee: nobody → Athos Ribeiro (athos-ribeiro)
Changed in postgresql-14 (Ubuntu Jammy):
assignee: nobody → Athos Ribeiro (athos-ribeiro)
Changed in postgresql-12 (Ubuntu Focal):
assignee: nobody → Sergio Durigan Junior (sergiodj)
Changed in postgresql-10 (Ubuntu Bionic):
assignee: nobody → Sergio Durigan Junior (sergiodj)
Changed in postgresql-10 (Ubuntu Bionic):
status: New → In Progress
Changed in postgresql-12 (Ubuntu Focal):
status: New → In Progress
description: updated
description: updated
Revision history for this message
Andreas Hasenack (ahasenack) wrote : Please test proposed package

Hello Athos, or anyone else affected,

Accepted postgresql-14 into kinetic-proposed. The package will build now and be available at https://launchpad.net/ubuntu/+source/postgresql-14/14.6-0ubuntu0.22.10.1 in a few hours, and then in the -proposed repository.

Please help us by testing this new package. See https://wiki.ubuntu.com/Testing/EnableProposed for documentation on 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 add a comment to this bug, mentioning the version of the package you tested, what testing has been performed on the package and change the tag from verification-needed-kinetic to verification-done-kinetic. If it does not fix the bug for you, please add a comment stating that, and change the tag to verification-failed-kinetic. In either case, without details of your testing we will not be able to proceed.

Further information regarding the verification process can be found at https://wiki.ubuntu.com/QATeam/PerformingSRUVerification . Thank you in advance for helping!

N.B. The updated package will be released to -updates after the bug(s) fixed by this package have been verified and the package has been in -proposed for a minimum of 7 days.

Changed in postgresql-14 (Ubuntu Kinetic):
status: New → Fix Committed
tags: added: verification-needed verification-needed-kinetic
Changed in postgresql-14 (Ubuntu Jammy):
status: New → Fix Committed
tags: added: verification-needed-jammy
Revision history for this message
Andreas Hasenack (ahasenack) wrote :

Hello Athos, or anyone else affected,

Accepted postgresql-14 into jammy-proposed. The package will build now and be available at https://launchpad.net/ubuntu/+source/postgresql-14/14.6-0ubuntu0.22.04.1 in a few hours, and then in the -proposed repository.

Please help us by testing this new package. See https://wiki.ubuntu.com/Testing/EnableProposed for documentation on 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 add a comment to this bug, mentioning the version of the package you tested, what testing has been performed on the package and change the tag from verification-needed-jammy to verification-done-jammy. If it does not fix the bug for you, please add a comment stating that, and change the tag to verification-failed-jammy. In either case, without details of your testing we will not be able to proceed.

Further information regarding the verification process can be found at https://wiki.ubuntu.com/QATeam/PerformingSRUVerification . Thank you in advance for helping!

N.B. The updated package will be released to -updates after the bug(s) fixed by this package have been verified and the package has been in -proposed for a minimum of 7 days.

Changed in postgresql-12 (Ubuntu Focal):
status: In Progress → Fix Committed
tags: added: verification-needed-focal
Revision history for this message
Andreas Hasenack (ahasenack) wrote :

Hello Athos, or anyone else affected,

Accepted postgresql-12 into focal-proposed. The package will build now and be available at https://launchpad.net/ubuntu/+source/postgresql-12/12.13-0ubuntu0.20.04.1 in a few hours, and then in the -proposed repository.

Please help us by testing this new package. See https://wiki.ubuntu.com/Testing/EnableProposed for documentation on 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 add a comment to this bug, mentioning the version of the package you tested, what testing has been performed on the package and change the tag from verification-needed-focal to verification-done-focal. If it does not fix the bug for you, please add a comment stating that, and change the tag to verification-failed-focal. In either case, without details of your testing we will not be able to proceed.

Further information regarding the verification process can be found at https://wiki.ubuntu.com/QATeam/PerformingSRUVerification . Thank you in advance for helping!

N.B. The updated package will be released to -updates after the bug(s) fixed by this package have been verified and the package has been in -proposed for a minimum of 7 days.

Changed in postgresql-10 (Ubuntu Bionic):
status: In Progress → Fix Committed
tags: added: verification-needed-bionic
Revision history for this message
Andreas Hasenack (ahasenack) wrote :

Hello Athos, or anyone else affected,

Accepted postgresql-10 into bionic-proposed. The package will build now and be available at https://launchpad.net/ubuntu/+source/postgresql-10/10.23-0ubuntu0.18.04.1 in a few hours, and then in the -proposed repository.

Please help us by testing this new package. See https://wiki.ubuntu.com/Testing/EnableProposed for documentation on 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 add a comment to this bug, mentioning the version of the package you tested, what testing has been performed on the package and change the tag from verification-needed-bionic to verification-done-bionic. If it does not fix the bug for you, please add a comment stating that, and change the tag to verification-failed-bionic. In either case, without details of your testing we will not be able to proceed.

Further information regarding the verification process can be found at https://wiki.ubuntu.com/QATeam/PerformingSRUVerification . Thank you in advance for helping!

N.B. The updated package will be released to -updates after the bug(s) fixed by this package have been verified and the package has been in -proposed for a minimum of 7 days.

Revision history for this message
Athos Ribeiro (athos-ribeiro) wrote :

Setting lunar to won't fix: we dropped 14.6 from proposed in favor of allowing pg-15 to migrate to the release pocket.

Changed in postgresql-14 (Ubuntu Lunar):
status: New → Won't Fix
Revision history for this message
Ubuntu SRU Bot (ubuntu-sru-bot) wrote : Autopkgtest regression report (postgresql-10/10.23-0ubuntu0.18.04.1)

All autopkgtests for the newly accepted postgresql-10 (10.23-0ubuntu0.18.04.1) for bionic have finished running.
The following regressions have been reported in tests triggered by the package:

libpg-perl/1:2.1.1-5build4 (i386)
libreoffice/1:6.0.7-0ubuntu0.18.04.12 (amd64)
dovecot/1:2.2.33.2-1ubuntu4.8 (armhf)

Please visit the excuses page listed below and investigate the failures, proceeding afterwards as per the StableReleaseUpdates policy regarding autopkgtest regressions [1].

https://people.canonical.com/~ubuntu-archive/proposed-migration/bionic/update_excuses.html#postgresql-10

[1] https://wiki.ubuntu.com/StableReleaseUpdates#Autopkgtest_Regressions

Thank you!

Revision history for this message
Athos Ribeiro (athos-ribeiro) wrote :

As mentioned in the test case for this bug, the Postgres MREs traditionally rely on the large set of autopkgtests to run for verification. This is now complete for kinetic, jammy, and focal (bionic is still pending).

tags: added: verification-done-focal verification-done-jammy verification-done-kinetic
removed: verification-needed-focal verification-needed-jammy verification-needed-kinetic
Revision history for this message
Sergio Durigan Junior (sergiodj) wrote :

The autopkgtests for postgresql-10.23 on Bionic have succeeded, therefore I am tagging this as verified.

tags: added: verification-done verification-done-bionic
removed: server-todo verification-needed verification-needed-bionic
Revision history for this message
Launchpad Janitor (janitor) wrote :

This bug was fixed in the package postgresql-14 - 14.6-0ubuntu0.22.10.1

---------------
postgresql-14 (14.6-0ubuntu0.22.10.1) kinetic; urgency=medium

  * New upstream version (LP: #1996770).

    + A dump/restore is not required for those running 14.X.

    + Also, if you are upgrading from a version earlier than 14.4, see
      those release notes as well please.

    + Disallow rules named _RETURN that are not ON SELECT rules (Tom Lane).

    + Fix use-after-free hazard in string comparisons. (Tom Lane)

    + Details about these and many further changes can be found at:
      https://www.postgresql.org/docs/14/release-14-6.html

 -- Athos Ribeiro <email address hidden> Thu, 17 Nov 2022 16:42:48 -0300

Changed in postgresql-14 (Ubuntu Kinetic):
status: Fix Committed → Fix Released
Revision history for this message
Brian Murray (brian-murray) wrote : Update Released

The verification of the Stable Release Update for postgresql-14 has completed successfully and the package is now being released to -updates. Subsequently, the Ubuntu Stable Release Updates Team is being unsubscribed and will not receive messages about this bug report. In the event that you encounter a regression using the package from -updates please report a new bug using ubuntu-bug and tag the bug report regression-update so we can easily find any regressions.

Revision history for this message
Launchpad Janitor (janitor) wrote :

This bug was fixed in the package postgresql-14 - 14.6-0ubuntu0.22.04.1

---------------
postgresql-14 (14.6-0ubuntu0.22.04.1) jammy; urgency=medium

  * New upstream version (LP: #1996770).

    + A dump/restore is not required for those running 14.X.

    + Also, if you are upgrading from a version earlier than 14.4, see
      those release notes as well please.

    + Disallow rules named _RETURN that are not ON SELECT rules (Tom Lane).

    + Fix use-after-free hazard in string comparisons. (Tom Lane)

    + Details about these and many further changes can be found at:
      https://www.postgresql.org/docs/14/release-14-6.html

 -- Athos Ribeiro <email address hidden> Thu, 17 Nov 2022 17:11:29 -0300

Changed in postgresql-14 (Ubuntu Jammy):
status: Fix Committed → Fix Released
Revision history for this message
Launchpad Janitor (janitor) wrote :

This bug was fixed in the package postgresql-12 - 12.13-0ubuntu0.20.04.1

---------------
postgresql-12 (12.13-0ubuntu0.20.04.1) focal; urgency=medium

  * New upstream version (LP: #1996770).

    + A dump/restore is not required for those running 12.X.

    + Also, if you are upgrading from a version earlier than 12.10, see
      those release notes as well please.

    + Disallow rules named _RETURN that are not ON SELECT rules (Tom Lane).

    + Fix use-after-free hazard in string comparisons. (Tom Lane)

    + Details about these and many further changes can be found at:
      https://www.postgresql.org/docs/12/release-12-13.html

 -- Sergio Durigan Junior <email address hidden> Thu, 17 Nov 2022 17:07:25 -0500

Changed in postgresql-12 (Ubuntu Focal):
status: Fix Committed → Fix Released
Revision history for this message
Launchpad Janitor (janitor) wrote :

This bug was fixed in the package postgresql-10 - 10.23-0ubuntu0.18.04.1

---------------
postgresql-10 (10.23-0ubuntu0.18.04.1) bionic; urgency=medium

  * New upstream version (LP: #1996770).

    + A dump/restore is not required for those running 10.X.

    + Also, if you are upgrading from a version earlier than 10.19, see
      those release notes as well please.

    + Disallow rules named _RETURN that are not ON SELECT rules (Tom Lane).

    + Fix use-after-free hazard in string comparisons. (Tom Lane)

    + Details about these and many further changes can be found at:
      https://www.postgresql.org/docs/10/release-10-23.html

 -- Sergio Durigan Junior <email address hidden> Thu, 17 Nov 2022 16:39:57 -0500

Changed in postgresql-10 (Ubuntu Bionic):
status: Fix Committed → Fix Released
Changed in postgresql-12 (Ubuntu):
status: New → Invalid
Changed in postgresql-14 (Ubuntu):
status: New → Invalid
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.