Plesk update failed: Missing Dependency psa-proftpd or u’ERROR with transaction check vs depsolve:’

Symptoms

• Unable to update Plesk:

  PLESK_ERROR: psa-proftpd-xinetd-1.3.5-6.el5.art.x86_64 from installed has depsolving problems
  –> Missing Dependency: psa-proftpd = 1.3.5-6.el5.art is needed by package psa-proftpd-xinetd-1.3.5-6.el5.art.x86_64 (installed)
  Exception: Failed to solve dependencies:
  Missing Dependency: psa-proftpd = 1.3.5-6.el5.art is needed by package psa-proftpd-xinetd-1.3.5-6.el5.art.x86_64 (installed)

  ---

  Fatal error during packages installation: [u'ERROR with transaction check vs depsolve:', 'psa-proftpd = 1.3.6-11.el7.art is needed by (installed) psa-proftpd-xinetd-1.3.6-11.el7.art.x86_64']
  YumRPMCheckError: [u'ERROR with transaction check vs depsolve:', 'psa-proftpd = 1.3.6-11.el7.art is needed by (installed) psa-proftpd-xinetd-1.3.6-11.el7.art.x86_64']

• Unable to connect to the server over FTP:

  421 Service not available, remote server has closed connection

• plesk login command does not work:

  # plesk login
  ERR [panel] DB query failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘psa.ServiceInstallations’ doesn’t exist, query was: DESCRIBE ServiceInstallations
  DB query failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘psa.ServiceInstallations’ doesn’t exist, query was: DESCRIBE ServiceInstallations

• Atomic repository may be active on the server:

  # yum repolist | grep -i atomic
  atomic/7/x86_64 CentOS / Red Hat Enterprise Linux 7 – atomic 747

Cause

Incorrect package installed from a third-party repository.

Resolution

1. Connect to the server via SSH.

2. Remove psa-proftpd/psa-proftpd-xinetd packages mentioned in the error message, for example:

   # rpm -e psa-proftpd-xinetd-1.3.5-6.el5.art –nodeps
   # rpm -e psa-proftpd-1.3.5-6.el5.art –nodeps

3. In case the Atomic repository is active (see symptoms), add packages to exclusion list:

   # echo ‘exclude=psa-proftpd*’ >> /etc/yum.repos.d/atomic.repo

4. Install ProFTP from Web Hosting category in Plesk installer:

   # plesk installer