Activity log for bug #2040469

Date Who What changed Old value New value Message
2023-10-25 08:32:18 Bryce Harrington bug added bug
2023-10-25 08:32:21 Bryce Harrington postgresql-12 (Ubuntu): milestone ubuntu-23.11
2023-10-25 08:32:22 Bryce Harrington postgresql-14 (Ubuntu): milestone ubuntu-23.11
2023-10-25 08:32:23 Bryce Harrington postgresql-15 (Ubuntu): milestone ubuntu-23.11
2023-10-25 08:32:25 Bryce Harrington nominated for series Ubuntu Noble
2023-10-25 08:32:25 Bryce Harrington bug task added postgresql-12 (Ubuntu Noble)
2023-10-25 08:32:25 Bryce Harrington bug task added postgresql-14 (Ubuntu Noble)
2023-10-25 08:32:25 Bryce Harrington bug task added postgresql-15 (Ubuntu Noble)
2023-10-25 08:32:27 Bryce Harrington bug added subscriber Canonical Server
2023-11-16 13:36:34 Athos Ribeiro bug task deleted postgresql-12 (Ubuntu Noble)
2023-11-16 13:36:42 Athos Ribeiro bug task deleted postgresql-14 (Ubuntu Noble)
2023-11-16 13:37:13 Athos Ribeiro postgresql-15 (Ubuntu Noble): status New Invalid
2023-11-16 14:32:53 Athos Ribeiro description Backport postgresql as MRE to noble once the update for noble has been completed. <List exact versions being upgraded from and to for each release> [Impact] TBD <List bug links to former cases of MREs for this package>[Major Changes] TBD [Test Plan] <Link to wiki SRU page>TBD [Regression Potential] Upstream has an extensive build and integration test suite. So regressions would likely arise from a change in interaction with Ubuntu-specific integrations, such as in relation to the versions of dependencies available and other packaging-specific matters. <Also, ...> [Impact]  * MRE for latest stable fixes of Postgres 12, 14, and 15 released on November 2023. [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]  * Upstream tests are usually great and in addition 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 hiccups (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  * CVEs addressed by this MRE:   - TBD Current versions in supported releases that got updates:  postgresql-12 | 12.16-0ubuntu0.20.04.1 | focal-updates | source, amd64, arm64, armhf, i386, ppc64el, riscv64, s390x  postgresql-14 | 14.9-0ubuntu0.22.04.1 | jammy-updates | source, amd64, arm64, armhf, i386, ppc64el, riscv64, s390x  postgresql-15 | 15.4-0ubuntu0.23.04.1 | lunar-updates | source, amd64, arm64, armhf, i386, ppc64el, riscv64, s390x postgresql-15 | 15.4-1ubuntu1 | mantic | source, amd64, arm64, armhf, i386, ppc64el, riscv64, s390x Special cases: - we will not perform a postgresql-15 update for noble since it is transitioning to postgresql-16. 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 - pad.lv/1996770 - pad.lv/2006406 - pad.lv/2019214 - pad.lv/2028426 As usual we test and prep from the PPA and then push through SRU/Security as applicable. Once ready, the test packages should be available at https://launchpad.net/~canonical-server/+archive/ubuntu/postgresql-sru-preparation/+packages
2023-11-16 14:34:17 Athos Ribeiro summary MRE updates of postgresql for noble New upstream microreleases 12.17, 14.10, and 15.5
2023-11-16 14:37:40 Athos Ribeiro description [Impact]  * MRE for latest stable fixes of Postgres 12, 14, and 15 released on November 2023. [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]  * Upstream tests are usually great and in addition 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 hiccups (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  * CVEs addressed by this MRE:   - TBD Current versions in supported releases that got updates:  postgresql-12 | 12.16-0ubuntu0.20.04.1 | focal-updates | source, amd64, arm64, armhf, i386, ppc64el, riscv64, s390x  postgresql-14 | 14.9-0ubuntu0.22.04.1 | jammy-updates | source, amd64, arm64, armhf, i386, ppc64el, riscv64, s390x  postgresql-15 | 15.4-0ubuntu0.23.04.1 | lunar-updates | source, amd64, arm64, armhf, i386, ppc64el, riscv64, s390x postgresql-15 | 15.4-1ubuntu1 | mantic | source, amd64, arm64, armhf, i386, ppc64el, riscv64, s390x Special cases: - we will not perform a postgresql-15 update for noble since it is transitioning to postgresql-16. 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 - pad.lv/1996770 - pad.lv/2006406 - pad.lv/2019214 - pad.lv/2028426 As usual we test and prep from the PPA and then push through SRU/Security as applicable. Once ready, the test packages should be available at https://launchpad.net/~canonical-server/+archive/ubuntu/postgresql-sru-preparation/+packages [Impact]  * MRE for latest stable fixes of Postgres 12, 14, and 15 released on November 2023. [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]  * Upstream tests are usually great and in addition 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 hiccups (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  * CVEs addressed by this MRE:   - CVE-2023-5868   - CVE-2023-5869   - CVE-2023-5870 Current versions in supported releases that got updates:  postgresql-12 | 12.16-0ubuntu0.20.04.1 | focal-updates | source, amd64, arm64, armhf, i386, ppc64el, riscv64, s390x  postgresql-14 | 14.9-0ubuntu0.22.04.1 | jammy-updates | source, amd64, arm64, armhf, i386, ppc64el, riscv64, s390x  postgresql-15 | 15.4-0ubuntu0.23.04.1 | lunar-updates | source, amd64, arm64, armhf, i386, ppc64el, riscv64, s390x  postgresql-15 | 15.4-1ubuntu1 | mantic | source, amd64, arm64, armhf, i386, ppc64el, riscv64, s390x Special cases: - we will not perform a postgresql-15 update for noble since it is transitioning to postgresql-16. - Since there are 3 CVEs being fixed here, we will likely push this through the security pocket. 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 - pad.lv/1996770 - pad.lv/2006406 - pad.lv/2019214 - pad.lv/2028426 As usual we test and prep from the PPA and then push through SRU/Security as applicable. Once ready, the test packages should be available at https://launchpad.net/~canonical-server/+archive/ubuntu/postgresql-sru-preparation/+packages
2023-11-22 19:37:08 Sergio Durigan Junior postgresql-12 (Ubuntu Focal): assignee Sergio Durigan Junior (sergiodj)
2023-11-22 19:37:12 Sergio Durigan Junior postgresql-14 (Ubuntu Jammy): assignee Sergio Durigan Junior (sergiodj)
2023-11-22 19:37:20 Sergio Durigan Junior postgresql-12 (Ubuntu): status New Invalid
2023-11-22 19:37:23 Sergio Durigan Junior postgresql-14 (Ubuntu): status New Invalid
2023-11-22 19:40:56 Athos Ribeiro postgresql-15 (Ubuntu Lunar): assignee Athos Ribeiro (athos-ribeiro)
2023-11-22 19:40:59 Athos Ribeiro postgresql-15 (Ubuntu Mantic): assignee Athos Ribeiro (athos-ribeiro)
2023-11-23 15:10:45 Athos Ribeiro merge proposal linked https://code.launchpad.net/~athos-ribeiro/ubuntu/+source/postgresql-15/+git/postgresql-15/+merge/456187
2023-11-23 15:10:53 Athos Ribeiro merge proposal linked https://code.launchpad.net/~athos-ribeiro/ubuntu/+source/postgresql-15/+git/postgresql-15/+merge/456188
2023-11-24 17:32:04 Sergio Durigan Junior merge proposal linked https://code.launchpad.net/~sergiodj/ubuntu/+source/postgresql-14/+git/postgresql-14/+merge/456259
2023-11-24 17:32:09 Sergio Durigan Junior merge proposal linked https://code.launchpad.net/~sergiodj/ubuntu/+source/postgresql-12/+git/postgresql-12/+merge/456260
2023-11-24 20:45:12 Sergio Durigan Junior postgresql-12 (Ubuntu Focal): status New In Progress
2023-11-24 20:45:15 Sergio Durigan Junior postgresql-14 (Ubuntu Jammy): status New In Progress
2023-11-24 20:45:20 Sergio Durigan Junior postgresql-15 (Ubuntu Lunar): status New In Progress
2023-11-24 20:45:22 Sergio Durigan Junior postgresql-15 (Ubuntu Mantic): status New In Progress
2023-11-29 13:51:07 Athos Ribeiro tags needs-mre-backport needs-mre-backport server-todo
2023-12-03 21:21:04 Sergio Durigan Junior merge proposal linked https://code.launchpad.net/~sergiodj/ubuntu/+source/postgresql-14/+git/postgresql-14/+merge/456714
2023-12-03 21:21:13 Sergio Durigan Junior merge proposal linked https://code.launchpad.net/~sergiodj/ubuntu/+source/postgresql-12/+git/postgresql-12/+merge/456715
2023-12-03 21:21:20 Sergio Durigan Junior merge proposal unlinked https://code.launchpad.net/~sergiodj/ubuntu/+source/postgresql-12/+git/postgresql-12/+merge/456260
2023-12-03 21:21:30 Sergio Durigan Junior merge proposal unlinked https://code.launchpad.net/~sergiodj/ubuntu/+source/postgresql-14/+git/postgresql-14/+merge/456259
2023-12-06 15:01:39 Launchpad Janitor postgresql-14 (Ubuntu Jammy): status In Progress Fix Released
2023-12-06 15:01:39 Launchpad Janitor cve linked 2023-5868
2023-12-06 15:01:39 Launchpad Janitor cve linked 2023-5869
2023-12-06 15:01:39 Launchpad Janitor cve linked 2023-5870
2023-12-06 15:01:44 Launchpad Janitor postgresql-15 (Ubuntu Lunar): status In Progress Fix Released
2023-12-06 15:03:07 Launchpad Janitor postgresql-12 (Ubuntu Focal): status In Progress Fix Released
2023-12-06 15:03:11 Launchpad Janitor postgresql-15 (Ubuntu Mantic): status In Progress Fix Released