Plesk / system update fails after dist-upgrade from Debian 11 to Debian 12: Depends: libodbc2 (>= 2.3.1) but it is not going to be installed

Symptoms

• Debian has been upgraded from 11 (Bullseye) to 12 (Bookworm).

• Plesk/system update fails with the messages below:

  # apt upgrade
  ...
  The following packages have unmet dependencies:
  plesk-librdbmspp : Depends: libodbc2 (>= 2.3.1) but it is not installed
  E: Unmet dependencies. Try 'apt --fix-broken install' with no packages (or specify a solution).
  ...
  plesk-librdbmspp : Depends: libodbc2 (>= 2.3.1) but it is not going to be installed
  E: Unmet dependencies. Try 'apt --fix-broken install' with no packages (or specify a solution).

• The command apt --fix-broken install fails with:

  CONFIG_TEXT: dpkg: error processing archive /var/cache/apt/archives/libodbc2_2.3.11-2+deb12u1_amd64.deb (--unpack):
  trying to overwrite '/usr/lib/x86_64-linux-gnu/libodbc.so.2.0.0', which is also in package libodbc1:amd64 2.3.11-3

Cause

Plesk and system packages cannot be installed/upgraded because old ODBC packages from Debian 11 conflict with the new ODBC packages for Debian 12.

Resolution

1. Connect to your Plesk server via SSH.

2. Remove the conflicting packages:

   # dpkg -r --force-depends libodbc1 odbcinst1debian2 odbcinst

3. Install/upgrade required system packages:

   # apt --fix-broken install

4. Update Plesk:

   # plesk installer update

5. Optional: Upgrade system packages, if necessary:

   # apt upgrade