Problem: UCS 5.2 Upgrade Failure: `univention-dhcp` Package Error

[fdavid]

Problem

During the upgrade from UCS 5 to 5.2 there were some errors reported and the upgrade failed:

Processing triggers for univention-config (16.0.6) ...
dpkg-query: no packages found matching ldapacl_66univention-appcenter_app.acl
dpkg-query: no packages found matching messages_en.properties
dpkg-query: no packages found matching ldapacl_62univention-monitoring.acl
dpkg-query: no packages found matching ldapacl_58openid-connect-provider.ldapacl
dpkg-query: no packages found matching univention-keycloak
dpkg-query: no packages found matching ldapacl_61guardian.acl
dpkg-query: no packages found matching ldapacl_62univention-portal.acl
dpkg-query: no packages found matching ldapacl_59univention-radius.acl
dpkg-query: no packages found matching messages_de.properties
dpkg-query: no packages found matching ldapacl_67keycloak.acl
dpkg-query: no packages found matching ldapacl_66univention-radius.acl
dpkg-query: no packages found matching 50-keycloak
Errors were encountered while processing:
 univention-dhcp
WARNING:  database "pkgdb" has a collation version mismatch
DETAIL:  The database was created using collation version 2.28, but the operating system provides version 2.31.
HINT:  Rebuild all objects in this database that use the default collation and run ALTER DATABASE pkgdb REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.

Reading package lists... 0%
Reading package lists... 0%
...
Reading package lists... Done
Building dependency tree... 0%
...
Building dependency tree... Done
Reading state information... 0% 
Reading state information... 0%
Reading state information... Done
E: Sub-process /usr/bin/dpkg returned an error code (1)
Error: Failed to execute "apt-get -o DPkg::Options::=--force-confold -o DPkg::Options::=--force-overwrite -o DPkg::Options::=--force-overwrite-dir --trivial-only=no --assume-yes --quiet=1 dist-upgrade"
exitcode of univention-updater: 1

Cause

The issue seems to be related to the univention-dhcp package. During the upgrade process, certain package references and triggers fail, which prevents apt from completing the upgrade

Solution

To resolve the problem, temporarily removing the univention-dhcp package before continuing with the upgrade helped.

1. Remove the problematic package:

   apt remove univention-dhcp
   

2. Proceed with the UCS upgrade to version 5.2-0.

3. After the system has been successfully upgraded, reinstall the DHCP package:

   apt install univention-dhcp