ubuntu upgrade to noble failed because it couldn't remove postgresql12-wal2json
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
ubuntu-release-upgrader (Ubuntu) |
New
|
Undecided
|
Unassigned |
Bug Description
This stopped without telling why. The logs pointed towards postgres. After some failed attempts I found the denylist was actually shipped in the installer, but it seems a bit too strict.
```
root@kaa:
# deny list of packages that should never be removed
ubuntu-standard
ubuntu-minimal
ubuntu-desktop$
kubuntu-desktop
xubuntu-desktop
lubuntu-desktop
mythbuntu-desktop
ubuntustudio-
ubuntu-mate-core
ubuntu-mate-desktop
# ubuntu-
update-manager$
update-manager-core
ubuntu-
# if for example postgresql-10 is purged the cluster can be dropped which we
# should prevent (LP: #871893, #1825563)
^postgresql-
^postgresql-
# the upgrade runs in it
^screen$
# the upgrade might be run over ssh
^openssh-server$
```
Uninstalling the wal2json extension fixed it.
# apt remove postgresql-
I expected Ubuntu to just remove this, -- I've cleaned up he 12 cluster into 14 previously. It is a bit bothersome having to do that manually all the time, this is just a development machine, though I understand some people will be more afraid of their production clusters. Still think an auto-upgrade or migration or at least an option to just pg_dump the lot and remiport would be okay for desktop ubuntu installs.
ProblemType: Bug
DistroRelease: Ubuntu 22.04
Package: ubuntu-
ProcVersionSign
Uname: Linux 6.8.0-38-generic x86_64
ApportVersion: 2.20.11-0ubuntu82.5
Architecture: amd64
CasperMD5CheckR
CrashDB: ubuntu
CrashReports:
640:1000:
600:111:
644:0:
644:1000:
644:0:
CurrentDesktop: ubuntu:GNOME
Date: Sun Jul 28 12:54:04 2024
InstallationDate: Installed on 2018-08-28 (2161 days ago)
InstallationMedia: Ubuntu 18.04 LTS "Bionic Beaver" - Release amd64 (20180426)
PackageArchitec
SourcePackage: ubuntu-
UpgradeStatus: Upgraded to jammy on 2024-07-28 (0 days ago)
VarLogDistupgra
Start-Date: 2024-07-28 12:52:50
Requested-By: odin (1000)
End-Date: 2024-07-28 12:52:51
VarLogDistupgra
Log time: 2024-07-28 12:52:42.583505
Log time: 2024-07-28 12:52:48.167922
VarLogDistupgra
Log started: 2024-07-28 12:52:50
Log ended: 2024-07-28 12:52:51
mtime.conffile.