[RM] Remove src:postgresql-13 and src:glom from Jammy

[Christian Ehrhardt ]

With the postgresql-14 transition in bug 1949579 done we want to clean up the remainders of the former version.

Steps done:
0. Analyze remaining dependencies
1. @ubuntu-release: please accept the hint for postgresql-mysql-fdw to let it migrate - details in comment #3

Steps from here:
2. Remove src:glom - details see comment #1
3. remove src:postgresql-13 - superseeded by postgresql-14 (see bug 1949579)

[1]: https://code.launchpad.net/~paelzer/britney/+git/hints-ubuntu/+merge/413070

[Christian Ehrhardt  (paelzer)]

I have experimented with glom a bit and the summary for now is:

1. it also fails in Debian, I filed bug [3]
2. it is a FTBFS regression in release independent to postgres
3. The newer glom 1.32 fails as well, Desktop let me know that it would need the not yet packaged libxml++3.0
4. In a discussion with Desktop it was suggested to push it back from -release to -proposed (if that is possible) or remove the current version from Jammy and let it sync back once Debian uploads a new version
5. Bug [1][2] are currently present in Jammy when rebuilding glom and would break it as well.
6. no reverse dependencies of glom that would be affected
   $ reverse-depends --release jammy src:glom
   No reverse dependencies found

[1]: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=976686
[2]: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=956709
[3]: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1001611

[Christian Ehrhardt  (paelzer)]

Summary on postgresql-13
reverse dependencies are a bit tricky as some binary names transition to the new source (like libpq-dev, libpq5) while others get new versioned names like postgresql-13 -> postgresql-14.

Out of the following we can derive the list of binary packages we need to check:

$ git diff salsa/13 -- debian/control | grep Package
 Package: libpq-dev
 Package: libpq5
 Package: libecpg6
 Package: libecpg-compat3
 Package: libpgtypes3
-Package: postgresql-13
+Package: postgresql-14
-Package: postgresql-client-13
+Package: postgresql-client-14
-Package: postgresql-server-dev-13
+Package: postgresql-server-dev-14
-Package: postgresql-doc-13
+Package: postgresql-doc-14
-Package: postgresql-plperl-13
+Package: postgresql-plperl-14
-Package: postgresql-plpython3-13
+Package: postgresql-plpython3-14
-Package: postgresql-pltcl-13
+Package: postgresql-pltcl-14

That gives us two real dependencies glom and postgresql-13-mysql-fdw

$ for p in postgresql-13 postgresql-client-13 postgresql-server-dev-13 postgresql-doc-13 postgresql-plperl-13 postgresql-plpython3-13 postgresql-pltcl-13; do echo "Check $p"; reverse-depends --release jammy $p; done
Check postgresql-13
Reverse-Depends
* glom [amd64 arm64 armhf ppc64el s390x]
* glom-utils [amd64 arm64 armhf ppc64el s390x]
* postgresql-13-mysql-fdw [amd64 arm64 armhf ppc64el s390x]
* postgresql-plperl-13
* postgresql-plpython3-13
* postgresql-pltcl-13

Packages without architectures listed are reverse-dependencies in: amd64, arm64, armhf, i386, ppc64el, s390x
Check postgresql-client-13
Reverse-Depends
* postgresql-13
* postgresql-server-dev-13

Packages without architectures listed are reverse-dependencies in: amd64, arm64, armhf, i386, ppc64el, s390x
Check postgresql-server-dev-13
No reverse dependencies found
Check postgresql-doc-13
Check postgresql-plperl-13
No reverse dependencies found
Check postgresql-plpython3-13
No reverse dependencies found
Check postgresql-pltcl-13
No reverse dependencies found

Glom should be removed from Jammy as outlined in commend #1.
mysql-fdw needs to be resolved as the new version is stuck in proposed right now.

postgresql-13-mysql-fdw:
     2.5.5-2 500
        500 http://archive.ubuntu.com/ubuntu jammy/universe amd64 Packages
postgresql-14-mysql-fdw:
     2.7.0-1 500
        500 http://archive.ubuntu.com/ubuntu jammy-proposed/universe amd64 Packages

[Christian Ehrhardt  (paelzer)]

Summary for postgresql-mysql-fdw:

1. mysql-fdw needs >=2.7 for compatibility with postgresql-14 [1].
2. The new version adds tests (independent to PG-14) that fail on 32 bit platforms like armhf [2][3]
3. Currently these test issues block proposed migration of the new version

Right now upstream seems to have no intention to support those, so there we will challenge if we shall drop armhf. Right now this works just as good (or not) as before.

Until upstream has let us know if they want us to drop the arch entirely we have to go with a test hint to ignore the issue for now. I've filed that at [4].

[1]: https://github.com/EnterpriseDB/mysql_fdw/issues/219
[2]: https://github.com/EnterpriseDB/mysql_fdw/pull/227
[3]: https://autopkgtest.ubuntu.com/results/autopkgtest-jammy/jammy/armhf/p/postgresql-mysql-fdw/20211211_155028_09ce6@/log.gz
[4]: https://code.launchpad.net/~paelzer/britney/+git/hints-ubuntu/+merge/413070

[Christian Ehrhardt  (paelzer)]

The hint with the MP was merged, waiting for the next britney run.
If all works out just the two removals are left to be done.

[Christian Ehrhardt  (paelzer)]

As planned https://launchpad.net/ubuntu/+source/postgresql-mysql-fdw/2.7.0-1 migrated and thereby postgresql-13-mysql-fdw is superseded (it might be in the NBS list now).
But by that we are ready.

@Ubuntu-archive - please remove src:postgresql-13 and src:glom as outlined in detail above.

[Steve Langasek (vorlon)]

Removing packages from jammy:
 glom 1.30.4-6.1build3 in jammy
  glom 1.30.4-6.1build3 in jammy amd64
  glom 1.30.4-6.1build3 in jammy arm64
  glom 1.30.4-6.1build3 in jammy armhf
  glom 1.30.4-6.1build3 in jammy ppc64el
  glom 1.30.4-6.1build3 in jammy riscv64
  glom 1.30.4-6.1build3 in jammy s390x
  glom-doc 1.30.4-6.1build3 in jammy amd64
  glom-doc 1.30.4-6.1build3 in jammy arm64
  glom-doc 1.30.4-6.1build3 in jammy armhf
  glom-doc 1.30.4-6.1build3 in jammy i386
  glom-doc 1.30.4-6.1build3 in jammy ppc64el
  glom-doc 1.30.4-6.1build3 in jammy riscv64
  glom-doc 1.30.4-6.1build3 in jammy s390x
  glom-utils 1.30.4-6.1build3 in jammy amd64
  glom-utils 1.30.4-6.1build3 in jammy arm64
  glom-utils 1.30.4-6.1build3 in jammy armhf
  glom-utils 1.30.4-6.1build3 in jammy ppc64el
  glom-utils 1.30.4-6.1build3 in jammy riscv64
  glom-utils 1.30.4-6.1build3 in jammy s390x
  libglom-1.30-0 1.30.4-6.1build3 in jammy amd64
  libglom-1.30-0 1.30.4-6.1build3 in jammy arm64
  libglom-1.30-0 1.30.4-6.1build3 in jammy armhf
  libglom-1.30-0 1.30.4-6.1build3 in jammy ppc64el
  libglom-1.30-0 1.30.4-6.1build3 in jammy riscv64
  libglom-1.30-0 1.30.4-6.1build3 in jammy s390x
  libglom-1.30-dev 1.30.4-6.1build3 in jammy amd64
  libglom-1.30-dev 1.30.4-6.1build3 in jammy arm64
  libglom-1.30-dev 1.30.4-6.1build3 in jammy armhf
  libglom-1.30-dev 1.30.4-6.1build3 in jammy ppc64el
  libglom-1.30-dev 1.30.4-6.1build3 in jammy riscv64
  libglom-1.30-dev 1.30.4-6.1build3 in jammy s390x
Comment: FTBFS, blocks postgresql transition, no revdeps; LP: #1954374, Debian bug #1001611
1 package successfully removed.

[Steve Langasek (vorlon)]

Removing packages:
 postgresql-13 13.4-1 in jammy
  postgresql-13 13.4-1 in jammy amd64
  postgresql-13 13.4-1 in jammy arm64
  postgresql-13 13.4-1 in jammy armhf
  postgresql-13 13.4-1 in jammy i386
  postgresql-13 13.4-1 in jammy ppc64el
  postgresql-13 13.4-1 in jammy riscv64
  postgresql-13 13.4-1 in jammy s390x
  postgresql-13-dbgsym 13.4-1 in jammy amd64
  postgresql-13-dbgsym 13.4-1 in jammy arm64
  postgresql-13-dbgsym 13.4-1 in jammy armhf
  postgresql-13-dbgsym 13.4-1 in jammy i386
  postgresql-13-dbgsym 13.4-1 in jammy ppc64el
  postgresql-13-dbgsym 13.4-1 in jammy riscv64
  postgresql-13-dbgsym 13.4-1 in jammy s390x
  postgresql-client-13 13.4-1 in jammy amd64
  postgresql-client-13 13.4-1 in jammy arm64
  postgresql-client-13 13.4-1 in jammy armhf
  postgresql-client-13 13.4-1 in jammy i386
  postgresql-client-13 13.4-1 in jammy ppc64el
  postgresql-client-13 13.4-1 in jammy riscv64
  postgresql-client-13 13.4-1 in jammy s390x
  postgresql-client-13-dbgsym 13.4-1 in jammy amd64
  postgresql-client-13-dbgsym 13.4-1 in jammy arm64
  postgresql-client-13-dbgsym 13.4-1 in jammy armhf
  postgresql-client-13-dbgsym 13.4-1 in jammy i386
  postgresql-client-13-dbgsym 13.4-1 in jammy ppc64el
  postgresql-client-13-dbgsym 13.4-1 in jammy riscv64
  postgresql-client-13-dbgsym 13.4-1 in jammy s390x
  postgresql-doc-13 13.4-1 in jammy amd64
  postgresql-doc-13 13.4-1 in jammy arm64
  postgresql-doc-13 13.4-1 in jammy armhf
  postgresql-doc-13 13.4-1 in jammy i386
  postgresql-doc-13 13.4-1 in jammy ppc64el
  postgresql-doc-13 13.4-1 in jammy riscv64
  postgresql-doc-13 13.4-1 in jammy s390x
  postgresql-plperl-13 13.4-1 in jammy amd64
  postgresql-plperl-13 13.4-1 in jammy arm64
  postgresql-plperl-13 13.4-1 in jammy armhf
  postgresql-plperl-13 13.4-1 in jammy i386
  postgresql-plperl-13 13.4-1 in jammy ppc64el
  postgresql-plperl-13 13.4-1 in jammy riscv64
  postgresql-plperl-13 13.4-1 in jammy s390x
  postgresql-plperl-13-dbgsym 13.4-1 in jammy amd64
  postgresql-plperl-13-dbgsym 13.4-1 in jammy arm64
  postgresql-plperl-13-dbgsym 13.4-1 in jammy armhf
  postgresql-plperl-13-dbgsym 13.4-1 in jammy i386
  postgresql-plperl-13-dbgsym 13.4-1 in jammy ppc64el
  postgresql-plperl-13-dbgsym 13.4-1 in jammy riscv64
  postgresql-plperl-13-dbgsym 13.4-1 in jammy s390x
  postgresql-plpython3-13 13.4-1 in jammy amd64
  postgresql-plpython3-13 13.4-1 in jammy arm64
  postgresql-plpython3-13 13.4-1 in jammy armhf
  postgresql-plpython3-13 13.4-1 in jammy i386
  postgresql-plpython3-13 13.4-1 in jammy ppc64el
  postgresql-plpython3-13 13.4-1 in jammy riscv64
  postgresql-plpython3-13 13.4-1 in jammy s390x
  postgresql-plpython3-13-dbgsym 13.4-1 in jammy amd64
  postgresql-plpython3-13-dbgsym 13.4-1 in jammy arm64
  postgresql-plpython3-13-dbgsym 13.4-1 in jammy armhf
  postgresql-plpython3-13-dbgsym 13.4-1 in jammy i386
  postgresql-plpython3-13-dbgsym 13.4-1 in jammy ppc64el
  postgresql-plpython3-13-dbgsym 13.4-1 in jammy riscv64
  postgresql-plpython3-13-dbgsym 13.4-1 in jammy s390x
  postgresql-pltcl-13 13.4-1 in jammy amd64
  postgresql-pltcl-13 13.4-1 in jammy arm64
  postgresql-p...