Unable to delete domain: “Unable to find service node for web service on domain with id”

Symptoms

1. While deleting a domain Panel throwing the following error:

   PLESK_ERROR: Error: Unable to find service node for web service on domain with id=31

2. Plesk may be not available with the same error.

3. On Windows, after domain deletion the following error may appear under Plesk > Subscriptions > example.com :

   PLESK_ERROR: ERR [panel] PleskFatalException: Domain Service Web not exists: domain=example.com.com, id=156 file: C:Program Files (x86)ParallelsPleskadminplibDSWeb.php line: 76 code: 0

Cause

Database inconsistency, domain was not fully removed.

Resolution

Note: Before performing operations with database take psa database backup . Since Plesk 12.5 it’s possible to find database inconsistency using a command ” plesk repair db -n -v ” both for Linux and Windows. ” plesk repair db ” fixes known database inconsistencies, but it should be used carefully.

Below queries will fully remove domain from psa database:

1. Connect to the server via SSH, login to Plesk database and make sure that there is no records in “hosting” and “sys_users” table:

   mysql> select id,name,htype from domains where id=4;
    +-----+--------------------------+
    | id    | name        | htype |
    +-----+--------------------------+
    |   4 | example.com | vrt_hst |
    +-----+--------------------------+
    mysql> select * from hosting where dom_id=4;
    Empty set (0.00 sec) 
    mysql> select * from sys_users where home like "%example.com%" 
    Empty set (0.00 sec)

2. Make sure that domain example.com and its mail content doesn’t exist physically in /var/qmail/mailnames and /var/www/vhosts directories.

3. Create backup of psa database:

   # plesk db dump psa>psa.dump

4. Change type of hosting for domain as without hosting:

   mysql> update domains set htype='none' where id=4;
    Query OK, 1 row affected (0.00 sec)

5. Delete domain from Plesk Control panel.