Symptoms
-
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
-
Plesk may be not available with the same error.
-
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:
-
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) -
Make sure that domain example.com and its mail content doesn’t exist physically in
/var/qmail/mailnames
and/var/www/vhosts directories.
-
Create backup of psa database:
# plesk db dump psa>psa.dump
-
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) -
Delete domain from Plesk Control panel.