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-04-24 12:07:09 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.4 for Linux
  • Plesk 11.0 for Linux
  • Plesk
  • 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

Resolution

Note: before performing operations with database take psa database backup:

# mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` psa > /root/psa.dump2.sql
  1. Check the domain name and its hosting type using the id from the error message:

    mysql> select id,name,htype from domains where name like '%domain.tld%';
    +----+--------------------+---------+
    | id | name | htype |
    +----+--------------------+---------+
    | 31 | domain.tld | vrt_hst |
    +----+--------------------+---------+
    1 row in set (0.00 sec)
  2. Set hosting type of the domain to none and back to vrt_hst , then, try to delete the domain once again:

    mysql> update domains set htype='none' where id=31;
    Query OK, 1 row affected (0.00 sec)
    Rows matched: 1 Changed: 1 Warnings: 0

    mysql> update domains set htype='vrt_hst' where id=31;
    Query OK, 1 row affected (0.00 sec)
    Rows matched: 1 Changed: 1 Warnings: 0
  3. If step #2 did not help, delete DNS records of the domain manually:

    mysql> delete from domains where id=31;
    Query OK, 1 row affected (0.04 sec)

    mysql> delete from dns_zone where name='domain.tld';
    Query OK, 1 row affected (0.07 sec)

    mysql> delete from dns_recs where displayHost like '%domain.tld%';
    Query OK, 15 rows affected (0.06 sec)

For Plesk 12.5 and higher execute plesk repair db

Have more questions? Submit a request
Please sign in to leave a comment.