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

Created:

2016-11-16 12:55:56 UTC

Modified:

2017-08-16 16:34:02 UTC

0

Was this article helpful?


Have more questions?

Submit a request

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

Applicable to:

  • Plesk 10.x for Linux
  • Plesk 11.x for Linux
  • Plesk 12.0 for Linux

Symptoms

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

    Error: Unable to find service node for web service on domain with id=31
    Certains abonnements sélectionnés n'ont pas été retirés.
  2. Plesk is not available with the same error.

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.

Note: " plesk repair db " fixes known database inconsistency, but should be used carefully.

Below queries will fully remove domain from psa database:

1. Login to Plesk database and execute below query:

mysql> select id,displayName,dns_zone_id,htype from domains where displayName='example.com';
+----+-------------+-------------+---------+
| id | displayName | dns_zone_id | htype |
+----+-------------+-------------+---------+
| 4 | example.com | 9 | vrt_hst |
+----+-------------+-------------+---------+

2. Make sure that there is now records in "hosting" and "sys_users" table:

mysql> select * from hosting where dom_id=122;
Empty set (0.00 sec)
mysql> select * from sys_users where home like "%example.com%"
Empty set (0.00 sec)

3. Make sure that domain example.com and his mailcontent doesn't exist physically.
4. Remove following records:

mysql> delete from domains where id=4;
Query OK, 1 row affected (0.00 sec)
mysql> delete from dns_zone where id=9;
Query OK, 1 row affected (0.00 sec)
mysql> delete from dns_recs where dns_zone_id=9;
Query OK, 15 rows affected (0.00 sec)
mysql> delete from from DomainServices where dom_id=4;
Query OK, 2 rows affected (0.00 sec)
mysql> delete from serviceinstanceproperties where value like "%example.com%";
Have more questions? Submit a request
Please sign in to leave a comment.