Unable to open a subscription/domain in Plesk: Domain Service Web not exists

Symptoms

• Unable to open or search the subscription example.com. The following error message is shown in a browser:

  PLESK_INFO: Internal error: Domain Service Web not exists: domain=example.com, id=57
  Message Domain Service Web not exists: domain=example.com, id=57
  File DSWeb.php
  Line 76
  Type PleskFatalException

• The domain example.com does not exist physically on the server:

  # ls -ld /var/www/vhosts/example.com
  ls: cannot access /var/www/vhosts/example.com: No such file or directory

Cause

Inconsistency in the Plesk database: orphaned records from the domain exist in domains and dns_recs tables.

Resolution

1. Connect to a Plesk server via SSH or RDP

2. Create a backup of the Plesk database

3. Login into Plesk database

4. Remove an orphaned record from the “psa.domains” table:

   MYSQL_LIN: mysql> select id,name,displayName from domains where name like ‘%example.com%’G;
   *************************** 1. row ***************************
   id: 57
   name: example.com
   displayName: example.com

   mysql> delete from domains where name = ‘example.com’;
   Query OK, 1 row affected (0.01 sec)

5. Remove orphaned records from the “psa.dns_recs” table:

   MYSQL_LIN: mysql> delete from dns_recs where host like “%example.com%”;